Summer Sale ends Fri Aug 26th - Free shipping on orders $39 and above

Array ( [0] => 414 [PRODUCT_CATEGORY_ID] => 414 [1] => Chrome Plaques [CATEGORY_NAME] => Chrome Plaques [2] => [CATEGORY_HEADER] => [3] => Chrome plaques, chrome wall signs, chrome beach decor, beach decor, beach wall signs, to the beach signs, chrome captain signs, captain signs, door signs, chrome door signs, wall and door signs [PRODUCT_META_TAG] => Chrome plaques, chrome wall signs, chrome beach decor, beach decor, beach wall signs, to the beach signs, chrome captain signs, captain signs, door signs, chrome door signs, wall and door signs [4] => Interested in Nautical Accents? We have many to choose from plus hundreds of other ideas and gifts. FREE shipping on orders over $39. Only at www.handcraftednauticaldecor.com [PRODUCT_META_DESCRIPTION] => Interested in Nautical Accents? We have many to choose from plus hundreds of other ideas and gifts. FREE shipping on orders over $39. Only at www.handcraftednauticaldecor.com [5] => "Chrome Plaques - Chrome beach wall decor, beach signs, to the beach signs" [PRODUCT_PAGE_TITLE] => "Chrome Plaques - Chrome beach wall decor, beach signs, to the beach signs" [6] => [PRODUCT_SEO] => [7] => nautical-chrome-plaques.php [FILENAME] => nautical-chrome-plaques.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Chrome Plaqu [12] => [H2] => [13] => A modern take on a nautical classic Browse %count% styles priced from %lowest% Label each room in nautical chic [POINTS] => A modern take on a nautical classic Browse %count% styles priced from %lowest% Label each room in nautical chic [14] => [CATEGORY_SPLASH] => [15] => 1539 [CATEGORY_PICTURE] => 1539 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(7 Items) Sort:
Items: 1 to 7
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='414' 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