Summer Sale ends Fri Sept 23th - Free shipping on orders $39 and above

Array ( [0] => 287 [PRODUCT_CATEGORY_ID] => 287 [1] => Lynx [CATEGORY_NAME] => Lynx [2] => [CATEGORY_HEADER] => [3] => tall ships,warships from the age of sail,hms victory,sovereign of the seas,uss constitution,merchant tall ships,cutty sark,star of india,flying cloud,flying fish,balt clipper - harvey,hms bounty,gothenburg,thermopylae,spanish galleon,legendary pirate ships,famous tea clippers,cutty sark,flying cloud,flying fish,star of india,exploration ships from the age of discovery,golden hind,nina,pinta,santa maria,mayflower,hms endeavour,famous navy training tall ships,uscg eagle,amerigo vespucci,christian radich,danmark,gorch fock,tall ships currently sailing ,uscg eagle,amerigo vespucci,christian radich,danmark,californian,dapper tom 24",gorch fock,pride of baltimore,lynx,Lynx,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => tall ships,warships from the age of sail,hms victory,sovereign of the seas,uss constitution,merchant tall ships,cutty sark,star of india,flying cloud,flying fish,balt clipper - harvey,hms bounty,gothenburg,thermopylae,spanish galleon,legendary pirate ships,famous tea clippers,cutty sark,flying cloud,flying fish,star of india,exploration ships from the age of discovery,golden hind,nina,pinta,santa maria,mayflower,hms endeavour,famous navy training tall ships,uscg eagle,amerigo vespucci,christian radich,danmark,gorch fock,tall ships currently sailing ,uscg eagle,amerigo vespucci,christian radich,danmark,californian,dapper tom 24",gorch fock,pride of baltimore,lynx,Lynx,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => Lynx model ships are fully assembled and in stock. Lynx model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => Lynx model ships are fully assembled and in stock. Lynx model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy Lynx Models Assembled - Tall Ships Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy Lynx Models Assembled - Tall Ships Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => lynx-top-sail-schooner-privateer.php [FILENAME] => lynx-top-sail-schooner-privateer.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Lynx [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 0 [CATEGORY_PICTURE] => 0 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(1 Items) Sort:
Items: 1 to 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='287' 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