Stately Farms Colonial located on quiet cul de sac and done to the nines! Move in ready and gorgeous! Open concept kitchen with white cabinets, granite counters, walk in pantry and counter seating. Eating space off of kitchen with high end appliances. Family room with vaulted ceiling and tons of natural sunlight and vent less fireplace. Formal dining room with built-ins, and formal living room with natural fireplace. 5 bedrooms and 3 full baths as well as a reading nook off hallway. Place for second floor laundry if desired. Master bedroom with full bath. 2 updated full baths. Lovely patio perfect for entertaining. Refinished hardwood floors, newer carpet and freshly painted. Finished basement with rec room and new carpet. Attached two car garage, new stamped concrete driveway. Nestled in the Farms with great walkability to schools and The Hill. Schools are Kerby, Brownell and GP South.
Single-familyProperty Type
1937Year Built
0.27 acresLot Size
$207Est. Price/Sq.Ft.
2 car garageParking
Listed by Shana Sine Cameron• Sine & Monaghan LLC
Bought with Connie Dunlap• Bolton-Johnston Assoc. of G.P.
Stately Farms Colonial located on quiet cul de sac and done to the nines! Move in ready and gorgeous! Open concept kitchen with white cabinets, granite counters, walk in pantry and counter seating. Eating space off of kitchen with high end appliances. Family room with vaulted ceiling and tons of natural sunlight and vent less fireplace. Formal dining room with built-ins, and formal living room with natural fireplace. 5 bedrooms and 3 full baths as well as a reading nook off hallway. Place for second floor laundry if desired. Master bedroom with full bath. 2 updated full baths. Lovely patio perfect for entertaining. Refinished hardwood floors, newer carpet and freshly painted. Finished basement with rec room and new carpet. Attached two car garage, new stamped concrete driveway. Nestled in the Farms with great walkability to schools and The Hill. Schools are Kerby, Brownell and GP South.
REALCOMP #2200071250
Oct 21, 2020
Sold
$575,000
$146/sq ft
Oct 12, 2020
Pending
—
Sep 20, 2020
Contingent
—
Aug 31, 2020
Listed
$625,000
$158/sq ft
Stately Farms Colonial located on quiet cul de sac and done to the nines! Move in ready and gorgeous! Open concept kitchen with white cabinets, granite counters, walk in pantry and counter seating. Eating space off of kitchen with high end appliances. Family room with vaulted ceiling and tons of natural sunlight and vent less fireplace. Formal dining room with built-ins, and formal living room with natural fireplace. 5 bedrooms and 3 full baths as well as a reading nook off hallway. Place for second floor laundry if desired. Master bedroom with full bath. 2 updated full baths. Lovely patio perfect for entertaining. Refinished hardwood floors, newer carpet and freshly painted. Finished basement with rec room and new carpet. Attached two car garage, new stamped concrete driveway. Nestled in the Farms with great walkability to schools and The Hill. Schools are Kerby, Brownell and GP South.
MiRealSource-MiMLS #809146
Feb 27, 1997
Sold
$365,000
$92/sq ft
Jan 31, 1997
Listing Removed
—
Dec 16, 1996
Listed
$389,900
$99/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$8,231 (−46.8%)
2024
$15,468 (+109.4%)
2022
$7,388 (−45.5%)
2021
$13,557 (+14.6%)
2020
$11,830 (+6.5%)
2019
$11,103 (+4.2%)
2018
$10,659 (+2.8%)
2017
$10,369 (+0.3%)
2016
$10,334 (+3.1%)
2015
$10,023 (+2.6%)
2014
$9,769
Tax history for 342 Touraine Rd
Year
Property tax
Land + Additions
Assessment*
2025
$8,231 (−46.8%)
2024
$15,468 (+109.4%)
2022
$7,388 (−45.5%)
2021
$13,557 (+14.6%)
2020
$11,830 (+6.5%)
2019
$11,103 (+4.2%)
2018
$10,659 (+2.8%)
2017
$10,369 (+0.3%)
2016
$10,334 (+3.1%)
2015
$10,023 (+2.6%)
2014
$9,769
*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
3.5
Stories
—
Lot width
84 ft.
Lot depth
138 ft.
Lot size
0.27 Acres
Year renovated
—
Sq. Ft.
3,001
Year built
1937
Style
Single Family Residential
County
Wayne County
APN
38 006 05 0671 000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 23, 2026.
Dec 14, 2023 • Final
Plumbing
Plumbing
Nov 29, 2023 • Final
Building
Remodel
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: 3
# of Half Bathrooms: 2
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air, Natural Gas
Interior Features
Appliances: Gas Water Heater
Has Fireplace
Fireplace Features: Family Room, Living Room
Room Information
# of Rooms Total: 15
Has Basement
Basement Details: Finished
Exterior
Exterior Features
Patio And Porch Features: Patio, Porch
Building Information
Above Grade Finished Area: 3,001
Below Grade Finished Area: 950
# of Stories Total: 2
Construction Materials: Aluminum Siding
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family
Lot Information
Frontage Length: 84
Lot Size : 84.00X138.00
Lot Size Acres: 0.27
Financial
Tax Information
Tax Annual Amount: $11,102
Utilities
Utility Information
Utilities: Sewer Available
Sewer: Public Sewer
Location
Schools Information
School District: Grosse Pointe Public Schools
Location Information
Directions: South of Kerby / West of Kercheval
Subdivision Name: JOY REALTY CO HAMILTON PARK SUB NO 2
Cross Street: Kerby
Public facts
Beds: —
Baths: 3.5
Sq. Ft.: 3,001
Stories: —
Lot Size: 0.27 acres
Style: Single Family Residential
Year Built: 1937
Year Renovated: —
County: Wayne County
APN: 38 006 05 0671 000
Home facts updated by county records on Oct 23, 2026
Other
Listing Information
List AOR: RealComp
Around this home
Schools
K - 12
Preschool & daycare
Brownell Middle School
Public 5-8 • Assigned • 0.1mi
8/10
Grosse Pointe South High School
Public 9-12 • Assigned • 1.3mi
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
64
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
$776,000 – $940,000
Reach more buyers when you sell with Redfin. Save up to $8,165 in fees.3 minutes to get started.