RV Rentals

SELECT * FROM CLASSIFIED_DATA CD, COMPANY C WHERE CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 13 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|NY|%' OR CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 13 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|NY|%' OR CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 13 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|NY|%' ORDER BY C.REVENUE DESC, C.COMPANY_NAME ASC
 
Already know which classified you want to see? Enter the classified ad number in the box below.
   
 
 
 
     

Site Information

        

RV Information
Home About Us New and Used RV Dealers RV Articles
Contact Us Privacy Policy RV Accessories Parts Tourism Information
    RV Services  
 

Copyright © 2008 RVGlobal.com and Vertical Alliance Group, Inc. All rights reserved.
NOTICE: We collect personal information on this site.
To learn more about how we use your information, see our Privacy Policy.