The Metropolitan Specialist - Rosemarie Johnson, REALTOR®
ACTIVE
$599,900
4 bd   
3 ba  
1 half ba
   3,936 SQFT
9 WALNUT GROVE DR
FREDERICKSBURG, VA 22406
ACTIVE
$569,900
4 bd   
3 ba  
1 half ba
   3,936 SQFT
9 WALNUT GROVE DR
FREDERICKSBURG, VA 22406
ACTIVE
$500,000
LOT 7 SECTION 1 HOLLY ACRES GREENBANK RD
FREDERICKSBURG, VA 22406
ACTIVE UNDER CONTRACT
$499,975
4 bd   
3 ba  
1 half ba
   3,800 SQFT
13 NATCHEZ LN
FREDERICKSBURG, VA 22406
ACTIVE
$389,999
2 bd   
2 ba
   1,340 SQFT
213 LONG POINT DR
FREDERICKSBURG, VA 22406
ACTIVE
$440,000
2 bd   
2 ba
   1,536 SQFT
128 LONG POINT DR
FREDERICKSBURG, VA 22406
ACTIVE
$415,000
2 bd   
2 ba
   1,505 SQFT
177 HYANNIS PL
FREDERICKSBURG, VA 22406
ACTIVE
$399,000
2 bd   
2 ba
   1,505 SQFT
143 HYANNIS PL
FREDERICKSBURG, VA 22406
Database last updated  10/31/2024 07:25 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.

Rosemarie Johnson, Realtor®
RE/MAX Executives
4000 Legato Rd
Fairfax, VA 22033
Office:
703-449-7629
rosemarie@rsjhomes.com
 
Powered by ListingsToGo™
set @lat=38.3454400;set @lon = -77.5326600;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;