GBP £

For Sales & Advice Call Us on 0121 501 1111

Search

Menu
Settings
  • AUD A$
  • CAD CA$
  • USD $

    • LONGBOARD WHEELS

    Longboarding can really take its toll on wheels, bombing hills and sending the board into a slide to take a corner and dumping four lines of urethane behind you will quickly cause wear. Well don’t worry, SkateHut has you covered with a wide range of some of the best brand longboard wheels on the market including Orangatang, Shark, Abec 11, Hawgs and many more. Use the filters to quickly select your preferred durometer or wheel diameter from 60mm to 85mm wheels. Chat to our knowledgeable customer service staff for help picking the best wheels 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 (249051, 85816, 85794, 85797, 85800, 85798, 85792, 85815, 85814, 85801, 85795, 158889, 154481))) AND (e.created_in <= '1641570900') AND (e.updated_in > '1641570900') ORDER BY FIELD(e.entity_id,249051,85816,85794,85797,85800,85798,85792,85815,85814,85801,85795,158889,154481)