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` = 'C' ORDER BY list_price DESC ;
Viewing Class C Motorhome - 4 Found
2012 Triple E Regency GT29T | $119,900
| Stock # 1201E | Model: GT29T |
| Designation: New | Year: 2012 |
| Availability: In Stock | Type: Class C Motorhome |
| Manufacturer: Triple E | Slides: 3 |
| Brand: Regency | Int. Color: Blue Slate |
| Monthly Payment: $1,134 | Mileage: 1444 |
2011 Triple E Regency 28DB | $69,990
| Stock # 1114E | Model: 28DB |
| Designation: New | Year: 2011 |
| Availability: In Stock | Type: Class C Motorhome |
| Manufacturer: Triple E | Slides: 2 |
| Brand: Regency | Int. Color: Encore |
| Monthly Payment: $607 |
2008 Coachmen Freelander 26 | $44,990
| Stock # 1147U | Model: 26 |
| Designation: Pre-Owned | Year: 2008 |
| Availability: In Stock | Type: Class C Motorhome |
| Manufacturer: Coachmen | Slides: 1 |
| Brand: Freelander | |
| Monthly Payment: $523 | Mileage: 42020 |
2004 Triple E Regal 28RQ | $37,990
| Stock # 1203X | Model: 28RQ |
| Designation: Pre-Owned | Year: 2004 |
| Availability: In Stock | Type: Class C Motorhome |
| Manufacturer: Triple E | |
| Brand: Regal | |
| Mileage: 120909 |
Guarantee RV








