Melissa Comi Realtor®
COMING SOON
$1,125,000
4 bd   
4 ba  
1 half ba
   4,719 SQFT
5638 LICK RIVER LN
GAINESVILLE, VA 20155
ACTIVE
$1,850,000
6 bd   
6 ba  
1 half ba
   7,927 SQFT
15280 RIDING CLUB DR
HAYMARKET, VA 20169
ACTIVE
$1,350,000
6 bd   
5 ba  
1 half ba
   8,082 SQFT
4740 ANGUS DR
GAINESVILLE, VA 20155
ACTIVE
$995,000
15070 FALLEN OAKS PL
GAINESVILLE, VA 20155
COMING SOON
$1,100,000
4 bd   
3 ba  
1 half ba
   4,520 SQFT
13519 ACCORD CT
GAINESVILLE, VA 20155
Database last updated  05/27/2025 03:31 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.8446000;set @lon = -77.6071200;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;