SCOOTER GRIPS

Browse a full range of the best scooter grips in the UK! Shop grips with maximum comfort, maximum grip and magnificent design. Handlebar grips are an important part of the scooter, they are available in foam or rubber forms. The more comfortable you are with the grips, the more confidence you will have going into jumps and performing bar spins. Find scooter parts that will make your tricks more fluid, here at SkateHut. We have a wide range of grips that cover the need of every rider. Use the price, colour and product filters at the side to find the right grips 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 (62666, 62667, 62671, 62672, 62698, 62700, 62701, 62702, 62704, 62705, 62706, 101624, 101621, 101628, 101622, 101625, 101195, 101623, 160480, 101671, 101196, 101616, 101197, 101670, 160482, 101615, 101677, 101669, 153029, 101626, 101736, 160478, 101672, 160483, 160490, 102159))) AND (e.created_in <= '1632902400') AND (e.updated_in > '1632902400') ORDER BY FIELD(e.entity_id,62666,62667,62671,62672,62698,62700,62701,62702,62704,62705,62706,101624,101621,101628,101622,101625,101195,101623,160480,101671,101196,101616,101197,101670,160482,101615,101677,101669,153029,101626,101736,160478,101672,160483,160490,102159)
Page