For Sale Listings
Find a Home
Minimum Sale Price
Maximum Sale Price
Rosemarie Johnson, RealtorĀ®
RE/MAX Executives
4000 Legato Rd
Fairfax, VA 22033
 
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;