HOLIDAY SALE ends Dec 15th plus FREE shipping over $39
Category:
Array ( [0] => 508 [PRODUCT_CATEGORY_ID] => 508 [1] => Nautical Decor [CATEGORY_NAME] => Nautical Decor [2] => [CATEGORY_HEADER] => [3] => nautical decor,nautical gifts,decoration,nautical home decor,beach decor,home accents decor,brass compass,brass telescope,nautical decorating,brass nautical decor [PRODUCT_META_TAG] => nautical decor,nautical gifts,decoration,nautical home decor,beach decor,home accents decor,brass compass,brass telescope,nautical decorating,brass nautical decor [4] => Wide Selection of Nautical Decor in stock and ready to ship. Your finest source for authentic spyglasses, compasses, bells, ship wheels, and much more with Free Shipping. Quantity Discounts, Engraving Available. [PRODUCT_META_DESCRIPTION] => Wide Selection of Nautical Decor in stock and ready to ship. Your finest source for authentic spyglasses, compasses, bells, ship wheels, and much more with Free Shipping. Quantity Discounts, Engraving Available. [5] => Nautical Decorative Gift - [PRODUCT_PAGE_TITLE] => Nautical Decorative Gift - [6] => [PRODUCT_SEO] => [7] => nautical-decor.php [FILENAME] => nautical-decor.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Nautical Decor [12] => [H2] => [13] => [POINTS] => [14] =>
Spyglasses
[CATEGORY_SPLASH] =>
Spyglasses
[15] => 0 [CATEGORY_PICTURE] => 0 [16] => product [CATEGORY_TYPE] => product [17] => 0 [FEATURED] => 0 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(896 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='508' OR PRODUCT_BRIDGE.CATEGORY_ID='69' OR PRODUCT_BRIDGE.CATEGORY_ID='439' OR PRODUCT_BRIDGE.CATEGORY_ID='442' OR PRODUCT_BRIDGE.CATEGORY_ID='2096' OR PRODUCT_BRIDGE.CATEGORY_ID='2283' OR PRODUCT_BRIDGE.CATEGORY_ID='2296' OR PRODUCT_BRIDGE.CATEGORY_ID='470' OR PRODUCT_BRIDGE.CATEGORY_ID='2098' OR PRODUCT_BRIDGE.CATEGORY_ID='2099' OR PRODUCT_BRIDGE.CATEGORY_ID='2103' OR PRODUCT_BRIDGE.CATEGORY_ID='2104' OR PRODUCT_BRIDGE.CATEGORY_ID='2106' OR PRODUCT_BRIDGE.CATEGORY_ID='2300' OR PRODUCT_BRIDGE.CATEGORY_ID='518' OR PRODUCT_BRIDGE.CATEGORY_ID='443' OR PRODUCT_BRIDGE.CATEGORY_ID='452' OR PRODUCT_BRIDGE.CATEGORY_ID='1038' OR PRODUCT_BRIDGE.CATEGORY_ID='2091' OR PRODUCT_BRIDGE.CATEGORY_ID='2112' OR PRODUCT_BRIDGE.CATEGORY_ID='2295' OR PRODUCT_BRIDGE.CATEGORY_ID='520' OR PRODUCT_BRIDGE.CATEGORY_ID='363' OR PRODUCT_BRIDGE.CATEGORY_ID='1049' OR PRODUCT_BRIDGE.CATEGORY_ID='2167' OR PRODUCT_BRIDGE.CATEGORY_ID='2235' OR PRODUCT_BRIDGE.CATEGORY_ID='2297' OR PRODUCT_BRIDGE.CATEGORY_ID='525' OR PRODUCT_BRIDGE.CATEGORY_ID='84' OR PRODUCT_BRIDGE.CATEGORY_ID='361' OR PRODUCT_BRIDGE.CATEGORY_ID='369' OR PRODUCT_BRIDGE.CATEGORY_ID='463' OR PRODUCT_BRIDGE.CATEGORY_ID='464' OR PRODUCT_BRIDGE.CATEGORY_ID='1049' OR PRODUCT_BRIDGE.CATEGORY_ID='2233' OR PRODUCT_BRIDGE.CATEGORY_ID='2304' OR PRODUCT_BRIDGE.CATEGORY_ID='526' OR PRODUCT_BRIDGE.CATEGORY_ID='439' OR PRODUCT_BRIDGE.CATEGORY_ID='2140' OR PRODUCT_BRIDGE.CATEGORY_ID='2201' OR PRODUCT_BRIDGE.CATEGORY_ID='2303' OR PRODUCT_BRIDGE.CATEGORY_ID='529' OR PRODUCT_BRIDGE.CATEGORY_ID='86' OR PRODUCT_BRIDGE.CATEGORY_ID='442' OR PRODUCT_BRIDGE.CATEGORY_ID='1138' OR PRODUCT_BRIDGE.CATEGORY_ID='2264' OR PRODUCT_BRIDGE.CATEGORY_ID='2265' OR PRODUCT_BRIDGE.CATEGORY_ID='2301' OR PRODUCT_BRIDGE.CATEGORY_ID='530' OR PRODUCT_BRIDGE.CATEGORY_ID='2155' OR PRODUCT_BRIDGE.CATEGORY_ID='2242' OR PRODUCT_BRIDGE.CATEGORY_ID='2243' OR PRODUCT_BRIDGE.CATEGORY_ID='2244' OR PRODUCT_BRIDGE.CATEGORY_ID='2247' OR PRODUCT_BRIDGE.CATEGORY_ID='2298' OR PRODUCT_BRIDGE.CATEGORY_ID='1153' OR PRODUCT_BRIDGE.CATEGORY_ID='88' OR PRODUCT_BRIDGE.CATEGORY_ID='362' OR PRODUCT_BRIDGE.CATEGORY_ID='2236' OR PRODUCT_BRIDGE.CATEGORY_ID='2237' OR PRODUCT_BRIDGE.CATEGORY_ID='2255' OR PRODUCT_BRIDGE.CATEGORY_ID='2440' OR PRODUCT_BRIDGE.CATEGORY_ID='413' OR PRODUCT_BRIDGE.CATEGORY_ID='2110' OR PRODUCT_BRIDGE.CATEGORY_ID='2111' OR PRODUCT_BRIDGE.CATEGORY_ID='466' OR PRODUCT_BRIDGE.CATEGORY_ID='2116' OR PRODUCT_BRIDGE.CATEGORY_ID='2117' OR PRODUCT_BRIDGE.CATEGORY_ID='2294' OR PRODUCT_BRIDGE.CATEGORY_ID='2176' OR PRODUCT_BRIDGE.CATEGORY_ID='2342' OR PRODUCT_BRIDGE.CATEGORY_ID='2344' OR PRODUCT_BRIDGE.CATEGORY_ID='2345' OR PRODUCT_BRIDGE.CATEGORY_ID='2346') 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