TRIAD

There are few things cooler than a Triad drift trike, with the Australian company responsible for making some of the best available for purchase across the entire market. With a reputation that precedes them, Triad trikes are well known for their reliability and high performance, as well as their distinctive style and aesthetic. You won’t find many better ranges of Triad trikes for sale, with our selection of models and colours sure to satisfy almost any need for either longstanding enthusiasts or absolute beginners. We even have kids’ drift trikes available for those little ones that have a sense of adventure about them! So whether you want to start out slow with the Triad Counter Measure 3, or skip straight to the top end of the market with the Triad Syndicate 3 – or any model in between – we’ve got all of your drift trike needs covered.

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 (60205, 60206, 60207, 135048, 136670, 156122))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,60205,60206,60207,135048,136670,156122)