Google street view image for 247 Lake Shore Rd, Grosse Pointe Farms, MI 48236

Off market oct 2017 for $1.3M

$2,287,516

•

7,562

sq ft

247 Lake Shore Rd, Grosse Pointe Farms, MI 48236

About this home

LAKE FRONT LIVING AT ITS FINEST with amazing views of Lake St. Clair in Grosse Pointe Farms. Exquisite detail throughout, updated and designed for luxury living. Stunning marble foyer with grand sweeping staircase leads to the picturesque living room with breathtaking views of the lake and private, beautifully landscaped bluestone patio. Distinctive kitchen has a unique back lit onyx back splash, limited edition Viking appliances, double dishwashers, and gas fireplace. The luxurious spa inspired master suite has gas fireplace, jetted tub, coffee bar, dishwasher, refrigerator, and spacious dressing room. Custom finished basement with large wine cellar, full bath and workout area. Additional features include first and second floor master suites, 3 car heated garage, large sun room (not included in sq ft) service staircase, 6 fireplaces, two laundry spaces, and 50 AMP generator.

Single-familyProperty Type

1968Year Built

0.52 acresLot Size

$303Est. Price/Sq.Ft.

3 car garageParking

Listed by Julie Kaiser • Higbie Maxon Agney Inc

Bought with Matthew Jankowski • Lucido and Associates, Inc

Redfin checked: a minute ago

•Source:Greater Lansing AoR #31324117

Listing provided courtesy of Greater Lansing AoR

Redfin Estimate

$2,287,516

$908K since sold in October 2017$31K since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 59.8% higher than the average sale price ($1.43M) of 6 comparable homes.

SOLD NOV 2, 2026
$1,575,000
A
4 beds4.5 baths4,333 sq ft
89 Vendome Rd, Grosse Pointe Farms, MI 48236
SOLD NOV 3, 2026
$1,250,000
B
3 beds2.5 baths5,698 sq ft
121 Vendome Rd, Grosse Pointe Farms, MI 48236
SOLD JUL 17, 2026
$1,855,000
C
4 beds4 baths5,757 sq ft
207 Lake Shore Dr, Grosse Pointe Farms, MI 48236
SOLD AUG 27, 2026
$1,400,000
D
4 beds4 baths4,890 sq ft
77 Merriweather Rd, Grosse Pointe Farms, MI 48236
SOLD OCT 27, 2026
$1,235,000
E
3 beds3.5 baths4,152 sq ft
159 Cloverly Rd, Grosse Pointe Farms, MI 48236
SOLD OCT 13, 2026
$1,275,000
F
5 beds3.5 baths4,319 sq ft
211 Lewiston St, Grosse Pointe Farms, MI 48236-3221

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$1,260,128

Est. take-home

List your home with Redfin and save $22,875

Rent

$4,523/mo

Redfin rental estimate

List your home for rent

Market trends in 48236, MI

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

99.4%

+0.2% MoM

Median sale price

$460K

$6K MoM

Avg. days on market

16d

0 days MoM

Recently sold homes

130

23 MoM

New listings for sale

NEW 3 HRS AGO
$465,000
4 beds2.5 baths2,684 sq ft
946 Crescent Ln, Grosse Pointe Woods, MI 48236
3D WALKTHROUGH
$650,000
4 beds2.5 baths2,785 sq ft
116 Kerby Rd, Grosse Pointe Farms, MI 48236
$325,000
4 beds1.5 baths2,434 sq ft
1301 Brys Dr, Grosse Pointe Woods, MI 48236
$239,000
3 beds2.5 baths2,765 sq ft
19196 Berden St, Detroit, MI 48236
3D WALKTHROUGH
$1,395,000
3 beds4 baths7,492 sq ft
489 Ballantyne Rd, Grosse Pointe Shores, MI 48236
3D WALKTHROUGH
$419,000
3 beds1.5 baths1,848 sq ft
470 Mckinley Ave, Grosse Pointe Farms, MI 48236
3D WALKTHROUGH
$299,000
2 beds2 baths1,989 sq ft
2189 Hollywood Ave, Grosse Pointe Woods, MI 48236
COMING SOON
$335,000
3 beds2.5 baths2,551 sq ft
1630 Fairholme Rd, Grosse Pointe Woods, MI 48236 2367
(313) 886-7239
3D WALKTHROUGH
$370,000
3 beds1.5 baths2,775 sq ft
433 Maison Rd, Grosse Pointe Farms, MI 48236
3D WALKTHROUGH
$370,000
3 beds1.5 baths1,831 sq ft
470 Allard Rd, Grosse Pointe Farms, MI 48236
See all

