|
|
![]() New Handcrafted Model Ships |
![]() New Handcrafted Nautical Décor |
![]() New Handcrafted Beach Décor |
![]() New Handcrafted Sealife Décor |
![]() New Famous Ships |
![]() From Movies And Television (27) |
![]() Historically Significant Ships (84) |
![]() Civil War Ships (8) |
![]() Pirate Ships (60) |
![]() United States Warships (26) |
![]() Blackbeard's Queen Anne's Revenge (7) |
![]() Captain Kidd's Pirate Ships (7) |
![]() Calico Jack's The William (5) |
![]() Black Bart's Royal Fortune (6) |
![]() Pirates of the Caribbean (26) |
![]() Privateers (23) |
![]() New Sail Boats |
![]() Famous Historic Sailboats (90) |
![]() Table Centerpiece Sailboats (96) |
![]() Floating Sail Boats (34) |
![]() J Yachts (48) |
![]() Rustic Sailboats (17) |
![]() Remote Control Sailboats (3) |
Spring Sale ends Friday April 27th. Free shipping on orders over $39.
Array
(
[0] => 317
[PRODUCT_CATEGORY_ID] => 317
[1] => Chris Craft Triple Cockpit
[CATEGORY_NAME] => Chris Craft Triple Cockpit
[2] =>
[CATEGORY_HEADER] =>
[3] =>
[PRODUCT_META_TAG] =>
[4] =>
[PRODUCT_META_DESCRIPTION] =>
[5] =>
[PRODUCT_PAGE_TITLE] =>
[6] =>
[PRODUCT_SEO] =>
[7] => cris-craft-triple-cockpit-model-speed-boats.php
[FILENAME] => cris-craft-triple-cockpit-model-speed-boats.php
[8] =>
[CATEGORY_FOOTER] =>
[9] =>
[AMAZON] =>
[10] =>
[IMAGE] =>
[11] =>
[H1] => Chris Craft Triple Cockpit
[12] =>
[H2] =>
[13] =>
[POINTS] =>
[14] =>
[CATEGORY_SPLASH] =>
[15] => 0
[CATEGORY_PICTURE] => 0
[16] => product
[CATEGORY_TYPE] => product
[17] => 3
[FEATURED] => 3
[18] =>
[EBAY] =>
[19] =>
[BREADCRUMB] =>
[20] => 0
[SHOW_ALL] => 0
[21] =>
[HOME_IMAGE] =>
[SUPER_NAME] =>
)
(1 Items) Sort:
|
Items: 1 to 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='317' 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 `price` ASC,PRODUCTS.PRODUCT_NAME, PRODUCT_ACTIVE DESC |
Welcome Aboard!
Los Angeles Showroom

Watch Us On TV
As Seen In

Quantity Discounts
|
Links: | Stay Connected: | |||||||
---|---|---|---|---|---|---|---|---|---|
Contact Us
FAQ About Us Money Back Guarantee Become a Dealer Privacy / Terms of Use |

SHOWROOM OPEN MONDAY - FRIDAY 7:30am to 4:00pm
1827 West Valley Blvd. Alhambra, CA 91803
1827 West Valley Blvd. Alhambra, CA 91803
Page you are viewing: