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

Array ( [0] => 2353 [PRODUCT_CATEGORY_ID] => 2353 [1] => Cast Iron [CATEGORY_NAME] => Cast Iron [2] => [CATEGORY_HEADER] => [3] => new items,wholesale famous ships,new famous ships,from movies and television,historically significant ships,rms titanic,uss constitution,santa maria,hms victory,mayflower,cutty sark,united states warships,pirate ships,new 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 ,john gows revenge,thomas tews amity,civil war ships,monitor,css alabama,css virginia,h. l. hunley,wholesale tall ships,new tall ships,famous navy training tall ships,uscg eagle,christian radich,danmark,gorch fock,vespucci,warships from the age of sail,hms victory,sovereign of the seas,uss constitution,san felipe,hms surprise,exploration ships from the age of discovery,santa maria,mayflower,santa maria,darwins hms beagle,famous whaling ships ,kate cory whale boat,charles w. morgan,famous tea clippers,cutty sark,flying cloud,flying fish,star of india,merchant tall ships,cutty sark,star of india,flying cloud,tall ships currently sailing ,uscg eagle,christian radich,danmark,gorch fock,legendary pirate ships,blackbeards queen annes revenge,privateers,black barts royal fortune,pirates of the caribbean,calico jacks the william ,captain kidds pirate ships,wholesale sail boats,new sail boats,famous americas cup yachts,defender,america,ranger,columbia,endeavour,enterprise,americas cup challenger,remote control famous americas cup yachts,sloop sailboats ,bermuda sloop,old ironsides sloop,modern sloop,newport sloop,j yachts,enterprise,shamrock,ranger,intrepid,endeavour,table centerpiece sailboats,famous historic sailboats,atlantic,columbia,bluenose,america,enterprise,endeavour,floating sail boats,rc sailboats,wholesale pirate ships,captain kidds pirate ships,calico jacks the william ,black barts royal fortune,privateers,pirates of the caribbean,blackbeards queen annes revenge,wholesale cruise ships,new cruise ships,led lighted cruise ships,pre 1955 cruise ships,remote control cruise ships,post 1950s cruise ships,titanic related cruise ships,rms titanic,wholesale coast guard,wholesale fishing boats,new fishing boats,decorative fishing boats,fishing boats from movies and tv,wholesale rc boats,new rc boats,remote control cruise ships,remote control sailboats,museum quality rc speedboats,wholesale speed boats,best selling nautical decor items,wholesale help center,dropship faq,as seen on,track shipment,shipping information,return policy,contact us,about us,link partners,become a dealer,quantity discounts,faq,terms,privacy policy,buyers guide,our guarantee,packaging,custom orders,wholesale ships in a bottle,wholesale civil war ships,h. l. hunley,css virginia,css alabama,wholesale nautical decor,new items,wholesale nautical bells,new nautical bells,nautical hand bells,nautical chrome ship bells,nautical brass ship bells,nautical cast iron bells,nautical antique copper bells,cast iron,Wholesale Cast Iron,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => new items,wholesale famous ships,new famous ships,from movies and television,historically significant ships,rms titanic,uss constitution,santa maria,hms victory,mayflower,cutty sark,united states warships,pirate ships,new 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 ,john gows revenge,thomas tews amity,civil war ships,monitor,css alabama,css virginia,h. l. hunley,wholesale tall ships,new tall ships,famous navy training tall ships,uscg eagle,christian radich,danmark,gorch fock,vespucci,warships from the age of sail,hms victory,sovereign of the seas,uss constitution,san felipe,hms surprise,exploration ships from the age of discovery,santa maria,mayflower,santa maria,darwins hms beagle,famous whaling ships ,kate cory whale boat,charles w. morgan,famous tea clippers,cutty sark,flying cloud,flying fish,star of india,merchant tall ships,cutty sark,star of india,flying cloud,tall ships currently sailing ,uscg eagle,christian radich,danmark,gorch fock,legendary pirate ships,blackbeards queen annes revenge,privateers,black barts royal fortune,pirates of the caribbean,calico jacks the william ,captain kidds pirate ships,wholesale sail boats,new sail boats,famous americas cup yachts,defender,america,ranger,columbia,endeavour,enterprise,americas cup challenger,remote control famous americas cup yachts,sloop sailboats ,bermuda sloop,old ironsides sloop,modern sloop,newport sloop,j yachts,enterprise,shamrock,ranger,intrepid,endeavour,table centerpiece sailboats,famous historic sailboats,atlantic,columbia,bluenose,america,enterprise,endeavour,floating sail boats,rc sailboats,wholesale pirate ships,captain kidds pirate ships,calico jacks the william ,black barts royal fortune,privateers,pirates of the caribbean,blackbeards queen annes revenge,wholesale cruise ships,new cruise ships,led lighted cruise ships,pre 1955 cruise ships,remote control cruise ships,post 1950s cruise ships,titanic related cruise ships,rms titanic,wholesale coast guard,wholesale fishing boats,new fishing boats,decorative fishing boats,fishing boats from movies and tv,wholesale rc boats,new rc boats,remote control cruise ships,remote control sailboats,museum quality rc speedboats,wholesale speed boats,best selling nautical decor items,wholesale help center,dropship faq,as seen on,track shipment,shipping information,return policy,contact us,about us,link partners,become a dealer,quantity discounts,faq,terms,privacy policy,buyers guide,our guarantee,packaging,custom orders,wholesale ships in a bottle,wholesale civil war ships,h. l. hunley,css virginia,css alabama,wholesale nautical decor,new items,wholesale nautical bells,new nautical bells,nautical hand bells,nautical chrome ship bells,nautical brass ship bells,nautical cast iron bells,nautical antique copper bells,cast iron,Wholesale Cast Iron,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => Wholesale Cast Iron model ships are fully assembled and in stock. Cast Iron model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => Wholesale Cast Iron model ships are fully assembled and in stock. Cast Iron model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Wholesale Cast Iron Models Assembled - Wholesale Replica - Wholesale Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Wholesale Cast Iron Models Assembled - Wholesale Replica - Wholesale Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => nautical-cast-iron-decor.php [FILENAME] => nautical-cast-iron-decor.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Cast Iron [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 7272 [CATEGORY_PICTURE] => 7272 [16] => product [CATEGORY_TYPE] => product [17] => 0 [FEATURED] => 0 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => cast-iron.jpg [HOME_IMAGE] => cast-iron.jpg [SUPER_NAME] => )
(1522 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='2353' 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
Show: / page