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

Array ( [0] => 2286 [PRODUCT_CATEGORY_ID] => 2286 [1] => New Famous Ships [CATEGORY_NAME] => New Famous Ships [2] => [CATEGORY_HEADER] => [3] => famous ships,from movies and television,historically significant ships,pirate ships,blackbeards queen annes revenge,captain kidds pirate ships,pirates of the caribbean,privateers,calico jacks the william ,black barts royal fortune,henry averys the fancy,john halseys charles,edward englands the pearl,ed lows rose pink ,new pirate ships,john gows revenge,thomas tews amity,united states warships,new famous ships,New Famous Ships,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => famous ships,from movies and television,historically significant ships,pirate ships,blackbeards queen annes revenge,captain kidds pirate ships,pirates of the caribbean,privateers,calico jacks the william ,black barts royal fortune,henry averys the fancy,john halseys charles,edward englands the pearl,ed lows rose pink ,new pirate ships,john gows revenge,thomas tews amity,united states warships,new famous ships,New Famous Ships,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => New Famous Ships model ships are fully assembled and in stock. New Famous Ships model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => New Famous Ships model ships are fully assembled and in stock. New Famous Ships model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy New Famous Ships Models Assembled - Famous Ships Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy New Famous Ships Models Assembled - Famous Ships Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => new-famous-ships.php [FILENAME] => new-famous-ships.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => New Famous Ship [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 2834 [CATEGORY_PICTURE] => 2834 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(162 Items) Sort:
Page: 1    
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2286' AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' GROUP BY PRODUCTS.PRODUCT_ID ORDER BY PRODUCTS.PRODUCT_ID DESC, PRODUCT_ACTIVE DESC
Show: / page

Similar to New Famous Ships Models