Provided by Redfin

Sale history for 247 Lake Shore Rd

Date

Event

Price

Greater Lansing AoR #31324117

Oct 25, 2017

Sold

$1,380,000

$182/sq ft

Oct 4, 2017

Pending

—

Sep 6, 2017

Price Changed

$1,590,000

$210/sq ft

Aug 1, 2017

Price Changed

$1,690,000

$223/sq ft

Jun 30, 2017

Listed

$1,790,000

$237/sq ft

Jun 30, 2017

Listed

$1,590,000

$210/sq ft

REALCOMP #58031324117

Oct 25, 2017

Sold

$1,380,000

$182/sq ft

Jun 30, 2017

Listed

$1,590,000

$210/sq ft

REALCOMP #217027552

Jun 29, 2017

Listing Removed

—

May 21, 2017

Price Changed

$1,950,000

$258/sq ft

Apr 11, 2017

Price Changed

$2,200,000

$291/sq ft

Apr 10, 2017

Listed

$2,000,000

$264/sq ft

MiRealSource-MiMLS #31316766

Jun 27, 2017

Listing Removed

—

Jun 19, 2017

Listing Removed

—

May 21, 2017

Price Changed

$1,950,000

$258/sq ft

Apr 10, 2017

Listed

$2,200,000

$291/sq ft

REALCOMP #58031316766

Jun 19, 2017

Listing Removed

—

Apr 10, 2017

Listed

$1,950,000

$258/sq ft

Tax history for 247 Lake Shore Rd

*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

Stories

Lot width

120 ft.

Lot depth

191 ft.

Lot size

0.52 Acres

Year renovated

—

Sq. Ft.

5,310

Year built

1968

Style

Single Family Residential

County

Wayne County

APN

38 008 04 0001 000

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 23, 2026.

Property details

Parking

Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 3
Parking Features: Attached, Paved, Garage Door Opener, Heated Garage, Garage Faces Side

Interior

Bathroom Information
# of Full Bathrooms: 3
# of Half Bathrooms: 1

Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air, Zoned, Natural Gas

Interior Features
Interior Features: Walk-In Closet(s), Bar
Appliances: Dishwasher, Disposal, Dryer, Freezer, Microwave, Refrigerator, Washer, Range, Oven, Gas Water Heater, Humidifier
Flooring: Hardwood
Has Fireplace
Fireplace Features: Gas, Living Room, Master Bedroom

Room Information
Laundry Features: Upper Level
Has Basement
Basement Details: Crawl Space, Finished, Block

Exterior

Exterior Features
Patio And Porch Features: Patio, Terrace

Pool Information
Has Private Pool

Building Information
Above Grade Finished Area: 5,310
Below Grade Finished Area: 2,252
# of Stories Total: 2
Construction Materials: Brick

Property Features
On Waterfront
Waterfront Features: Lake Front, Lake
Has View
Security Features: Security System
Accessibility Features: Therapeutic Whirlpool

Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family

Lot Information
Frontage Length: 120
Lot Size : 120x191
Lot Size Acres: 0.52
Zoning Description: Residential

Financial

Tax Information
Tax Annual Amount: $26,776

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: Blair Subdivision
Cross Street: N Moran

Public facts

Beds: —
Baths: 4.0
Sq. Ft.: 5,310
Stories: 2.0
Lot Size: 0.52 acres
Style: Single Family Residential
Year Built: 1968
Year Renovated: —
County: Wayne County
APN: 38 008 04 0001 000

