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

Array ( [0] => 2440 [PRODUCT_CATEGORY_ID] => 2440 [1] => Cast Iron Key Chains [CATEGORY_NAME] => Cast Iron Key Chains [2] => [CATEGORY_HEADER] => [3] => new items,shot glasses,plates & bowls,napkin rings & holders,towel holders,candle holders,nautical barware,nautical bottle openers,trivets,life rings,new life rings,decorative life rings,decorative life ring clocks,decorative life ring mirrors,decorative titanic life rings,decorative buoys,new decorative buoys,decorative glass floats,decorative wooden buoys,decorative lobster buoys,decorative squared buoys,oars & paddles,new oars & paddles,decorative wooden oars,decorative wooden oars w/ hanging hooks,decorative wooden oars under 50",decorative wooden oars over 50",decorative paddles,throw pillows,nautical signs,new nautical signs,beach signs,pirate signs,nautical alphabet flags and signs,nautical metal signs,cast iron ,nautical cast iron bells,cast iron paperweights,cast iron door stoppers/knockers,cast iron bottle openers,nautical metal signs,wall mounted hooks/key racks,plates & bowls,towel holders,candle holders,decorative cast iron rustic sealife,cast iron key chains,,beach decor,beach,coastal,living,decor,decorating,house,bedroom decor,gift,decor,ideas [PRODUCT_META_TAG] => new items,shot glasses,plates & bowls,napkin rings & holders,towel holders,candle holders,nautical barware,nautical bottle openers,trivets,life rings,new life rings,decorative life rings,decorative life ring clocks,decorative life ring mirrors,decorative titanic life rings,decorative buoys,new decorative buoys,decorative glass floats,decorative wooden buoys,decorative lobster buoys,decorative squared buoys,oars & paddles,new oars & paddles,decorative wooden oars,decorative wooden oars w/ hanging hooks,decorative wooden oars under 50",decorative wooden oars over 50",decorative paddles,throw pillows,nautical signs,new nautical signs,beach signs,pirate signs,nautical alphabet flags and signs,nautical metal signs,cast iron ,nautical cast iron bells,cast iron paperweights,cast iron door stoppers/knockers,cast iron bottle openers,nautical metal signs,wall mounted hooks/key racks,plates & bowls,towel holders,candle holders,decorative cast iron rustic sealife,cast iron key chains,,beach decor,beach,coastal,living,decor,decorating,house,bedroom decor,gift,decor,ideas [4] => Cast Iron Key Chains Beach Decorating Gifts are in stock and ready to ship. Cast Iron Key Chains Nautical Decor and Gifts. Buy Cast Iron Key Chains nautical decor now. [PRODUCT_META_DESCRIPTION] => Cast Iron Key Chains Beach Decorating Gifts are in stock and ready to ship. Cast Iron Key Chains Nautical Decor and Gifts. Buy Cast Iron Key Chains nautical decor now. [5] => Cast Iron Key Chains - Beach Decor Living Ideas [PRODUCT_PAGE_TITLE] => Cast Iron Key Chains - Beach Decor Living Ideas [6] => [PRODUCT_SEO] => [7] => cast-iron-nautical-key-chains.php [FILENAME] => cast-iron-nautical-key-chains.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Cast Iron Key Chains [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 8566 [CATEGORY_PICTURE] => 8566 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 1 [SHOW_ALL] => 1 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(46 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='2440') 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 Cast Iron Key Chains