* * Just Reduced * * Let's get you in your new home for the Holidays!! Welcome to this exquisite 4152-square-foot waterfront estate, just a short boat ride to Lake St. Clair. This towering four-story modern marvel offers ease of access via the spiraling stairway or the accessible elevator. Seller spared no expense when building, using an extensive amount of steel in the structure. The entry floor features a three-car attached garage, an in-law/ guest suite, a spacious sitting area with expansive water views, and access to the lower deck with three boat slips. The second floor boasts two bedrooms, a formal sitting area, dining area, a sprawling family room, a den area, and a chef's dream kitchen, all with spectacular water views. The third floor is dedicated to a master suite with breathtaking waterway views, his and her bathrooms and closets, a dressing room for special occasions, and a private workout room or office. The fourth floor provides access to a large exterior gathering area by means of an elegant circular staircase. No expense spared with a back up generator, insta-hot system in the kitchen, dual HVAC systems, 3000lb hoist, 2-36' boat wells and a 20'+ boat well with power supply on the dock, connected to a partially covered massive vinyl deck/entertaining area. This could be a great multiple unit AirBNB. Great potential. Come see us, just to much to list!!
Single-familyProperty Type
1997Year Built
6,534 sq ftLot Size
$211Est. Price/Sq.Ft.
3 car garageParking
Listed by David Jacobson• Realty Executives Home Towne Chesterfield
•586-949-8300 (broker)
•htrperod@gmail.com (broker)
Bought with David Jacobson• Realty Executives Home Towne Chesterfield
* * Just Reduced * * Let's get you in your new home for the Holidays!! Welcome to this exquisite 4152-square-foot waterfront estate, just a short boat ride to Lake St. Clair. This towering four-story modern marvel offers ease of access via the spiraling stairway or the accessible elevator. Seller spared no expense when building, using an extensive amount of steel in the structure. The entry floor features a three-car attached garage, an in-law/ guest suite, a spacious sitting area with expansive water views, and access to the lower deck with three boat slips. The second floor boasts two bedrooms, a formal sitting area, dining area, a sprawling family room, a den area, and a chef's dream kitchen, all with spectacular water views. The third floor is dedicated to a master suite with breathtaking waterway views, his and her bathrooms and closets, a dressing room for special occasions, and a private workout room or office. The fourth floor provides access to a large exterior gathering area by means of an elegant circular staircase. No expense spared with a back up generator, insta-hot system in the kitchen, dual HVAC systems, 3000lb hoist, 2-36' boat wells and a 20'+ boat well with power supply on the dock, connected to a partially covered massive vinyl deck/entertaining area. This could be a great multiple unit AirBNB. Great potential. Come see us, just to much to list!!
REALCOMP #58050148008
Dec 11, 2024
Sold
$780,000
$188/sq ft
Jul 10, 2024
Listed
$879,000
$212/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$13,752 (+9.2%)
2024
$12,591 (+5.0%)
2023
$11,989 (+5.3%)
2022
$11,390 (+4.1%)
2021
$10,945 (+0.6%)
2020
$10,881 (+7.8%)
2019
$10,098 (+2.1%)
2018
$9,890 (+4.4%)
2017
$9,475 (+0.3%)
2016
$9,442 (+2.7%)
2015
$9,195 (−0.1%)
2014
$9,205 (+4.6%)
2013
$8,799
Tax history for 31700 N River Rd Rd
Year
Property tax
Land + Additions
Assessment*
2025
$13,752 (+9.2%)
2024
$12,591 (+5.0%)
2023
$11,989 (+5.3%)
2022
$11,390 (+4.1%)
2021
$10,945 (+0.6%)
2020
$10,881 (+7.8%)
2019
$10,098 (+2.1%)
2018
$9,890 (+4.4%)
2017
$9,475 (+0.3%)
2016
$9,442 (+2.7%)
2015
$9,195 (−0.1%)
2014
$9,205 (+4.6%)
2013
$8,799
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Permits
Beds
—
Baths
3.5
Stories
2
Lot width
50 ft.
Lot depth
132 ft.
Lot size
6,534 Sq. Ft.
Year renovated
—
Sq. Ft.
4,152
Year built
1997
Style
Single Family Residential
County
Macomb County
APN
17-12-15-156-004
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 13, 2026.
Jul 31, 2009 • Final
Mechanical
Remove and replace the air conditioning unit.
HVAC
Plumbing
Water heater
Dec 22, 2006 • Final
Electrical
Install electrical systems for a sunroom.
Electrical
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 3
Garage Type: Gar Door Opener, Attached Garage, Electric In Garage
Interior
Virtual Tour
Interior Features
Has Fireplace
# of Fireplaces (Total): 2
Rooms: Den/Study/Lib, Entry, Exercise Room, Family Room, First Floor Bedroom, First Floor Laundry, First Floor Mstr Bedroom, Great Room, In-Law/auPair/Ste, Living Room, Second Floor Laundry, Utility/Laundry Room, Master Bedroom, Master Bathroom, Home Office, Bonus Room, Basement Full Bath, First Flr Full Bathroom, PrimaryBdrm Full Bathroom, Other-See Remarks, Second Flr Lavatory, Second Flr Full Bathroom, Shared Bathroom, Breakfast Nook/Room, Pantry, Formal Dining Room