RV Search

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, coc.payment, 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, stock_item_details.youtube_share_url 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 LEFT JOIN coc ON stock_item.list_price = coc.price WHERE `d` REGEXP '^[UDC]$' ORDER BY list_price DESC ;

Searching Pre-Owned - 83 Found

1 2 3 4 5 6 7 8 9 | Next >

2008 Monaco Marquis 45 | $299,990

Stock # 1467X Model: 45
Designation: Pre-Owned Year: 2008
Availability: In Stock Type: Class A Motorhome
Manufacturer: Monaco
Brand: Marquis
Mileage: 50102

2009 Monaco Dynasty 43MPV | $199,900

Stock # 14111X Model: 43MPV
Designation: Pre-Owned Year: 2009
Availability: In Stock Type: Class A Motorhome
Manufacturer: Monaco
Brand: Dynasty Int. Color: Cognac Swirl
Mileage: 12250

2006 Newmar Essex 4502 | $179,900

Stock # 14195U Model: 4502
Designation: Pre-Owned Year: 2006
Availability: Deal Pending Type: Class A Motorhome
Manufacturer: Newmar
Brand: Essex
Mileage: 84727

2011 Monaco Knight 40PBT | $169,990

Stock # 14116X Model: 40PBT
Designation: Pre-Owned Year: 2011
Availability: In Stock Type: Class A Motorhome
Manufacturer: Monaco
Brand: Knight
Mileage: 32931

2005 Monaco Executive 40PBT | $169,900

Stock # 1480X Model: 40PBT
Designation: Pre-Owned Year: 2005
Availability: In Stock Type: Class A Motorhome
Manufacturer: Monaco
Brand: Executive
Mileage: 60571

2006 Monaco Camelot 40PDQ | $159,990

Stock # 1494X Model: 40PDQ
Designation: Pre-Owned Year: 2006
Availability: In Stock Type: Class A Motorhome
Manufacturer: Monaco
Brand: Camelot
Mileage: 45665

2014 Thor Motorized Palazzo 33.2 | $149,990

Stock # 1491X Model: 33.2
Designation: Pre-Owned Year: 2014
Availability: In Stock Type: Class A Motorhome
Manufacturer: Thor Motorized
Brand: Palazzo
Mileage: 10500

2006 Monaco Windsor 40 PDQ | $149,900

Stock # 1469X Model: 40 PDQ
Designation: Pre-Owned Year: 2006
Availability: In Stock Type: Class A Motorhome
Manufacturer: Monaco
Brand: Windsor
Mileage: 35602

2007 Fleetwood Revolution 40L | $137,990

Stock # 14121X Model: 40L
Designation: Pre-Owned Year: 2007
Availability: In Stock Type: Class A Motorhome
Manufacturer: Fleetwood
Brand: Revolution

2005 Monaco Dynasty 40 PLATINUM III | $129,900

Stock # 14114X Model: 40 PLATINUM III
Designation: Pre-Owned Year: 2005
Availability: In Stock Type: Class A Motorhome
Manufacturer: Monaco
Brand: Dynasty Int. Color: Indian Summer
Mileage: 47254
1 2 3 4 5 6 7 8 9 | Next >