ACTIVE
$524,990
4 bd   
3 ba  
1 half ba
   1,962 SQFT
452 HERRINGBONE WAY
FREDERICK, MD 21701
ACTIVE
$594,800
4 bd   
3 ba  
1 half ba
   2,436 SQFT
854 AMITY ST
FREDERICK, MD 21701
ACTIVE
$727,436
5 bd   
5 ba
   3,213 SQFT
465 HANSON ST
FREDERICK, MD 21701
ACTIVE
$559,990
4 bd   
3 ba  
1 half ba
   1,962 SQFT
736 COMPASS WAY
FREDERICK, MD 21701
ACTIVE
$524,990
4 bd   
3 ba  
1 half ba
   1,962 SQFT
732 COMPASS WAY
FREDERICK, MD 21701
ACTIVE
$524,990
4 bd   
3 ba  
1 half ba
   1,962 SQFT
734 COMPASS WAY
FREDERICK, MD 21701
ACTIVE
$519,990
4 bd   
3 ba  
1 half ba
   1,962 SQFT
730 COMPASS WAY
FREDERICK, MD 21701
ACTIVE
$524,990
4 bd   
3 ba  
1 half ba
   1,962 SQFT
728 COMPASS WAY
FREDERICK, MD 21701
ACTIVE
$739,990
5 bd   
5 ba  
1 half ba
   3,642 SQFT
470 HERRINGBONE WAY
FREDERICK, MD 21701
ACTIVE
$835,990
5 bd   
5 ba
   3,979 SQFT
453 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$488,990
4 bd   
4 ba
   1,793 SQFT
338 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE UNDER CONTRACT
$467,490
4 bd   
4 ba
   1,793 SQFT
715 COURIER LN
FREDERICK, MD 21701
ACTIVE
$569,900
4 bd   
3 ba  
1 half ba
   2,436 SQFT
871 AMITY ST
FREDERICK, MD 21701
ACTIVE
$739,990
5 bd   
5 ba  
1 half ba
   3,642 SQFT
471 HANSON ST
FREDERICK, MD 21701
ACTIVE
$589,950
4 bd   
3 ba  
1 half ba
   2,316 SQFT
470 TILLER ST
FREDERICK, MD 21701
ACTIVE
$837,900
5 bd   
5 ba
   3,979 SQFT
352 CARROLL WALK AVE
FREDERICK, MD 21701
ACTIVE
$513,990
4 bd   
4 ba
   1,793 SQFT
336 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$468,990
4 bd   
4 ba
   1,793 SQFT
342 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$599,990
4 bd   
3 ba  
1 half ba
   2,270 SQFT
331 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$488,990
4 bd   
4 ba
   1,793 SQFT
340 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$468,990
4 bd   
4 ba
   1,793 SQFT
344 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$569,990
4 bd   
3 ba  
1 half ba
   2,270 SQFT
333 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$499,990
4 bd   
4 ba
   1,793 SQFT
346 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$465,000
4 bd   
4 ba
   1,793 SQFT
818 BOND ST
FREDERICK, MD 21701
ACTIVE
$619,900
3 bd   
3 ba  
1 half ba
   2,564 SQFT
485 HANSON ST
FREDERICK, MD 21701
ACTIVE
$599,990
4 bd   
3 ba  
1 half ba
   2,270 SQFT
337 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$856,990
5 bd   
5 ba
   3,979 SQFT
478 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$660,000
3 bd   
3 ba  
1 half ba
   2,532 SQFT
493 ENSEMBLE WAY
FREDERICK, MD 21701
ACTIVE
$475,000
4 bd   
4 ba
   1,734 SQFT
826 CREEKWAY DR
FREDERICK, MD 21701
ACTIVE
$2,722,600
331 AVIATION WAY #UNIT 3
FREDERICK, MD 21701
COMING SOON
$690,000
4 bd   
3 ba  
2 half ba
   2,783 SQFT
1130 HOLDEN RD
FREDERICK, MD 21701
ACTIVE
$598,000
3 bd   
2 ba  
1 half ba
   2,516 SQFT
1144 HOLDEN RD
FREDERICK, MD 21701
ACTIVE
$600,000
3 bd   
2 ba  
1 half ba
   2,374 SQFT
1133 HOLDEN RD
FREDERICK, MD 21701
ACTIVE
$769,900
5 bd   
3 ba  
1 half ba
   3,902 SQFT
734 HOLDEN RD
FREDERICK, MD 21701
ACTIVE
$250,000
5 DAVIS AVE
FREDERICK, MD 21701
ACTIVE
$724,900
3 bd   
3 ba  
2 half ba
   2,428 SQFT
612 BLANDWOOD RD
FREDERICK, MD 21701
ACTIVE
$699,900
4 bd   
3 ba  
2 half ba
   2,416 SQFT
961 HOLDEN RD
FREDERICK, MD 21701
ACTIVE
$675,000
4 bd   
3 ba  
2 half ba
   2,934 SQFT
501 E 7TH ST
FREDERICK, MD 21701
ACTIVE
$780,000
5 bd   
3 ba  
1 half ba
   3,724 SQFT
803 HOLDEN RD
FREDERICK, MD 21701
ACTIVE
$339,900
3 bd   
1 ba
   1,080 SQFT
14 FRANKLIN ST
FREDERICK, MD 21701
ACTIVE
$1,299,000
801-E E SOUTH ST
FREDERICK, MD 21701
ACTIVE UNDER CONTRACT
$460,000
3 bd   
3 ba
   2,614 SQFT
812 AZTEC DR
FREDERICK, MD 21701
Database last updated  05/09/2025 01:54 AM
 
For Sale Listings
Find a Home
Minimum Sale Price
Maximum Sale Price
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
 
Powered by ListingsToGo™
set @lat=39.4175900;set @lon = -77.3878700;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;