An extraordinary expression of refined lakefront living, this meticulously maintained, single-owner custom residence is gracefully positioned along the coveted shoreline of Lake St. Clair. From radiant sunrises to shimmering evening horizons, sweeping panoramic water views create a breathtaking and ever-changing backdrop from nearly every principal room. Thoughtfully designed to blend timeless elegance with modern comfort, the main level showcases a luxurious first-floor primary suite — a private sanctuary defined by scale, serenity, and understated sophistication. At the heart of the home, a dramatic great room seamlessly integrates with a bespoke bar and expansive chef’s kitchen, creating an inspired setting for grand entertaining and memorable family gatherings alike. Upstairs, three beautifully appointed bedroom suites provide exceptional privacy and comfort, each complemented by spa-inspired en-suite baths and substantial walk-in dressing closets. Throughout the residence, enduring craftsmanship, refined architectural detail, and meticulous care are evident at every turn. With its premier lakefront setting, generous proportions, and limitless opportunity for personalization, this remarkable estate offers a rare canvas to create a legacy residence tailored to your vision and lifestyle.
Single-familyProperty Type
1992Year Built
0.55 acresLot Size
$322Price/Sq.Ft.
3 car garageParking
Listed by Alex M. Lucido• Lucido and Associates, Inc
•313-882-1010 (broker)
•alex@lucidorealestate.com (broker)
Bought with Alex M. Lucido• Lucido and Associates, Inc
Est. $4,559 per month, based on comparable rentals
Sale and tax history for 207 Lake Shore Dr
Sale History
Tax History
Date
Event
Price
MiRealSource-MiMLS #50201310
Jul 17, 2026
Sold
$1,855,000
$322/sq ft
Jul 1, 2026
Pending
—
May 1, 2026
Price Changed
$2,249,000
$391/sq ft
Apr 23, 2026
Price Changed
$2,250,000
$391/sq ft
Mar 11, 2026
Listed
$2,450,000
$426/sq ft
REALCOMP #58050201310
Jul 17, 2026
Sold
$1,855,000
$322/sq ft
Jul 1, 2026
Pending
—
May 1, 2026
Price Changed
$2,249,000
$391/sq ft
Apr 23, 2026
Price Changed
$2,250,000
$391/sq ft
Mar 11, 2026
Listed
$2,450,000
$426/sq ft
An extraordinary expression of refined lakefront living, this meticulously maintained, single-owner custom residence is gracefully positioned along the coveted shoreline of Lake St. Clair. From radiant sunrises to shimmering evening horizons, sweeping panoramic water views create a breathtaking and ever-changing backdrop from nearly every principal room. Thoughtfully designed to blend timeless elegance with modern comfort, the main level showcases a luxurious first-floor primary suite - a private sanctuary defined by scale, serenity, and understated sophistication. At the heart of the home, a dramatic great room seamlessly integrates with a bespoke bar and expansive chef's kitchen, creating an inspired setting for grand entertaining and memorable family gatherings alike. Upstairs, three beautifully appointed bedroom suites provide exceptional privacy and comfort, each complemented by spa-inspired en-suite baths and substantial walk-in dressing closets. Throughout the residence, enduring craftsmanship, refined architectural detail, and meticulous care are evident at every turn. With its premier lakefront setting, generous proportions, and limitless opportunity for personalization, this remarkable estate offers a rare canvas to create a legacy residence tailored to your vision and lifestyle.
Year
Property tax
Land + Additions
Assessment*
2025
$16,788 (−46.8%)
2024
$31,547 (+109.4%)
2022
$15,068 (−45.5%)
2021
$27,651 (−4.6%)
2020
$28,970 (+6.6%)
2019
$27,189 (+4.2%)
2018
$26,101 (+2.8%)
2017
$25,392 (+0.3%)
2016
$25,307 (+3.1%)
2015
$24,546 (+2.6%)
2014
$23,923
Public record
Beds
—
Baths
4
Stories
2
Lot width
100 ft.
Lot depth
240 ft.
Lot size
0.55 Acres
Year renovated
—
Sq. Ft.
5,456
Year built
1992
Style
Single Family Residential
County
Wayne County
APN
38 012 99 0011 703
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 7, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 3
Garage Type: Attached Garage, Electric In Garage, Gar Door Opener, Direct Access
Interior
Interior Features
Has Fireplace
# of Rooms (Total): 14
# of Fireplaces (Total): 2
Rooms: Den/Study/Lib, Entry, Exercise Room, First Floor Bedroom, First Floor Laundry, First Floor Mstr Bedroom, Great Room, Utility/Laundry Room, Bonus Room, First Flr Lavatory, PrimaryBdrm Full Bathroom, Second Flr Full Bathroom, Breakfast Nook/Room, Eat-In Kitchen, Formal Dining Room
Interior Features: 9 Ft + Ceilings, Bay Window, Cathedral/Vaulted Ceiling, Hardwood Floors, Walk-In Closet
Appliances: Bar (Refrigerator), Central Vacuum, Dishwasher, Disposal, Dryer, Range/Oven, Refrigerator, Washer
Has Fireplace
Fireplace Features: Family Room Fireplace, Great Room Fireplace
Bedroom Information
Bedroom 1 Level: Entry
Bedroom 1 Dimensions: 16 x 21
Bedroom 1 Floor Covering: Carpet
Bedroom 1 Floor Covering: Carpet
Bedroom 2 Level: Second
Bedroom 2 Dimensions: 18 x 19
Bedroom 2 Floor Covering: Carpet
Bedroom 3 Level: Second
Bedroom 3 Dimensions: W=17
Bedroom 3 Floor Covering: Carpet
Bedroom 4 Level: Second
Bedroom 4 Dimensions: 14 x 22
Bedroom 4 Floor Covering: Carpet
Bathroom Information
Second
# of Lavatories: 2
# of Bathrooms (Full): 3
# of Baths/Lavatories (Total): 5
Bathroom 1 Information
Lavatory 1 Level: Entry
Bathroom 1 Floor Covering: Marble
Bathroom 1 Level: Entry
Bathroom 2 Information
Lavatory 2 Level: Entry
Bathroom 2 Floor Covering: Ceramic
Bathroom 2 Level: Second
Bathroom 3 Information
Bathroom 3 Floor Covering: Ceramic
Bathroom 3 Level: Second
Dining/Kitchen Information
Breakfast Nook Floor Covering: Wood
Dining Room Floor Covering: Wood
Kitchen Floor Covering: Wood
Kitchen Level: Entry
Kitchen Dimension: 15 x 18
Breakfast Nook Level: Entry
Breakfast Nook Dimension: 14 x 15
Dining Room Level: Entry
Dining Room Dimension: 16 x 23
Family/Great Room Information
Great Room Floor Covering: Wood
Great Room Level: Entry
Great Room Dimensions: 20 x 31
Library/Den/Living Room Information
Library/Den Floor Covering: Wood
Bonus/Media Room Floor Covering: Carpet
Library/Den Level: Entry
Library/Den Dimensions: 14 x 17
Laundry/Basement Information
Laundry Room Floor Covering: Laminate
Basement : Has Basement
Basement Type: Full
Laundry Room Level: Entry
Laundry Room Dimensions: 8 x 11
Other Room Information
Other Room 2 Floor Covering: Carpet
Other Room 2 Level: Second
Other Room 2 Dimensions: 10 x 13
Exterior
Exterior Features
Exterior Construction: Brick
Exterior Features: Lawn Sprinkler, Patio
Foundation Type: Basement
Property Features
On Waterfront
Water Features: All Sports Lake, Lake Frontage, Water View, Waterfront
Home facts updated by county records on Aug 7, 2026
Other
Listing Information
Originating MLS: MiRealSource
Originating MLS: MI Real Source
Around this home
Schools
Kerby Elementary School
Public K-4 • Assigned • 1.0mi
9/10
Brownell Middle School
Public 5-8 • Assigned • 1.2mi
8/10
Grosse Pointe South High School
Public 9-12 • Assigned • 0.8mi
10/10
Provided by GreatSchools
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
3/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
3/10 Air Factor
3 unhealthy days expected this year, 4 days in 30 years
Provided by First Street
Historical weather
Grosse Pointe Farms, MI • 48236
Average low and high temperatures (°F)
28
17
34
21
50
33
59
42
66
50
80
63
82
69
78
64
75
60
65
49
50
39
37
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
93/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 9% for direct sun exposure in Grosse Pointe Farms. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.3 hrs
6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$2.10M – $2.54M
Reach more buyers when you sell with Redfin. Plus, you'll save $22,048 in fees.