Melissa Comi Realtor®
ACTIVE
$839,999
4 bd   
3 ba  
1 half ba
   4,397 SQFT
5506 HILLSMAN FARM LN
HAYMARKET, VA 20169
COMING SOON
$980,000
4 bd   
4 ba  
1 half ba
   4,299 SQFT
5510 HILLSMAN FARM LN
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
$1,100,000
4 bd   
4 ba  
1 half ba
   6,124 SQFT
14903 MARLBANK PL
HAYMARKET, VA 20169
COMING SOON
$1,029,000
4 bd   
3 ba  
1 half ba
   3,570 SQFT
15077 SYCAMORE HILLS PL
HAYMARKET, VA 20169
ACTIVE UNDER CONTRACT
$1,099,999
5 bd   
3 ba  
1 half ba
   4,780 SQFT
5627 SHOAL CREEK DR
HAYMARKET, VA 20169
ACTIVE
$1,050,000
5 bd   
3 ba  
1 half ba
   3,726 SQFT
15070 JUPITER HILLS LN
HAYMARKET, VA 20169
ACTIVE UNDER CONTRACT
$490,000
3 bd   
2 ba
   1,833 SQFT
15241 ROYAL CREST DR #306
HAYMARKET, VA 20169
ACTIVE
$415,000
2 bd   
2 ba
   1,499 SQFT
15251 ROYAL CREST DR #204
HAYMARKET, VA 20169
ACTIVE
$450,000
2 bd   
2 ba
   1,499 SQFT
15110 HEATHER MILL LN #304
HAYMARKET, VA 20169
ACTIVE UNDER CONTRACT
$424,900
2 bd   
2 ba
   1,538 SQFT
15100 HEATHER MILL LN #307
HAYMARKET, VA 20169
ACTIVE
$425,000
2 bd   
2 ba
   1,499 SQFT
15130 HEATHER MILL LN #102
HAYMARKET, VA 20169
ACTIVE UNDER CONTRACT
$484,500
3 bd   
2 ba
   1,800 SQFT
15140 HEATHER MILL LN #301
HAYMARKET, VA 20169
Database last updated  05/06/2025 12:06 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.

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=38.8407700;set @lon = -77.6292200;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;