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

> Page 2

Array ( [0] => 350 [PRODUCT_CATEGORY_ID] => 350 [1] => Titanic Related Cruise Ships [CATEGORY_NAME] => Titanic Related Cruise Ships [2] => [CATEGORY_HEADER] => [3] => RMS Titanic, The Titanic, Cruise Ship Model, Cruise Ship Models, The Titanic Model, The Titanic Replica, Cruise Ship Replica, Cruise Ship Replicas, Cruise Ship Model for Sale, Model Cruise Ships for Sale [PRODUCT_META_TAG] => RMS Titanic, The Titanic, Cruise Ship Model, Cruise Ship Models, The Titanic Model, The Titanic Replica, Cruise Ship Replica, Cruise Ship Replicas, Cruise Ship Model for Sale, Model Cruise Ships for Sale [4] => Interested in model cruise ships? We have many to choose from, including famous cruise ships like the Titanic, plus other decor ideas and gifts. FREE shipping on orders over $39. [PRODUCT_META_DESCRIPTION] => Interested in model cruise ships? We have many to choose from, including famous cruise ships like the Titanic, plus other decor ideas and gifts. FREE shipping on orders over $39. [5] => The Titanic Replica - Buy Titanic Toys, Titanic Toy, Titanic Memorabilia, RMS Titanic [PRODUCT_PAGE_TITLE] => The Titanic Replica - Buy Titanic Toys, Titanic Toy, Titanic Memorabilia, RMS Titanic [6] => [PRODUCT_SEO] => [7] => whit-star-cunard-cruise-ship-models.php [FILENAME] => whit-star-cunard-cruise-ship-models.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Titanic Related Cruise Ship [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 885 [CATEGORY_PICTURE] => 885 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(45 Items) Sort:
Page:  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='350' 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