Summer Sale ends Fri Jul 8th - Free shipping on orders $39 and above

> Page 2

Category:
Array ( [0] => 2040 [PRODUCT_CATEGORY_ID] => 2040 [1] => Wholesale RC Boats [CATEGORY_NAME] => Wholesale RC Boats [2] => [CATEGORY_HEADER] => [3] => Wholesale remote controlled boats, rc boats, rc racing boats, rc ships, rc model ships, rc tug boat, chris craft model, rc electric boat, rc model boat, fast rc boats, fast rc boat, rc tug boats, rc speed boats, rc boat racing, chris craft model boats, model rc boats, large rc boats, big rc boats, rc hydroplane boat, rc power boats, rc race boats, rc fishing boats, gas powered rc boats, chris craft models, remote control ships, chris craft model boat, large rc boat, rc boats for sale, rc race boat, remote control speed boats, remote control toy boats, remote control speed boat, cheap rc boats, rc tugboat, radio controlled ships, radio controlled model boats, radio control model boats, rc speedboat, rc yachts, remote control sailboats, rc airboats, remote control sailboat, radio control submarine, radio control sailboats, radio controlled sailboats, radio controlled sailboat, radio control sailboat, radio controlled yacht [PRODUCT_META_TAG] => Wholesale remote controlled boats, rc boats, rc racing boats, rc ships, rc model ships, rc tug boat, chris craft model, rc electric boat, rc model boat, fast rc boats, fast rc boat, rc tug boats, rc speed boats, rc boat racing, chris craft model boats, model rc boats, large rc boats, big rc boats, rc hydroplane boat, rc power boats, rc race boats, rc fishing boats, gas powered rc boats, chris craft models, remote control ships, chris craft model boat, large rc boat, rc boats for sale, rc race boat, remote control speed boats, remote control toy boats, remote control speed boat, cheap rc boats, rc tugboat, radio controlled ships, radio controlled model boats, radio control model boats, rc speedboat, rc yachts, remote control sailboats, rc airboats, remote control sailboat, radio control submarine, radio control sailboats, radio controlled sailboats, radio controlled sailboat, radio control sailboat, radio controlled yacht [4] => Large wholesale selection of [PRODUCT_META_DESCRIPTION] => Large wholesale selection of [5] => Wholesale RC Boats, RC Ships - Remote Controlled Boats, RC Electric Boat, Fast RC Boat [PRODUCT_PAGE_TITLE] => Wholesale RC Boats, RC Ships - Remote Controlled Boats, RC Electric Boat, Fast RC Boat [6] => [PRODUCT_SEO] => [7] => wholesale-remote-control-boats.php [FILENAME] => wholesale-remote-control-boats.php [8] => [CATEGORY_FOOTER] => [9] => [AMAZON] => [10] => [IMAGE] => [11] => [H1] => Wholesale RC Boat [12] => [H2] => [13] => Pure nautical fun Browse %count% styles priced from %lowest% A wonderful collection that will excite the whole family [POINTS] => Pure nautical fun Browse %count% styles priced from %lowest% A wonderful collection that will excite the whole family [14] => [CATEGORY_SPLASH] => [15] => 638 [CATEGORY_PICTURE] => 638 [16] => product [CATEGORY_TYPE] => product [17] => 0 [FEATURED] => 0 [18] => [EBAY] => [19] => [BREADCRUMB] => [20] => 0 [SHOW_ALL] => 0 [21] => 513.jpg [HOME_IMAGE] => 513.jpg [SUPER_NAME] => )
(36 Items) Sort:
Page:  2 
SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2040' 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

Similar to Wholesale RC Boats Models