247 Lake Shore Rd, Grosse Pointe Farms, MI 48236

Off Market Oct 2017 for $1.3M

$2,317,092

•

5,310

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

$436Est. Price/Sq.Ft.

3 car garageParking

Listed by Julie Kaiser • Higbie Maxon Agney Inc

•313-886-3400 (broker)

•kay@higbiemaxon.com (broker)

Bought with Matthew Jankowski • Lucido and Associates, Inc

•313-882-1010 (broker)

•alex@lucidorealestate.com (broker)

Redfin checked: a few seconds ago

•Source:MiRealSource-MiMLS #31324117

Redfin Estimate

$2,317,092

$937K since sold in October 2017$4,000 since August

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUL 8, 2026
$703,000
A
4 beds3.5 baths2,367 sq ft
274 Hillcrest Ave, Grosse Pointe Farms, MI 48236 3123
SOLD AUG 27, 2026
$1,400,000
B
4 beds4 baths4,890 sq ft
77 Merriweather 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 28, 2026
$910,000
D
3 beds3.5 baths3,040 sq ft
276 Kercheval Ave, Grosse Pointe Farms, MI 48236
SOLD JUN 23, 2026
$670,000
E
4 beds2.5 baths2,680 sq ft
100 Moran Rd, Grosse Pointe Farms, MI 48236
SOLD FEB 27, 2026
$835,000
F
3 beds3.5 baths3,206 sq ft
286 Grosse Pointe Blvd, Grosse Pointe Farms, MI 48236

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

Earn from this home

Sell

$1,283,006

Est. take-home

List your home with Redfin and save $23,171

Rent

$4,559/mo

Redfin rental estimate

List your home for rent

Market trends in 48236, MI

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

99.2%

0.6% MoM

Median sale price

$451K

$805 MoM

Avg. days on market

16d

0 days MoM

Recently sold homes

155

14 MoM

New listings for sale

COMING SOON
$335,000
3 beds2 baths2,378 sq ft
1790 Kenmore Dr, Grosse Pointe Woods, MI 48236
(586) 840-0400
3D WALKTHROUGH
$1,495,000
2 beds2.5 baths5,663 sq ft
121 Vendome Rd, Grosse Pointe Farms, MI 48236
(313) 884-7000
3D WALKTHROUGH
$625,000
4 beds2.5 baths3,302 sq ft
525 Saddle Ln, Grosse Pointe Woods, MI 48236
(313) 884-7000
3D WALKTHROUGH
$399,000
3 beds1.5 baths2,716 sq ft
1803 Littlestone Rd, Grosse Pointe Woods, MI 48236 1956
(888) 553-1956
3D WALKTHROUGH
$362,500
3 beds2 baths2,387 sq ft
306 Ridge Rd, Grosse Pointe Farms, MI 48236
(313) 884-7000
3D WALKTHROUGH
$375,000
3 beds1.5 baths2,432 sq ft
1930 Lochmoor Blvd, Grosse Pointe Woods, MI 48236
(313) 884-7000
3D WALKTHROUGH
$950,000
3 beds2.5 baths4,710 sq ft
361 Moselle Pl, Grosse Pointe Farms, MI 48236
(313) 884-7000
$319,000
2 beds1.5 baths1,961 sq ft
2100 Fleetwood Dr, Grosse Pointe Woods, MI 48236
(313) 886-1000
3D WALKTHROUGH
$425,000
3 beds2.5 baths2,203 sq ft
277 Ridgemont Rd, Grosse Pointe Farms, MI 48236
(313) 884-7000
$550,000
3 beds2 baths2,384 sq ft
604 S Higbie Pl, Grosse Pointe Woods, MI 48236 2418
(586) 792-8000
See all

Provided by Redfin

Sale history for 247 Lake Shore Rd

Date

Event

Price

MiRealSource-MiMLS #31324117

Oct 25, 2017

Sold

$1,380,000

$260/sq ft

Oct 25, 2017

Sold

$1,380,000

$260/sq ft

Oct 4, 2017

Pending

—

Sep 6, 2017

Price Changed

$1,590,000

$299/sq ft

Aug 1, 2017

Price Changed

$1,690,000

$318/sq ft

Jun 30, 2017

Listed

$1,790,000

$337/sq ft

Jun 30, 2017

Listed

$1,590,000

$299/sq ft

REALCOMP #58031324117

Oct 25, 2017

Sold

$1,380,000

$260/sq ft

Jun 30, 2017

Listed

$1,590,000

$299/sq ft

REALCOMP #217027552

Jun 29, 2017

Listing Removed

—

May 21, 2017

Price Changed

$1,950,000

$367/sq ft

Apr 11, 2017

Price Changed

$2,200,000

$414/sq ft

Apr 10, 2017

Listed

$2,000,000

$377/sq ft

MiRealSource-MiMLS #31316766

