Lowest Prices Ever - Free Shipping over $39 - Delivery within 5-7 business days
Holiday Sale

Array ( [0] => 2065 [PRODUCT_CATEGORY_ID] => 2065 [1] => Wholesale Beach Wall Decor [CATEGORY_NAME] => Wholesale Beach Wall Decor [2] => [CATEGORY_HEADER] => [3] => Wholesale handcrafted beach decor,beach wall decor,Beach Wall Decor,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [PRODUCT_META_TAG] => Wholesale handcrafted beach decor,beach wall decor,Beach Wall Decor,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats, [4] => Large wholesale selection of Beach Wall Decor model ships are fully assembled and in stock. Beach Wall Decor model ships at discounted prices. No assembly required. Lots of models to choose from. [PRODUCT_META_DESCRIPTION] => Large wholesale selection of Beach Wall Decor model ships are fully assembled and in stock. Beach Wall Decor model ships at discounted prices. No assembly required. Lots of models to choose from. [5] => Wholesale Buy Beach Wall Decor Models Assembled - Wholesale Beach Decor Replica - Model Ship Model Boat [PRODUCT_PAGE_TITLE] => Wholesale Buy Beach Wall Decor Models Assembled - Wholesale Beach Decor Replica - Model Ship Model Boat [6] => [PRODUCT_SEO] => [7] => wholesale-beach-home-decor.php [FILENAME] => wholesale-beach-home-decor.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Wholesale Beach Wall Decor [12] => [H2] => [13] => [POINTS] => [14] => [CATEGORY_SPLASH] => [15] => 3807 [CATEGORY_PICTURE] => 3807 [16] => product [CATEGORY_TYPE] => product [17] => 0 [FEATURED] => 0 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => 1142.jpg [HOME_IMAGE] => 1142.jpg [SUPER_NAME] => )
(78 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='2065' 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