ICE HOCKEY SKATES

Whether you’re new on the ice or you’re a seasoned veteran, you can find the right ice hockey skates to help you tear past the opposition. Comfortable, supportive, lightweight and affordable – these are some of the qualities that you’ll probably be looking for before getting in the rink. Well, our cheap ice hockey skates for sale don’t compromise on quality. Every aspect of our skates has been carefully designed to be the ultimate in performance. The liner is durable, the tongue ensures comfort and protection, the outsole assists with energy transfer, the footbed is moulded for support, the blade holder is strong, and the runner is light and sturdy. All of these components form ice hockey skates in which your foot remains secure, giving you the perfect support to hit the ice like a pro. Stocking leading brands like CCM and Bauer, ice hockey skates have never been more affordable and high-quality than 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 (82845, 158508))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,82845,158508)