Jun 27, 2017

Listing Removed

—

Jun 19, 2017

Listing Removed

—

May 21, 2017

Price Changed

$1,950,000

$367/sq ft

Apr 10, 2017

Listed

$2,200,000

$414/sq ft

REALCOMP #58031316766

Jun 19, 2017

Listing Removed

—

Apr 10, 2017

Listed

$1,950,000

$367/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

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 Aug 7, 2026.

Property details

Parking

Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 3
Garage Type: Attached Garage, Electric In Garage, Gar Door Opener, Heated Garage, Side Loading Garage

Interior

Interior Features
Interior Features: Cable/Internet Avail., Hardwood Floors, Security System, Walk-In Closet, Wet Bar/Bar
Appliances: Bar (Refrigerator), Dishwasher, Disposal, Dryer, Freezer, Microwave, Range/Oven, Refrigerator, Washer
Has Fireplace
Fireplace Features: Gas Fireplace, Livingroom Fireplace, Master Bedroom Fireplace, Natural Fireplace

Bedroom Information
Bedroom 1 Level: Main
Bedroom 1 Dimensions: 15 x 15
Bedroom 1 Floor Covering: Carpet
Bedroom 1 Floor Covering: Carpet
Bedroom 2 Level: Second
Bedroom 2 Dimensions: 19 x 20
Bedroom 2 Floor Covering: Carpet
Bedroom 3 Level: Second
Bedroom 3 Dimensions: W=17
Bedroom 3 Floor Covering: Carpet
Bedroom 4 Level: Second
Bedroom 4 Dimensions: 17 x 15
Bedroom 4 Floor Covering: Carpet

Bathroom Information
# of Lavatories: 1
# of Bathrooms (Full): 3
# of Baths/Lavatories (Total): 6
Bath Descriptions: Whirlpool/Hot Tub
Below Grade Lavatory: 1
Below Grade Bathroom: 1

Bathroom 1 Information
Lavatory 1 Width: 8
Lavatory 1 Length: 7
Lavatory 1 Level: Main
Lavatory 1 Floor Covering: Marble
Bathroom 1 Floor Covering: Granite
Bathroom 1 Level: Second
Bathroom 1 Length: 17
Bathroom 1 Width: 17

Bathroom 2 Information
Bathroom 2 Floor Covering: Granite
Bathroom 2 Level: Main
Bathroom 2 Length: 9
Bathroom 2 Width: 6

Bathroom 3 Information
Bathroom 3 Floor Covering: Ceramic
Bathroom 3 Level: Second
Bathroom 3 Length: 10
Bathroom 3 Width: 4

Dining/Kitchen Information
Breakfast Nook Floor Covering: Wood
Dining Room Floor Covering: Wood
Kitchen Floor Covering: Wood
Kitchen Level: Main
Kitchen Dimension: 27 x 12
Breakfast Nook Level: Main
Breakfast Nook Dimension: 12 x 7
Dining Room Level: Main
Dining Room Dimension: 17 x 13

Family/Great Room Information
Sun/Florida Room Floor Covering: Granite
Sun/Florida Room Level: Main
Sun/Florida Room Dimensions: 16 x 18

Library/Den/Living Room Information
Living Room Floor Covering: Wood
Library/Den Floor Covering: Carpet
Office Floor Covering: Carpet
Living Room Level: Main
Living Room Dimensions: 19 x 22
Library/Den Level: Main
Library/Den Dimensions: 13 x 15

Laundry/Basement Information
Laundry Room Floor Covering: Ceramic
Basement : Has Basement
Basement Type: Block, Finished
Laundry Room Level: Second
Laundry Room Dimensions: 10 x 4

Other Room Information
Other Room 1 Floor Covering: Carpet
Other Room 1 Level: Second
Other Room 1 Dimensions: 22 x 16

Exterior

Exterior Features
Exterior Construction: Brick
Exterior Features: Lawn Sprinkler, Patio, Sidewalks, Terrace
Foundation Type: Basement, Crawl

Property Features
Has Pool
On Waterfront
Water Features: All Sports Lake, Lake Frontage, Sea Wall, Water View

Property Information
Property Type: Residential
Structure Style: 2 Story
Year Built: 1968
Below Grade Sq. Ft.: 2252
Below Grade Sq. Ft. (Finished): 2252

Lot Information
Lot Size: 120,191
Zoning: Residential

Land Information
Acreage: 0.52
Roads: Curbed, Paved Street
Frontage: 120
Flood Insurance: Not Required

Financial

Tax/Assessments Information
Taxable Value: $537,345
Total Tax Amount: $26,776
Summer Tax Year: 2016
Summer Tax Amount: $14,037
Winter Tax Year: 2016
Winter Tax Amount: $12,769

Utilities