Home facts updated by county records on Oct 23, 2026

Other

Listing Information
List AOR: MiRealSource

Around this home

Schools

K - 12
Preschool & daycare

Kerby Elementary School

Public K-4 • Assigned • 0.9mi

9/10

Brownell Middle School

Public 5-8 • Assigned • 1.1mi

8/10

Grosse Pointe South High School

Public 9-12 • Assigned • 1.0mi

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 97° 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)

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.17M – $2.63M

Reach more buyers when you sell with Redfin. Save up to $22,875 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

3D WALKTHROUGH

$1,995,000

5 beds5.5 baths6,346 sq ft

89 Lake Shore Rd, Grosse Pointe Farms, MI 48236

Chef's kitchen • Private library • Second primary suite

OPEN TODAY, 3PM TO 4:30PM

$455,000

3 beds2 baths2,091 sq ft

316 Chalfonte Ave, Grosse Pointe Farms, MI 48236

Attached garage • Double driveway • Soaking tub

$389,900

4 beds3 baths2,050 sq ft

476 Touraine Rd, Grosse Pointe Farms, MI 48236

First floor bedroom • Natural fireplace • Updated kitchen

3D WALKTHROUGH

$1,100,000

4 beds2.5 baths4,192 sq ft

20 Lakecrest Ln, Grosse Pointe Farms, MI 48236

Dedicated library • First-floor laundry • Large eat-in kitchen

3D WALKTHROUGH

$2,650,000

8 beds7 baths11,419 sq ft

105 Lake Shore Rd, Grosse Pointe Farms, MI 48236

One acre • 157 feet of frontage • Georgian colonial

3D WALKTHROUGH

$450,000

3 beds2 baths2,466 sq ft

818 Cadieux Rd, Grosse Pointe, MI 48230

Gourmet kitchen • Custom cabinetry • Granite countertops

New listings for sale in 48236

NEW 3 HRS AGO

$465,000

4 beds2.5 baths2,684 sq ft

946 Crescent Ln, Grosse Pointe Woods, MI 48236

Fenced in backyard • 6,300 sq ft lot • 2 garage spots

3D WALKTHROUGH

$650,000

4 beds2.5 baths2,785 sq ft

116 Kerby Rd, Grosse Pointe Farms, MI 48236

James kerby house • Updated interior • Hardwood floors

$325,000

4 beds1.5 baths2,434 sq ft

1301 Brys Dr, Grosse Pointe Woods, MI 48236

4,792 sq ft lot • 2 garage spots • Built 1948

$239,000

3 beds2.5 baths2,765 sq ft

19196 Berden St, Detroit, MI 48236

New roof • New furnace • New central a/c

3D WALKTHROUGH

$1,395,000

3 beds4 baths7,492 sq ft

489 Ballantyne Rd, Grosse Pointe Shores, MI 48236

Finished lower level • Grand foyer • Formal dining room

3D WALKTHROUGH

$419,000

3 beds1.5 baths1,848 sq ft

470 Mckinley Ave, Grosse Pointe Farms, MI 48236

Tudor charm • Finished basement • Wonderful backyard

3D WALKTHROUGH

$299,000

2 beds2 baths1,989 sq ft

2189 Hollywood Ave, Grosse Pointe Woods, MI 48236

Updated home • Open floor plan • Full bath

COMING SOON3D WALKTHROUGH

$335,000

3 beds2.5 baths2,551 sq ft

1630 Fairholme Rd, Grosse Pointe Woods, MI 48236 2367

Brick bungalow • Lakefront park • Jeld-wen windows

(313) 886-7239

3D WALKTHROUGH

$370,000

3 beds1.5 baths2,775 sq ft

433 Maison Rd, Grosse Pointe Farms, MI 48236

Updated kitchen • Hardwood floors • Natural fireplace

Home values near 247 Lake Shore Rd

Data from public records.

