Fans of Tony Hawk and his skating prowess will not be disappointed by our range of Tony Hawk skating decks, which are in the Tony Hawk signature series. With some stunning designs and quality materials, the Hawk board you choose is sure to impress your fellow skaters. Take a good look through to see our full range, and use the colour filter on the side if you already have an idea of which colour you’re after. We are sure that there will be a Tony Hawk skateboard for you, so choose wisely and go make Tony proud!

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 (175551, 271921, 109010, 271922, 271923, 201855, 205110, 229254, 108889, 108893, 109007, 109071, 109073, 109076, 136935, 175548, 175550))) AND (e.created_in <= '1656698400') AND (e.updated_in > '1656698400') ORDER BY FIELD(e.entity_id,175551,271921,109010,271922,271923,201855,205110,229254,108889,108893,109007,109071,109073,109076,136935,175548,175550)

17 Items