REALTY2U, INC
ACTIVE
$65,000
CUMBERLAND RD #LOT 52B
FREDERICKSBURG, VA 22405
ACTIVE
$65,000
CUMBERLAND RD #LOT 52C
FREDERICKSBURG, VA 22405
ACTIVE UNDER CONTRACT
$514,900
5 bd   
3 ba
   2,712 SQFT
604 ELMWOOD DR
FREDERICKSBURG, VA 22405
ACTIVE
$850,000
403 CHATHAM SQUARE OFFICE PARK
FREDERICKSBURG, VA 22405
ACTIVE
$449,900
4 bd   
2 ba
   1,188 SQFT
147 DEACON RD
FREDERICKSBURG, VA 22405
ACTIVE UNDER CONTRACT
$670,000
6 bd   
3 ba  
1 half ba
   4,790 SQFT
5 OAK CREST CT
FREDERICKSBURG, VA 22405
ACTIVE UNDER CONTRACT
$399,000
417 PRATT ST
FREDERICKSBURG, VA 22405
ACTIVE
$315,000
2 bd   
1 ba
   946 SQFT
411 PRATT ST
FREDERICKSBURG, VA 22405
Database last updated  08/01/2025 03:47 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.

Mayura Gupte, Principal Broker®
REALTY2U, INC.
24805 Pinebrook Road, #209
Chantilly, VA 20152
mayura@realty2u.com
 
Powered by ListingsToGo™
set @lat=38.3178828;set @lon = -77.4504576;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;