Utility Information
Heat/Fuel Type: Natural Gas
Water Heater: Gas
Water: Public Water
Cooling System: Central A/C
Heating System: Forced Air, Zoned Heating, Air Cleaner, Humidifier
Sewer Septic: Public Sanitary

Location

Unit 5 Information
Living Room Dimensions: L=7562

School Information
School District: Grosse Pointe Public Schools
School District: Grosse Pointe Public Schools

Location Details
Municipality Type: City
Municipality: Grosse Pointe Farms
Mail City: Grosse Pointe Farms
Subdivision: Blair Subdivision
Municipality: Grosse Pointe Farms
Area (Municipality): Grosse Pointe Farms (82334)

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 Aug 7, 2026

Other

Listing Information
Originating MLS: MiRealSource
Originating MLS: MI Real Source

Around this home

Schools

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.20M – $2.67M

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

Need the cash from your home fast? Sell to .

Nearby similar homes

$33,000

2 beds1 bath2,300 sq ft

4619 Farmbrook St, Detroit, MI 48224 3901

(313) 658-6400

VIDEO TOUR

$585,000

4 beds2 baths2,737 sq ft

891 Washington Rd, Grosse Pointe, MI 48230

(313) 343-0100

$394,900

4 beds3 baths2,050 sq ft

476 Touraine Rd, Grosse Pointe Farms, MI 48236 3226

(313) 858-6580

3D WALKTHROUGH

$1,685,000

7 beds5.5 baths8,980 sq ft

304 University Pl, Grosse Pointe, MI 48230

(313) 884-7000

3D WALKTHROUGH

$2,650,000

8 beds7 baths11,419 sq ft

105 Lake Shore Rd, Grosse Pointe Farms, MI 48236

(313) 884-7000

$149,900

3 beds1.5 baths2,184 sq ft

3560 Guilford St, Detroit, MI 48224 2240

(313) 466-7253

New listings for sale in 48236

COMING SOON

$335,000

3 beds2 baths2,378 sq ft

1790 Kenmore Dr, Grosse Pointe Woods, MI 48236

(586) 840-0400

3D WALKTHROUGH

$1,495,000

2 beds2.5 baths5,663 sq ft

121 Vendome Rd, Grosse Pointe Farms, MI 48236

(313) 884-7000

3D WALKTHROUGH

$625,000

4 beds2.5 baths3,302 sq ft

525 Saddle Ln, Grosse Pointe Woods, MI 48236

(313) 884-7000

3D WALKTHROUGH

$399,000

3 beds1.5 baths2,716 sq ft

1803 Littlestone Rd, Grosse Pointe Woods, MI 48236 1956

(888) 553-1956

3D WALKTHROUGH

$362,500

3 beds2 baths2,387 sq ft

306 Ridge Rd, Grosse Pointe Farms, MI 48236

(313) 884-7000

3D WALKTHROUGH

$375,000

3 beds1.5 baths2,432 sq ft

1930 Lochmoor Blvd, Grosse Pointe Woods, MI 48236

(313) 884-7000

3D WALKTHROUGH

$950,000

3 beds2.5 baths4,710 sq ft

361 Moselle Pl, Grosse Pointe Farms, MI 48236

(313) 884-7000

$319,000

2 beds1.5 baths1,961 sq ft

2100 Fleetwood Dr, Grosse Pointe Woods, MI 48236

(313) 886-1000

3D WALKTHROUGH

$425,000

3 beds2.5 baths2,203 sq ft

277 Ridgemont Rd, Grosse Pointe Farms, MI 48236

(313) 884-7000

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,445,392
241 Lake Shore Road, Grosse Pointe Farms, MI - Beds \| 10.5 Baths \| 20223 Sq. Ft.	$3,021,145

Address	Redfin Estimate
231 Lake Shore Road, Grosse Pointe Farms, MI 4 Beds \| 4 Baths \| 4679 Sq. Ft.	$2,721,937
227 Lake Shore Road, Grosse Pointe Farms, MI 4 Beds \| 4.5 Baths \| 3528 Sq. Ft.	$1,679,667

Address	Redfin Estimate
255 Lake Shore Road, Grosse Pointe Farms, MI 5 Beds \| 6.5 Baths \| 6800 Sq. Ft.	$3,613,182
237 Lake Shore Road, Grosse Pointe Farms, MI 6 Beds \| 9.5 Baths \| 1317 Sq. Ft.	$3,563,973

Property information provided by MiRealSource-MiMLS when last listed in 2017. This data may not match . Learn more.

More real estate resources

Zip Codes
Minor Civil Divisions
Neighborhoods
Cities
Popular Searches

48230 homes for sale
48236 homes for sale
48224 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.

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 sale near me	Detroit, MI homes for sale	Novi, MI homes for sale
Land for sale near me	Ann Arbor, MI homes for sale	Royal Oak, 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
Agents near me	Livonia, MI homes for sale	Grosse Pointe Farms Housing Market

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