17731 HAMILTON Rd, Detroit, MI 48203 1799

Off market nov 2018 for $659K

$946,514

Est. refi paymentEst. refi $4,953/mo

•

5,360

sq ft

17731 HAMILTON Rd, Detroit, MI 48203 1799

About this home

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

$177Est. 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

•313-886-4200 (broker)

•jamie.begin@cbpmichigan.com (broker)

Redfin checked: 2 minutes ago

•Source:MiRealSource-MiMLS #21473287

Redfin Estimate

$946,514

$288K since sold in November 2018$13K since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 59.3% higher than the average sale price ($594K) of 6 comparable homes.

SOLD SEP 4, 2026
$555,000
A
7 beds4 baths6,587 sq ft
1735 Lincolnshire Dr, Detroit, MI 48203 1410
SOLD AUG 24, 2026
$525,000
B
5 beds4.5 baths5,300 sq ft
17596 Wildemere St, Detroit, MI 48221 2725
SOLD JUN 11, 2026
$660,000
C
7 beds3.5 baths5,047 sq ft
1686 Balmoral Dr, Detroit, MI 48203 1447
SOLD JUL 16, 2026
$515,000
D
6 beds4 baths3,500 sq ft
18221 Muirland Rd, Detroit, MI 48221
SOLD NOV 26, 2025
$590,000
E
5 beds6 baths4,575 sq ft
17600 Fairway Dr, Detroit, MI 48221 2783
SOLD JUL 14, 2026
$720,000
F
5 beds4 baths3,650 sq ft
3261 Sherbourne Rd, Detroit, MI 48221 1814

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$449,099

Est. take-home

List your home with Redfin and save $9,465

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,089/mo

Redfin rental estimate

List your home for rent

Market trends in 48203, MI

Last updated September 2026

Buyer's Market

Seller's Market

Buyer's market

Sale-to-List Price

95.1%

+0.5% MoM

Median sale price

$115K

$23K MoM

Avg. days on market

85d

28 days MoM

Recently sold homes

3 MoM

New listings for sale

$850,000
6 beds5.5 baths6,239 sq ft
19494 Suffolk Dr, Detroit, MI 48203 1472
(888) 501-7085
NEW 21 HRS AGO
$46,900
3 beds1 bath1,886 sq ft
20150 Orleans St, Detroit, MI 48203 1356
(888) 876-3372
NEW 22 HRS AGO
$400,000
4 beds2 baths3,127 sq ft
1260 Strathcona Dr, Detroit, MI 48203 1460
(313) 846-0960
NEW 24 HRS AGO
$60,000
3 beds1 bath1,485 sq ft
20215 Russell St, Detroit, MI 48203
(586) 580-8092
$95,000
2 beds1.5 baths1,352 sq ft
18064 Greeley St, Highland Park, MI 48203 2473
(248) 378-1000
COMING SOON
$150,000
— beds3 baths2,764 sq ft
111 Midland St, Highland Park, MI 48203 3749
(313) 363-0389
OPEN OCT 20, 5PM TO 7PM
$295,000
4 beds2.5 baths2,985 sq ft
35 Massachusetts St, Highland Park, MI 48203 3536
(248) 733-5811
$169,999
4 beds2 baths1,836 sq ft
19404 Andover St, Detroit, MI 48203 4913
(313) 877-9020
$139,900
— beds2 baths2,920 sq ft
158-160 W Arizona St, Detroit, MI 48203 5233
(586) 580-8092
$99,900
3 beds2 baths1,650 sq ft
13488 Orleans St, Highland Park, MI 48203 2454
(833) 264-6832
See all

Provided by Redfin

Sale history for 17731 HAMILTON Rd

Date

Event

Price

MiRealSource-MiMLS #21473287

Nov 2, 2018

Sold

$659,000

$123/sq ft

Aug 26, 2018

Pending

—

Jul 12, 2018

Listed

$669,900

