Agent profile image in chat bubble
Agent profile image in chat header

IDX Support

sales rep | Brivity IDX

Agent profile image in message

104 Prospect Rd , Mount Airy, MD 21771
$1,980,000
Est. Payment: $10,538.39/mo
4 Bed
4 Bath
4122 Sqft
0.45 Acres
Status: active | Days on site: 38
Get Pre-Qualified
KREP1 - 3097971
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from IDX Support, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.

House Description

Never before on the market! Whether you are looking for a residential home or commercial property with potential for a bed-and-breakfast, wedding venue, or other suitable business this is the property for you. This unique custom built home with bespoke features including: leaded stained glass windows, tin ceiling, hawk and trowel textured drywall, in-laid hardwoods on some floors and walls, turrets, corbels, unique fireplace features, and a marble floor wrap around porch - too many to list. The magic of this home begins as soon as you walk through the front door entering the vestibule leading you to the grand foyer with fireplace. The primary suite boasts its own grand entrance, a Juliette balcony overlooking the living room fireplace, and a sitting room leading to the outside balcony overlooking the large koi pond. The kitchen features an Othello cast iron wood burning stove, propane cooktop, wall oven and a walk-in pantry. Don't miss your opportunity to see this hidden gem with its many charming features... to many to list. While this home does need some TLC; it is livable, providing you the opportunity to live in the home while doing the TLC work to your liking. With respect to commercial business opportunities, Buyer to do their due diligence with the town and county.

Highlights

Listed by Bert Newcomer , 3013701270 Kelley Real Estate Professionals , 3013714415. Bright MLS

Property Type

Residential

Lot/Acreage
0.45

Year Built

1965

County

Frederick

Neighborhood

None Available

School District

Frederick County Public Schools

Listing ID

MDFR2089550

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:4
  • ▪ Full Bathrooms:4
Appliances:Cooktop, Oven - Wall, Refrigerator, Dishwasher
Air Cond:Ceiling Fan(s),Window Unit(s)
Fireplaces:3 Fireplaces
Floor:Carpet,Ceramic Tile,Hardwood,Partially Carpeted
Above Ground Sq Ft:4122
Other:
  • ▪ Main Floor Bedrooms:4
  • ▪ Additional:Additional Stairway, Attic, Bathroom - Tub Shower, Built-Ins, Carpet, Ceiling Fan(s), Chair Railings, Dining Area, Kitchen - Island, Pantry, Primary Bath(s)
Water:Public

Exterior Features

Lot:Backs to Trees,Cleared,Pond,Road Frontage,Not New Construction,Horse Property: No,In City Limits
Garage Capacity:6
Zoning:CC
Roof:Architectural Shingle
Sewer:Public Sewer
Parking Features:Paved Driveway,Garage - Front Entry,Attached Garage,Detached Garage,Driveway,Off Site,4+ Spaces,3+ Spaces,2+ Spaces,1+ Spaces
Principal Interest
$10,538
Taxes
$648

Home Price

$1,980,000

Loan Details

30 yrs
7%

Down Payment

20%
$396,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$10,538.39

Principal

Taxes

Principal Taxes HOA Total
Monthly $10,538.39 $648.00 $0.00 $11,186.39
Yearly $126,460.70 $7,776.00 $0.00 $134,236.70
Total $3,793,820.95 $233,280.00 $0.00 $4,027,100.95
Lender profile image
Chico Gordy
Test
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Nov 2026

Average Price

All Price Ranges
N/A
Nov 2026

Average Days on Market

All Price Ranges
N/A
Nov 2026
Market insight data is pulled from the same city as the listing being viewed (Mount Airy, MD).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Information provided by Bright MLS, and is deemed reliable but not guaranteed accurate.

IDX service by Blueroof 360

Data last updated: 2026-11-13T17:14:43.000Z

© 2026 Bright MLS