Seller's Agent in 2026
Ed Martin
RE/MAX
(727) 344-9611
2 in this area
481 Total Sales
Stunning, one-of-a-kind split-level estate ideally situated on the Clinton River, just seconds from Lake St. Clair, offering the ultimate waterfront lifestyle. Extensive recent upgrades make this home truly turnkey, including a brand-new retaining wall and seawall, 40-ft. steel dock, and a new 17,000 lb Golden boat lift. Outdoor living is unmatched with a new composite back deck showcasing a dramatic 360-degree gas fireplace and a fully equipped outdoor kitchen featuring a refrigerator, 22" griddle, and 36" barbecue. A new paver patio and composite boardwalk along the seawall complete this incredible waterfront setting. A whole-house generator provides added peace of mind. Inside, updates continue with fresh paint, new carpet, and luxury vinyl plank flooring. The impressive great room features a step ceiling, cozy gas fireplace, and doorwall leading to your backyard oasis. The open-concept layout flows seamlessly into the chef’s kitchen, appointed with brand-new quartzite countertops, premium Wolf and Sub-Zero stainless steel appliances, a built-in wine cooler, and a large island with bar seating—perfect for entertaining. Host elegant gatherings in the formal dining room, and enjoy working from home in the stately office with cathedral ceilings and timeless wainscoting. Designed for ultimate comfort and flexibility, each level offers its own laundry room and primary ensuite. The entry-level ensuite features a walk-in closet and private doorwall to the back deck. The expansive upper-level ensuite is a true retreat with a private balcony overlooking the water, gas fireplace, kitchenette, and custom built-in closet system. Two additional ensuites provide exceptional accommodations, including one with a spacious sitting room. Completing the home is an impressive 40x23 attached garage with new gas heat and epoxy floors. A rare opportunity to own a thoughtfully updated waterfront masterpiece.
Last Agent to Sell the Property
RE/MAX First License #MISPE-6506021889 Listed on: 03/03/2026
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $1,550,000 | Ata National Title | |
| Warranty Deed | $1,200,000 | Greater Macomb Title Agency | |
| Quit Claim Deed | -- | Greater Macomb Title Agency | |
| Warranty Deed | -- | Title Connect Llc | |
| Warranty Deed | -- | Title Connect Llc | |
| Warranty Deed | $505,000 | Title Connect Llc | |
| Corporate Deed | -- | Philip R Seaver Title Co Inc | |
| Quit Claim Deed | -- | Philip R Seaver Title Co Inc |
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 | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,092,000 | New Conventional | |
| Previous Owner | $656,000 | Fannie Mae Freddie Mac |
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 04/10/2026 04/10/26 | Sold | $1,550,000 | -3.1% | $317 / Sq Ft | |
| 03/18/2026 03/18/26 | Pending | -- | -- | -- | |
| 03/03/2026 03/03/26 | For Sale | $1,599,900 | +33.3% | $327 / Sq Ft | |
| 07/08/2024 07/08/24 | Sold | $1,200,000 | -7.7% | $245 / Sq Ft | View Prior Sale |
| 06/21/2024 06/21/24 | Pending | -- | -- | -- | |
| 05/14/2024 05/14/24 | Price Changed | $1,299,999 | 0.0% | $265 / Sq Ft | |
| 05/11/2024 05/11/24 | For Sale | $1,300,000 | -- | $265 / 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 |
|---|---|---|---|---|
| 2025 | $15,845 | $677,200 | $0 | $0 |
| 2024 | $189 | $626,200 | $0 | $0 |
| 2023 | $17,990 | $602,500 | $0 | $0 |
| 2022 | $21,736 | $561,800 | $0 | $0 |
| 2021 | $21,027 | $555,400 | $0 | $0 |
| 2020 | $9,410 | $522,200 | $0 | $0 |
| 2019 | $12,736 | $488,900 | $0 | $0 |
| 2018 | $12,473 | $437,800 | $0 | $0 |
| 2017 | $11,950 | $439,700 | $102,620 | $337,080 |
| 2016 | $11,909 | $439,700 | $0 | $0 |
| 2015 | -- | $424,130 | $0 | $0 |
| 2012 | $16,965 | $350,140 | $0 | $0 |
Seller's Agent in 2026
Ed Martin
RE/MAX
(727) 344-9611
2 in this area
481 Total Sales
Seller Co-Listing Agent in 2026
Breanne Gaudard
RE/MAX
(586) 596-9668
1 in this area
9 Total Sales
Buyer's Agent in 2026
Sebastian Frank Lucido
Sine & Monaghan LLC
(586) 419-7607
1 in this area
84 Total Sales
Seller's Agent in 2024
Joseph Morris
RE/MAX
(586) 557-3800
3 in this area
97 Total Sales
Source: Michigan Multiple Listing Service
MLS Number: 50200630
APN: 17-12-15-401-015
Ask me questions while you tour the home.