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

Array ( [0] => 2161 [PRODUCT_CATEGORY_ID] => 2161 [1] => Nautical Photo & Card Holders [CATEGORY_NAME] => Nautical Photo & Card Holders [2] => [CATEGORY_HEADER] => [3] => handcrafted beach decor,beach wall decor,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered buoys,floaters & bobbers,life rings,titanic life rings,decorative life rings,life ring clocks,oars & paddles,decorative wooden oars,wooden oars w/ hanging hooks,rustic wooden oars,university/collegiate wooden oars,rowing club wooden oars,wooden oars under 50",wooden oars over 50,decorative paddles,mounted fish & sealife,bottom fish,offshore fish,freshwater fish,nautical animals,inshore fish,billfish,sharks,beach accents,beach signs,decorative ship wheels,decorative wood anchors,nautical coasters,shell decorations,nautical art,other beach accents,nautical salt and pepper shakers,signs & flags,brass nautical signs,beach signs,pirate signs,nautical flags,rustic iron signs,chrome nautical signs,life rings,titanic life rings,decorative life rings,life ring clocks,oars & paddles,decorative wooden oars,wooden oars w/ hanging hooks,rustic wooden oars,university/collegiate wooden oars,rowing club wooden oars,wooden oars under 50",wooden oars over 50,decorative paddles,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered buoys,floaters & bobbers,coastal 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 case & table combinations,lighthouses,lighthouses under $49,wooden 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,marblehead lighthouses,fire island lighthouses,oak island lighthouses,bodie island lighthouses,cape henry lighthouses,american lighthouses,st. augustine lighthouses,white shoal lighthouses,assateague lighthouses,montauk lighthouses,split rock lighthouses,gifts under $20,life rings,titanic life rings,decorative life rings,life ring clocks,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered buoys,floaters & bobbers,nautical fun for kids,spyglasses,nautical key chains,nautical paperweights,ships in a bottle,pirate ship in bottle,nautical flags,nautical salt and pepper shakers,brass pocket compasses,floating sail boats,wooden ship wheels,chrome plaques,nautical brass signs,nautical bottle openers,wedding decor,wedding centerpieces,wedding table decor,nautical flags,nautical coasters,nautical bottle openers,wedding favors,wedding table decor,nautical coasters,nautical bottle openers,compasses under $20 retail,nautical paperweights,spyglasses,nautical placecard and photo holders,Nautical Placecard and Photo Holders,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => handcrafted beach decor,beach wall decor,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered buoys,floaters & bobbers,life rings,titanic life rings,decorative life rings,life ring clocks,oars & paddles,decorative wooden oars,wooden oars w/ hanging hooks,rustic wooden oars,university/collegiate wooden oars,rowing club wooden oars,wooden oars under 50",wooden oars over 50,decorative paddles,mounted fish & sealife,bottom fish,offshore fish,freshwater fish,nautical animals,inshore fish,billfish,sharks,beach accents,beach signs,decorative ship wheels,decorative wood anchors,nautical coasters,shell decorations,nautical art,other beach accents,nautical salt and pepper shakers,signs & flags,brass nautical signs,beach signs,pirate signs,nautical flags,rustic iron signs,chrome nautical signs,life rings,titanic life rings,decorative life rings,life ring clocks,oars & paddles,decorative wooden oars,wooden oars w/ hanging hooks,rustic wooden oars,university/collegiate wooden oars,rowing club wooden oars,wooden oars under 50",wooden oars over 50,decorative paddles,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered buoys,floaters & bobbers,coastal 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 case & table combinations,lighthouses,lighthouses under $49,wooden 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,marblehead lighthouses,fire island lighthouses,oak island lighthouses,bodie island lighthouses,cape henry lighthouses,american lighthouses,st. augustine lighthouses,white shoal lighthouses,assateague lighthouses,montauk lighthouses,split rock lighthouses,gifts under $20,life rings,titanic life rings,decorative life rings,life ring clocks,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered buoys,floaters & bobbers,nautical fun for kids,spyglasses,nautical key chains,nautical paperweights,ships in a bottle,pirate ship in bottle,nautical flags,nautical salt and pepper shakers,brass pocket compasses,floating sail boats,wooden ship wheels,chrome plaques,nautical brass signs,nautical bottle openers,wedding decor,wedding centerpieces,wedding table decor,nautical flags,nautical coasters,nautical bottle openers,wedding favors,wedding table decor,nautical coasters,nautical bottle openers,compasses under $20 retail,nautical paperweights,spyglasses,nautical placecard and photo holders,Nautical Placecard and Photo Holders,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => Nautical Placecard and Photo Holders model ships are fully assembled and in stock. Nautical Placecard and Photo Holders model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => Nautical Placecard and Photo Holders model ships are fully assembled and in stock. Nautical Placecard and Photo Holders model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy Nautical Placecard and Photo Holders Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy Nautical Placecard and Photo Holders Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => nautical-placecard-and-photo-holders.php [FILENAME] => nautical-placecard-and-photo-holders.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Nautical Photo & Card Holder [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 4719 [CATEGORY_PICTURE] => 4719 [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='2161' 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