NOT LISTED FOR SALE

2003 Butterfield Overlook Frederick, MD 21702

Clover Hill Neighborhood

Estimated Value: $614,000 - $715,000

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

Last Sold March 30, 2021

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

Est. 26% increase in value since last sale

Current estimated payment $4,797/month

1 Day on Market

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%
Total Days on Market
1
Current Estimated Value
$683,286

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$142,286
Avg. Annual Appreciation
5.73%
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

Similar Homes in Frederick, MD

  • 7832 Old Receiver Rd, Frederick, MD 21702

    $775,000

    • 5 Beds
    • 4.5 Baths
    • 4,415 Sq Ft
    • 7832 Old Receiver Rd
    • Frederick, MD

    Welcome home to 7832 Old Receiver Road! Discover a rare chance to own a stunning home, built in 2021, on a sprawling 1.6-acre lot. The expansive interior features 4 bedrooms and 3 full baths on the upper level of the home. The main level of the home is complete with a spacious, open concept living plan. You'll find a generously sized family room anchored by a custom stone and marble wall with an

    Jim Bass Real Estate Teams, LLC

    Section Image
  • 1115 Lakin Dr, Frederick, MD 21702

    $729,000

    • 5 Beds
    • 4.5 Baths
    • 4,183 Sq Ft
    • 1115 Lakin Dr
    • Frederick, MD

    This stunning home has been meticulously maintained by the original owner who added all the major upgrades to their build and chose the finest materials and design features. The premium front elevation with welcoming front porch will delight you with its durable epoxy surface and views. The interior is fabulous and has a modern floor plan that you will love. There is a main level office with

    Marc Infeld Long & Foster Real Estate, Inc.

    Section Image
  • 1710 Trotter St, Frederick, MD 21702

    $830,000

    • 6 Beds
    • 4 Baths
    • 4,396 Sq Ft
    • 1710 Trotter St
    • Frederick, MD

    Welcome to this stunning single-family home in the highly sought-after Kellerton community! From the moment you arrive, you'll be charmed by the inviting front porch—perfect for enjoying your morning coffee.Step inside to a bright and welcoming foyer, where you'll find a private home office to the right, featuring an elegant arched bay window that fills the space with natural light. A full bath

    Sharon Lelm Charis Realty Group

    Section Image
  • 1936 Moran Dr, Frederick, MD 21702

    $768,000

    • 4 Beds
    • 5.5 Baths
    • 5,544 Sq Ft
    • 1936 Moran Dr
    • Frederick, MD

    Stop searching—this is the home where the owner has truly done it all. With nearly 6,000 sq ft of living space and an open‐concept layout, this stunning 4-bedroom, 5.5-bath Colonial in the highly sought-after Clover Ridge community is completely turnkey. The main level features gleaming hardwood floors throughout and a gourmet kitchen boasting granite countertops, stainless-steel appliances, and

    JIANBO CHEN Smart Realty, LLC

    Section Image
  • 4 Garden Gate Cir, Frederick, MD 21702

    $799,990

    • 3 Beds
    • 4 Baths
    • 3,998 Sq Ft
    • 4 Garden Gate Cir
    • Frederick, MD

    Experience refined and luxurious 55+ active adult living with NVHomes at Bloomfields. With expansive and sophisticated amenities in the works, including a well-appointed community clubhouse and pool, access to shops and dining, a social atmosphere, and inclusive community activities, you won't ever want to leave. This to-be-built Davenport model offers elegant main-level living with thoughtful

    Emily Grimshaw Compass

    Section Image
  • 3 Garden Gate Cir, Frederick, MD 21702

    $769,990

    • 3 Beds
    • 4 Baths
    • 3,492 Sq Ft
    • 3 Garden Gate Cir
    • Frederick, MD

    Come experience luxurious active adult living with NVHomes at 55+ Bloomfields. With expansive and sophisticated amenities in the works, including a well-appointed community clubhouse and pool, access to shops and dining, a social atmosphere, and inclusive community activities, you won't ever want to leave. The Clarkson single-family home offers a new level of luxury. Enter the foyer to find a

    Ross Wilhelm Compass

    Section Image
  • 2400 Hunters Chase Ct, Frederick, MD 21702

    $649,997

    • 5 Beds
    • 4.5 Baths
    • 3,867 Sq Ft
    • 2400 Hunters Chase Ct
    • Frederick, MD

    A Rare Frederick Treasure: Timeless Brick Beauty, Modern Living Vibes — Priced to SellFrederick isn’t just a place — it’s a vibe. Where else can you sip craft coffee in the morning, stroll through historic streets by afternoon, and cheer on racers atop towering penny-farthings during the annual National Clustered Spires High Wheel Race? This one-of-a-kind event, the only high wheel race of its

    Anthony Verdi IMPACT Maryland Real Estate

    Section Image
  • 1691 Shookstown Rd, Frederick, MD 21702

    $675,000

    • 4 Beds
    • 4 Baths
    • 2,968 Sq Ft
    • 1691 Shookstown Rd
    • Frederick, MD

    **Open House Saturday 3/15 from 12 - 2PM** Check out this rare opportunity to own an 8 + acre tract of land with a gorgeously updated home in close proximity to all Downtown Frederick has to offer. This completely updated home has gleaming hardwood floors throughout and four full bathrooms with beautiful tile and new vanities. Enjoy the potential for main level living with the spacious primary

    Dan Chlebowski Real Broker, LLC

    Section Image
See All Homes in Frederick

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
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

    54 Total Sales

    Tara Shegogue
    Section Image
  • Felicia Tukpeyi

    Buyer's Agent in 2021

    Felicia Tukpeyi

    Remax 100

    (301) 758-8716

    1 in this area

    52 Total Sales

    Felicia Tukpeyi
    Section Image
  • Cindy Souza

    Seller's Agent in 2014

    Cindy Souza

    Long & Foster

    (301) 332-5032

    190 Total Sales

    Cindy Souza
    Section Image

  • C

    Buyer's Agent in 2014

    Colleen Geppi

    Taylor Properties

    (240) 367-0273

    8 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 $683,286, approximately $155 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