Summer Sale ends Fri Aug 26th - Free shipping on orders $39 and above

Array ( [0] => 1078 [PRODUCT_CATEGORY_ID] => 1078 [1] => Barnegat Lighthouses [CATEGORY_NAME] => Barnegat Lighthouses [2] => [CATEGORY_HEADER] => [3] => handcrafted beach decor,beach wall decor,floats/buoys,life rings,beach signs,oars & paddles,mounted fish & sealife,bottom fish,offshore fish,freshwater fish,nautical animals,inshore fish,billfish,sharks,beach art,beach art,gifts under $20,beach signs,life rings,floats/buoys,nautical fun for kids,spyglasses,toy ships & sailboats ,key chains,paperweights,ships in a bottle,pirate ship in bottle,brass pocket compasses,wooden ship wheels,chrome plaques,nautical brass signs,bottle openers,mounted fish & sealife,bottom fish,offshore fish,freshwater fish,nautical animals,inshore fish,billfish,sharks,oars & paddles,floats/buoys,life rings,beach signs,furniture,nautical tables & desks,canoe and lifeboat bookcases,nautical themed cabinets,nautical themed chairs,wooden sailors chests,additional nautical furniture,display cases & tables ,display tables,display cases,display case & table combinations,lighthouses,lighthouses under $49,electric lighthouses,wooden lighthouses,landscape lighthouses,lawn lighthouses,mailbox lighthouses,stucco lighthouses,lighthouses by name,cape hatteras lighthouses,west quoddy lighthouses,cape lookout lighthouses,cape canaveral lighthouses,cape may lighthouses,cape cod lighthouses,hilton head lighthouses,fenwick lighthouses,old saybrook lighthouses,patriot lighthouses,seul choix lighthouses,tybee island lighthouses,barnegat lighthouses,Barnegat Lighthouses,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => handcrafted beach decor,beach wall decor,floats/buoys,life rings,beach signs,oars & paddles,mounted fish & sealife,bottom fish,offshore fish,freshwater fish,nautical animals,inshore fish,billfish,sharks,beach art,beach art,gifts under $20,beach signs,life rings,floats/buoys,nautical fun for kids,spyglasses,toy ships & sailboats ,key chains,paperweights,ships in a bottle,pirate ship in bottle,brass pocket compasses,wooden ship wheels,chrome plaques,nautical brass signs,bottle openers,mounted fish & sealife,bottom fish,offshore fish,freshwater fish,nautical animals,inshore fish,billfish,sharks,oars & paddles,floats/buoys,life rings,beach signs,furniture,nautical tables & desks,canoe and lifeboat bookcases,nautical themed cabinets,nautical themed chairs,wooden sailors chests,additional nautical furniture,display cases & tables ,display tables,display cases,display case & table combinations,lighthouses,lighthouses under $49,electric lighthouses,wooden lighthouses,landscape lighthouses,lawn lighthouses,mailbox lighthouses,stucco lighthouses,lighthouses by name,cape hatteras lighthouses,west quoddy lighthouses,cape lookout lighthouses,cape canaveral lighthouses,cape may lighthouses,cape cod lighthouses,hilton head lighthouses,fenwick lighthouses,old saybrook lighthouses,patriot lighthouses,seul choix lighthouses,tybee island lighthouses,barnegat lighthouses,Barnegat Lighthouses,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => Barnegat Lighthouses model ships are fully assembled and in stock. Barnegat Lighthouses model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => Barnegat Lighthouses model ships are fully assembled and in stock. Barnegat Lighthouses model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy Barnegat Lighthouses Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy Barnegat Lighthouses Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => barnegat-lighthouses.php [FILENAME] => barnegat-lighthouses.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Barnegat Lighthous [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 3429 [CATEGORY_PICTURE] => 3429 [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='1078' 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

Similar to Barnegat Lighthouses Models