Melissa Comi Realtor®
ACTIVE UNDER CONTRACT
$1,175,000
5 bd   
4 ba  
2 half ba
   5,306 SQFT
40107 CHARLES TOWN PIKE
HAMILTON, VA 20158
COMING SOON
$325,000
1 bd   
1 ba
   576 SQFT
40397 CHARLES TOWN PIKE
PAEONIAN SPRINGS, VA 20129
ACTIVE
$1,324,990
4 bd   
3 ba
   2,998 SQFT
40242 CHARLES TOWN PIKE
HAMILTON, VA 20158
ACTIVE
$1,324,900
40242 CHARLES TOWN PIKE
HAMILTON, VA 20158
ACTIVE
$495,000
2 bd   
2 ba
   1,464 SQFT
39901 CATOCTIN RIDGE ST
PAEONIAN SPRINGS, VA 20129
ACTIVE
$1,795,000
4 bd   
3 ba
   7,042 SQFT
39937 CHARLES TOWN PIKE
HAMILTON, VA 20158
ACTIVE
$1,080,000
39892 HEDGELAND LN
WATERFORD, VA 20197
ACTIVE
$405,000
3 bd   
1 ba
   1,992 SQFT
16950 SIMPSON CIR
PAEONIAN SPRINGS, VA 20129
ACTIVE
$1,300,000
20.17 ACRES HEDGELAND LANE
WATERFORD, VA 20197
ACTIVE
$3,750,000
4 bd   
3 ba  
2 half ba
   4,379 SQFT
40035 HEDGELAND LN
WATERFORD, VA 20197
ACTIVE UNDER CONTRACT
$1,650,000
3 bd   
2 ba  
1 half ba
   3,300 SQFT
17026 SIMPSON CIR
PAEONIAN SPRINGS, VA 20129
ACTIVE
$1,225,000
4 bd   
3 ba
   2,888 SQFT
17115 SIMPSON CIR
PAEONIAN SPRINGS, VA 20129
Database last updated  05/27/2025 02:36 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.1530395;set @lon = -77.6291084;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;