Welcome home! This 5 bed, 4.5 bath former model home in Tuscarora Creek boasts over 3,000 finished sq ft. and has everything you could want and more! Dual Zone heating & cooling, 9ft ceilings, beautiful millwork, ample work from home spaces, recessed lighting, gas fireplace, insulated and dry-walled garage, mountain views, maintenance-free Trex deck and stone patio overlooking private forest area, wet bar for entertaining, tons of closet space, and the list goes on. This home also features New GE kitchen suite: Gas Stove/Oven, Refrigerator, Dishwasher, Microwave (2020), New ceiling fans and toilets (2020), Entire house painted (2019), Exterior wood painted (2019), New Architectural roof with warranty (2018), and a New washer and dryer (2017). Make memories with family and friends while enjoying the activity field, clubhouse and pool directly across the street. Easy access to Downtown Frederick, Shopping, Ft. Detrick and commuter routes. Come see this home before it's too late!
*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.5
Stories
2
Lot width
—
Lot depth
—
Lot size
7,800 Sq. Ft.
Year renovated
—
Sq. Ft.
4,386
Year built
2006
Style
Single Family Residential
County
Frederick County
APN
02 258757
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, Built In, Inside Access
# of Total Garage and Parking Spaces: 2
Has Garage
# of Garage Spaces: 2
Asphalt Driveway
Attached Garage
Interior
Virtual Tour
Bedroom Information
# of Bedrooms On 1st Upper Level: 4
# of Bedrooms On 1st Lower Level: 1
Bathroom Information
# of Bathrooms (Full) On 1st Upper Level: 3
# of Bathrooms (Half) On Main Level: 1
# of Bathrooms (Full) On 1st Lower Level: 1
# of Bathrooms (Full) On All Upper Levels: 3
# of Bathrooms (Full) On All Lower Levels: 1
# of Bathrooms (Half): 1
# of Bathrooms (Full): 4
Interior Information
Appliances: Built-In Microwave, Cooktop, Dishwasher, Disposal, Dryer, Energy Efficient Appliances, Exhaust Fan, Extra Refrigerator/Freezer, Icemaker, Microwave, Oven - Wall, Range Hood, Refrigerator, Stove, Washer, Stainless Steel Appliances
Flooring Type: Hardwood, Bamboo
Interior Features: Breakfast Area, Built-Ins, Carpet, CeilngFan(s), Chair Railings, Combination Dining/Living, Combination Kitchen/Dining, Combination Kitchen/Living, Crown Moldings, Dining Area, Family Room Off Kitchen, Formal/Separate Dining Room, Kitchen - Eat-In, Pantry, Walk-in Closet(s), Wet/Dry Bar, Window Treatments, Wood Floors, Other
School District Name: FREDERICK COUNTY PUBLIC SCHOOLS
School District Source: Listing Agent
Location Information
In City Limits
Directions: Oppossumtown Pike to Poole Jones Rd then a left on Tuscarora Creek then left onto Butterfield Overlook. House is on the right hand side of the street.
Municipality: Frederick City
Public facts
Beds: —
Baths: 4.5
Sq. Ft.: 4,386
Stories: 2.0
Lot Size: 7,800 square feet
Style: Single Family Residential
Year Built: 2006
Year Renovated: —
County: Frederick County
APN: 02 258757
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.7mi
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
$706,000 – $855,000
Reach more buyers when you sell with Redfin. Save up to $7,426 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.