NOT LISTED FOR SALE

Estimated Value: $677,706

5 Beds
3.5 Baths
3,264 Sq Ft
$208/Sq Ft Est. Value

Sale Details

Date Sold: May 29, 2026

Last sale price $680,000 $208 Per Sq Ft

Current estimated payment $4,676 / mo

5 Days on Market

Highlights

  • Eat-In Gourmet Kitchen
  • Open Floorplan
  • Wood Flooring
  • Yellow Springs Elementary School Rated A-
  • Colonial Architecture
  • Loft

About This Home

As of May 2026

Welcome to this stunning 5-bedroom, 3.5-bath Colonial/Craftsman home in the highly desirable Tuscarora Creek community, offering over 3,200 sq. ft. of beautifully customized living space. Built in 2020 and enhanced with thoughtful upgrades throughout, this home blends modern comfort with timeless design.
The main level features a bright, open layout anchored by a spacious family room and a gourmet kitchen with a large center island, white cabinetry, and abundant counter space. Just off the foyer, a private first‐floor office showcases floor‐to‐ceiling built‐in bookcases, creating an ideal workspace or library.
Custom windows—including larger profile windows and select transoms—flood the home with natural light, highlighting the detailed moldings and trim work that elevate every room. The family room includes a custom bar, perfect for entertaining. Upstairs, the primary suite is a true retreat with a tray ceiling, a walk‐in closet outfitted with high‐end built‐ins, and a luxury bath featuring a soaking tub and separate glass shower. A bright and open second‐level family room/loft adds flexible living space, ideal for relaxation or play. The large bedroom‐level laundry room offers exceptional convenience with custom cabinetry and countertop workspace. The fully finished lower level provides a fifth bedroom, full bath, and additional living area—ideal for guests, multigenerational living, or a private studio.
Outside, enjoy a covered front porch, a white vinyl picket‐fenced backyard, and a 2‐car garage with additional driveway parking. Located in a vibrant, amenity‐rich community offering a pool, clubhouse, and walking paths, this home provides the perfect blend of comfort, style, and convenience—just minutes from shopping, dining, and commuter routes.

Last Agent to Sell the Property

Nancy Hulsman

(410) 740-7100 kenny.fulton@cbrealty.com Coldwell Banker Realty Brokerage Phone: 4107407100 License #79849 Listed on: 04/08/2026

Coldwell Banker Realty

Last Buyer's Agent

Mary Neubauer

(301) 831-5099 home@charisrealty.com Charis Realty Group

Charis Realty Group

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,010

Year Built

  • Built in 2020

Lot Details

  • 5,000 Sq Ft Lot
  • Vinyl Fence
  • Landscaped
  • Back Yard Fenced and Front Yard
  • Property is in excellent condition

HOA Fees

  • $90 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Craftsman Architecture
  • Architectural Shingle Roof
  • Vinyl Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Wet Bar
  • Built-In Features
  • Bar
  • Wainscoting
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Recessed Lighting
  • Family Room Off Kitchen
  • Living Room
  • Dining Room
  • Home Office
  • Loft
  • Storage Room
  • Laundry Room

Kitchen

  • Eat-In Gourmet Kitchen
  • Kitchen Island
  • Upgraded Countertops

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • En-Suite Bathroom
  • Walk-In Closet
  • Soaking Tub
  • Walk-in Shower

Finished Basement

  • Heated Basement
  • Basement Fills Entire Space Under The House
  • Connecting Stairway
  • Basement Windows

Parking

  • 6 Parking Spaces
  • 4 Driveway Spaces
  • 2 Attached Carport Spaces
  • Private Parking
  • On-Street Parking

Utilities

  • Forced Air Heating and Cooling System
  • Electric Water Heater

Listing and Financial Details

  • Tax Lot 637
  • Assessor Parcel Number 1102593658

Community Details

Overview

  • Tuscarora Creek Subdivision

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,010

Year Built

Built in 2020

Lot Details

5,000 Sq Ft Lot

HOA Fees

$90 per month

