MAJOR REDUCED--Original Model Home, No Luxuries Spared, 1st FL Mstr w/ full bath, dual WIC, Gourmet Kit w/ SS Appl & Granite counters, Gleaming Wood Floors on Main, Gas FP in Fmly RM, 2nd Mstr Suite w/ extra Lg WIC & Gas FP, Tile bath w/ jetted tub, dual vanity, Fully finished basement w/ 2 sep rooms, Wet Bar w/ Granite, Wine Fridge, sep Media Room. 2 car garage, Landscaped, Trex Deck-SHORT SALE
Single-familyProperty Type
2009Year Built
7,800 sq ftLot Size
$132Est. Price/Sq.Ft.
2 car garageParking
Listed by Darren Ahearn• RE/MAX Results
•301-698-5005 (broker)
•sandyolson@remax.net (broker)
Listed by Filomena Thompson• RE/MAX Results
•301-698-5005 (broker)
•sandyolson@remax.net (broker)
Bought with Seth Shapero• Long & Foster Real Estate, Inc.
Corner lot. Kitchen opens to living room and breakfast area. Master on main level with two closets. Four bedrooms on upper level including second master with fireplace. Laundry upstairs. Finished walkout basement with full bath and wet bar. Also has...
two additional rooms just missing closets to be labeled bedrooms.
10 years ago• May not reflect the current state of the home
*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
7,800 Sq. Ft.
Year renovated
—
Sq. Ft.
3,455
Year built
2009
Style
Single Family Residential
County
Frederick County
APN
02 258749
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.
HOA/Condo/Coop Management Type: Professional - Off-site
HOA/Condo/Coop Amenities: Baseball Field, Bike Trail, Club House, Common Grounds, Community Center, Fencing, Pool - Outdoor, Soccer Field
HOA Fee: $48.50
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
Location Information
In City Limits
Directions: Route 15 to Opossumtown Pike, Turn Left onto Poole Jones Road--turns into Walter Martz Road, Left onto Tuscarora Creek BLVD, 1st Left onto Butterfield Overlook, Home is on the Left
Municipality: FREDERICK CITY
Has View
Public facts
Beds: —
Baths: 3.5
Sq. Ft.: 3,455
Stories: 2.0
Lot Size: 7,800 square feet
Style: Single Family Residential
Year Built: 2009
Year Renovated: —
County: Frederick County
APN: 02 258749
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
$636,000 – $770,000
Reach more buyers when you sell with Redfin. Save up to $6,694 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.