Black Friday Sale ends Nov 27th plus FREE shipping over $39
Holiday Sale Click for Great Holiday Deals!

Array ( [0] => 2042 [PRODUCT_CATEGORY_ID] => 2042 [1] => Wholesale Pirate Ships [CATEGORY_NAME] => Wholesale Pirate Ships [2] => [CATEGORY_HEADER] => [3] => Wholesale pirate ship model, pirate model ship, pirate model ships, pirates of the caribbean model, black pearl model, blackbeard pirate ship, remote control pirate ships, blackbeard ship, remote control pirate ship, r c pirate ship [PRODUCT_META_TAG] => Wholesale pirate ship model, pirate model ship, pirate model ships, pirates of the caribbean model, black pearl model, blackbeard pirate ship, remote control pirate ships, blackbeard ship, remote control pirate ship, r c pirate ship [4] => Large wholesale selection of [PRODUCT_META_DESCRIPTION] => Large wholesale selection of [5] => Wholesale Pirate Ship Models - Blackbeard Pirate Ship, Black Pearl Model, Pirates of the Caribbean Model [PRODUCT_PAGE_TITLE] => Wholesale Pirate Ship Models - Blackbeard Pirate Ship, Black Pearl Model, Pirates of the Caribbean Model [6] => [PRODUCT_SEO] => [7] => wholesale-pirate-ship-models.php [FILENAME] => wholesale-pirate-ship-models.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Wholesale Pirate Ship [12] => [H2] => [13] => The world's most infamous captains and their legendary ships Browse %count% styles priced from %lowest% Fearsome and mighty, yet fascinatingly enchanting [POINTS] => The world's most infamous captains and their legendary ships Browse %count% styles priced from %lowest% Fearsome and mighty, yet fascinatingly enchanting [14] => [CATEGORY_SPLASH] => [15] => 2457 [CATEGORY_PICTURE] => 2457 [16] => product [CATEGORY_TYPE] => product [17] => 0 [FEATURED] => 0 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 1 [SHOW_ALL] => 1 [21] => 512.jpg [HOME_IMAGE] => 512.jpg [SUPER_NAME] => )
(44 Items) Sort:
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE (PRODUCT_BRIDGE.CATEGORY_ID='2042') 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 Wholesale Pirate Ships Models