THE BILL DAVIS TEAM
ACTIVE
$875,000
5 bd   
4 ba  
1 half ba
   4,692 SQFT
7267 RIDGEDALE DR
WARRENTON, VA 20186
ACTIVE
$225,000
9654 JAMES MADISON HWY
WARRENTON, VA 20186
ACTIVE
$1,750,000
9533 JAMES MADISON
WARRENTON, VA 20187
ACTIVE
$4,965,090
JAMES MADISON HW
WARRENTON, VA 20186
ACTIVE
$2,200,000
4 bd   
3 ba
   2,855 SQFT
7453 OPAL RD
WARRENTON, VA 20186
Database last updated  09/16/2024 11:38 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.6348900;set @lon = -77.8095000;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;