$989,900
UNDER CONTRACT

5447 Stone Rd Frederick, MD 21703

Estimated payment $6,080/month

Total Views 3,549
5 Beds
5.5 Baths
7,020 Sq Ft
$141 Price per Sq Ft

Highlights

  • Gourmet Kitchen
  • Hydromassage or Jetted Bathtub
  • 1 Fireplace
  • Open Floorplan
  • Mediterranean Architecture
  • No HOA

About This Home

Welcome to this fully custom-built Mediterranean-inspired retreat, a private luxury residence offering 5 bedrooms, 5.5 bathrooms, and refined living across every level. Designed to evoke a resort-style escape, the home features soaring 14-ft ceilings, elegant living spaces, and abundant natural light throughout.
Step inside through a grand entrance with a private study, as timeless architecture meets modern sophistication. The heart of the home seamlessly flows into indoor and outdoor spaces—perfect for effortless entertaining and everyday living.The fully finished walkout basement offers a full kitchen, guest suite, and expansive recreation area. This home is enhanced by following upgrades:
New flooring (2025), Dual-zone HVAC + updated furnace (2023/2025), Smart water heater (2024) with WiFi leak detection, 7-stage water filtration system, Brand-new well pump (2026), Newly resurfaced driveway (2026), 3-car garage with Tesla charger & WiFi-enabled openers
A true home away from home, offering luxury, privacy, and convenience just minutes from Frederick’s shopping, dining, and commuter routes. This one-of-a-kind estate is a must-see—schedule your private tour today.

Listing Agent

Saeed Mohebbi

(410) 705-6295 saeedmohebbi@gmail.com Hyatt & Company Real Estate, LLC Brokerage Phone: 4107056295 Listed on: 04/23/2026

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,553

Year Built

  • Built in 2003

Parking

  • 3 Car Attached Garage
  • Electric Vehicle Home Charger
  • Front Facing Garage
  • Garage Door Opener

Home Design

  • Mediterranean Architecture
  • Brick Exterior Construction
  • Slab Foundation

Interior Spaces

  • Property has 2 Levels
  • Open Floorplan
  • Recessed Lighting
  • 1 Fireplace
  • Family Room Off Kitchen
  • Combination Kitchen and Dining Room
  • Finished Basement

Kitchen

  • Gourmet Kitchen
  • Butlers Pantry
  • Kitchen Island

Bedrooms and Bathrooms

  • Hydromassage or Jetted Bathtub
  • Walk-in Shower

Utilities

  • Cooling Available
  • Heat Pump System
  • Water Treatment System
  • Well
  • Electric Water Heater
  • Septic Equal To The Number Of Bedrooms

Additional Features

  • Halls are 36 inches wide or more
  • 39,730 Sq Ft Lot

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Tax Lot 3
  • Assessor Parcel Number 1123457911

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,553

Year Built

Built in 2003

Lot Details

0.91 Acres

Parking

3

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Mediterranean
  • Accessibility Features: 36"+ Wide Halls
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 4/23/2026 12:00:00 AM
  • Year Built: 2003
  • Automatically Close On Close Date: No
  • Special Features: 4224
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Bathroom - Walk-In Shower, Bathroom - Jetted Tub, Butlers Pantry, Combination Kitchen/Dining, Family Room Off Kitchen, Floor Plan - Open, Kitchen - Gourmet, Kitchen - Island, Recessed Lighting, Water Treat System
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Foundation Details: Slab
  • Levels Count: 2
  • Basement: Yes
  • Basement Type: Fully Finished, Improved
  • Total Sq Ft: 7468
  • Living Area Sq Ft: 7020
  • Price Per Sq Ft: 237.50
  • Above Grade Finished Sq Ft: 4168
  • Above Grade Unfinished Sq Ft: 448
  • Below Grade Finished Sq Ft: 2852
  • Total Below Grade Sq Ft: 2852
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 5
  • Main Level Bedrooms: 3
  • All Lower Level Bedrooms: 1
  • Total Bathrooms: 6
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Main Level Bathrooms: 4.00
  • Upper Level Bathrooms: 1
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 1.00
  • Lower Levels Bathrooms: 1.00
  • Main Level Full Bathrooms: 3
  • Lower Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

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

Garage/Parking

  • Garage Spaces: 3.00
  • Garage: Yes
  • Parking Features: Electric Vehicle Charging Station(s), Concrete Driveway
  • Garage Features: Garage - Front Entry, Garage Door Opener
  • Attached Garage Spaces: 3
  • Total Garage And Parking Spaces: 3
  • Type Of Parking: Attached Garage

Utilities

  • Central Air Conditioning: No
  • Cooling Fuel: Electric
  • Cooling Type: Heat Pump(s)
  • Heating Fuel: Electric
  • Heating Type: Heat Pump(s)
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Septic = # Of Br
  • Water Source: Well

Condo/Co-op/Association

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

Schools

  • School District Source: Listing Agent

Lot Info

  • Lot Size Acres: 0.91
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 39730.00
  • Zoning: R
  • In City Limits: No

Rental Info

  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 9553.00
  • Assessor Parcel Number: 1123457911
  • Tax Lot: 3
  • 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

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 $8,424 $788,233 -- --
2024 $8,424 $683,467 $0 $0
2023 $6,869 $578,700 $86,700 $492,000
2022 $6,869 $578,700 $86,700 $492,000
2021 $6,961 $578,700 $86,700 $492,000
2020 $6,961 $586,600 $86,700 $499,900
2019 $6,870 $578,767 $0 $0
2018 $6,839 $570,933 $0 $0
2017 $6,688 $563,100 $0 $0
2016 $7,772 $548,200 $0 $0
2015 $7,772 $533,300 $0 $0
2014 $7,772 $518,400 $0 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/23/2026 04/23/26 For Sale $989,900 -- $141 / Sq Ft
Source: Bright MLS

Source: Bright MLS

MLS Number: MDFR2079968

Bright MLS

APN: 23-457911

Your Personal Tour Guide

Ask me questions while you tour the home.