4BR 3.5BA brick front Waterford model with 1st floor master. Covered portico opens to 2 story foyer, hrdwd flrs, arched doorways, decorative colums, beautiful trim work. Open kitchen w/ island, dbl ovens, pantry, brkfst room. Sunny 2 story great room w/ stone FP. Formal LR & DR. 2 upper lvl BRs w/ FBA. Finished LL w/ BR, FBA & huge rec room! Screened-in porch, deck, patio, 2 car gar & water views!
Single-familyProperty Type
2004Year Built
8,669 sq ftLot Size
$195Est. Price/Sq.Ft.
2 car garageParking
Listed by Elaine Koch• RE/MAX Metropolitan Realty
•301-947-6500 (broker)
Bought with Charles Seymour• Turning Point Real Estate
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
—
Baths
3.5
Stories
2
Lot width
—
Lot depth
—
Lot size
8,669 Sq. Ft.
Year renovated
—
Sq. Ft.
4,237
Year built
2004
Style
Single Family Residential
County
Frederick County
APN
02 247348
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 17, 2026.
R-4
Low Density Residential District
The R4 District is intended to provide for residences in an urban residential environment with a maximum density of 4 dwellings per acre. In addition, this district is intended to accommodate a complement of residential support uses normally utilized during the daily activities of residents, to protect these areas from the encroachment of incompatible uses and to guide development within the district to occur in a manner that complies with the Comprehensive Plan.
Permitted uses
Include but are not limited to:
Agriculture
Housing-Single unit
Park & open space
Property details
Parking
Parking Information
# of Attached Garage Spaces: 2
Garage Features: Garage - Front Entry, Garage Door Opener
HOA/Condo/Coop Amenities: Basketball Courts, Billiard Room, Club House, Common Grounds, Community Center, Exercise Room, Library, Meeting Room, Party Room, Pool - Outdoor, Putting Green, Tennis Courts, Tot Lots/Playground
HOA Fee: $187.50
HOA Fee Frequency: Monthly
Location Information
In City Limits
Directions: I-270 to US-40W to US-15N. Right onto Monocacy Blvd. Left onto Waterside Drive. Left onto Mill Island Pkwy. Left onto Mill Race Road. Right onto Arbor Sq Dr. Left to stay on Arbor Sq Dr. Stay straight onto Brook Valley Rd to 2677 on the left
Municipality: FREDERICK CITY
Has View
Public facts
Beds: —
Baths: 3.5
Sq. Ft.: 4,237
Stories: 2.0
Lot Size: 8,669 square feet
Style: Single Family Residential
Year Built: 2004
Year Renovated: —
County: Frederick County
APN: 02 247348
Home facts updated by county records on Jul 17, 2026
Around this home
Schools
Walkersville Elementary School
Public PreK-5 • Assigned • 1.8mi
6/10
Walkersville Middle School
Public 6-8 • Assigned • 2.4mi
9/10
Walkersville High School
Public 9-12 • Assigned • 1.9mi
6/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
6/10 Flood Factor
Estimated 37-51% chance of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
6/10 Heat Factor
7 days above 105° expected this year, 15 days in 30 years
4/10 Wind Factor
7% chance of strong winds in next 30 years
2/10 Air Factor
0 unhealthy days expected this year, 1 days in 30 years
Provided by First Street
Historical weather
Frederick, MD • 21701
Average low and high temperatures (°F)
37
23
43
28
61
40
70
49
74
56
85
66
91
71
84
64
79
59
69
46
57
39
43
28
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.2 hours in
June and 3.9 hours in December, placing it below the
U.S. average for solar exposure.
9.2 hrs
3.9 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$784,000 – $948,000
Reach more buyers when you sell with Redfin. Save up to $8,243 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.