For Sale Listings
Find a Home
Minimum Sale Price
Maximum Sale Price
Mayura Gupte, Principal BrokerĀ®
REALTY2U, INC.
24805 Pinebrook Road, #209
Chantilly, VA 20152
 
Powered by ListingsToGo™
select ListingID, ListingStatus, LotAreaAcre, LivingArea, ForSale, Longitude, ModificationTimestamp, YearBuilt, Latitude, Subdivision, VirtualTourURL, ListPicture2URL,ListPicture3URL, ListOfficeName, ListingKey, ZipCode, FullStreetAddress, StreetName, Beds, BathsFull,BathsHalf, CityName,state,ZipCode, ListPrice, ClosePrice, Advertising, STATE, Stories, ListOfficeName, ListingKey, VirtualTourURL,InternetRemarks, LotAreaAcre from bright.searchALL where (ListingStatus LIKE "Active%" and StreetName = '' ) order by StreetName, ListPrice DESC LIMIT 0,1000;