SELECT
stock_item.id,
stock_item.cms_headline,
stock_item.year,
stock_item.d,
stock_item.sc,
stock_item.type,
stock_item.manufacturer,
stock_item.brand_name,
stock_item.model,
stock_item.mileage,
stock_item.list_price,
stock_item.slides,
stock_item.monthly,
stock_item.int_clr,
stock_item.option_description,
stock_item_image.large_image,
stock_item_image.small_image,
stock_item_image.thumbnail_image,
stock_item_details.description,
stock_item_details.floor_plan
FROM stock_item
LEFT JOIN stock_item_image ON stock_item.cms_headline = stock_item_image.stock_item
LEFT JOIN stock_item_details ON stock_item.cms_headline = stock_item_details.cms_headline
WHERE `type` = 'THT' OR `type` = 'TH5' ORDER BY list_price DESC ;
Viewing Toy Hauler - 3 Found
2012 Gulf Stream Enduramax Th5 3912 | $77,990
| Stock # 1201GS | Model: 3912 |
| Designation: New | Year: 2012 |
| Availability: In Stock | Type: Toy Hauler Fifth Wheel |
| Manufacturer: Gulf Stream | Slides: 3 |
| Brand: Enduramax th5 | Int. Color: Saddle |
2012 Crossroads Rv Elevation TF3310 | $64,990
| Stock # 12115CR | Model: TF3310 |
| Designation: New | Year: 2012 |
| Availability: In Stock | Type: Toy Hauler Fifth Wheel |
| Manufacturer: Crossroads Rv | Slides: 4 |
| Brand: Elevation | Int. Color: Malibu |
| Monthly Payment: $607 |
2007 Timberland Rpm Toyhauler FBSFG26 | $19,990
| Stock # 11147U | Model: FBSFG26 |
| Designation: Pre-Owned | Year: 2007 |
| Availability: In Stock | Type: Toy Hauler |
| Manufacturer: Timberland | Slides: 1 |
| Brand: Rpm Toyhauler | |
| Monthly Payment: $230 |
Guarantee RV








