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, 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 WHERE `d` REGEXP '^[UDC]$' ORDER BY list_price DESC ;

Searching Pre-Owned - 89 Found

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

2008 Monaco Marquis 45 | $349,990

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

2006 Newmar Essex 45' | $199,900

Stock # 13112X Model: 45'
Designation: Pre-Owned Year: 2006
Availability: In Stock Type: Class A Motorhome
Manufacturer: Newmar Slides: 4
Brand: Essex
Mileage: 84645

2009 Beaver Contessa 42WES | $184,990

Stock # 1462X Model: 42WES
Designation: Pre-Owned Year: 2009
Availability: Deal Pending Type: Class A Motorhome
Manufacturer: Beaver
Brand: Contessa
Mileage: 25080

2006 American Coach American Eagle 40 | $184,900

Stock # 1478X Model: 40
Designation: Pre-Owned Year: 2006
Availability: In Stock Type: Class A Motorhome
Manufacturer: American Coach
Brand: American Eagle
Mileage: 28000

2005 Monaco Executive 40PBT | $179,990

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

2012 Monaco Vesta 35PBD | $169,990

Stock # 1455X Model: 35PBD
Designation: Pre-Owned Year: 2012
Availability: In Stock Type: Class A Motorhome
Manufacturer: Monaco
Brand: Vesta
Mileage: 5050

2006 Monaco Windsor 40 PDQ | $154,990

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

2006 Monaco Dynasty 38 BISHOP IV | $149,900

Stock # 1309MU Model: 38 BISHOP IV
Designation: Pre-Owned Year: 2006
Availability: In Stock Type: Class A Motorhome
Manufacturer: Monaco Slides: 4
Brand: Dynasty Int. Color: Metallo Platinum
Monthly Payment: $1,819 Mileage: 63325

2009 Thor Tuscany 4072 | $138,900

Stock # 1424X Model: 4072
Designation: Pre-Owned Year: 2009
Availability: In Stock Type: Class A Motorhome
Manufacturer: Thor Slides: 4
Brand: Tuscany
Mileage: 39240

2007 Winnebago Eclipse 40 | $134,990

Stock # 1439X Model: 40
Designation: Pre-Owned Year: 2007
Availability: In Stock Type: Class A Motorhome
Manufacturer: Winnebago
Brand: Eclipse
Mileage: 58801
1 2 3 4 5 6 7 8 9 | Next >