Off Market Aug 2020 for $475K

$629,957

•

3,116

sq ft

400 Inverness, Highland, MI 48357

About this home

Welcome to this custom home that sits on the Signature 17th hole of Prestwick Village Golf Course with Cascading Fairways! From the minute you walk through the Main Entrance you are drawn to the magnificent views of the golf course that surrounds the backyard. Open floor plan showcases floor to ceiling 18' Stone Gas Fireplace in the Great Room & Hardwood floors throughout. Office/Study beautifully finished w/ French Doors & Built in Shelves. The Dinning room features Crown Molding and is ready for many Family gatherings. Make your way to the Kitchen that opens to the Great room and is perfect for entertaining w/ center Island & extra seating area. Kitchen features Gas stove, Subzero Fridge, Walk-in pantry & Breakfast nook that leads way to the two tiered Brick Paver patio area & Breathtaking Views of a Golfers Dream! Main floor Master Bedroom with his and Hers walk in closet & master bath with 2 person Jetted tub with shower. Radiate heated 3 car garage. Truly a Must See! Video Tour

Single-familyProperty Type

1998Year Built

0.47 acresLot Size

$202Est. Price/Sq.Ft.

3 car garageParking

Listed by Cheryl Mueller • EXP Realty

Bought with Kirsten Scopacasa • Preferred, Realtors® Ltd

Redfin checked: a minute ago

•Source:REALCOMP #2200048909

Listing provided courtesy of Realcomp MLS

Redfin Estimate

$629,957

$155K since sold in August 2020$21K since August

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUL 30, 2026
$850,000
A
4 beds3.5 baths2,795 sq ft
1270 Gleneagles, Highland, MI 48357
SOLD AUG 26, 2026
$655,000
B
4 beds2.5 baths4,350 sq ft
3130 Katie Ln, Milford, MI 48380 2021
SOLD SEP 30, 2025
$540,000
C
3 beds2.5 baths3,085 sq ft
726 Berwick Ct #231, Highland, MI 48357
SOLD AUG 5, 2026
$298,500
D
4 beds3 baths1,770 sq ft
4271 W Highland Rd, Milford, MI 48380
SOLD JUN 29, 2026
$450,000
E
4 beds2.5 baths2,799 sq ft
678 Joshua Dr, Highland, MI 48356 2958
SOLD AUG 7, 2026
$405,000
F
4 beds2.5 baths2,028 sq ft
1250 Shotey Ct, Milford, MI 48380 1734

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

Earn from this home

Sell

$257,713

Est. take-home

List your home with Redfin and save $6,300

Rent

$3,426/mo

Redfin rental estimate

List your home for rent

Market trends in 48357, MI

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

98.6%

+0.2% MoM

Median sale price

$570K

$9K MoM

Avg. days on market

17d

5 days MoM

Recently sold homes

8 MoM

New listings for sale

NEW 1 HR AGO
$765,000
4 beds3.5 baths5,382 sq ft
2459 Overbrook, Highland, MI 48357 4233
(248) 380-5141
COMING SOON
$594,900
4 beds2.5 baths4,209 sq ft
398 Delmar Ct, Highland, MI 48357 4790
(810) 227-1111
NEW 15 HRS AGO
$1,550,000
4 beds5.5 baths6,080 sq ft
1315 Maryland, Milford, MI 48380 1601
(248) 850-8632
$224,900
3 beds1 bath1,901 sq ft
535 Snyder Rd, Highland, MI 48357 2860
(810) 344-7275
$25,000
2 beds2 baths1,100 sq ft
247 Sutherland Dr, Highland, MI 48357
(734) 318-2121
OPEN SAT, 1PM TO 4PM
$789,999
4 beds4 baths5,227 sq ft
624 Nairn Cir, Highland, MI 48357 4762
(248) 218-0234
VIDEO TOUR
$624,900
3 beds2.5 baths3,082 sq ft
492 Delmar Ct, Highland, MI 48357 4790
(248) 504-4000
See all