$125/sq ft

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

—

Feb 7, 2017

Listed

$660,000

$123/sq ft

MiRealSource-MiMLS #21259324

Apr 19, 2017

Listing Removed

—

Feb 7, 2017

Listed

$660,000

$123/sq ft

MiRealSource-MiMLS #21126868

Feb 7, 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

—

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

Tax history for 17731 HAMILTON Rd

*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

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.

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.

Permitted uses

Include but are not limited to:

Housing-Single unit

Property details

Parking

Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 2
Garage Type: Attached Garage, Gar Door Opener

Interior

Virtual Tour

Interior Features
Has Fireplace
# of Rooms (Total): 22
Interior Features: Cable/Internet Avail., Spa/Jetted Tub, Wet Bar/Bar
Appliances: Dishwasher, Disposal, Dryer, Range/Oven, Refrigerator, Washer
Has Fireplace
Fireplace Features: Family Room Fireplace, Great Room Fireplace, Natural Fireplace

Bathroom Information
# of Lavatories: 1
# of Bathrooms (Full): 6
# of Baths/Lavatories (Total): 7

Laundry/Basement Information
Basement : Has Basement
Basement Type: Finished, Walk Out

Exterior

Exterior Features
Exterior Construction: Brick
Exterior Features: Exterior Balcony, Patio, Porch
Foundation Type: Basement

Property Information
Property Type: Residential
Structure Style: More than 2 Stories
Year Built: 1923
Below Grade Sq. Ft.: 2066
Below Grade Sq. Ft. (Finished): 2000

Lot Information
Lot Size: 90,240,100,237

Land Information
Land Contract: No
Acreage: 0.52
Roads: Paved Street
Frontage: 90

Financial

Tax/Assessments Information
Total Tax Amount: $7,950
Summer Tax Amount: $6,784
Winter Tax Amount: $1,166

Utilities

Utility Information
Heat/Fuel Type: Natural Gas
Water Heater: Gas
Cooling System: Ceiling Fan(S), Central A/C
Heating System: Radiant

Location

Unit 5 Information
Living Room Dimensions: L=7360

Homeowners Association Information
Association/Community Amenities: Golf Course

School Information
School District: Detroit City School District
School District: Detroit City School District

Address Information
Street Designation: Road

Location Details
Directions: Between 7 Mile Rd. and W McNichols Ave.; Between Woodward Ave. and Livernois Ave.
Municipality Type: City
Municipality: Detroit
Mail City: Detroit
Subdivision: DETROIT GOLF CLUB (PG 99 & 100)
Municipality: Detroit
Area (Municipality): Detroit (82001)

Public facts

Beds: —
Baths: 3.0
Sq. Ft.: —
Stories: 2.5
Lot Size: 0.52 acres
Style: Single Family Residential
Year Built: 1923
Year Renovated: —
County: Wayne County
APN: 02002755.

Home facts updated by county records on Aug 7, 2026

Other

Listing Information
Originating MLS: RealComp
No

Around this home

Schools

Palmer Park Preparatory Academy

Public PreK-8 • Assigned • 0.8mi

4/10

Mumford High School

Public 9-12 • Assigned • 2.0mi

4/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

2/10 Heat Factor

6 days above 97° expected this year, 13 days in 30 years

2/10 Wind Factor

Minor risk of severe winds over next 30 years

4/10 Air Factor

4 unhealthy days expected this year, 6 days in 30 years

Provided by First Street

Historical weather

Detroit, MI • 48203 1799

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9.3 hours in June and 2.5 hours in December, placing it below the U.S. average for solar exposure.

9.3 hrs

2.5 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$900,000 – $1.09M

Reach more buyers when you sell with Redfin. Save up to $9,465 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$29,900

2 beds1 bath1,584 sq ft

975 FERNHILL St, Detroit, MI 48203 1539

(734) 459-4700

$5,000

3 beds1 bath1,820 sq ft

