Estimated Value: $3,816,000 - $4,987,613
Hailing over 18,000 square feet, this mansion has 5 over sized bedrooms and 10.3 baths, ranging over 4 acres. The master suite includes separate his and hers walk-in closets, complete with divided dressing rooms and full baths.The front entrance opens to a two-story foyer with winding staircases leading to the upper mezzanine. The two-storied living room features floor-to-ceiling windows that overlook the estate grounds, including the beautifully landscaped lawn with swimming pool,regulation tennis court & indoor basketball court with locker room,sauna,steam,workout room,spa and 16 seat home theater. The scene reminds you of a private resort because of the many places to relax. Enjoy summer evenings on one of the wrap-around terraces. Feel the warmth of the outdoor fireplace, watching television, as you absorb the fragrances under the poolside lanai. Lake front property included in estate on lower Long Lake.
Home Type
Est. Annual Taxes
Year Built
Lot Details
Home Design
Interior Spaces
Kitchen
Bedrooms and Bathrooms
Laundry
Finished Basement
Parking
Eco-Friendly Details
Pool
Outdoor Features
Utilities
Community Details
Listing and Financial Details
$5,495,000
Welcome to an unparalleled opportunity to own a prestigious waterfront estate in the exclusive Heron Bay Gated Community of Bloomfield Hills. This elegant masterpiece spans over 10,000 square feet, offering a perfect blend of architectural brilliance and sophisticated design, making it the epitome of luxury living. As you step inside, you are greeted by grand spaces and exquisite detailing
Sheel Sohal KW Domain
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Sheikh Mahwish | -- | None Listed On Document | |
| Sheikh Abubakar | -- | None Available | |
| Sheikh Abubakar | -- | None Available | |
| Sheikh Abubakar | -- | Attorney |
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Dumars Joe | $1,156,600 | |
| Previous Owner | Dumars Joe | $400,000 | |
| Previous Owner | Dumars Joe | $1,700,000 |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 09/15/2015 09/15/15 | Sold | $5,350,000 | -17.7% | $573 / Sq Ft |
| 09/15/2015 09/15/15 | Pending | -- | -- | -- |
| 07/11/2015 07/11/15 | For Sale | $6,500,000 | -- | $696 / Sq Ft |
| 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 | $38,301 | $2,463,460 | $0 | $0 |
| 2023 | $37,065 | $2,323,810 | $0 | $0 |
| 2022 | $69,653 | $2,224,630 | $0 | $0 |
| 2021 | $69,152 | $2,139,330 | $0 | $0 |
| 2020 | $33,899 | $2,071,980 | $0 | $0 |
| 2019 | $65,067 | $2,008,400 | $0 | $0 |
| 2018 | $65,364 | $1,899,840 | $0 | $0 |
| 2017 | $64,894 | $1,727,520 | $0 | $0 |
| 2016 | $54,468 | $1,388,710 | $0 | $0 |
| 2015 | -- | $1,341,890 | $0 | $0 |
| 2014 | -- | $1,207,320 | $0 | $0 |
| 2011 | -- | $1,174,590 | $0 | $0 |
Seller's Agent in 2015
Stacey Weinberg
Real Broker Birmingham
(248) 931-8181
29 Total Sales
J
Buyer's Agent in 2015
John Kay
RE/MAX of Southeast Michigan
(248) 926-9412
17 Total Sales
J
Buyer's Agent in 2015
John Kucish
RE/MAX Classic
Source: Realcomp
MLS Number: 215072656
APN: 19-09-301-016
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.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393