Folding Bikes

Folding Bikes

Folding bikes are the perfect solution if you need to save space. The perfect commuter bike, they can be easily tucked away under your seat or in a luggage rack and brought on any type of public transport. Unlike other bikes, you can even bring your fold up bike on trains at peak times. A folding bicycle generally comes in either a 16” or 20” wheel size and will fold in either 2 or 3 sections. The perfect bike for the city dweller with limited space and a commute that includes a train or bus, a folding bike is a strong and stable bike regardless of your level of experience.

1 Item

per page
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE ((e.entity_id IN (497195))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,497195)