Thanksgiving Sale ends Monday Nov 26th - Free shipping over $39
Holiday Sale Click for Great Holiday Deals!

Array ( [0] => 2572 [PRODUCT_CATEGORY_ID] => 2572 [1] => Flying Dutchman [CATEGORY_NAME] => Flying Dutchman [2] => [CATEGORY_HEADER] => [3] => famous ships,new famous ships,from movies and television,historically significant ships,rms titanic,uss constitution,cutty sark,pirate ships,blackbeards queen annes revenge,captain kidds pirate ships,pirates of the caribbean,privateers,calico jacks the william ,black barts royal fortune,flying dutchman,Flying Dutchman, model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => famous ships,new famous ships,from movies and television,historically significant ships,rms titanic,uss constitution,cutty sark,pirate ships,blackbeards queen annes revenge,captain kidds pirate ships,pirates of the caribbean,privateers,calico jacks the william ,black barts royal fortune,flying dutchman,Flying Dutchman, model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => Flying Dutchman model ships are fully assembled and in stock. Flying Dutchman model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => Flying Dutchman model ships are fully assembled and in stock. Flying Dutchman model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy Flying Dutchman Models Assembled - Famous Ships Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy Flying Dutchman Models Assembled - Famous Ships Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => flying-dutchman-model-ship-pirates-of-the-carribbean.php [FILENAME] => flying-dutchman-model-ship-pirates-of-the-carribbean.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Flying Dutchman [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 11285 [CATEGORY_PICTURE] => 11285 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(11 Items) Sort:
Items: 1 to 11
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2572' 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

Similar to Flying Dutchman Models