Provided by Redfin

Sale history for 400 Inverness

Date

Event

Price

MiRealSource-MiMLS #40073126

Aug 5, 2020

Sold

$475,000

$152/sq ft

Aug 1, 2020

Pending

—

Jul 7, 2020

Contingent

—

Jul 1, 2020

Listed

$489,900

$157/sq ft

REALCOMP #2200048909

Aug 5, 2020

Sold

$475,000

$152/sq ft

Aug 1, 2020

Pending

—

Jul 7, 2020

Contingent

—

Jul 1, 2020

Listed

$489,900

$157/sq ft

Public record

Public record
Zoning

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Single Family Residential

County

Oakland County

APN

1129227009

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jun 12, 2025.

R1.5

Single-Family Residential District

It is the intent of these districts to provide for single-family detached residential development in Highland Township at varying densities which are consistent with the existing and desirable future pattern of development in the Township. It is the goal of the Township to protect single-family residential development from the encroachment of incompatible land uses. The Residential R-3, R-1.5 and LV Zoning Districts are distinguished by varying residential densities to accommodate a wide range of existing and future residential preferences in the Township.; The R-3 and R-1.5 Districts are intended for lower density rural residential development. The R-3 and R-1.5 Districts are designated in the northern, western and southern portions of the Township, consistent with the Township Master Plan. Restricting these areas to lower density use will help ensure that the majority of future development occurs in the central portion of the Township, where public services can be more economically provided.

Permitted uses

Include but are not limited to:

Housing-Single unit
Housing-Senior
Housing-Mobile home park
Park & open space

Property details

Parking

Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 3
Parking Features: Attached

Interior

Virtual Tour

Bathroom Information
# of Full Bathrooms: 2
# of Half Bathrooms: 1

Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air, Natural Gas

Interior Features
Appliances: Refrigerator, Gas Water Heater, Built-In Electric Oven, Built-In Refrigerator, Dishwasher, Dryer, Gas Cooktop, Humidifier, Microwave, Washer, Water Softener Owned
Flooring: Carpet, Ceramic Tile, Linoleum, Marble, Wood
Has Fireplace
Fireplace Features: Gas, Great Room

Room Information
# of Rooms Total: 10
Has Basement
Basement Details: Unfinished

Exterior

Exterior Features
Exterior Features: Tennis Court(s)
Patio And Porch Features: Covered, Porch
Roof: Asphalt

Pool Information
Pool Features: Community

Building Information
Entry Location: GroundLevel
Above Grade Finished Area: 3,116
Above Grade Finished Area Units: Square Feet
Levels: Two
Construction Materials: Brick, Wood Siding
Has Home Warranty

Property Features
Accessibility Features: Therapeutic Whirlpool

Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: SingleFamilyResidence

Lot Information
Lot Features: On Golf Course, Near Golf Course
Road Surface Type: Paved
Lot Size Dimensions: 123 x 186 x 120 x 155
Lot Size Area: 0.47
Lot Size Units: Acres
Lot Size Acres: 0.47

Financial

Tax Information
Tax Annual Amount: $4,882

Utilities

Utility Information
Utilities: Cable Available
Sewer: Septic Tank

Location

HOA Information
Has Homeowners Association
Association Fee: $1,000
Association Fee Frequency: Annually
Derived Association Fee (Monthly): $83.33
Association Fee Includes: Maintenance Grounds, Snow Removal

Schools Information
High School District: HuronValley

Location Information
Directions: M59 TO PRESTWICK TRL-S TO INVERNESS-RIGHT
Subdivision Name: PRESTWICK VILLAGE OCCPN 875
Cross Street: S of M59/W of Milford Road

Community Information
Community Features: Pool, Clubhouse, Golf, Tennis Court(s)

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oakland County
APN: 1129227009

Home facts updated by county records on Jun 11, 2025

