THE BILL DAVIS TEAM
ACTIVE UNDER CONTRACT
$1,049,000
5 bd   
4 ba
   4,600 SQFT
12061 ROSE HALL DRIVE
CLIFTON, VA 20124
COMING SOON
$1,500,000
5 bd   
5 ba  
1 half ba
   4,402 SQFT
8108 SPRUCE VALLEY LN
CLIFTON, VA 20124
COMING SOON
$1,300,000
5 bd   
3 ba  
1 half ba
   2,822 SQFT
12204 HENDERSON RD
CLIFTON, VA 20124
Database last updated  05/09/2025 04:26 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.7536700;set @lon = -77.3772100;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;