Listing Details

  • Standard Status: Closed
  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial, Craftsman
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 4/8/2026 12:00:00 AM
  • Year Built: 2020
  • Automatically Close On Close Date: No
  • MLS Status: CLOSED-BRIGHT
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Bar, Bathroom - Soaking Tub, Bathroom - Stall Shower, Bathroom - Walk-In Shower, Built-Ins, Carpet, Ceiling Fan(s), Dining Area, Family Room Off Kitchen, Floor Plan - Open, Kitchen - Eat-In, Kitchen - Gourmet, Kitchen - Island, Kitchen - Table Space, Primary Bath(s), Recessed Lighting, Upgraded Countertops, Walk-In Closet(s), Wainscotting, Wet/Dry Bar, Wood Floors
  • Fireplace: No
  • Wall Ceiling Types: 9'+ Ceilings
  • Foundation Details: Concrete Perimeter
  • Levels Count: 3
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Kitchen, Family Room, Laundry, Loft, Office, Storage Room, Bathroom 3, Primary Bathroom, Half Bath
  • Basement: Yes
  • Basement Type: Connecting Stairway, Full, Fully Finished, Heated, Improved, Windows
  • Total Sq Ft: 3900
  • Living Area Sq Ft: 3264
  • Price Per Sq Ft: 245.98
  • Above Grade Finished Sq Ft: 2764
  • Below Grade Finished Sq Ft: 500
  • Below Grade Sq Ft: 636
  • Total Below Grade Sq Ft: 1136
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 5
  • All Lower Level Bedrooms: 1
  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 2
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 2.00
  • Lower Levels Bathrooms: 1.00
  • Lower Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Vinyl Siding
  • Exterior Features: Sidewalks
  • Roof: Architectural Shingle
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage: No
  • Parking Features: Paved Driveway, Private
  • Attached Carport Spaces: 2
  • Total Garage And Parking Spaces: 6
  • Type Of Parking: Attached Carport, Driveway, On Street
  • Number of Spaces in Driveway: 4

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C, Ceiling Fan(s)
  • Heating Fuel: Electric
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 89.53
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA: Yes
  • Senior Community: No

Schools

  • School District Source: Listing Agent

Lot Info

  • Fencing: Vinyl, Rear
  • Lot Features: Front Yard, Landscaping, Rear Yard
  • Lot Size Acres: 0.11
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 5000.00
  • Property Condition: Excellent
  • Zoning: R
  • In City Limits: No

Rental Info

  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 10010.00
  • Assessor Parcel Number: 1102593658
  • Tax Lot: 637
  • County Tax Payment Frequency: Annually
  • Tax Year: 2025

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 8, 2026
Closed on
May 29, 2026
Sold by
Pfeiffer Kyle and Kyle B Pfeiffer Revocable Trust
Bought by
Seller's Agent
Nancy Hulsman
Coldwell Banker Realty
Buyer's Agent
Mary Neubauer
Charis Realty Group
List Price
$679,900
Sold Price
$680,000
Premium/Discount to List
$100
0.01%
Views
51
Current Estimated Value
$677,706

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$2,294
Avg. Annual Appreciation
-1.12%
Original Mortgage
$578,000
Outstanding Balance
$576,911
Interest Rate
6.3%
Mortgage Type
New Conventional
Estimated Equity
$100,795

Purchase Details

Closed on
Nov 25, 2024
Sold by
Pfeiffer Kyle Burke and Pfeiffer Angela Lynn
Bought by
Kyle B Pfeiffer Revocable Trust and Angela L Pfeiffer Revocable Trust

Purchase Details

Closed on
Sep 20, 2019
Sold by
Dream Finders Homes Llc
Bought by
Pfeiffer Kyle Burke and Pfeiffer Angela Lynn

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$352,000
Interest Rate
3.6%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 13, 2018
Sold by
Drsfa Llc
Bought by
Dream Finders Homes Llc

Purchase Details

Closed on
Dec 22, 2016
Sold by
Day Development Company Lc
Bought by
Drsfa Llc
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Clover Hill, MD

See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$680,000 Fidelity National Title
Kyle B Pfeiffer Revocable Trust -- None Listed On Document
Pfeiffer Kyle Burke $440,000 Village Settlements Inc
Dream Finders Homes Llc $308,250 None Available
Drsfa Llc $1,952,250 Keystone Title Settlement Se
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $578,000
Previous Owner Pfeiffer Kyle Burke $476,000
Previous Owner Pfeiffer Kyle Burke $82,000
Previous Owner Pfeiffer Kyle Burke $352,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
05/29/2026 05/29/26 Sold $680,000 0.0% $208 / Sq Ft
04/22/2026 04/22/26 For Sale $679,900 0.0% $208 / Sq Ft
04/13/2026 04/13/26 Pending -- -- --
04/08/2026 04/08/26 For Sale $679,900 -- $208 / Sq Ft
Source: Bright MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2026 $9,116 $578,700
2025 $9,116 $548,400 $100,000 $448,400
2024 $8,704 $507,000 $0 $0
2023 $8,043 $465,600 $0 $0
2022 $7,615 $424,200 $100,000 $324,200
2021 $7,607 $424,200 $100,000 $324,200
2020 $7,592 $424,200 $100,000 $324,200
2019 $1,768 $100,000 $100,000 $0
2018 $1,784 $100,000 $100,000 $0
2017 $1,172 $100,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR2079870

Bright MLS

APN: 02-593658

Your Personal Tour Guide

Ask me questions while you tour the home.