RVshowcase.com - the MLS of the RV Industry! offers New and Used RVs for sale.

Search by ListingId:

Search by One or More*:

Search by Special Features:

Welcome to "The MLS of the RV Industry"®.

	A Liner RV Description Field	2009	100000
save this listing	Broker's Web Site

	Abel RV Description 2	2008	10000
save this listing	Broker's Web Site

	Adventure Manufacturing Description 3	2006	20000
save this listing	Broker's Web Site

	Adventure Manufacturing RV Description 4	2005	50000
save this listing	Broker's Web Site

	Aero Coach a	2009	70000
save this listing	Broker's Web Site

MyRVErrorString	:
MyRVTestString	:
MyRVViewMode	:	List
MyRVViewImages	:	Images
MyRVPrimaryId	:	0
MyRVChildId	:	0
MyRVParentId	:	0
MyRVUserId	:	0
MyRVName	:	Any RV Name
MyRVListingId	:	0
MyRVSqlCount	:	0
MyRVSql	:	SELECT top 5 iprimaryid, ichildid, iparentid, iuserid, crvmodel, crvdescription, (SELECT cname FROM baseddl AS a2 WHERE (cactive = '1') AND (ichildid = a1.irvmakeddl)) AS RVMake, (SELECT cname FROM baseddl AS a2 WHERE (cactive = '1') AND (ichildid = a1.irvstateddl)) AS RVState, irvprice, (SELECT cname FROM baseddl AS a2 WHERE (cactive = '1') AND (ichildid = a1.irvyearddl)) AS RVYear FROM rvlisting AS a1
MyRVSqlWhere	:	Where cactive = '1'
MyRVSqlFilter	:
MyRVSqlOrderBy	:
MyRVClassddl[123835]	:	123835
MyRVMakeddl[123856]	:	123856
MyRVModel	:
MyRVYearMinddl[123718]	:	123718
MyRVYearMaxddl[123971]	:	123718
MyRVPriceMinddl[123680]	:	123680
MyRVPriceMaxddl[124072]	:	123680
MyRVStateddl[123605]	:	123605
MyRVCountryddl[123594]	:	123594
MyRVHandicapddl[124218]	:	124218
MyRVRoofACddl[124222]	:	124222
MyRVNoSmokeddl[124226]	:	124226
MyRVSlideOutddl[124230]	:	124230
MyRVAwningddl[124234]	:	124234
MyRVLevelJackddl[124238]	:	124238

Our VIP Buyer Guarantee!

"We promise to put forth our best efforts, our time and our money to help you buy your RV." - teamRV

more info...