Summer Sale ends Fri Aug 5th - Free shipping on orders $39 and above

Array ( [0] => 2319 [PRODUCT_CATEGORY_ID] => 2319 [1] => Vespucci [CATEGORY_NAME] => Vespucci [2] => [CATEGORY_HEADER] => [3] => tall ships,new tall ships,warships from the age of sail,hms victory,sovereign of the seas,uss constitution,san felipe,hms surprise,merchant tall ships,cutty sark,star of india,flying cloud,legendary pirate ships,blackbeards queen annes revenge,privateers,black barts royal fortune,pirates of the caribbean,calico jacks the william ,captain kidds pirate ships,famous tea clippers,cutty sark,flying cloud,flying fish,star of india,exploration ships from the age of discovery,santa maria,mayflower,santa maria,darwins hms beagle,famous navy training tall ships,uscg eagle,christian radich,danmark,gorch fock,vespucci,Vespucci,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => tall ships,new tall ships,warships from the age of sail,hms victory,sovereign of the seas,uss constitution,san felipe,hms surprise,merchant tall ships,cutty sark,star of india,flying cloud,legendary pirate ships,blackbeards queen annes revenge,privateers,black barts royal fortune,pirates of the caribbean,calico jacks the william ,captain kidds pirate ships,famous tea clippers,cutty sark,flying cloud,flying fish,star of india,exploration ships from the age of discovery,santa maria,mayflower,santa maria,darwins hms beagle,famous navy training tall ships,uscg eagle,christian radich,danmark,gorch fock,vespucci,Vespucci,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => Vespucci model ships are fully assembled and in stock. Vespucci model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => Vespucci model ships are fully assembled and in stock. Vespucci model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy Vespucci Models Assembled - Tall Ships Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy Vespucci Models Assembled - Tall Ships Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => vespucci-wood-tall-ship-model.php [FILENAME] => vespucci-wood-tall-ship-model.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Vespucci [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 741 [CATEGORY_PICTURE] => 741 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(2 Items) Sort:
Items: 1 to 2
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2319' 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 Vespucci Models