Guarantee RVSELECT
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` = 'B' ORDER BY list_price DESC ;
Viewing Class B Motorhome - 3 Found
2011 Triple E Regency 29T | $109,900
| Stock # 1122E | Model: 29T |
| Designation: New | Year: 2011 |
| Availability: In Stock | Type: Class B Motorhome |
| Manufacturer: Triple E | Slides: 3 |
| Brand: Regency | Int. Color: Tranquil Mist |
| Monthly Payment: $1,134 | Mileage: 1385 |
2011 Triple E Regency 24MB | $89,990
| Stock # 1117E | Model: 24MB |
| Designation: New | Year: 2011 |
| Availability: In Stock | Type: Class B Motorhome |
| Manufacturer: Triple E | Slides: 1 |
| Brand: Regency | Int. Color: Metropolitan |
| Monthly Payment: $782 | Mileage: 1411 |
2010 Roadtrek Versatile 190 | $67,990
| Stock # 11195U | Model: 190 |
| Designation: Pre-Owned | Year: 2010 |
| Availability: In Stock | Type: Class B Motorhome |
| Manufacturer: Roadtrek | |
| Brand: Versatile | |
| Monthly Payment: $685 | Mileage: 3645 |
