All models fully assembled -  Free Shipping over $199

Array ( [0] => 2598 [PRODUCT_CATEGORY_ID] => 2598 [1] => Cast Iron Decor Weekly Deals [CATEGORY_NAME] => Cast Iron Decor Weekly Deals [2] => [CATEGORY_HEADER] => [3] => top sellers,nautical decor top sellers,model ship top sellers,beach & sealife decor top sellers,cast iron decor top sellers,clearance sale,model ship clearance sale,nautical decor clearance sale,beach & sealife decor clearance sale,cast iron decor clearance sale,,beach decor,beach,coastal,living,decor,decorating,house,bedroom decor,gift,decor,ideas [PRODUCT_META_TAG] => top sellers,nautical decor top sellers,model ship top sellers,beach & sealife decor top sellers,cast iron decor top sellers,clearance sale,model ship clearance sale,nautical decor clearance sale,beach & sealife decor clearance sale,cast iron decor clearance sale,,beach decor,beach,coastal,living,decor,decorating,house,bedroom decor,gift,decor,ideas [4] => Cast Iron Decor Clearance Sale Beach Decorating Gifts are in stock and ready to ship. Cast Iron Decor Clearance Sale Nautical Decor and Gifts. Buy Cast Iron Decor Clearance Sale nautical decor now. [PRODUCT_META_DESCRIPTION] => Cast Iron Decor Clearance Sale Beach Decorating Gifts are in stock and ready to ship. Cast Iron Decor Clearance Sale Nautical Decor and Gifts. Buy Cast Iron Decor Clearance Sale nautical decor now. [5] => Cast Iron Decor Clearance Sale - Beach Decor Living Ideas [PRODUCT_PAGE_TITLE] => Cast Iron Decor Clearance Sale - Beach Decor Living Ideas [6] => [PRODUCT_SEO] => [7] => cast-iron-decor-clearance-sale.php [FILENAME] => cast-iron-decor-clearance-sale.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Cast Iron Decor Weekly Deal [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 6559 [CATEGORY_PICTURE] => 6559 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [22] => HCI [CATEGORY_SITE] => HCI [SUPER_NAME] => )
(74 Items) Sort:
Items: 1 to 43
::SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2598' 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 LIMIT 0,48

Similar to Cast Iron Decor Weekly Deals Models