Fall Into Savings Sale ends Fri Oct. 7th - Free shipping on orders $39 and above

Array ( [0] => 2240 [PRODUCT_CATEGORY_ID] => 2240 [1] => Nautical Mirrors [CATEGORY_NAME] => Nautical Mirrors [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,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,chrome,wooden,brass,nautical,gift,decor,nautical gift,nautical decor [4] => Nautical Mirrors Nautical Gifts are in stock and ready to ship. Nautical Mirrors Nautical Decor and Gifts. Buy Nautical Mirrors nautical decor now. [PRODUCT_META_DESCRIPTION] => Nautical Mirrors Nautical Gifts are in stock and ready to ship. Nautical Mirrors Nautical Decor and Gifts. Buy Nautical Mirrors nautical decor now. [5] => Nautical Mirrors - Nautical Accents Nautical Decor Gifts [PRODUCT_PAGE_TITLE] => Nautical Mirrors - Nautical Accents Nautical Decor Gifts [6] => [PRODUCT_SEO] => [7] => decorative-nautical-mirrors.php [FILENAME] => decorative-nautical-mirrors.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Nautical Mirror [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 5608 [CATEGORY_PICTURE] => 5608 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(89 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='2240' 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
Show: / page