Stately colonial in GP Farms on highly sought after street. Steps from The Hill, two blocks from walking on LakeShore, close to the library and public and private schools. This is the home you have been looking for! Stunning new designer kitchen with eat-in space, spacious foyer with sweeping staircase, step down formal living room, cozy wormwood library/den, backhall/mudroom area with pewabic floor. Hardwood throughout, new roof (2020), 6 bedrooms (one currently being used as a closet), 5 full baths, brand new 2nd floor laundry room with closet system to dry flat-lays, basement has large rec room space with fireplace and original wet bar. Attached 2.5 car garage. Lots of storage, spacious yard with patio. Welcome home!
Single-familyProperty Type
1937Year Built
0.38 acresLot Size
$254Est. Price/Sq.Ft.
2 car garageParking
Listed by Alexis Deluca• Bolton-Johnston Assoc. of G.P.
Bought with Lewis G. Gazoul• Real Estate One Grosse Pointe
Stately colonial in GP Farms on highly sought after street. Steps from The Hill, two blocks from walking on LakeShore, close to the library and public and private schools. This is the home you have been looking for! Stunning new designer kitchen with eat-in space, spacious foyer with sweeping staircase, step down formal living room, cozy wormwood library/den, backhall/mudroom area with pewabic floor. Hardwood throughout, new roof (2020), 6 bedrooms (one currently being used as a closet), 5 full baths, brand new 2nd floor laundry room with closet system to dry flat-lays, basement has large rec room space with fireplace and original wet bar. Attached 2.5 car garage. Lots of storage, spacious yard with patio. Welcome home!
REALCOMP #58050009735
Jul 27, 2020
Sold
$730,000
$174/sq ft
Apr 20, 2020
Listed
$749,500
$179/sq ft
Greater Lansing AoR #31319233
Jul 1, 2017
Listing Removed
—
May 19, 2017
Price Changed
$639,900
$153/sq ft
May 8, 2017
Listed
$649,900
$155/sq ft
REALCOMP #58031319233
Jul 1, 2017
Listing Removed
—
May 8, 2017
Listed
$639,900
$153/sq ft
MiRealSource-MiMLS #821338
May 21, 2009
Sold
$450,000
$107/sq ft
May 2, 2009
Listing Removed
—
Feb 23, 2009
Listed
$499,000
$119/sq ft
MiRealSource-MiMLS #856399
Feb 23, 2009
Listing Removed
—
Dec 17, 2008
Listed
$544,900
$130/sq ft
MiRealSource-MiMLS #855656
Dec 10, 2008
Listing Removed
—
Sep 15, 2008
Listed
$599,000
$143/sq ft
REALCOMP #28155550
Dec 10, 2008
Listing Removed
—
Sep 15, 2008
Listed
$599,000
$143/sq ft
MiRealSource-MiMLS #856718
Sep 11, 2008
Listing Removed
—
Jun 24, 2008
Listed
$599,500
$143/sq ft
REALCOMP #28058093
Sep 11, 2008
Listing Removed
—
Apr 4, 2008
Listed
$599,500
$143/sq ft
MiRealSource-MiMLS #859016
Jun 24, 2008
Listing Removed
—
Jun 5, 2008
Listed
$634,900
$151/sq ft
MiRealSource-MiMLS #858394
Jun 5, 2008
Listing Removed
—
Apr 2, 2008
Listed
$649,000
$155/sq ft
MiRealSource-MiMLS #854168
Sep 29, 2006
Sold
$1
$0/sq ft
Sep 12, 2006
Listing Removed
—
Jul 31, 2006
Listed
$699,000
$167/sq ft
REALCOMP #26132956
Jul 31, 2006
Listed
$699,000
$167/sq ft
MiRealSource-MiMLS #856343
Jul 30, 2006
Listing Removed
—
Jan 30, 2006
Listed
$699,000
$167/sq ft
REALCOMP #26016372
Jul 30, 2006
Listing Removed
—
Jan 30, 2006
Listed
$699,000
$167/sq ft
MiRealSource-MiMLS #856293
Nov 17, 2005
Listing Removed
—
Aug 17, 2005
Listed
$789,000
$188/sq ft
REALCOMP #25136080
Nov 17, 2005
Listing Removed
—
Aug 17, 2005
Listed
$789,000
$188/sq ft
REALCOMP #25061955
Aug 5, 2005
Listing Removed
—
May 9, 2005
Listed
$829,000
$198/sq ft
MiRealSource-MiMLS #855647
Aug 5, 2005
Listing Removed
—
Dec 5, 2004
Listed
$829,000
$198/sq ft
REALCOMP #25040162
Apr 30, 2005
Listing Removed
—
Mar 31, 2005
Listed
$879,900
$210/sq ft
Public Records
Mar 12, 2001
Sold
$493,000
$117/sq ft
Public Records
Apr 15, 1999
Sold
$36,272
$9/sq ft
MiRealSource-MiMLS #832739
Jul 15, 1996
Sold
$380,000
$91/sq ft
Jan 30, 1995
Listed
$399,999
$95/sq ft
Jan 30, 1995
Listing Removed
—
Year
Property tax
Land + Additions
Assessment*
2025
$19,395 (+8.7%)
2024
$17,849 (+109.4%)
2022
$8,526 (−46.0%)
2021
$15,793 (+38.8%)
2020
$11,379 (+6.5%)
2019
$10,680 (+4.2%)
2018
$10,253 (+4.9%)
2017
$9,778 (+0.3%)
2016
$9,745 (+3.1%)
2015
$9,452 (+2.6%)
2014
$9,212
Tax history for 171 Lewiston Rd
Year
Property tax
Land + Additions
Assessment*
2025
$19,395 (+8.7%)
2024
$17,849 (+109.4%)
2022
$8,526 (−46.0%)
2021
$15,793 (+38.8%)
2020
$11,379 (+6.5%)
2019
$10,680 (+4.2%)
2018
$10,253 (+4.9%)
2017
$9,778 (+0.3%)
2016
$9,745 (+3.1%)
2015
$9,452 (+2.6%)
2014
$9,212
*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.5
Stories
2
Lot width
100 ft.
Lot depth
167 ft.
Lot size
0.38 Acres
Year renovated
—
Sq. Ft.
3,480
Year built
1937
Style
Single Family Residential
County
Wayne County
APN
38 011 07 0008 002
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 23, 2026.
Jul 6, 2022 • Final
Electrical
Electrical
Jan 16, 2020 • Final
Electrical
Work on an electrical permit.
Electrical
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: 2
Parking Features: Attached, Paved
Interior
Virtual Tour
Bathroom Information
# of Full Bathrooms: 5
# of Half Bathrooms: 1
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air, Natural Gas
Interior Features
Window Features: Bay Window(s)
Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Washer, Range, Oven, Gas Water Heater
Flooring: Hardwood
Room Information
# of Rooms Total: 14
Has Basement
Basement Details: Partially Finished
Exterior
Exterior Features
Patio And Porch Features: Patio
Fencing: Fenced
Building Information
Above Grade Finished Area: 3,480
Below Grade Finished Area: 716
# of Stories Total: 2
Construction Materials: Brick
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family
Lot Information
Frontage Length: 100
Road Responsibility: Public Maintained Road
Road Frontage Type: City Street
Lot Size : 100x167
Lot Size Acres: 0.38
Zoning Description: Residential
Financial
Tax Information
Tax Annual Amount: $10,697.96
Utilities
Utility Information
Water Source: Public
Utilities: Cable Available
Sewer: Public Sewer
Location
Schools Information
School District: Grosse Pointe Public Schools
Location Information
Subdivision Name: Lewis Estates Sub
Cross Street: Kercheval
Community Information
Community Features: Street Lights
Public facts
Beds: —
Baths: 6.5
Sq. Ft.: 3,480
Stories: 2.0
Lot Size: 0.38 acres
Style: Single Family Residential
Year Built: 1937
Year Renovated: —
County: Wayne County
APN: 38 011 07 0008 002
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.2mi
8/10
Brownell Middle School
Public 5-8 • Assigned • 0.8mi
8/10
Grosse Pointe South High School
Public 9-12 • Assigned • 0.5mi
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, 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
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
$1.01M – $1.23M
Reach more buyers when you sell with Redfin. Save up to $10,653 in fees.3 minutes to get started.