NOT LISTED FOR SALE

2003 Butterfield Overlook Frederick, MD 21702

Clover Hill Neighborhood

Estimated Value: $714,000 - $726,000

5 Beds
4.5 Baths
4,386 Sq Ft
$164/Sq Ft Est. Value

Last Sold March 30, 2021

Last sale price $541,000 $123 Per Sq Ft

Est. 33% increase in value since last sale

Current estimated payment $4,787/month

Highlights

  • Colonial Architecture
  • Bamboo Flooring
  • Open Floorplan
  • Yellow Springs Elementary School Rated A-
  • Sun or Florida Room
  • Community Pool

About This Home

As of March 2021

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!

Last Agent to Sell the Property

Tara Shegogue

L. P. Calomeris Realty License #0225236136 Listed on: 02/23/2021

Last Buyer's Agent

Felicia Tukpeyi

RE/MAX Realty Group

RE/MAX Realty Group

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,616

Year Built

  • Built in 2006

Lot Details

  • 7,800 Sq Ft Lot
  • West Facing Home
  • Property is in very good condition
  • Property is zoned PND

HOA Fees

  • $45 Monthly HOA Fees

Parking

  • 2 Car Direct Access Garage
  • Front Facing Garage
  • Garage Door Opener

Home Design

  • Colonial Architecture
  • Shingle Roof

Interior Spaces

  • Property has 3 Levels
  • Wet Bar
  • Built-In Features
  • Chair Railings
  • Crown Molding
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Fireplace With Glass Doors
  • Gas Fireplace
  • Window Treatments
  • Entrance Foyer
  • Family Room Off Kitchen
  • Open Floorplan
  • Living Room
  • Formal Dining Room
  • Den
  • Sun or Florida Room
  • Finished Basement

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Built-In Oven
  • Stove
  • Cooktop with Range Hood
  • Built-In Microwave
  • Extra Refrigerator or Freezer
  • Ice Maker
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal

Flooring

  • Bamboo
  • Wood
  • Carpet

Bedrooms and Bathrooms

  • En-Suite Primary Bedroom
  • Walk-In Closet

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Utilities

  • Central Heating and Cooling System
  • Vented Exhaust Fan
  • Natural Gas Water Heater

Additional Features

  • Energy-Efficient Appliances
  • Exterior Lighting

Listing and Financial Details

  • Tax Lot 102
  • Assessor Parcel Number 1102258757

Community Details

Overview

  • Tuscarora HOA
  • Built by Greentree Homes
  • Tuscarora Creek Subdivision

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,616

Year Built

Built in 2006

Lot Details

0

HOA Fees

