Welcome to 242 Lewiston Road, A rare Wallace Frost architectural masterpiece. This French Normandy estate sits on a double lot in Grosse Pointe Farms. Built in 1926 and thoughtfully updated since, this residence blends timeless architectural detail with modern living. Frost’s signature craftsmanship shines through in the soaring two-story beamed living room with wet bar, fireplace and French doors to a terrace, and access to an additional entertaining room. Exceptional floor plan offers comfortable living and entertaining spaces throughout the 3 floors. Main floor has an original wood paneled library with fireplace, and classic Pewabic tile accents throughout the home & offers modern tiles in the updated powder room. Recent enhancements include a heated breezeway connecting to a new attached garage, a custom French kitchen with soaring ceilings & banquet dining nook, a new patio for casual entertaining. Additional updates feature a brand new designer powder room, new custom-matched windows in keeping with Frost’s original aesthetic, and modern systems such as dual-zone A/C, SpacePak central air, and a full Grosse Pointe alarm system with fire and CO detection. Upstairs, enjoy a renovated second-floor laundry with servant passage access to all floors, a gas-converted fireplace in the primary suite, and spacious bedrooms with character and charm. Thoughtful conveniences include a mudroom, custom dog run, and abundance of storage over the garage, which could all be converted into an additional in-law or guest suite. Outdoors, extensive landscaping creates eight distinct garden and patio areas across the estate-sized double lot, enhanced by a smart sprinkler system for ease of care. This is a rare chance to own a true Wallace Frost masterpiece preserved, enhanced, and ready to welcome its next steward.
Single-familyProperty Type
1926Year Built
0.73 acresLot Size
$358Price/Sq.Ft.
3 car garageParking
Listed by Thomas Youngblood• Real Estate One Grosse Pointe
Bought with Robert Hellow• Ascendent Realty Associates, LLC
Est. $4,755 per month, based on comparable rentals
Sale and tax history for 242 Lewiston Rd
Sale History
Tax History
Date
Event
Price
Public Records
Jun 2, 2026
Sold
$1,825,000
$358/sq ft
REALCOMP #58050202667
May 27, 2026
Price Changed
$1,825,000
$358/sq ft
May 27, 2026
Sold
$1,825,000
$358/sq ft
May 6, 2026
Pending
—
Apr 15, 2026
Contingent
—
Apr 3, 2026
Listed
$1,850,000
$363/sq ft
Welcome to 242 Lewiston Road, A rare Wallace Frost architectural masterpiece. This French Normandy estate sits on a double lot in Grosse Pointe Farms. Built in 1926 and thoughtfully updated since, this residence blends timeless architectural detail with modern living. Frost's signature craftsmanship shines through in the soaring two-story beamed living room with wet bar, fireplace and French doors to a terrace, and access to an additional entertaining room. Exceptional floor plan offers comfortable living and entertaining spaces throughout the 3 floors. Main floor has an original wood paneled library with fireplace, and classic Pewabic tile accents throughout the home & offers modern tiles in the updated powder room. Recent enhancements include a heated breezeway connecting to a new attached garage, a custom French kitchen with soaring ceilings & banquet dining nook, a new patio for casual entertaining. Additional updates feature a brand new designer powder room, new custom-matched windows in keeping with Frost's original aesthetic, and modern systems such as dual-zone A/C, SpacePak central air, and a full Grosse Pointe alarm system with fire and CO detection. Upstairs, enjoy a renovated second-floor laundry with servant passage access to all floors, a gas-converted fireplace in the primary suite, and spacious bedrooms with character and charm. Thoughtful conveniences include a mudroom, custom dog run, and abundance of storage over the garage, which could all be converted into an additional in-law or guest suite. Outdoors, extensive landscaping creates eight distinct garden and patio areas across the estate-sized double lot, enhanced by a smart sprinkler system for ease of care. This is a rare chance to own a true Wallace Frost masterpiece preserved, enhanced, and ready to welcome its next steward.
MiRealSource-MiMLS #50202667
May 27, 2026
Price Changed
$1,825,000
$358/sq ft
May 27, 2026
Sold
$1,825,000
$358/sq ft
May 6, 2026
Pending
—
Apr 15, 2026
Contingent
—
Apr 3, 2026
Listed
$1,850,000
$363/sq ft
Mar 27, 2026
Coming Soon
$1,850,000
$363/sq ft
Mar 30, 2025
Listed
$1,825,000
$358/sq ft
Welcome to 242 Lewiston Road, A rare Wallace Frost architectural masterpiece. This French Normandy estate sits on a double lot in Grosse Pointe Farms. Built in 1926 and thoughtfully updated since, this residence blends timeless architectural detail with modern living. Frost’s signature craftsmanship shines through in the soaring two-story beamed living room with wet bar, fireplace and French doors to a terrace, and access to an additional entertaining room. Exceptional floor plan offers comfortable living and entertaining spaces throughout the 3 floors. Main floor has an original wood paneled library with fireplace, and classic Pewabic tile accents throughout the home & offers modern tiles in the updated powder room. Recent enhancements include a heated breezeway connecting to a new attached garage, a custom French kitchen with soaring ceilings & banquet dining nook, a new patio for casual entertaining. Additional updates feature a brand new designer powder room, new custom-matched windows in keeping with Frost’s original aesthetic, and modern systems such as dual-zone A/C, SpacePak central air, and a full Grosse Pointe alarm system with fire and CO detection. Upstairs, enjoy a renovated second-floor laundry with servant passage access to all floors, a gas-converted fireplace in the primary suite, and spacious bedrooms with character and charm. Thoughtful conveniences include a mudroom, custom dog run, and abundance of storage over the garage, which could all be converted into an additional in-law or guest suite. Outdoors, extensive landscaping creates eight distinct garden and patio areas across the estate-sized double lot, enhanced by a smart sprinkler system for ease of care. This is a rare chance to own a true Wallace Frost masterpiece preserved, enhanced, and ready to welcome its next steward.
Greater Lansing AoR #21145118
May 10, 2016
Sold
$800,000
$157/sq ft
May 9, 2016
Listed
$850,000
$167/sq ft
REALCOMP #216044585
May 10, 2016
Listing Removed
—
May 10, 2016
Sold
$800,000
$157/sq ft
May 9, 2016
Listed
$850,000
$167/sq ft
Public Records
Apr 22, 2016
Sold
$800,000
$157/sq ft
Public Records
Feb 14, 2012
Sold
$600,000
$118/sq ft
MiRealSource-MiMLS #836099
Aug 5, 2008
Listing Removed
—
Nov 6, 2006
Listed
$395,000
$77/sq ft
REALCOMP #26189903
Aug 5, 2008
Listing Removed
—
Oct 27, 2006
Listed
$395,000
$77/sq ft
MiRealSource-MiMLS #856494
Nov 6, 2006
Listing Removed
—
Jun 22, 2005
Listed
$825,000
$162/sq ft
REALCOMP #25087272
Oct 27, 2006
Listing Removed
—
Jun 22, 2005
Listed
$825,000
$162/sq ft
MiRealSource-MiMLS #854963
Sep 25, 2000
Sold
$1
$0/sq ft
Sep 4, 2000
Listing Removed
—
Jul 13, 2000
Listed
$974,000
$191/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$31,634 (+16.4%)
2024
$27,182 (+109.4%)
2022
$12,983 (−45.5%)
2021
$23,825 (−4.6%)
2020
$24,961 (+6.5%)
2019
$23,427 (+4.2%)
2018
$22,490 (+2.8%)
2017
$21,878 (+41.1%)
2016
$15,504 (+3.1%)
2015
$15,038 (+2.6%)
2014
$14,656
Public record
Public record
Permits
Beds
—
Baths
5.5
Stories
—
Lot width
191 ft.
Lot depth
166 ft.
Lot size
0.73 Acres
Year renovated
—
Sq. Ft.
4,549
Year built
1926
Style
Single Family Residential
County
Wayne County
APN
38 010 04 0021 000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 23, 2026.
Dec 11, 2023 • Final
Building
Work on a building.
Remodel
Jun 22, 2023 • Final
Plumbing
Plumbing
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
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
Has Fireplace
# of Fireplaces: 4
Fireplace Features: Gas, Wood Burning
Room Information
Laundry Features: Upper Level
Has Basement
Exterior
Building Information
Above Grade Finished Area: 5,100
Construction Materials: Brick, Stone
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family
Lot Information
Frontage Length: 191
Lot Size : 191x166
Lot Size Acres: 0.73
Financial
Tax Information
Tax Annual Amount: $27,182
Utilities
Utility Information
Water Source: Public
Utilities: Sewer Available
Sewer: Public Sewer
Location
Schools Information
School District: Grosse Pointe Public Schools
Elementary School: Richard Elementary School
Middle Or Junior School: Brownell middle School
High School: Grosse Pointe South High Schoo
Location Information
Directions: South of Kerby / West of Kercheval
Subdivision Name: Lewiston Road Sub
Cross Street: Kerby
Public facts
Beds: —
Baths: 5.5
Sq. Ft.: 4,549
Stories: —
Lot Size: 0.73 acres
Style: Single Family Residential
Year Built: 1926
Year Renovated: —
County: Wayne County
APN: 38 010 04 0021 000
Home facts updated by county records on Oct 23, 2026
Other
Listing Information
List AOR: MiRealSource
Around this home
Schools
Richard Elementary School
Public K-4 • Assigned • 0.3mi
8/10
Brownell Middle School
Public 5-8 • Assigned • 0.6mi
8/10
Grosse Pointe South High School
Public 9-12 • Assigned • 0.7mi
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, 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
64
49
50
39
37
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
89/ 100
Very good sunlight
Sunscore
This home receives average direct sun exposure in Grosse Pointe Farms. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.4 hrs
5.3 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.69M – $2.04M
Reach more buyers when you sell with Redfin. Plus, you'll save $17,749 in fees.