RateMyAgentGo to search
Back 242 Lewiston Rd
Off Market

242 Lewiston Rd

Grosse Pointe Farms MI 48236

6
7
3
6600 sq. ft.
0.73 ac.
Single-Family
Last sold for $1,825,000
Thomas YoungbloodThomas Youngblood, last sold this property on 27 May 2026 after 54 days on market.

Overview

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.

Features

6 bedrooms
7 bathrooms
3 carspaces
3 garage spaces
6600 sq. ft. floor area
0.73 ac. lot size
Single-Family

Estimated Value

Based on this property and similar 6 bedroom single-family properties sold in Grosse Pointe Farms over the last 12 months, the estimated median property value of 242 Lewiston Rd is $1.78m.

Median value
$1.78m
Estimated value range
$990k - $3.48m
Median days on market
32
Estimated value trend
24%
increase over the last 12 months
Average days on market is based on recent, comparable sales in Grosse Pointe Farms. It is only an indication of the time a property is actively listed and should not be relied upon as an accurate representation of how soon a property will be sold.

Property history for 242 Lewiston Rd

2026
Sold
$1,825,000
27 May 2026 by Thomas Youngblood, of Real Estate in the Pointes
2016
Sold
$800,000
10 May 2016 by Michael Webb, of Sine & Monaghan LLC
2000
Sold
$1
25 Sep 2000 by Mary Lynn Baker Hunter, of Johnstone & Johnstone

Happy sellers in Grosse Pointe Farms

90%
90% of sellers in Grosse Pointe Farms reported that their sale price either exceeded or met their price expectations.

Grosse Pointe Farms stands out for consistently delivering exceptional satisfaction and strong market results for homeowners.

This is based on voluntary sentiment collected from 6 reviews in Grosse Pointe Farms over the last 12 months.

Local market activity for 6 bedroom single-family properties in Grosse Pointe Farms

In the last 12 months, 8 six-bedroom single-family properties similar to 242 Lewiston Rd, have been sold.

This represents a 10% increase in six-bedroom single-family properties sales when compared to the previous 12 months.

Nearby agents

Compare and contact these top performing agents who’ve delivered exception customer service for their clients in Grosse Pointe Farms

placeholder
Sebastian Lucido

Sebastian Lucido is a recommended agent for Grosse Pointe Farms.  They have 7 local sales and collected 2 local reviews across the last 12 months.

  •   5   (5 reviews)
  •  2 Reviews in Grosse Pointe Farms
  •  7 Sales in Grosse Pointe Farms
View profile
placeholder
Ryan Lally

Sellers who recommend Ryan Lally have praised them for being local expert, clear communication, responsive, dedicated, supportive, hard-working, and detail-oriented

  •   5   (80 reviews)
  •  1 Review in Grosse Pointe Farms
  •  4 Sales in Grosse Pointe Farms
View profile
placeholder
Mark Monaghan

Mark Monaghan is a recommended agent for Grosse Pointe Farms.  They have 2 local sales and collected 1 local review across the last 12 months.

  •   4.8   (4 reviews)
  •  1 Review in Grosse Pointe Farms
  •  2 Sales in Grosse Pointe Farms
View profile
placeholder
Erik Hill

Erik Hill is a recommended agent for Grosse Pointe Farms.  They have 2 local sales and collected 1 local review across the last 12 months.

  •   4.9   (15 reviews)
  •  1 Review in Grosse Pointe Farms
  •  2 Sales in Grosse Pointe Farms
View profile
or
Skip the list and find your ideal agent to sell your propertyFind My Agent
RateMyAgent
Sales:
(619) 566-0008
Quick Links
© 2026 RateMyAgent
Privacy PolicyTerms & ConditionsLicensingSitemap