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
$387/sq ft
Feb 28, 2025
Sold
$2,540,000
$387/sq ft
Feb 12, 2025
Pending
—
Feb 11, 2025
Listed
$2,725,000
$415/sq ft
Feb 11, 2025
Listed
$2,725,000
$415/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!
MiRealSource-MiMLS #50146942
Dec 30, 2024
Listing Removed
—
Dec 30, 2024
Listing Removed
—
Oct 7, 2024
Price Changed
$2,725,000
$415/sq ft
Aug 9, 2024
Price Changed
$2,950,000
$450/sq ft
Jul 2, 2024
Listed
$3,200,000
$488/sq ft
Jun 28, 2024
Coming Soon
*
REALCOMP #58050146942
Dec 30, 2024
Listing Removed
—
Jun 28, 2024
Listed
$2,725,000
$415/sq ft
MiRealSource-MiMLS #883912
Apr 15, 1996
Sold
$1
$0/sq ft
Jul 29, 1993
Listing Removed
—
Jul 29, 1993
Listed
$760,000
$116/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
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 Aug 7, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 3
Garage Type: Attached Garage
Parking: Garage
Interior
Interior Features
Has Fireplace
# of Fireplaces (Total): 3
Rooms: Den/Study/Lib, Entry, Exercise Room, Family Room, First Floor Bedroom, First Floor Mstr Bedroom, Home Theater, In-Law/auPair/Ste, Living Room, Lower Level Laundry, Maids Room/Quarter, Recreation Room, Master Bedroom, Master Bathroom, Home Office, Bonus Room, Basement Full Bath, First Flr Lavatory, First Flr Full Bathroom, PrimaryBdrm Full Bathroom, Second Flr Full Bathroom, Breakfast Nook/Room, Pantry, Eat-In Kitchen, Formal Dining Room
Interior Features: Hardwood Floors, Wet Bar/Bar
Has Fireplace
Fireplace Features: Family Room Fireplace, Natural Fireplace
Bedroom Information
First Floor Bedroom
Bedroom 1 Level: Second
Bedroom 1 Dimensions: 21 x 33
Bedroom 2 Level: Second
Bedroom 2 Dimensions: 17 x 19
Bedroom 3 Level: Second
Bedroom 3 Dimensions: W=19
Bedroom 4 Level: Second
Bedroom 4 Dimensions: 16 x 23
Bedroom 5 Level: First
Bedroom 5 Dimensions: 14 x 12
Bathroom Information
Main Floor Full Bathroom
Second
# of Lavatories: 2
# of Bathrooms (Full): 5
# of Baths/Lavatories (Total): 7
Bathroom 1 Information
Lavatory 1 Width: 5
Lavatory 1 Length: 5
Lavatory 1 Level: First
Bathroom 1 Level: Second
Bathroom 1 Length: 18
Bathroom 1 Width: 17
Bathroom 2 Information
Lavatory 2 Width: 4
Lavatory 2 Length: 6
Lavatory 2 Level: First
Bathroom 2 Level: Second
Bathroom 2 Length: 9
Bathroom 2 Width: 6
Bathroom 3 Information
Bathroom 3 Level: Second
Bathroom 3 Length: 9
Bathroom 3 Width: 6
Bathroom 4 Information
Bathroom 4 Level: Second
Bathroom 4 Length: 6
Bathroom 4 Width: 9
Bathroom 5 Information
Bathroom 5 Level: First
Bathroom 5 Length: 8
Bathroom 5 Width: 6
Dining/Kitchen Information
Kitchen Level: First
Kitchen Dimension: 14 x 22
Dining Room Level: First
Dining Room Dimension: 16 x 19
Family/Great Room Information
Family Room Level: First
Family Room Dimensions: 17 x 23
Library/Den/Living Room Information
Sitting Room Level: First
Sitting Room Dimensions: 14 x 14
Living Room Level: First
Living Room Dimensions: 18 x 19
Library/Den Level: First
Library/Den Dimensions: 16 x 17
Laundry/Basement Information
Basement : Has Basement
Basement Type: Finished
Laundry Room Level: First
Laundry Room Dimensions: 8 x 8
Other Room Information
Other Room 1 Level: First
Other Room 1 Dimensions: 16 x 17
Other Room 2 Level: Second
Other Room 2 Dimensions: 22 x 14
Exterior
Exterior Features
Exterior Construction: Brick
Exterior Features: Exterior Balcony, Patio
Foundation Type: Basement
Property Features
On Waterfront
Water Features: Water View, Waterfront
Frontage Type: Water
Property Information
Property Type: Residential
Structure Style: 2 Story
Year Built: 1997
Below Grade Sq. Ft.: 3948
Below Grade Sq. Ft. (Finished): 1745
Lot Information
SITE/LOT FEATURES: Corner Lot, Cul-De-Sac, Dead End
VIEW: Lake View
Lot Size: 263,147
Land Information
Land Contract: No
Acreage: 0.83
Roads: Paved Street
Frontage: 263
Financial
Tax/Assessments Information
Taxable Value Year: 2024
Taxable Value: $834,782
Total Tax Year: 2024
Total Tax Amount: $42,195
Summer Tax Year: 2024
Summer Tax Amount: $22,000
Winter Tax Year: 2024
Winter Tax Amount: $20,195
Utilities
Utility Information
Heat/Fuel Type: Natural Gas
Water Heater: Gas
Water: Public Water
Cooling System: Central A/C
Heating System: Forced Air
Sewer Septic: Public Sanitary
Location
Unit 5 Information
Living Room Dimensions: L=8306
School Information
School District: Grosse Pointe Public Schools
School District: Grosse Pointe Public Schools
Address Information
Street Designation: Road
Location Details
Municipality: Grosse Pointe Farms
Mail City: Grosse Pointe Farms
Subdivision: Harbor Hill Sub
Municipality: Grosse Pointe Farms
Area (Municipality): Grosse Pointe Farms (82334)
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 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
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
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
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.44M – $2.95M
Reach more buyers when you sell with Redfin. Save up to $25,638 in fees.3 minutes to get started.