Melissa Comi Realtor®
COMING SOON
$725,000
4 bd   
2 ba  
1 half ba
   2,148 SQFT
2606 DREAM CATCHER LN
GOLDVEIN, VA 22720
ACTIVE
$549,000
3 bd   
2 ba  
1 half ba
   2,730 SQFT
13354 BLACKWELLS MILL
GOLDVEIN, VA 22720
Database last updated  05/27/2025 02:52 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.4891100;set @lon = -77.6336200;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;