Lowest Prices Ever - Free Shipping over $39 - Delivery within 5-7 business days
Holiday Sale

Array ( [0] => 2288 [PRODUCT_CATEGORY_ID] => 2288 [1] => New Pirate Ships [CATEGORY_NAME] => New Pirate 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,New Pirate 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,New Pirate Ships,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => New Pirate Ships model ships are fully assembled and in stock. New Pirate Ships model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => New Pirate Ships model ships are fully assembled and in stock. New Pirate Ships model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy New Pirate Ships Models Assembled - Famous Ships Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy New Pirate Ships Models Assembled - Famous Ships Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => new-pirate-ships.php [FILENAME] => new-pirate-ships.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => New Pirate Ship [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 2470 [CATEGORY_PICTURE] => 2470 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(60 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='2288' 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