We are open! - Use coupon SAVE20 at checkout for extra 20% off!

Array ( [0] => 2607 [PRODUCT_CATEGORY_ID] => 2607 [1] => Tall Ship Christmas Ornaments [CATEGORY_NAME] => Tall Ship Christmas Ornaments [2] => [CATEGORY_HEADER] => [3] => tall ships,warships from the age of sail,uss constitution,merchant tall ships,cutty sark,flying cloud,famous tea clippers,cutty sark,flying cloud,exploration ships from the age of discovery,famous navy training tall ships,tall ship christmas ornaments,Tall Ship Christmas Ornaments, model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => tall ships,warships from the age of sail,uss constitution,merchant tall ships,cutty sark,flying cloud,famous tea clippers,cutty sark,flying cloud,exploration ships from the age of discovery,famous navy training tall ships,tall ship christmas ornaments,Tall Ship Christmas Ornaments, model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => Tall Ship Christmas Ornaments model ships are fully assembled and in stock. Tall Ship Christmas Ornaments model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => Tall Ship Christmas Ornaments model ships are fully assembled and in stock. Tall Ship Christmas Ornaments model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy Tall Ship Christmas Ornaments Models Assembled - Tall Ships Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy Tall Ship Christmas Ornaments Models Assembled - Tall Ships Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => wooden-model-ship-christmas-ornaments.php [FILENAME] => wooden-model-ship-christmas-ornaments.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Tall Ship Christmas Ornament [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 9144 [CATEGORY_PICTURE] => 9144 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(34 Items) Sort:
Items: 1 to 34
::SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2607' AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' AND PRODUCTS.DISCONTINUED='' and PRODUCTS.ISDELETED='0' GROUP BY PRODUCTS.PRODUCT_ID ORDER BY `price` ASC,PRODUCTS.PRODUCT_NAME, PRODUCT_ACTIVE DESC LIMIT 0,48

Similar to Tall Ship Christmas Ornaments Models