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

Array ( [0] => 2118 [PRODUCT_CATEGORY_ID] => 2118 [1] => Other Nautical Accents [CATEGORY_NAME] => Other Nautical Accents [2] => [CATEGORY_HEADER] => [3] => nautical accents,new nautical accents,christmas tree ornaments/toppers,nautical bottle openers,nautical key chains,antique copper key chains,chrome key chains,brass key chains,nautical diving helmets,nautical paperweights,nautical fun for kids,nautical door stoppers/knockers,nautical hooks / hide a keys / key racks,nautical book ends,decorative nautical pillows,pirate decor,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,pirate signs,pirate compasses,compasses under $20 retail,spyglasses,pirate decorative ship wheels,anchor decor,decorative wooden rustic anchors,decorative metal anchors,nautical mirrors,lighthouse salt & pepper shakers,nautical napkin rings,brass napkin rings,chrome napkin rings,antique copper napkin rings,nautical art,other nautical accents,chrome,wooden,brass,nautical,gift,decor,nautical gift,nautical decor [PRODUCT_META_TAG] => nautical accents,new nautical accents,christmas tree ornaments/toppers,nautical bottle openers,nautical key chains,antique copper key chains,chrome key chains,brass key chains,nautical diving helmets,nautical paperweights,nautical fun for kids,nautical door stoppers/knockers,nautical hooks / hide a keys / key racks,nautical book ends,decorative nautical pillows,pirate decor,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,pirate signs,pirate compasses,compasses under $20 retail,spyglasses,pirate decorative ship wheels,anchor decor,decorative wooden rustic anchors,decorative metal anchors,nautical mirrors,lighthouse salt & pepper shakers,nautical napkin rings,brass napkin rings,chrome napkin rings,antique copper napkin rings,nautical art,other nautical accents,chrome,wooden,brass,nautical,gift,decor,nautical gift,nautical decor [4] => Other Nautical Accents Nautical Gifts are in stock and ready to ship. Other Nautical Accents Nautical Decor and Gifts. Buy Other Nautical Accents nautical decor now. [PRODUCT_META_DESCRIPTION] => Other Nautical Accents Nautical Gifts are in stock and ready to ship. Other Nautical Accents Nautical Decor and Gifts. Buy Other Nautical Accents nautical decor now. [5] => Other Nautical Accents - Nautical Accents Nautical Decor Gifts [PRODUCT_PAGE_TITLE] => Other Nautical Accents - Nautical Accents Nautical Decor Gifts [6] => [PRODUCT_SEO] => [7] => decorative-nautical-gifts.php [FILENAME] => decorative-nautical-gifts.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Other Nautical Accent [12] => [H2] => [13] => Choose between a variety of nautical items at a low price Browse %count% styles priced from %lowest% Shot glasses, paper clips, and more available [POINTS] => Choose between a variety of nautical items at a low price Browse %count% styles priced from %lowest% Shot glasses, paper clips, and more available [14] => [CATEGORY_SPLASH] => [15] => 4358 [CATEGORY_PICTURE] => 4358 [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:
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE (PRODUCT_BRIDGE.CATEGORY_ID='2118') 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