$699,999
COMING SOON SEP 04, 2026

Estimated payment $4,801/month

Total Views 891
5 Beds
4.5 Baths
3,816 Sq Ft
7,976 Sq Ft Lot

Highlights

  • Contemporary Architecture
  • 1 Fireplace
  • Farmhouse Sink
  • Yellow Springs Elementary School Rated A-
  • Community Pool
  • Double Oven

About This Home

Wow! This stunning home offers a well-designed floor plan with over 3,800 finished square feet of living space in the highly sought-after Tuscarora Creek community! Enjoy your morning coffee on the charming covered front porch or unwind in the evening in your own backyard oasis! The eat-in kitchen is a gourmet chef’s dream, featuring ample cabinetry, quartz countertops, a custom tile backsplash, a farmhouse sink, an oversized center island complete with a breakfast bar, a walk-in pantry, and stainless steel appliances including a double oven. This culinary haven seamlessly flows into a light-filled family room featuring a cozy gas fireplace. The formal dining room is the perfect place to entertain guests. Enjoy working from home in the main-level office. A convenient half bathroom completes this level. Upstairs, you will find four spacious bedrooms upgraded with ceiling fans and three full bathrooms. Retreat to the luxurious primary bedroom suite featuring a spa-like bathroom with dual sinks, a custom tile shower with a built-in bench, a separate water closet, and two large walk-in closets. The second and third bedrooms share a Jack-and-Jill bathroom with dual sinks. The fourth bedroom is a private retreat with two closets and its own en-suite bathroom. This level also features a convenient laundry room. The lower level offers even more living space with an additional bedroom and a full bathroom. Outside, you can entertain on the low-maintenance deck or grill dinner on the paver patio. The large, flat, fenced-in yard offers ample space for relaxation or outdoor activities. Enjoy the luxury amenities of Tuscarora Creek, including the clubhouse, pool, walking trails, playgrounds, and a tot lot. This home’s prime location offers endless entertainment options and is just a short distance from various shops and restaurants, grocery stores, and the charming downtown area of Frederick. Enjoy easy access to major commuter routes as well. Don't miss the opportunity to make this stunning house your home!

Listing Agent

Brooke Steinhoff

(877) 366-2213 mdbrokers@lptrealty.com LPT Realty, LLC Brokerage Phone: 8773662213

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,407

Year Built

  • Built in 2020

Lot Details

  • 7,976 Sq Ft Lot
  • Property is in excellent condition
  • Property is zoned PUD

HOA Fees

  • $90 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Front Facing Garage
  • Driveway

Home Design

  • Contemporary Architecture
  • Traditional Architecture
  • Permanent Foundation
  • Vinyl Siding

Interior Spaces

  • Property has 3 Levels
  • 1 Fireplace
  • Laundry Room
  • Partially Finished Basement

Kitchen

  • Double Oven
  • Farmhouse Sink

Bedrooms and Bathrooms

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Electric Water Heater

Listing and Financial Details

  • Coming Soon on 9/4/26
  • Tax Lot 351
  • Assessor Parcel Number 1102595983

Community Details

Overview

  • Tuscarora Creek Subdivision

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,407

Year Built

Built in 2020

Lot Details

7,976 Sq Ft Lot

HOA Fees

$90 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Contemporary, Traditional
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 9/4/2026 12:00:00 AM
  • Federal Flood Zone: No
  • Year Built: 2020
  • Special Features: ComingSoon
  • Property Sub Type: Detached

Interior Features

  • Fireplaces Count: 1
  • Fireplace: Yes
  • Foundation Details: Permanent
  • Levels Count: 3
  • Basement: Yes
  • Basement Type: Partially Finished
  • Laundry Type: Has Laundry
  • Total Sq Ft: 4224
  • Living Area Sq Ft: 3816
  • Price Per Sq Ft: 248.58
  • Above Grade Finished Sq Ft: 2816
  • Below Grade Finished Sq Ft: 1000
  • Below Grade Sq Ft: 408
  • Total Below Grade Sq Ft: 1408
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 5
  • All Lower Level Bedrooms: 1
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 3
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 3.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
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Garage Features: Garage - Front Entry
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Attached Garage, Driveway

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

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

Schools

  • School District Source: Listing Agent

Lot Info

  • Lot Size Acres: 0.18
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 7976.00
  • Property Condition: Excellent
  • Zoning: PUD
  • In City Limits: Yes

Rental Info

  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 10407.00
  • Assessor Parcel Number: 1102595983
  • Tax Lot: 351
  • County Tax Payment Frequency: Annually
  • Tax Year: 2025

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Map

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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

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 $10,495 $609,300
2025 $9,708 $570,100 $100,200 $469,900
2024 $9,708 $524,867 $0 $0
2023 $8,630 $479,633 $0 $0
2022 $7,796 $434,400 $100,200 $334,200
2021 $7,693 $423,233 $0 $0
2020 $886 $50,100 $50,100 $0
2019 $886 $50,100 $50,100 $0
2018 $894 $50,100 $50,100 $0
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 Prior Sale
03/24/2023 03/24/23 Sold $685,000 0.0% $243 / Sq Ft View Prior Sale
02/06/2023 02/06/23 Pending -- -- --
02/06/2023 02/06/23 Price Changed $685,000 +1.5% $243 / Sq Ft
02/02/2023 02/02/23 For Sale $674,900 -- $240 / Sq Ft
Source: Bright MLS

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 Type Sale Price Title Company
Deed $685,000 Legacyhouse Title
Deed $491,039 Keystone Ttl Setmnt Svcs Llc
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 Loan Amount Loan Type
Open $582,250 New Conventional
Previous Owner $482,144 FHA
Source: Public Records

Source: Bright MLS

MLS Number: MDFR2088096

Bright MLS

APN: 02-595983

Your Personal Tour Guide

Ask me questions while you tour the home.