3: SELECT PRODUCTS.PRODUCT_ID FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='476' AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' and PRODUCTS.DISCONTINUED='' GROUP BY PRODUCT_BRIDGE.PRODUCT_ID ORDER BY PRODUCT_BRIDGE.ORDER ASC

Named Tea Clippers because of the tea trade with the East and the sails that allowed them to “clip” through the water, these ships were designed to transport large amounts of cargo at a high rate of speed. Handcrafted Model Ships is proud to offer an amazing collection of Tea Clippers from delightful 7” models to sophisticated 50” replicas. The fleet Flying Cloud and the stunning Cutty Sark, among others, were amazing vessels that cut through the water with both power and grace. The complex sails of Tea Clippers allowed these sleek ships to sail with great ease and maneuverability throughout the 1800s and into the early 1900s.

[CATEGORY_FOOTER] =>

Named Tea Clippers because of the tea trade with the East and the sails that allowed them to “clip” through the water, these ships were designed to transport large amounts of cargo at a high rate of speed. Handcrafted Model Ships is proud to offer an amazing collection of Tea Clippers from delightful 7” models to sophisticated 50” replicas. The fleet Flying Cloud and the stunning Cutty Sark, among others, were amazing vessels that cut through the water with both power and grace. The complex sails of Tea Clippers allowed these sleek ships to sail with great ease and maneuverability throughout the 1800s and into the early 1900s.

SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='476' AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' GROUP BY PRODUCTS.PRODUCT_ID ORDER BY `price` ASC,PRODUCTS.PRODUCT_NAME, PRODUCT_ACTIVE DESC

Similar to Famous Tea Clippers

Famous Tea Clippers

Named Tea Clippers because of the tea trade with the East and the sails that allowed them to “clip” through the water, these ships were designed to transport large amounts of cargo at a high rate of speed. Handcrafted Model Ships is proud to offer an amazing collection of Tea Clippers from delightful 7” models to sophisticated 50” replicas. The fleet Flying Cloud and the stunning Cutty Sark, among others, were amazing vessels that cut through the water with both power and grace. The complex sails of Tea Clippers allowed these sleek ships to sail with great ease and maneuverability throughout the 1800s and into the early 1900s.