LONGBOARD TRUCKS

Here at SkateHut we have a wide selection of reverse kingpin trucks, risers and hardware bolts perfect for building your dream longboard setup. With top brands Paris Trucks Co, Mindless and more, you can pick the best width for your deck which will give you the best turn possible. No matter if your style is freestyle carving or hill bombing we have got you covered. Chat to our knowledgeable customer service staff for help picking the right sized trucks for you with our live chat on our website.

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 (85769, 243175, 243176, 237460, 243177, 85771, 136362, 85778, 85774, 85766, 85767, 124463, 136361, 85844, 130761))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,85769,243175,243176,237460,243177,85771,136362,85778,85774,85766,85767,124463,136361,85844,130761)