This majestic, gorgeous and meticulously detailed mansion, overlooking the 11th hole on the North Course of the Detroit Golf Club is absolutely breathtaking! Come see Tiger, Phil, Dustin Johnson and more play in your own backyard, LITERALLY, at the recently announced 2019 PGA Tour event at the DGC. This amazing 6-bd/6.1 ba home with serene golf course views boasts custom woodwork, multiple entertaining rooms, hardwood floors throughout, regal library, large gourmet kitchen w/ stainless steel appl + custom brick stove area, multiple staircases, 360-degree sunroom, large master bedroom en suite w/ custom bath + XL size dressing room, 3rd floor loft, finished bsmnt w/ granite wetbar and an eye-dropping Jacuzzi/steam shower rm w/ Sauna. Professionally landscaped backyard w/ in-ground custom Koi pond. Private drive, 24-hour security, Well-maintained w/ upgraded baths, brand new roof(2018), insulation, electrical. What a rare opportunity! Homes like these only hit the market once in a blue moon!
Single-familyProperty Type
1923Year Built
0.52 acresLot Size
$223Est. Price/Sq.Ft.
2 car garageParking
Listed by Derek Oglesby• Coldwell Banker Metro Real Estate
•248-242-7282 (broker)
Bought with Tamara Smith• Coldwell Banker Professionals-GPF
This majestic, gorgeous and meticulously detailed mansion, overlooking the 11th hole on the North Course of the Detroit Golf Club is absolutely breathtaking! Come see Tiger, Phil, Dustin Johnson and more play in your own backyard, LITERALLY, at the recently announced 2019 PGA Tour event at the DGC. This amazing 6-bd/6.1 ba home with serene golf course views boasts custom woodwork, multiple entertaining rooms, hardwood floors throughout, regal library, large gourmet kitchen w/ stainless steel appl + custom brick stove area, multiple staircases, 360-degree sunroom, large master bedroom en suite w/ custom bath + XL size dressing room, 3rd floor loft, finished bsmnt w/ granite wetbar and an eye-dropping Jacuzzi/steam shower rm w/ Sauna. Professionally landscaped backyard w/ in-ground custom Koi pond. Private drive, 24-hour security, Well-maintained w/ upgraded baths, brand new roof(2018), insulation, electrical. What a rare opportunity! Homes like these only hit the market once in a blue moon!
REALCOMP #218058228
Nov 2, 2018
Sold
$659,000
$123/sq ft
Aug 26, 2018
Pending
—
Jul 12, 2018
Listed
$669,900
$125/sq ft
REALCOMP #217009391
Aug 28, 2017
Listing Removed
—
Apr 20, 2017
Pending
—
Feb 7, 2017
Listed
$660,000
$123/sq ft
MiRealSource-MiMLS #21259324
Apr 20, 2017
Pending
—
Apr 19, 2017
Listing Removed
—
Apr 19, 2017
Listing Removed
—
Feb 7, 2017
Listed
$660,000
$123/sq ft
MiRealSource-MiMLS #21126868
Feb 7, 2017
Listing Removed
—
Feb 6, 2017
Listing Removed
—
Sep 20, 2016
Price Changed
$725,000
$135/sq ft
Apr 10, 2016
Listed
$799,000
$149/sq ft
REALCOMP #216031238
Feb 7, 2017
Listing Removed
—
Sep 19, 2016
Price Changed
$725,000
$135/sq ft
Apr 8, 2016
Listed
$799,000
$149/sq ft
MiRealSource-MiMLS #20733393
Apr 10, 2016
Listing Removed
—
Apr 8, 2016
Listing Removed
—
Apr 6, 2016
Relisted
—
Mar 2, 2016
Listing Removed
—
Mar 1, 2016
Listed
$799,000
$149/sq ft
REALCOMP #216012118
Apr 8, 2016
Listing Removed
—
Feb 11, 2016
Listed
$799,000
$149/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$1,351 (−31.9%)
2024
$1,983 (+45.3%)
2023
$1,365 (+3.5%)
2022
$1,319 (+3.2%)
2021
$1,278 (−14.9%)
2020
$1,501 (−20.2%)
2019
$1,882 (−75.8%)
2018
$7,775 (+0.3%)
2017
$7,753 (−0.8%)
2016
$7,815 (+1.7%)
2015
$7,682 (+0.5%)
2014
$7,644 (−3.5%)
2013
$7,918
Tax history for 17731 HAMILTON Rd
Year
Property tax
Land + Additions
Assessment*
2025
$1,351 (−31.9%)
2024
$1,983 (+45.3%)
2023
$1,365 (+3.5%)
2022
$1,319 (+3.2%)
2021
$1,278 (−14.9%)
2020
$1,501 (−20.2%)
2019
$1,882 (−75.8%)
2018
$7,775 (+0.3%)
2017
$7,753 (−0.8%)
2016
$7,815 (+1.7%)
2015
$7,682 (+0.5%)
2014
$7,644 (−3.5%)
2013
$7,918
*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
Zoning
Beds
—
Baths
3
Stories
2.5
Lot width
90 ft.
Lot depth
252 ft.
Lot size
0.52 Acres
Year renovated
—
Sq. Ft.
—
Year built
1923
Style
Single Family Residential
County
Wayne County
APN
02002755.
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 7, 2026.
R1
Single-Family Residential District
The R1 Single-Family Residential District is designed to protect and preserve quiet, low-density residential areas now primarily developed and those areas which will be developed with single-family detached dwellings and characterized by a high ratio of home ownership. The regulations for this district are designed to stabilize and protect the essential characteristics of the district and to promote and encourage a suitable environment for activities associated with family life. To these ends, development is limited to a relatively low concentration and uses permitted by right are limited to single-family detached dwellings which provide homes for the residents of the area. Additional residential uses such as religious institutions, neighborhood centers, and utility uses necessary to serve the immediate area may be permitted on a conditional basis.