All models fully assembled -  Free Shipping over $199

Array ( [0] => 2306 [PRODUCT_CATEGORY_ID] => 2306 [1] => New Decorative Buoys [CATEGORY_NAME] => New Decorative Buoys [2] => [CATEGORY_HEADER] => [3] => handcrafted beach decor,new items,gifts under $20,life rings,decorative life rings,decorative colored life rings,decorative antique life rings,decorative life ring clocks,decorative life ring mirrors,decorative titanic life rings,new life rings,decorative buoys,decorative glass floats,decorative wooden buoys,decorative lobster buoys,decorative squared buoys,numbered squared buoys,decorative vintage buoys,new decorative buoys,New Decorative Buoys,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => handcrafted beach decor,new items,gifts under $20,life rings,decorative life rings,decorative colored life rings,decorative antique life rings,decorative life ring clocks,decorative life ring mirrors,decorative titanic life rings,new life rings,decorative buoys,decorative glass floats,decorative wooden buoys,decorative lobster buoys,decorative squared buoys,numbered squared buoys,decorative vintage buoys,new decorative buoys,New Decorative Buoys,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => New Decorative Buoys model ships are fully assembled and in stock. New Decorative Buoys model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => New Decorative Buoys model ships are fully assembled and in stock. New Decorative Buoys model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Buy New Decorative Buoys Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Buy New Decorative Buoys Models Assembled - Handcrafted Beach Decor Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => new-floats-and-buoys.php [FILENAME] => new-floats-and-buoys.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => New Decorative Buoy [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 3322 [CATEGORY_PICTURE] => 3322 [16] => product [CATEGORY_TYPE] => product [17] => 3 [FEATURED] => 3 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => [HOME_IMAGE] => [22] => [CATEGORY_SITE] => [SUPER_NAME] => )
(111 Items) Sort:
Page: 1   
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='2306' 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 PRODUCTS.PRODUCT_ID DESC, PRODUCT_ACTIVE DESC LIMIT 0,48
Show: / page

Similar to New Decorative Buoys Models