Fall Sale ends Oct 27th plus FREE shipping over $39

Array ( [0] => 2358 [PRODUCT_CATEGORY_ID] => 2358 [1] => Paperweights [CATEGORY_NAME] => Paperweights [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,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,chrome,wooden,brass,nautical,gift,decor,nautical gift,nautical decor [4] => Cast Iron Paperweights Nautical Gifts are in stock and ready to ship. Cast Iron Paperweights Nautical Decor and Gifts. Buy Cast Iron Paperweights nautical decor now. [PRODUCT_META_DESCRIPTION] => Cast Iron Paperweights Nautical Gifts are in stock and ready to ship. Cast Iron Paperweights Nautical Decor and Gifts. Buy Cast Iron Paperweights nautical decor now. [5] => Cast Iron Paperweights - Nautical Accents Nautical Decor Gifts [PRODUCT_PAGE_TITLE] => Cast Iron Paperweights - Nautical Accents Nautical Decor Gifts [6] => [PRODUCT_SEO] => [7] => nautical-cast-iron-paperweights.php [FILENAME] => nautical-cast-iron-paperweights.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Paperweights [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 7255 [CATEGORY_PICTURE] => 7255 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(39 Items) Sort:
Items: 1 to 39
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2358' 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

Similar to Paperweights