Around this home

Schools

Highland Elementary School

Public K-5 • Assigned • 1.3mi

5/10

Milford High School

Public 7-12 • Assigned • 1.6mi

8/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

7 days above 96° expected this year, 15 days in 30 years

2/10 Wind Factor

Minor risk of severe winds over next 30 years

2/10 Air Factor

1 unhealthy days expected this year, 3 days in 30 years

Provided by First Street

Historical weather

Highland, MI • 48357

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.6 hours in June and 2.6 hours in December, placing it below the U.S. average for solar exposure.

9.6 hrs

2.6 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$599,000 – $725,000

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

Need the cash from your home fast? Sell to .

Nearby similar homes

$25,000

2 beds2 baths1,100 sq ft

247 Sutherland Dr, Highland, MI 48357

(734) 318-2121

NEW CONSTRUCTION

$550,000

3 beds2.5 baths2,558 sq ft

187 Summit View Trl, Milford, MI 48381

(248) 553-5050

OPEN SAT, 11AM TO 2PM

$449,900

5 beds3.5 baths5,265 sq ft

1471 Blue Heron Dr, Highland, MI 48357 3915

(248) 360-2900

$275,000

3 beds1.5 baths1,096 sq ft

3219 West St, Milford, MI 48380

3D WALKTHROUGH

$449,000

4 beds2.5 baths3,278 sq ft

3332 Woodruff Meadows Ct, Highland, MI 48357 3582

(248) 644-7000

$790,000

4 beds2.5 baths4,335 sq ft

688 Perthshire Ct, Highland, MI 48357 4742

(248) 773-7572

New listings for sale in 48357 4233

NEW 1 HR AGO

$765,000

4 beds3.5 baths5,382 sq ft

2459 Overbrook, Highland, MI 48357 4233

(248) 380-5141

COMING SOON

$594,900

4 beds2.5 baths4,209 sq ft

398 Delmar Ct, Highland, MI 48357 4790

(810) 227-1111

NEW 15 HRS AGO

$1,550,000

4 beds5.5 baths6,080 sq ft

1315 Maryland, Milford, MI 48380 1601

(248) 850-8632

$224,900

3 beds1 bath1,901 sq ft

535 Snyder Rd, Highland, MI 48357 2860

(810) 344-7275

$25,000

2 beds2 baths1,100 sq ft

247 Sutherland Dr, Highland, MI 48357

(734) 318-2121

OPEN SAT, 1PM TO 4PM

$789,999

4 beds4 baths5,227 sq ft

624 Nairn Cir, Highland, MI 48357 4762

(248) 218-0234

VIDEO TOUR

$624,900

3 beds2.5 baths3,082 sq ft

492 Delmar Ct, Highland, MI 48357 4790

(248) 504-4000

Home values near 400 Inverness

Data from public records.

Address	Redfin Estimate
475 Inverness, Highland, MI 5 Beds \| 3.5 Baths \| 4589 Sq. Ft.	$732,281
311 Inverness, Highland, MI 3 Beds \| 2.5 Baths \| 3020 Sq. Ft.	$590,063

Address	Redfin Estimate
352 Inverness, Highland, MI 4 Beds \| 5 Baths \| 10291 Sq. Ft.	$1,522,582
328 Inverness, Highland, MI 5 Beds \| 3.5 Baths \| 5539 Sq. Ft.	$780,944

Address	Redfin Estimate
448 Inverness, Highland, MI 4 Beds \| 3.5 Baths \| 5100 Sq. Ft.	$783,320
472 Inverness, Highland, MI 4 Beds \| 3.5 Baths \| 3528 Sq. Ft.	$700,743

Property information provided by REALCOMP when last listed in 2020. 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.

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

Livingston County homes for sale
Macomb County homes for sale
Wayne County homes for sale

Livonia homes for sale
Royal Oak homes for sale
Troy homes for sale