Address	Redfin Estimate
261 Lake Shore Road, Grosse Pointe Farms, MI 4 Beds \| 4.5 Baths \| 4854 Sq. Ft.	$1,411,372
241 Lake Shore Road, Grosse Pointe Farms, MI - Beds \| 10.5 Baths \| 20223 Sq. Ft.	$2,986,732
249 Lake Shore Road, Grosse Pointe Farms, MI 3 Beds \| 4 Baths \| 4180 Sq. Ft.	$1,599,538
28 Winthrop Place, Grosse Pointe Farms, MI 4 Beds \| 3.5 Baths \| 4300 Sq. Ft.	$1,046,679
32 Winthrop Place, Grosse Pointe Farms, MI 6 Beds \| 4.5 Baths \| 5810 Sq. Ft.	$1,366,272
32 Harbor Hill Road, Grosse Pointe Farms, MI 4 Beds \| 4 Baths \| 3700 Sq. Ft.	$1,142,520
26 Winthrop Place, Grosse Pointe Farms, MI 4 Beds \| 4 Baths \| 4919 Sq. Ft.	$1,161,588

Address	Redfin Estimate
231 Lake Shore Road, Grosse Pointe Farms, MI 4 Beds \| 4 Baths \| 5845 Sq. Ft.	$2,616,558
227 Lake Shore Road, Grosse Pointe Farms, MI 4 Beds \| 4.5 Baths \| 3528 Sq. Ft.	$1,574,459
29 Winthrop Place, Grosse Pointe Farms, MI 5 Beds \| 4 Baths \| 4534 Sq. Ft.	$1,738,365
45 Christine Drive, Grosse Pointe Farms, MI 5 Beds \| 4 Baths \| 5568 Sq. Ft.	$1,839,731
30 Harbor Hill Road, Grosse Pointe Farms, MI 4 Beds \| 4 Baths \| 4446 Sq. Ft.	$1,097,312
26 Harbor Hill Road, Grosse Pointe Farms, MI 5 Beds \| 4 Baths \| 5814 Sq. Ft.	$1,510,134
7 Carmel Lane, Grosse Pointe Farms, MI - Beds \| 5 Baths \| 3356 Sq. Ft.	$1,165,197

Address	Redfin Estimate
255 Lake Shore Road, Grosse Pointe Farms, MI 5 Beds \| 6.5 Baths \| 6800 Sq. Ft.	$3,694,170
237 Lake Shore Road, Grosse Pointe Farms, MI 6 Beds \| 9.5 Baths \| 1317 Sq. Ft.	$3,428,911
38 Harbor Hill Road, Grosse Pointe Farms, MI 4 Beds \| 3.5 Baths \| 3100 Sq. Ft.	$1,015,305
35 Winthrop Place, Grosse Pointe Farms, MI 6 Beds \| 6 Baths \| 6000 Sq. Ft.	$2,049,652
25 Winthrop Place, Grosse Pointe Farms, MI 5 Beds \| 4 Baths \| 3825 Sq. Ft.	$1,198,561
23 Winthrop Place, Grosse Pointe Farms, MI 3 Beds \| 4 Baths \| 4785 Sq. Ft.	$1,472,257
3 Carmel Lane, Grosse Pointe Farms, MI - Beds \| 4 Baths \| 4337 Sq. Ft.	$1,223,225

Property information provided by Greater Lansing AoR when last listed in 2017. This data may not match . Learn more.

More real estate resources

Cities
Minor Civil Divisions
Zip Codes
Neighborhoods
Popular Searches

Detroit homes for sale
Royal Oak homes for sale
Troy homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Grosse Pointe Farms	Agents near me	Livonia, MI homes for sale	Grosse Pointe Farms Housing Market
Houses for sale near me	Detroit, MI homes for sale	Royal Oak, MI homes for sale
Land for sale near me	Ann Arbor, MI homes for sale	Novi, MI homes for sale
Open Houses near me	Grand Rapids, MI homes for sale	Grosse Pointe Farms Property Records
Condos for sale near me	Troy, MI homes for sale	MI New Listings

48230 homes for sale
48236 homes for sale
48224 homes for sale