Price reduced $10K! Absolutely gorgeous 4 bed room, 2 full and 2 half bath Greentree built home in sought after Tuscarora creek! This home is impeccable! Sun room addition with see thru gas fireplace. Beautiful hardwoods throughout the first level, finished lower level with wet bar and half bath, walk out to a custom built patio, fenced yard, deck off of family room, upgraded cabinets in kitchen and basement, granite counter tops, large owners suite with luxury bath and a large walk in closet, laundry room on the upper level, community pool and clubhouse, and more! This one won't last long! Note: Tax records are incorrect actual above grade sq. ft. is 2886.
Single-familyProperty Type
2006Year Built
8,636 sq ftLot Size
$194Est. Price/Sq.Ft.
2 car garageParking
Listed by Bill Hoffman• RE/MAX Leading Edge
•410-721-9600 (broker)
•rmlebroker@gmail.com (broker)
Bought with Susan Munoz• Long & Foster Real Estate, Inc.
*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
4
Stories
2
Lot width
—
Lot depth
—
Lot size
8,636 Sq. Ft.
Year renovated
—
Sq. Ft.
3,574
Year built
2006
Style
Single Family Residential
County
Frederick County
APN
02 258803
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 8, 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 Door Opener, Garage - Front Entry
# of Total Garage and Parking Spaces: 2
Has Garage
# of Garage Spaces: 2
Attached Garage
Interior
Virtual Tour
Bedroom Information
# of Bedrooms On 1st Upper Level: 4
Bathroom Information
# of Bathrooms (Full) On 1st Upper Level: 2
# of Bathrooms (Half) On Main Level: 1
# of Bathrooms (Half) On 1st Lower Level: 1
# of Bathrooms (Full) On All Upper Levels: 2
# of Bathrooms (Half) On All Lower Levels: 1
# of Bathrooms (Half): 2
# of Bathrooms (Full): 2
Interior Information
Living Area Sq.Ft. Source: Estimated
Room Information
Living Room, Dining Room, Kitchen, Family Room, Breakfast Room, Sun/Florida Room, Laundry, Recreation Room, Utility Room, Half Bath
Laundry Type: Upper Floor
Fireplace Information
Has Fireplace
# of Fireplaces: 1
Double Sided, Mantel(s), Gas/Propane
Basement Information
Basement: Yes
Daylight, Full, Improved, Rear Entrance, Walkout Level, Windows
Basement Finished Percent: 95.00
Exterior
Property Information
Property Manager Present
Total Below Grade Sq. Ft.: 1200
Improvement Assessed Value: $286,100
Ownership Interest: Fee Simple
Year Built Source: Assessor
Building Information
Builder Name: Greentree Homes
Construction Materials: Brick Front, Vinyl Siding
Other Structures: Above Grade, Below Grade
Outdoor Living Structures: Deck(s), Patio(s)
Structure Type: Detached
Exterior Information
Fencing: Rear, Wood
Pool Information
Community Pool Features: Gunite, In Ground
Community Pool
Lot Information
Tidal Water: No
Land Information
Land Assessed Value: $100,300
Above Grade Information
Finished Sq.Ft.: 2,574
Finished Sq.Ft. Source: Assessor
Below Grade Information
Unfinished Sq.Ft.: 200
Unfinished Sq.Ft. Source: Estimated
Finished Sq.Ft.: 1,000
Finished Sq.Ft. Source: Estimated
Financial
Tax Information
City/Town Tax: $2,890
County Tax: $4,171
Tax Assessed Value: $386,400
Tax Year: 2020
Tax Annual Amount: $7,150
Assessments Information
Year Assessed: 2020
Utilities
Utilities Information
Central Air
Cooling Type: Central A/C
Cooling Fuel: Electric
Forced Air
Heating Fuel: Natural Gas
Hot Water: Natural Gas
Sewer Septic: Public Sewer
Water Source: Public
Location
Homeowners Association Information
HOA Fee: $80.66
HOA Fee Frequency: Monthly
School Information
Elementary School: YELLOW SPRINGS
Middle Or Junior School: MONOCACY
High School: GOVERNOR THOMAS JOHNSON
School District Name: FREDERICK COUNTY PUBLIC SCHOOLS
Elementary School Source: 3rd Party
Middle School Source: 3rd Party
High School Source: 3rd Party
School District Source: 3rd Party
Location Information
In City Limits
Directions: Rt. 70 to Rt. 15N toexit 14 Rosemont to traffic circle first exit to Christopher Crossing to next traffic circle 2nd exit to Walter Martz to left onto Tuscarora Creek Rd. to left onto Butterfield Oval
Municipality: Frederick City
Public facts
Beds: —
Baths: 4.0
Sq. Ft.: 3,574
Stories: 2.0
Lot Size: 8,636 square feet
Style: Single Family Residential
Year Built: 2006
Year Renovated: —
County: Frederick County
APN: 02 258803
Home facts updated by county records on Oct 8, 2026
Around this home
Schools
Yellow Springs Elementary School
Public PreK-5 • Assigned • 1.0mi
8/10
Monocacy Middle School
Public 6-8 • Assigned • 1.6mi
6/10
Gov. Thomas Johnson High School
Public 9-12 • Assigned • 3.0mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk 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, 16 days in 30 years
3/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 • 21702
Average low and high temperatures (°F)
34
21
40
26
58
38
66
47
71
54
82
64
86
69
79
62
77
59
66
47
54
38
41
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
$660,000 – $799,000
Reach more buyers when you sell with Redfin. Save up to $6,946 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.