NOT LISTED FOR SALE

1004 S Main St Mount Airy, MD 21771

Estimated Value: $596,598 - $668,000

5 Beds
2.5 Baths
2,378 Sq Ft
$264/Sq Ft Est. Value

Last Sold May 10, 2021

Last sale price $499,900 $210 Per Sq Ft

Est. 25% increase in value since last sale

Current estimated payment $3,836/month

Highlights

  • Gourmet Kitchen
  • Colonial Architecture
  • Wood Flooring
  • Twin Ridge Elementary School Rated A-
  • Traditional Floor Plan
  • No HOA

About This Home

As of May 2021

This amazing turn-of-the-century home located on beautiful Main Street is sure to impress. This home is beaming with character and unique spaces with just the right amount of updates and historic preservation. Boasting wood floors throughout, a large entry foyer, separate dining room with a large window looking to the front portion of the wrap-around porch, spacious living room, a custom gourmet kitchen with updated counters, extra cabinets and stainless steel appliances, a walk-in pantry & laundry combo, an upper level with 3 large bedrooms, updated full bathroom with exposed brick, an extra den that connects to the 3-season room with gorgeous views of the backyard & sunset, an additional upper level/owner's suite that's complete with a sitting room, 2 bedrooms, a fully-remodeled full bathroom with heated floors and so much more! Enjoy having a home office with custom-fit windows that overlook historic Main Street and escape to your own private oasis. The over-sized backyard has just the perfect balance of a fenced yard and open area to the back of the lot for added room to entertain. This stunning home is located in the heart of Mt. Airy and will not last long!

Last Agent to Sell the Property

Dan Hozhabri

(301) 461-9154 Dan@DHGSells.com Keller Williams Realty Centre License #587796 Listed on: 03/11/2021

Keller Williams Realty Centre

Last Buyer's Agent

Jane Stillwell

(240) 505-9255 team@janestillwell.com RE/MAX Realty Centre, Inc. License #522501

RE/MAX Realty Centre, Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,276

Year Built

  • Built in 1910

Lot Details

  • 0.47 Acre Lot
  • Back Yard Fenced
  • Property is in excellent condition

Home Design

  • Colonial Architecture
  • Frame Construction

Interior Spaces

  • 2,378 Sq Ft Home
  • Property has 4 Levels
  • Traditional Floor Plan
  • Entrance Foyer
  • Living Room
  • Dining Room
  • Den
  • Wood Flooring
  • Basement

Kitchen

  • Gourmet Kitchen
  • Electric Oven or Range
  • Kitchen Island
  • Upgraded Countertops

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Laundry Room
  • Laundry on main level

Parking

  • 4 Parking Spaces
  • 4 Driveway Spaces

Outdoor Features

  • Patio
  • Shed
  • Porch

Schools

  • Twin Ridge Elementary School
  • Windsor Knolls Middle School
  • Linganore High School

Utilities

  • Window Unit Cooling System
  • Radiator
  • Heating System Uses Oil
  • Electric Baseboard Heater
  • Electric Water Heater

Community Details

  • No Home Owners Association
  • Mt Airy Estates Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1118379716

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,276

Year Built

Built in 1910

Lot Details

0

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1, Upper 2
  • Expected On Market: 2021-03-11
  • Year Built: 1910
  • Automatically Close On Close Date: No
  • Remarks Public: This amazing turn-of-the-century home located on beautiful Main Street is sure to impress. This home is beaming with character and unique spaces with just the right amount of updates and historic preservation. Boasting wood floors throughout, a large entry foyer, separate dining room with a large window looking to the front portion of the wrap-around porch, spacious living room, a custom gourmet kitchen with updated counters, extra cabinets and stainless steel appliances, a walk-in pantry & laundry combo, an upper level with 3 large bedrooms, updated full bathroom with exposed brick, an extra den that connects to the 3-season room with gorgeous views of the backyard & sunset, an additional upper level/owner's suite that's complete with a sitting room, 2 bedrooms, a fully-remodeled full bathroom with heated floors and so much more! Enjoy having a home office with custom-fit windows that overlook historic Main Street and escape to your own private oasis. The over-sized backyard has just the perfect balance of a fenced yard and open area to the back of the lot for added room to entertain. This stunning home is located in the heart of Mt. Airy and will not last long!
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Oven/Range - Electric
  • Interior Amenities: Kitchen - Gourmet, Kitchen - Island, Floor Plan - Traditional, Upgraded Countertops, Wood Floors, Pantry
  • Fireplace: No
  • Levels Count: 4
  • Room List: Living Room, Dining Room, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Kitchen, Den, Foyer, Bedroom 1, Laundry, Full Bath
  • Basement: Yes
  • Laundry Type: Main Floor
  • Total Sq Ft: 2378
  • Living Area Sq Ft: 2378
  • Price Per Sq Ft: 210.22
  • Above Grade Finished Sq Ft: 2378
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 1004

