Melissa Comi Realtor®
ACTIVE
$700,000
3 bd   
3 ba  
1 half ba
   2,892 SQFT
5605 SWIFT CREEK CT
HAYMARKET, VA 20169
COMING SOON
$750,000
3 bd   
3 ba  
1 half ba
   3,064 SQFT
5601 SWIFT CREEK CT
HAYMARKET, VA 20169
ACTIVE
$949,999
4 bd   
3 ba  
1 half ba
   3,968 SQFT
15645 RYDER CUP DR
HAYMARKET, VA 20169
ACTIVE UNDER CONTRACT
$1,200,000
4 bd   
5 ba  
1 half ba
   6,466 SQFT
5868 WATERLOO BRIDGE CIR
HAYMARKET, VA 20169
ACTIVE UNDER CONTRACT
$749,900
4 bd   
3 ba  
1 half ba
   3,890 SQFT
5665 SOLHEIM CUP DR
HAYMARKET, VA 20169
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=38.8302400;set @lon = -77.6618800;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;