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` = 'A' ORDER BY list_price DESC ;
Viewing Class A Motorhome - 29 Found
2012 Monaco Diplomat 43DFT | $309,900
| Stock # 1205M | Model: 43DFT |
| Designation: New | Year: 2012 |
| Availability: In Stock | Type: Class A Motorhome |
| Manufacturer: Monaco | |
| Brand: Diplomat | Int. Color: Manhattan Bronze |
| Monthly Payment: $2,890 | Mileage: 1483 |
2006 Monaco Signature 45 | $299,000
| Stock # 1154X | Model: 45 |
| Designation: Pre-Owned | Year: 2006 |
| Availability: In Stock | Type: Class A Motorhome |
| Manufacturer: Monaco | Slides: 4 |
| Brand: Signature | Int. Color: / |
| Mileage: 28472 |
2012 Monaco Knight 40PDQ | $249,900
| Stock # 1204M | Model: 40PDQ |
| Designation: New | Year: 2012 |
| Availability: In Stock | Type: Class A Motorhome |
| Manufacturer: Monaco | Slides: 4 |
| Brand: Knight | Int. Color: Mocha Splendor |
| Monthly Payment: $2,451 | Mileage: 2011 |
2007 Monaco Dynasty Palace 43 | $239,990
| Stock # 1155X | Model: 43 |
| Designation: Pre-Owned | Year: 2007 |
| Availability: In Stock | Type: Class A Motorhome |
| Manufacturer: Monaco | Slides: 3 |
| Brand: Dynasty Palace | Int. Color: / |
| Mileage: 22501 |
2012 Monaco Vesta 35PBD | $189,990
| Stock # 1202M | Model: 35PBD |
| Designation: New | Year: 2012 |
| Availability: In Stock | Type: Class A Motorhome |
| Manufacturer: Monaco | Slides: 2 |
| Brand: Vesta | Int. Color: Casbah |
| Monthly Payment: $1,573 | Mileage: 1000 |
2011 Monaco Knight 36PFT | $189,000
| Stock # 1126M | Model: 36PFT |
| Designation: New | Year: 2011 |
| Availability: In Stock | Type: Class A Motorhome |
| Manufacturer: Monaco | Slides: 3 |
| Brand: Knight | Int. Color: Platinum |
| Monthly Payment: $1,573 | Mileage: 1027 |
2008 Monaco Beaver ROME 43 | $184,900
_m_sm.jpg)
| Stock # 1201MU | Model: ROME 43 |
| Designation: Pre-Owned | Year: 2008 |
| Availability: In Stock | Type: Class A Motorhome |
| Manufacturer: Monaco | Slides: 4 |
| Brand: Beaver | |
| Mileage: 12559 |
2006 Itasca Horizon 40FD | $154,900
| Stock # 1051X | Model: 40FD |
| Designation: Pre-Owned | Year: 2006 |
| Availability: In Stock | Type: Class A Motorhome |
| Manufacturer: Itasca | Slides: 4 |
| Brand: Horizon | Int. Color: / |
| Mileage: 47961 |
2008 Monaco Diplomat 40SKQ | $147,990
| Stock # 1203U | Model: 40SKQ |
| Designation: Pre-Owned | Year: 2008 |
| Availability: In Stock | Type: Class A Motorhome |
| Manufacturer: Monaco | Slides: 4 |
| Brand: Diplomat | |
| Monthly Payment: $1,521 | Mileage: 25363 |
2012 Coachmen Cross Country 406QS | $145,000
| Stock # 1106CM | Model: 406QS |
| Designation: New | Year: 2012 |
| Availability: In Stock | Type: Class A Motorhome |
| Manufacturer: Coachmen | Slides: 4 |
| Brand: Cross Country | Int. Color: Saddlebrook |
| Monthly Payment: $1,134 |
