FRENZY

An iconic British brand that offers a fun alternative to your daily commute, Frenzy scooters are suitable for everyone, from beginners to pros, with a range of premium folding scooters at affordable prices. Either buy a complete scooter or customise your own, by taking a look at our range of scooter wheels with bearings. Then, pair it with Frenzy accessories, like a stylish scooter bag to keep all your essentials dry and secure when you're travelling. This is an adventurous way to get around, whilst also keeping you active and reducing your carbon footprint compared to other forms of transport. Whether you're looking for an eye-catching teal or an elegant black design, our Frenzy scooters for sale are all foldable for easy storage, making them the perfect commuting scooter that is both stylish and compact. You can travel in style and in an eco-friendly way when you buy Frenzy scooters here at Skatehut.

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 (98831, 99153, 99154, 99155, 99156, 99157, 99158, 99159, 99160, 99161, 124580))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,98831,99153,99154,99155,99156,99157,99158,99159,99160,99161,124580)