Buzz Mackintosh
Mackintosh, Inc.
(240) 693-3924
68 Total Sales
1 in Braddock Heights
$665,000 Price
5447 Stone Rd Frederick, MD 21703
Braddock Heights AreaEstimated Value: $977,944
5
Beds
5.5
Baths
7,020
Sq Ft
$139/Sq Ft
Est. Value
Highlights
- Gourmet Kitchen
- Hydromassage or Jetted Bathtub
- 1 Fireplace
- Open Floorplan
- Mediterranean Architecture
- No HOA
About This Home
As of June 2026Welcome 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.
Last Agent to Sell the Property
(410) 705-6295 saeedmohebbi@gmail.com Hyatt & Company Real Estate, LLC Brokerage Phone: 4107056295 Listed on: 04/23/2026
Last Buyer's Agent
Unrepresented
datacorrect@brightmls.com Unrepresented
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 Details
Home Type
- Single Family
Est. Annual Taxes
- $9,553
Year Built
- Built in 2003
Lot Details
- 0.91
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
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 23, 2026
Closed on
Jun 12, 2026
Sold by
Shahid Latif
Bought by
Seller's Agent
Saeed Mohebbi
Hyatt & Company Real Estate, LLC
Buyer's Agent
Unrepresented
Unrepresented
List Price
$989,900
Sold Price
$970,000
Premium/Discount to List
-$19,900
-2.01%
Views
137
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$7,944
Avg. Annual Appreciation
3.07%
Original Mortgage
$970,000
Outstanding Balance
$967,923
Interest Rate
5.63%
Mortgage Type
New Conventional
Estimated Equity
$10,021
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Frederick, MD
-
Buzz Mackintosh
-
Barbara McPhail
Barbara McPhail
Douglas Realty LLC
(410) 291-1444
15 Total Sales
1 in Braddock Heights
$569,900 Price
-
Lauren Seaton
Lauren Seaton
Charis Realty Group
(240) 898-4133
86 Total Sales
2 in Braddock Heights
$480K - $590K Price Range
-
Shelley Eyler
Shelley Eyler
Berkshire Hathaway HomeServices PenFed Realty
(240) 594-5798
88 Total Sales
2 in Braddock Heights
$549K - $1.3M Price Range
-
Bikle Metz Group
Bikle Metz Group
Keller Williams Realty Centre
(814) 747-5487
172 Total Sales
1 in Braddock Heights
$402,000 Price
-
Edwin Escarraman
Edwin Escarraman
Compass
(240) 221-5056
138 Total Sales
1 in Braddock Heights
$385,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $970,000 | Legacyhouse Title |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $970,000 | ||
| Previous Owner | Latif Shahid | $318,500 | |
| Previous Owner | Latif Shahid | $103,000 | |
| Previous Owner | Latif Shahid | $662,000 | |
| Previous Owner | Latif Shahid | $75,000 | |
| Previous Owner | Latif Shahid | $533,600 | |
| Previous Owner | Latif Shahid | $150,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 06/12/2026 06/12/26 | Sold | $970,000 | -2.0% | $138 / Sq Ft |
| 04/23/2026 04/23/26 | For Sale | $989,900 | -- | $141 / Sq Ft |
Source: Bright MLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 |
|---|---|---|---|---|
| 2026 | $9,780 | $893,000 | $130,100 | $762,900 |
| 2025 | $9,780 | $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
Agents Affiliated with this Home
-
Saeed Mohebbi
Seller's Agent in 2026
Saeed Mohebbi
Hyatt & Company Real Estate, LLC
(240) 793-4721
96 Total Sales
-
U
Buyer's Agent in 2026
Unrepresented
Unrepresented
Map
Source: Bright MLS
MLS Number: MDFR2079968
APN: 23-457911
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.
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 2026 Bright MLS, Inc.
Nearby Homes
- 4509 Shaff Ln
- 4418 Teen Barnes Rd
- 4422 Teen Barnes Rd
- 5528 Woodlyn Rd
- 4750 Mount Zion Rd
- 4606 Mockingbird Ln
- 4609 Skyline Terrace
- 6113 Elaine Dr
- 6144 Mount Phillip Rd
- 4213 Wallingford Ct
- 6313 Jefferson Blvd
- 6248 Jefferson Blvd
- 4226 Jefferson Pike
- 6411 Fulmer Rd
- 5019 Old Swimming Pool Rd
- 4015 Jefferson Pike
- 3901 Manheim Place
- 6641 Jefferson Blvd
- 5901 Cloudberry Ct
- 4513 Timbery Dr
Your Personal Tour Guide
Ask me questions while you tour the home.