SCOOTER DECKS

There are 2 main styles of deck, a 1 piece deck which adds rigidity and strength to the scooter, these are generally used for tricks and freestyle use. The second are standard decks that require a folding mechanism to allow the scooter to be folded and transported more easily. The Key to a great 1 piece deck is to achieve great strength for big air tricks. While keeping the deck balanced and lightweight for more technical freestyle riding. The other variant is the type of headtube! both angle and headset compatibility can be different to suit all riders Here at SkateHut we have a wide range of decks that cover the need of every rider. We stock all the best brands available in the UK.

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 (237599, 233554, 233555, 233597, 233600, 233601, 233605, 233607, 233627, 233630, 233632, 233646, 228009, 101041, 237593, 237594, 237597, 237600, 245290, 233553, 233599, 233603, 233626, 233633))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,237599,233554,233555,233597,233600,233601,233605,233607,233627,233630,233632,233646,228009,101041,237593,237594,237597,237600,245290,233553,233599,233603,233626,233633)
Page