$45 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 2021-02-23
  • Year Built: 2006
  • Automatically Close On Close Date: No
  • Remarks Public: 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!
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • 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 Amenities: Breakfast Area, Built-Ins, Carpet, Ceiling Fan(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
  • Fireplace Features: Fireplace - Glass Doors, Gas/Propane
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Wall Ceiling Types: 9'+ Ceilings
  • Levels Count: 3
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Family Room, Foyer, Study, Sun/Florida Room, Laundry, Bathroom 1
  • Basement: Yes
  • Basement Type: Fully Finished
  • Laundry Type: Main Floor
  • Total Sq Ft: 4504
  • Living Area Sq Ft: 4386
  • Price Per Sq Ft: 173.36
  • Above Grade Finished Sq Ft: 3086
  • Below Grade Finished Sq Ft: 1300
  • Below Grade Sq Ft: 118
  • Total Below Grade Sq Ft: 1418
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 2003

Beds/Baths

  • Bedrooms: 5
  • All Lower Level Bedrooms: 1
  • Lower Level Bedroom: 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
  • Upper Level Full Bathrooms: 3
  • Lower Level Full Bathrooms: 1
  • Lower Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Combination
  • Exterior Features: Exterior Lighting, Sidewalks
  • Roof: Shingle
  • Spa: No
  • 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
  • Parking Features: Asphalt Driveway
  • Garage Features: Garage Door Opener, Garage - Front Entry, Built In, Inside Access
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Attached Garage

Utilities

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

Condo/Co-op/Association

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

Schools

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
  • School District Key: 121139693024
  • School District Source: Listing Agent

Green Features

  • Clean Green Assessed: No

Lot Info

  • Horses: No
  • Improvement Assessed Value: 377400.00
  • Land Assessed Value: 100200.00
  • Land Use Code: 010
  • Lot Size Acres: 0.18
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 7800.00
  • Property Condition: Very Good
  • Year Assessed: 2021
  • Zoning: PND
  • In City Limits: Yes

Building Info

  • Builder Name: Greentree Homes

Rental Info

  • Ground Rent Exists: No
  • Lease Considered: No
  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11579592
  • Tax Annual Amount: 8616.00
  • Assessor Parcel Number: 1102258757
  • Tax Lot: 102
  • Tax Total Finished Sq Ft: 4386
  • County Tax Payment Frequency: Annually
  • Tax Data Updated: No
  • Tax Year: 2021
  • Close Date: 03/30/2021

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 23, 2021
Closed on
Mar 30, 2021
Sold by
Bill Warren and Bill Lourdes
Bought by
Ashu Manfred M
Seller's Agent
Tara Shegogue
L. P. Calomeris Realty
Buyer's Agent
Felicia Tukpeyi
RE/MAX Realty Group
List Price
$535,000
Sold Price
$541,000
Premium/Discount to List
$6,000
1.12%
Current Estimated Value
$718,053

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$177,053
Avg. Annual Appreciation
5.36%
Original Mortgage
$531,201
Interest Rate
3%
Mortgage Type
FHA

Purchase Details

Closed on
Oct 20, 2017
Sold by
Day Development Lc
Bought by
Bill Warren and Bill Lourdes

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$36,000
Interest Rate
3.85%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

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

Purchase History

Date Buyer Sale Price Title Company
Ashu Manfred M $541,000 Commonwealth Land Ttl Ins Co
Bill Warren $450,000 Liberty Titlw And Escrow
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ashu Manfred M $530,058
Closed Ashu Manfred M $531,201
Previous Owner Bill Warren $36,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/30/2021 03/30/21 Sold $541,000 +1.1% $123 / Sq Ft
02/24/2021 02/24/21 Pending -- -- --
02/24/2021 02/24/21 For Sale $535,000 0.0% $122 / Sq Ft
02/23/2021 02/23/21 For Sale $535,000 0.0% $122 / Sq Ft
09/15/2014 09/15/14 Rented $2,800 -1.8% --
09/12/2014 09/12/14 Under Contract -- -- --
07/25/2014 07/25/14 For Rent $2,850 -- --
Source: Bright MLS

Tax History Compared to Growth

Source: Public Records

Tax History

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
2025 $11,002 $654,400 $100,200 $554,200
2024 $11,002 $595,467 $0 $0
2023 $9,643 $536,533 $0 $0
2022 $8,563 $477,600 $100,200 $377,400
2021 $8,554 $477,600 $100,200 $377,400
2020 $8,617 $477,600 $100,200 $377,400
2019 $8,728 $488,700 $100,200 $388,500
2018 $8,507 $476,900 $0 $0
2017 $8,081 $488,700 $0 $0
2016 $7,217 $453,300 $0 $0
2015 $7,217 $433,567 $0 $0
2014 $7,217 $413,833 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Tara Shegogue

    Seller's Agent in 2021

    Tara Shegogue

    L. P. Calomeris Realty

    (240) 745-5299

    1 in this area

    51 Total Sales

    Tara Shegogue
    Section Image
  • Felicia Tukpeyi

    Buyer's Agent in 2021

    Felicia Tukpeyi

    Remax 100

    (301) 758-8716

    1 in this area

    48 Total Sales

    Felicia Tukpeyi
    Section Image
  • Cindy Souza

    Seller's Agent in 2014

    Cindy Souza

    Long & Foster

    (301) 332-5032

    185 Total Sales

    Cindy Souza
    Section Image

  • C

    Buyer's Agent in 2014

    Colleen Geppi

    Taylor Properties

    (240) 367-0273

    9 Total Sales

    Colleen Geppi
    Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR277326

Bright MLS

APN: 02-258757

Maryland Frederick County Frederick 21702 Clover Hill

2003 Butterfield Overlook, Frederick, MD

This home is located at 2003 Butterfield Overlook, Frederick, MD 21702 since 23 February 2021 and is currently estimated at $718,053, approximately $163 per square foot. This property was built in 2006. 2003 Butterfield Overlook is a home located in Frederick County with nearby schools including Yellow Springs Elementary School, Monocacy Middle School, and Gov. Thomas Johnson High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Bright MLS The data relating to real estate for sale on this website appears in part through the BRIGHT Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by BRIGHT through a licensing agreement.
Listing information is from various brokers who participate in the Bright MLS IDX program and not all listings may be visible on the site.
The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale.
Property information displayed is deemed reliable but is not guaranteed.
Copyright 2025 Bright MLS, Inc.

Nearby Homes