Winter Sale ends Dec 15th plus FREE shipping over $39

Array ( [0] => 2357 [PRODUCT_CATEGORY_ID] => 2357 [1] => Door Stoppers [CATEGORY_NAME] => Door Stoppers [2] => [CATEGORY_HEADER] => [3] => nautical accents,new nautical accents,christmas ornaments,model ship christmas ornaments,nautical christmas tree ornaments,beach christmas tree ornaments,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,cast iron ,nautical cast iron bells,cast iron paperweights,cast iron door stoppers/knockers,chrome,wooden,brass,nautical,gift,decor,nautical gift,nautical decor [PRODUCT_META_TAG] => nautical accents,new nautical accents,christmas ornaments,model ship christmas ornaments,nautical christmas tree ornaments,beach christmas tree ornaments,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,cast iron ,nautical cast iron bells,cast iron paperweights,cast iron door stoppers/knockers,chrome,wooden,brass,nautical,gift,decor,nautical gift,nautical decor [4] => Cast Iron Door Stoppers/Knockers Nautical Gifts are in stock and ready to ship. Cast Iron Door Stoppers/Knockers Nautical Decor and Gifts. Buy Cast Iron Door Stoppers/Knockers nautical decor now. [PRODUCT_META_DESCRIPTION] => Cast Iron Door Stoppers/Knockers Nautical Gifts are in stock and ready to ship. Cast Iron Door Stoppers/Knockers Nautical Decor and Gifts. Buy Cast Iron Door Stoppers/Knockers nautical decor now. [5] => Cast Iron Door Stoppers/Knockers - Nautical Accents Nautical Decor Gifts [PRODUCT_PAGE_TITLE] => Cast Iron Door Stoppers/Knockers - Nautical Accents Nautical Decor Gifts [6] => [PRODUCT_SEO] => [7] => nautical-cast-iron-door-stoppers.php [FILENAME] => nautical-cast-iron-door-stoppers.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Door Stoppers [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 4336 [CATEGORY_PICTURE] => 4336 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 1 [SHOW_ALL] => 1 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(42 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='2357') 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

Similar to Door Stoppers