Stunning custom-built home located in the highly sought-after Keller Farm Community! Situated on a picture-perfect 1.24-acre lot with panoramic mountain views, spectacular outdoor living space, and loaded with updates throughout! Boasting polished elegance, superior craftsmanship, sophisticated detail, and design-inspired features in every room! Gleaming hardwood floors, custom window coverings, crown molding, and lofty windows embroider the common areas. Sure to be the envy of any guest the gourmet eat-in kitchen is appointed with sleek stainless steel appliances, range hood, granite countertops, a center island, decorative backsplash, breakfast bar, breakfast room, pantry, and views of the outdoor oasis. Designed for entertaining and everyday living the impressive family room is adorned with a stone profile fireplace and allows easy access to the covered deck. Formal living embellished with French doors. Full bath and laundry | mud room complete the main level. The upper-level owner’s suite is graced with an expansive walk-in closet and a luxurious full bath with spa-like elements including double vanity, a decadent soaking tub, and a glass-enclosed shower. Two additional bedrooms, an en-suite full bath, and a spacious loft conclude the upper-level sleeping quarters. Travel downstairs to find the recreation room, bar, bedroom, full bath, and storage. Landscaped grounds, custom patio, retractable awning, deck, covered front porch, secure storage, expansive lot, two-car attached garage, and panoramic mountain views. This remarkable property aims to please and is truly the embodiment of Maryland's good life! A MUST-SEE!
Awesome 3/4 BR, 4BA Cape, reduced $15K below appraisal! 1.24 AC lot in close-in location with no city taxes! Gourmet kit w/ cherry cabs, granite counters, commercial apps, open to casual dining area & fabulous Grt rm w/ split rock FP. Huge owner's STE w/ incredible bath + 2 more BR up + loft. . Hardwoods galore. Fin low lvl w/ rec-rm, full BA & den/BR. Incredible lot w/ spectacular mtn views.
*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
1.5
Lot width
—
Lot depth
—
Lot size
1.24 Acres
Year renovated
—
Sq. Ft.
3,605
Year built
1977
Style
Single Family Residential
County
Frederick County
APN
21 417351
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 17, 2026.
R1
Residential District 1
The purpose of the residential density districts is to promote healthful and convenient distribution of population with sufficient densities to maintain a high standard of physical design and community service. Residential density districts will conform to the County Comprehensive Plan and will be located within areas identified for residential development. The districts, as a group, are intended to provide for a variety of dwelling types and densities and to offer housing choices at various economic levels. It is further the intent to establish various densities of residential developments in order to efficiently and effectively provide for necessary public services and facilities. The following residential density districts and maximum densities are hereby established.
Permitted uses
Include but are not limited to:
Agriculture
Housing-Group
Housing-Single unit
Housing-Multiple units
Property details
Parking
Parking Information
# of Attached Garage Spaces: 2
Garage Features: Garage - Side Entry, Garage Door Opener, Inside Access, Oversized
# of Total Garage and Parking Spaces: 5
Has Garage
# of Garage Spaces: 2
Driveway - # of Spaces: 3
Asphalt Driveway
Attached Garage, Driveway
Interior
Virtual Tour
Bedroom Information
# of Bedrooms On 1st Upper Level: 3
# of Bedrooms On 1st Lower Level: 1
Bathroom Information
# of Bathrooms (Full) On 1st Upper Level: 2
# of Bathrooms (Full) On Main Level: 1
# of Bathrooms (Full) On 1st Lower Level: 1
# of Bathrooms (Full) On All Upper Levels: 2
# of Bathrooms (Full) On All Lower Levels: 1
# of Bathrooms (Full): 4
Interior Information
Appliances: Built-In Range, Dishwasher, Disposal, Exhaust Fan, Extra Refrigerator/Freezer, Icemaker, Oven - Self Cleaning, Oven/Range - Gas, Range Hood, Refrigerator, Stainless Steel Appliances, Washer/Dryer Hookups Only, Water Conditioner - Owned, Water Heater
Lot Features: Front Yard, Landscaping, Premium, Rear Yard, SideYard(s), Trees/Wooded
Tidal Water: No
Land Information
Land Assessed Value: $91,800
Above Grade Information
Finished Sq.Ft.: 2,405
Finished Sq.Ft. Source: Assessor
Below Grade Information
Unfinished Sq.Ft.: 673
Unfinished Sq.Ft. Source: Assessor
Finished Sq.Ft.: 975
Finished Sq.Ft. Source: Assessor
Financial
Tax Information
County Tax: $5,611
Tax Assessed Value: $488,333
Tax Year: 2021
Tax Annual Amount: $5,611
Assessments Information
Year Assessed: 2022
Utilities
Utilities Information
Central Air
Cooling Type: Ceiling Fan(s), Central A/C, Multi Units, Programmable Thermostat, Zoned
Cooling Fuel: Electric
Forced Air, Heat Pump - Gas BackUp, Heat Pump(s), Hot Water, Programmable Thermostat, Zoned
Heating Fuel: Electric, Propane - Leased
Hot Water: 60+ Gallon Tank, Electric
Sewer Septic: Holding Tank, Septic Exists, On Site Septic
Water Source: Well, Private, Conditioner, Filter
Location
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: Listing Agent
Middle School Source: Listing Agent
School District Source: Listing Agent
Location Information
Outside City Limits
Directions: From I-270 N, continue onto US-40 W. Continue onto US-15 N. Take exit 14 for Rosemont Avenue. Keep right at the fork and merge onto Rosemont Ave. Continue onto Yellow Springs Rd. Pass through 2 traffic circles, continuing straight to stay on Yellow Springs Rd. Your destination will be on the left. Welcome Home!
Municipality: Unincorporated
Public facts
Beds: —
Baths: 4.0
Sq. Ft.: 3,605
Stories: 1.5
Lot Size: 1.24 acres
Style: Single Family Residential
Year Built: 1977
Year Renovated: —
County: Frederick County
APN: 21 417351
Home facts updated by county records on Jul 17, 2026
Around this home
Schools
Yellow Springs Elementary School
Public PreK-5 • Assigned • 0.3mi
8/10
Monocacy Middle School
Public 6-8 • Assigned • 2.8mi
6/10
Gov. Thomas Johnson High School
Public 9-12 • Assigned • 3.9mi
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
5/10 Heat Factor
7 days above 105° expected this year, 17 days in 30 years
3/10 Wind Factor
5% chance of strong winds in next 30 years
2/10 Air Factor
1 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
87
70
79
62
76
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
$794,000 – $961,000
Reach more buyers when you sell with Redfin. Save up to $8,352 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.