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

Array ( [0] => 2255 [PRODUCT_CATEGORY_ID] => 2255 [1] => Brass Key Chains [CATEGORY_NAME] => Brass Key Chains [2] => [CATEGORY_HEADER] => [3] => handcrafted beach decor,beach accents,beach signs,decorative ship wheels,decorative wooden rustic anchors,nautical coasters,shell decorations,nautical art,nautical salt and pepper shakers,coastal furniture,nautical tables & desks,canoe and lifeboat bookcases,nautical themed cabinets,nautical themed chairs,wooden sailors chests,additional nautical furniture,display cases & tables ,display tables,display case & table combinations,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered squared buoys,vintage buoys,gifts under $20,life rings,decorative life rings,decorative antique life rings,decorative life ring clocks,titanic life rings,decorative life ring mirrors,multi colored life rings,solid colored life rings,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered squared buoys,vintage buoys,nautical fun for kids,spyglasses,nautical key chains,antique copper key chains,chrome key chains,brass key chains,Brass Key Chains,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => handcrafted beach decor,beach accents,beach signs,decorative ship wheels,decorative wooden rustic anchors,nautical coasters,shell decorations,nautical art,nautical salt and pepper shakers,coastal furniture,nautical tables & desks,canoe and lifeboat bookcases,nautical themed cabinets,nautical themed chairs,wooden sailors chests,additional nautical furniture,display cases & tables ,display tables,display case & table combinations,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered squared buoys,vintage buoys,gifts under $20,life rings,decorative life rings,decorative antique life rings,decorative life ring clocks,titanic life rings,decorative life ring mirrors,multi colored life rings,solid colored life rings,decorative buoys,glass floats,wooden buoys,lobster buoys,squared buoys,numbered squared buoys,vintage buoys,nautical fun for kids,spyglasses,nautical key chains,antique copper key chains,chrome key chains,brass key chains,Brass Key Chains,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => Brass Key Chains model ships are fully assembled and in stock. Brass Key Chains model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => Brass Key Chains model ships are fully assembled and in stock. Brass Key Chains model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy Brass Key Chains Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy Brass Key Chains Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => nautical-brass-key-chains.php [FILENAME] => nautical-brass-key-chains.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Brass Key Chain [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 1296 [CATEGORY_PICTURE] => 1296 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [SUPER_NAME] => )
(60 Items) Sort:
Page: 1  
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2255' 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
Show: / page

Similar to Brass Key Chains Models