Melissa Comi Realtor®
ACTIVE
$750,000
3 bd   
2 ba  
1 half ba
   2,936 SQFT
43214 BALTUSROL TER
ASHBURN, VA 20147
COMING SOON
$1,399,000
5 bd   
3 ba  
1 half ba
   3,067 SQFT
19674 PELICAN HILL CT
ASHBURN, VA 20147
ACTIVE
$795,000
3 bd   
2 ba  
1 half ba
   2,960 SQFT
43134 BALTUSROL TER
ASHBURN, VA 20147
ACTIVE
$765,000
3 bd   
2 ba  
1 half ba
   2,802 SQFT
43130 BALTUSROL TER
ASHBURN, VA 20147
COMING SOON
$1,095,000
5 bd   
3 ba  
1 half ba
   4,163 SQFT
43326 LA BELLE PL
ASHBURN, VA 20147
ACTIVE
$2,095,000
6 bd   
6 ba  
2 half ba
   7,526 SQFT
43522 PUMPKIN RIDGE CT
ASHBURN, VA 20147
ACTIVE UNDER CONTRACT
$750,000
3 bd   
3 ba  
1 half ba
   2,805 SQFT
43400 BRIAR CREEK TER
ASHBURN, VA 20147
COMING SOON
$1,180,000
3 bd   
3 ba  
1 half ba
   4,715 SQFT
19825 BETHPAGE CT
ASHBURN, VA 20147
ACTIVE UNDER CONTRACT
$799,999
5 bd   
4 ba  
1 half ba
   3,526 SQFT
19404 FRONT ST
LEESBURG, VA 20176
Database last updated  11/10/2024 02:39 PM
 
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.

Melissa Comi
CENTURY 21 New Millennium
4437 Brookfield Corporate Dr #110
Chantilly, VA 20151
Office:
703-818-0111
melissa.comi@c21nm.com
 
Powered by ListingsToGo™
set @lat=39.0698700;set @lon = -77.5054200;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;