string(26) "error retreiving q_details"
string(327) "SELECT * FROM sas_ft_vehicle_details WHERE Length(vin) > 9 AND   vehicle_detail_id IN () 
				ORDER BY
					 (finalprice=0) ASC,
					(finalprice=0) ASC,
					(soldflag = 1) ASC,
					(body = 'MV/Other') ASC,
					CASE
					WHEN finalprice != 0
					THEN finalprice
					ELSE finalprice
					END asc
					 LIMIT 0,15"
model_Terrain
1
FILTER
    BROWSE BY

    LOADING

  • Brand

    • Alante (2)
    • American Patriot (7)
    • Aurora (5)
    • Aurora Light (4)
    • Avenue (3)
    • Avenue All-Access (1)
    • Bay Star (3)
    • Bay Star Sport (1)
    • Canyon Star (1)
    • Dutch Star (3)
    • Eagle Fifth Wheel (8)
    • Eagle HT Fifth Wheel (1)
    • Eagle HT Travel Trailer (4)
    • Eagle Travel Trailer (1)
    • Embark (1)
    • Geneva (1)
    • Greyhawk (2)
    • ic-37 (1)
    • ih-45 (1)
    • Jay Feather 8' (3)
    • Jay Feather Micro (2)
    • Jay Flight (24)
    • Jay Flight Bungalow (5)
    • Jay Flight SLX 7' Wide (4)
    • Kountry Star (2)
    • Melbourne Prestige (1)
    • New Aire (1)
    • North Point (4)
    • Paradigm (9)
    • Pinnacle (2)
    • Presidential Series Realm FS605 (2)
    • REALM (1)
    • Realm FS450 (2)
    • Realm FS605 (3)
    • Redhawk (6)
    • Redhawk SE (4)
    • Rockwood ESP (2)
    • Rockwood Freedom Series (1)
    • Rockwood Geo Pro (3)
    • Rockwood LTD Series (1)
    • Rockwood Mini Lite (1)
    • Rockwood Premier Hard Side (1)
    • Rockwood Signature Ultra Lite Travel Trailer (2)
    • Rockwood Ultra Lite Fifth Wheel (1)
    • Rockwood Ultra Lite Travel Trailer (3)
    • Seismic (2)
    • Seismic Luxury (1)
    • Seneca (1)
    • Solstice (1)
    • Swift (2)
    • Twilight Select (1)
    • Twilight Signature (1)
    • Valor (4)
    • Valor All-Access Series TT (1)
    • Ventana (2)
    • White Hawk (3)
RVs
Spinner gif
1
/
0

*5 or more available at this discount. Example vehicle 2022 Dutchmen Yukon. Example STK#T1931, MSRP $120,241 - $61,241 Blue Compass RV discount = $59,000 Sale Price. Example STK# may be located at another Blue Compass RV location. All advertised prices exclude government fees and taxes, any finance charges, any dealer document processing charge, pre-delivery inspection and freight fees, any electronic filing charge, and any emission testing charge. Offer expires end of month. **See dealer for details.