Luxury Lakeside Living in Grosse Pointe Farms. Stunning Lake Views: Experience the serenity of lakefront living with panoramic views that will leave you in awe. Each level of this magnificent home is designed to maximize your connection to the tranquil waters of Lake St. Clair. This exquisite custom-built masterpiece boasts over 6500 square feet of luxurious living. The heart of the home features a state-of-the art gourmet kitchen equipped with top-of-the-line appliances, spacious eating area and an adjacent family room complete with a cozy fireplace - perfect for entertaining family & friends. Revel in the sophistication of the stunning wood-paneled library adorned with a fireplace, and host formal gatherings in the elegant dining room. An inviting private office offers a quiet retreat for work or study. The first floor includes a private in-law suite or guest quarters with full bath, ensuring comfort and privacy for visitors. The convenience of a first floor laundry, mud room and an attached 3 car garage adds to the homes functionality. Opulent Primary Suite: Ascend to the second floor to discover the expansive primary suite featuring a tray ceiling, fireplace and sweeping views of the lake. The en-suite bathroom is a spa-like oasis, complete with a soaking tub, dual vanities and 2 generous walk-in closets. Three additional second floor bedrooms, each with their own ensuite baths, provide ample space for family & guests, while an informal sitting room adds a cozy touch to the upper level. Entertainment and Utility Areas: The finished basement is a true entertainer's dream, featuring a media room and several dedicated spaces for projects and hobbies, along with a large utility room to accomodate all mechanical systems. Impeccable Upgrades: Recent updates include new furnaces, new A/C and a brand-new roof, ensuring peace of mind for years to come. The circular drive and majestic landscape enhance the home's curb appeal, welcoming you to your private oasis. This stunning property offers an unparalleled lifestyle in one of Michigan's most prestigious neighborhoods. Don't miss the opportunity to own this lakeside gem!
Luxury Lakeside Living in Grosse Pointe Farms. Stunning Lake Views: Experience the serenity of lakefront living with panoramic views that will leave you in awe. Each level of this magnificent home is designed to maximize your connection to the tranquil waters of Lake St. Clair. This exquisite custom-built masterpiece boasts over 6500 square feet of luxurious living. The heart of the home features a state-of-the art gourmet kitchen equipped with top-of-the-line appliances, spacious eating area and an adjacent family room complete with a cozy fireplace - perfect for entertaining family & friends. Revel in the sophistication of the stunning wood-paneled library adorned with a fireplace, and host formal gatherings in the elegant dining room. An inviting private office offers a quiet retreat for work or study. The first floor includes a private in-law suite or guest quarters with full bath, ensuring comfort and privacy for visitors. The convenience of a first floor laundry, mud room and an attached 3 car garage adds to the homes functionality. Opulent Primary Suite: Ascend to the second floor to discover the expansive primary suite featuring a tray ceiling, fireplace and sweeping views of the lake. The en-suite bathroom is a spa-like oasis, complete with a soaking tub, dual vanities and 2 generous walk-in closets. Three additional second floor bedrooms, each with their own ensuite baths, provide ample space for family & guests, while an informal sitting room adds a cozy touch to the upper level. Entertainment and Utility Areas: The finished basement is a true entertainer's dream, featuring a media room and several dedicated spaces for projects and hobbies, along with a large utility room to accomodate all mechanical systems. Impeccable Upgrades: Recent updates include new furnaces, new A/C and a brand-new roof, ensuring peace of mind for years to come. The circular drive and majestic landscape enhance the home's curb appeal, welcoming you to your private oasis. This stunning property offers an unparalleled lifestyle i
Greater Lansing AoR #50166368
Feb 28, 2025
Sold
$2,540,000
$306/sq ft
Feb 12, 2025
Pending
—
Feb 11, 2025
Listed
$2,725,000
$328/sq ft
Luxury Lakeside Living in Grosse Pointe Farms. Stunning Lake Views: Experience the serenity of lakefront living with panoramic views that will leave you in awe. Each level of this magnificent home is designed to maximize your connection to the tranquil waters of Lake St. Clair. This exquisite custom-built masterpiece boasts over 6500 square feet of luxurious living. The heart of the home features a state-of-the art gourmet kitchen equipped with top-of-the-line appliances, spacious eating area and an adjacent family room complete with a cozy fireplace - perfect for entertaining family & friends. Revel in the sophistication of the stunning wood-paneled library adorned with a fireplace, and host formal gatherings in the elegant dining room. An inviting private office offers a quiet retreat for work or study. The first floor includes a private in-law suite or guest quarters with full bath, ensuring comfort and privacy for visitors. The convenience of a first floor laundry, mud room and an attached 3 car garage adds to the homes functionality. Opulent Primary Suite: Ascend to the second floor to discover the expansive primary suite featuring a tray ceiling, fireplace and sweeping views of the lake. The en-suite bathroom is a spa-like oasis, complete with a soaking tub, dual vanities and 2 generous walk-in closets. Three additional second floor bedrooms, each with their own ensuite baths, provide ample space for family & guests, while an informal sitting room adds a cozy touch to the upper level. Entertainment and Utility Areas: The finished basement is a true entertainer's dream, featuring a media room and several dedicated spaces for projects and hobbies, along with a large utility room to accomodate all mechanical systems. Impeccable Upgrades: Recent updates include new furnaces, new A/C and a brand-new roof, ensuring peace of mind for years to come. The circular drive and majestic landscape enhance the home's curb appeal, welcoming you to your private oasis. This stunning property offers an unparalleled lifestyle in one of Michigan's most prestigious neighborhoods. Don't miss the opportunity to own this lakeside gem!
Greater Lansing AoR #50146942
Dec 30, 2024
Listing Removed
—
Oct 7, 2024
Price Changed
$2,725,000
$328/sq ft
Aug 9, 2024
Price Changed
$2,950,000
$355/sq ft
Jul 2, 2024
Listed
$3,200,000
$385/sq ft
REALCOMP #58050146942
Dec 30, 2024
Listing Removed
—
Jun 28, 2024
Listed
$2,725,000
$328/sq ft
MiRealSource-MiMLS #883912
Apr 15, 1996
Sold
$1
$0/sq ft
Jul 29, 1993
Listing Removed
—
Jul 29, 1993
Listed
$760,000
$92/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$45,848 (+8.7%)
2024
$42,195 (+109.4%)
2022
$20,154 (−58.1%)
2021
$48,142 (+1.0%)
2020
$47,651 (+5.1%)
2019
$45,330 (+4.8%)
2018
$43,241 (+3.0%)
2017
$41,968 (+1.0%)
2016
$41,544 (+2.7%)
2015
$40,447 (+3.1%)
2014
$39,221
Tax history for 217 Lake Shore Rd
Year
Property tax
Land + Additions
Assessment*
2025
$45,848 (+8.7%)
2024
$42,195 (+109.4%)
2022
$20,154 (−58.1%)
2021
$48,142 (+1.0%)
2020
$47,651 (+5.1%)
2019
$45,330 (+4.8%)
2018
$43,241 (+3.0%)
2017
$41,968 (+1.0%)
2016
$41,544 (+2.7%)
2015
$40,447 (+3.1%)
2014
$39,221
*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
6
Stories
—
Lot width
263 ft.
Lot depth
147 ft.
Lot size
0.83 Acres
Year renovated
—
Sq. Ft.
6,561
Year built
1997
Style
Single Family Residential
County
Wayne County
APN
38 012 99 0002 703
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 23, 2026.
Oct 11, 2022 • Final
Mechanical
Work on a mechanical system.
HVAC
Mar 16, 2021 • Final
Mechanical
Work on a mechanical system.
HVAC
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
Has Attached Garage
# of Garage Spaces: 3
Parking Features: Attached, Paved
Interior
Bathroom Information
# of Full Bathrooms: 5
# of Half Bathrooms: 2
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air, Natural Gas
Interior Features
Interior Features: Eat-in Kitchen, Pantry, Bar, Master Downstairs, In-Law Floorplan
Appliances: Gas Water Heater
Flooring: Hardwood
Has Fireplace
# of Fireplaces: 3
Fireplace Features: Family Room
Room Information
Laundry Features: Main Level, In Basement
Has Basement
Basement Details: Finished
Exterior
Exterior Features
Exterior Features: Balcony
Patio And Porch Features: Patio
Building Information
Above Grade Finished Area: 6,561
Below Grade Finished Area: 1,745
# of Stories Total: 2
Construction Materials: Brick
Property Features
On Waterfront
Waterfront Features: Waterfront
Has View
Other Equipment: Home Theater
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family
Lot Information
Lot Features: Corner Lot, Cul-De-Sac
Frontage Type: Waterfront
Frontage Length: 263
Lot Size : 263 X 147
Lot Size Acres: 0.83
Financial
Tax Information
Tax Annual Amount: $42,195
Utilities
Utility Information
Water Source: Public
Sewer: Public Sewer
Location
Schools Information
School District: Grosse Pointe Public Schools
Location Information
Subdivision Name: Harbor Hill Sub
Cross Street: Lakeshore
Public facts
Beds: —
Baths: 6.0
Sq. Ft.: 6,561
Stories: —
Lot Size: 0.83 acres
Style: Single Family Residential
Year Built: 1997
Year Renovated: —
County: Wayne County
APN: 38 012 99 0002 703
Home facts updated by county records on Oct 23, 2026
Other
Listing Information
List AOR: MiRealSource
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
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
3/10 Heat Factor
7 days above 96° expected this year, 14 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
84
69
78
64
75
58
65
49
50
39
37
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.1 hours in
June and 2.4 hours in December, placing it below the
U.S. average for solar exposure.
9.1 hrs
2.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$2.53M – $3.06M
Reach more buyers when you sell with Redfin. Save up to $26,602 in fees.3 minutes to get started.