68 E Nevada St, Detroit, MI 48203 2227

(248) 294-7850

$29,990

Land— sq ft

491 W Lantz St, Highland Park, MI 48203 1575

(313) 752-0000

$2,500

Land— sq ft

20195 Omira St, Highland Park, MI 48203 1104

(248) 294-7850

$220,000

2 beds1 bath1,811 sq ft

1350 Spencer St, Ferndale, MI 48220 2617

(313) 949-7191

$399,900

3 beds1.5 baths3,191 sq ft

18265 Parkside St, Detroit, MI 48221 2726

(734) 252-6108

New listings for sale in 48203 1472

$850,000

6 beds5.5 baths6,239 sq ft

19494 Suffolk Dr, Detroit, MI 48203 1472

(888) 501-7085

NEW 21 HRS AGO

$46,900

3 beds1 bath1,886 sq ft

20150 Orleans St, Detroit, MI 48203 1356

(888) 876-3372

NEW 22 HRS AGO

$400,000

4 beds2 baths3,127 sq ft

1260 Strathcona Dr, Detroit, MI 48203 1460

(313) 846-0960

NEW 24 HRS AGO

$60,000

3 beds1 bath1,485 sq ft

20215 Russell St, Detroit, MI 48203

(586) 580-8092

$95,000

2 beds1.5 baths1,352 sq ft

18064 Greeley St, Highland Park, MI 48203 2473

(248) 378-1000

COMING SOON

$150,000

— beds3 baths2,764 sq ft

111 Midland St, Highland Park, MI 48203 3749

(313) 363-0389

OPEN OCT 20, 5PM TO 7PM

$295,000

4 beds2.5 baths2,985 sq ft

35 Massachusetts St, Highland Park, MI 48203 3536

(248) 733-5811

$169,999

4 beds2 baths1,836 sq ft

19404 Andover St, Detroit, MI 48203 4913

(313) 877-9020

$139,900

— beds2 baths2,920 sq ft

158-160 W Arizona St, Detroit, MI 48203 5233

(586) 580-8092

Home values near 17731 HAMILTON Rd

Data from public records.

Address	Redfin Estimate
17581 Hamilton Road, Detroit, MI - Beds \| - Baths \| - Sq. Ft.	$457,890
17501 Hamilton Road, Detroit, MI 5 Beds \| 4 Baths \| 4868 Sq. Ft.	$779,173

Address	Redfin Estimate
17535 Hamilton Road, Detroit, MI 4 Beds \| 5.5 Baths \| 4223 Sq. Ft.	$975,536
17751 Hamilton Road, Detroit, MI - Beds \| 3.5 Baths \| 3754 Sq. Ft.	$565,151

Address	Redfin Estimate
17471 Hamilton Road Unit 1, Highland Park, MI 4 Beds \| 4.5 Baths \| 5000 Sq. Ft.	$650,755
18001 Hamilton Road, Detroit, MI 4 Beds \| 3 Baths \| 3388 Sq. Ft.	$472,519

Property information provided by MiRealSource-MiMLS when last listed in 2018. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

48219 homes for sale
48235 homes for sale
48124 homes for sale
48221 homes for sale
48224 homes for sale

Houses for rent in Detroit	Agents near me	Livonia, MI homes for sale	Detroit Housing Market
Houses for sale near me	Detroit, MI homes for sale	Royal Oak, MI homes for sale
Land for sale near me	Ann Arbor, MI homes for sale	Novi, MI homes for sale
Open Houses near me	Grand Rapids, MI homes for sale	Detroit Property Records
Condos for sale near me	Troy, MI homes for sale	MI New Listings

Farmington Hills homes for sale
Royal Oak homes for sale
Troy homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 48203, MI

Sale history for 17731 HAMILTON Rd

Tax history for 17731 HAMILTON Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 48203 1472

Home values near 17731 HAMILTON Rd

More real estate resources