THE BILL DAVIS TEAM
ACTIVE
$1,350,000
4 bd   
4 ba  
1 half ba
   6,419 SQFT
5610 GARNETTS FARM DR
HAYMARKET, VA 20169
ACTIVE UNDER CONTRACT
$1,449,500
6 bd   
6 ba  
1 half ba
   7,568 SQFT
5560 SHAWBROOK CT
HAYMARKET, VA 20169
ACTIVE
$839,999
4 bd   
3 ba  
1 half ba
   4,397 SQFT
5506 HILLSMAN FARM LN
HAYMARKET, VA 20169
ACTIVE
$949,900
4 bd   
2 ba  
1 half ba
   3,313 SQFT
15088 GAINES MILL CIR
HAYMARKET, VA 20169
ACTIVE UNDER CONTRACT
$799,900
5 bd   
4 ba  
1 half ba
   4,635 SQFT
5630 BENGAL PL
HAYMARKET, VA 20169
COMING SOON
$939,900
4 bd   
3 ba  
1 half ba
   4,030 SQFT
5363 YORKTOWN RUN CT
HAYMARKET, VA 20169
COMING SOON
$1,459,000
6 bd   
5 ba  
1 half ba
   7,424 SQFT
12961 TORY GATE CT
HAYMARKET, VA 20169
Database last updated  07/20/2024 05:11 AM
 
For Sale Listings
Rental Search
Find a Home
Minimum Sale Price
Maximum Sale Price
ADVANCED SEARCH OPTIONS
New Search
Search powered by
© Bright MLS. All rights reserved.
Listings provided by Bright MLS from various brokers who participate in IDX (Internet Data Exchange). Information deemed reliable but not guaranteed.

THE BILL DAVIS TEAM
CENTURY 21 New Millenium
4437 Brookfield Corporate Drive
Suite 110
Chantilly, VA 20151
Direct:
703-501-4471
Office:
703-818-0111
BillyC21@aol.com
Copyright © 2022. Bill Davis Team Real Estate
Copyright © 2022. Bill Davis Team Real Estate
 
Powered by ListingsToGo™
set @lat=38.8401300;set @lon = -77.6224200;set @dist = .7;set @rlon1 = @lon-@dist/abs(cos(radians(@lat))*69);set @rlon2 = @lon+@dist/abs(cos(radians(@lat))*69);set @rlat1 = @lat-(@dist/69);set @rlat2 = @lat+(@dist/69);select st_distance(point(@lon, @lat), thePoint) as distance, ListingID, ListingStatus, LotAreaAcre, LivingArea, ForSale, Longitude, ModificationTimestamp, YearBuilt, Latitude, Subdivision, VirtualTourURL, ListOfficeName, ListingKey, ZipCode, ListPictureURL,ListPicture3URL, FullStreetAddress, StreetName, Beds, BathsFull,BathsHalf, CityName, State, ZipCode, ListPrice, ClosePrice, InternetRemarks, LotAreaAcre from `searchALL` where st_within(thePoint, envelope(linestring(point(@rlon1, @rlat1), point(@rlon2, @rlat2)))) and (ListingStatus LIKE "Active%" or ListingStatus ='COMING SOON') and ForSale='Y' order by distance ASC, st_distance(point(@lon, @lat), thePoint) limit 50;