Beds/Baths

  • Bedrooms: 5
  • Total Bathrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 2
  • Upper Level Bathrooms: 1.00
  • Upper Level 2 Bathrooms: 1.00
  • Upper Level Full Bathrooms: 1
  • Upper Level 2 Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Other Structures List: Shed
  • Construction Materials: Frame
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: No Pool
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage: No
  • Total Garage And Parking Spaces: 4
  • Type Of Parking: Driveway
  • Number of Spaces in Driveway: 4

Utilities

  • Refuse: 88.00
  • Central Air Conditioning: No
  • Cooling Fuel: Electric
  • Cooling Type: Window Unit(s)
  • Heating Fuel: Oil
  • Heating Type: Baseboard - Electric, Radiator
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Condo Co-Op Association: No
  • HOA: No
  • Senior Community: No

Schools

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
  • Elementary School: TWIN RIDGE
  • Middle School: WINDSOR KNOLLS
  • High School: LINGANORE
  • Elementary School Source: 3rd Party
  • High School Source: 3rd Party
  • Middle School Source: 3rd Party
  • School District Key: 121139693024
  • School District Source: 3rd Party
  • Elementary School: TWIN RIDGE
  • High School: LINGANORE
  • Middle Or Junior School: WINDSOR KNOLLS

Green Features

  • Clean Green Assessed: No

Lot Info

  • Fencing: Rear
  • Improvement Assessed Value: 214400.00
  • Land Assessed Value: 99700.00
  • Land Use Code: 010
  • Lot Size Acres: 0.47
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 20440.00
  • Outdoor Living Structures: Patio(s), Porch(es)
  • Property Condition: Excellent
  • Year Assessed: 2021
  • Zoning: R
  • In City Limits: Yes

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11537142
  • Tax Annual Amount: 4276.00
  • Assessor Parcel Number: 1118379716
  • Tax Total Finished Sq Ft: 2378
  • County Tax Payment Frequency: Annually
  • Tax Data Updated: No
  • Tax Year: 2021
  • Close Date: 05/10/2021

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 11, 2021
Closed on
May 10, 2021
Sold by
Celestini Tamara M and The Tamara Marie Celestini Tru
Bought by
Boerger Timothy M and Marroy Boerger Angela
Seller's Agent
Dan Hozhabri
Keller Williams Realty Centre
Buyer's Agent
Jane Stillwell
RE/MAX Realty Centre, Inc.
List Price
$499,900
Sold Price
$499,900
Current Estimated Value
$627,150

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$127,250
Avg. Annual Appreciation
5.20%
Original Mortgage
$474,905
Outstanding Balance
$429,030
Interest Rate
2.9%
Mortgage Type
New Conventional
Estimated Equity
$198,120

Purchase Details

Closed on
Mar 12, 2018
Sold by
Celestini Tamara M
Bought by
Celestini Tamara M and Tamar Marie Celestini Trust

Purchase Details

Listed on
Oct 12, 2012
Closed on
Dec 20, 2012
Sold by
Maxev Donald R and Maxev Anne F
Bought by
Celestini Tamara M
Seller's Agent
Steve Jackson
Real Estate Teams, LLC
Buyer's Agent
Steve Jackson
Real Estate Teams, LLC
List Price
$298,500
Sold Price
$270,000
Premium/Discount to List
-$28,500
-9.55%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.77%
Original Mortgage
$243,000
Interest Rate
3.35%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 5, 1989
Sold by
Burcham Lee A and Burcham Maria
Bought by
Maxey Donald R and Maxey Anne F

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$135,450
Interest Rate
10.07%

Purchase Details

Closed on
Nov 9, 1982
Sold by
Selby Raymond E and Selby Mildred
Bought by
Burcham Lee A and Burcham Maria

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$48,000
Interest Rate
13.91%
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
Boerger Timothy M $499,900 Home Settlement Centre Llc
Celestini Tamara M -- None Available
Celestini Tamara M $270,000 United Title Service Llc
Maxey Donald R $150,500 --
Burcham Lee A $68,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Boerger Timothy M $474,905
Previous Owner Celestini Tamara M $243,000
Previous Owner Maxey Donald R $135,450
Previous Owner Burcham Lee A $48,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/10/2021 05/10/21 Sold $499,900 0.0% $210 / Sq Ft
03/18/2021 03/18/21 Pending -- -- --
03/11/2021 03/11/21 For Sale $499,900 +85.1% $210 / Sq Ft
12/20/2012 12/20/12 Sold $270,000 -9.5% $114 / Sq Ft View Prior Sale
11/17/2012 11/17/12 Pending -- -- --
10/12/2012 10/12/12 For Sale $298,500 -- $126 / Sq Ft
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 $6,547 $493,267 -- --
2024 $6,547 $460,300 $121,500 $338,800
2023 $5,538 $411,567 $0 $0
2022 $4,893 $362,833 $0 $0
2021 $4,240 $314,100 $99,700 $214,400
2020 $4,277 $313,000 $0 $0
2019 $4,218 $311,900 $0 $0
2018 $4,159 $310,800 $99,700 $211,100
2017 $4,179 $310,800 $0 $0
2016 $88 $308,133 $0 $0
2015 $88 $306,800 $0 $0
2014 $88 $306,800 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR2000026

Bright MLS

APN: 18-379716