BIG WHEEL SCOOTERS

Our variety of big wheeled scooters are perfect for your commute. Not only does it get you to A to B in style, but the larger wheels make travelling on rough surfaces a lot easier! The larger wheels will allow you to take on a curb whilst riding, along with uneven ground. These scooters will also allow you to travel faster with ease, whilst also allowing for a smoother and steadier travel. To add even more convenience to your journey, these scooters tend to be foldable, so that you can carry these on and off public transport with no trouble at all, taking up very little space. We stock in a range of top brands, such as Frenzy, JD Bug and Ozbozz. Feel free to reach out to our amazing customer services team who will be more than happy to help you find the perfect model for you!

Loading...
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.customer_group_id = 0 AND price_index.website_id = '1' 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')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (e.entity_id IN (99153, 99154, 99155, 99156, 99157, 99158, 99159, 99160, 99161, 99164, 99165, 99166, 99167, 99168, 124580, 254335, 260490, 260491, 260492))) AND (e.created_in <= '1653037202') AND (e.updated_in > '1653037202') ORDER BY FIELD(e.entity_id,99153,99154,99155,99156,99157,99158,99159,99160,99161,99164,99165,99166,99167,99168,124580,254335,260490,260491,260492)

19 Items