NOT LISTED FOR SALE

247 Lake Shore Rd Grosse Pointe Farms, MI 48236

Estimated Value: $1,814,000 - $2,042,000

4 Beds
3 Baths
7,562 Sq Ft
$254/Sq Ft Est. Value

Last Sold October 25, 2017

Last sale price $1,380,000 $182 Per Sq Ft

Est. 39% increase in value since last sale

Current estimated payment $11,885/month

96 Days on Market

Highlights

  • Outdoor Pool
  • Waterfront
  • Colonial Architecture
  • Kerby Elementary School Rated A
  • 0.52 Acre Lot
  • Wood Flooring

About This Home

As of October 2017

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.

Last Agent to Sell the Property

Julie Kaiser

Higbie Maxon Agney Inc License #MISPE-6501325154 Listed on: 06/30/2017

Last Buyer's Agent

Matthew Jankowski

Lucido and Associates, Inc License #MISPE-6501377313

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1968

Lot Details

  • 0.52 Acre Lot
  • Lot Dimensions are 120x191
  • Waterfront
  • Sprinkler System

Home Design

  • Colonial Architecture
  • Brick Exterior Construction

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Bar Fridge
  • Gas Fireplace
  • Living Room with Fireplace
  • Home Security System

Kitchen

  • Oven or Range
  • Microwave
  • Freezer
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • 3 Full Bathrooms
  • Whirlpool Bathtub

Laundry

  • Dryer
  • Washer

Finished Basement

  • Block Basement Construction
  • Crawl Space

Parking

  • 3 Car Attached Garage
  • Heated Garage
  • Side Facing Garage
  • Garage Door Opener

Eco-Friendly Details

  • Air Cleaner

Outdoor Features

  • Outdoor Pool
  • Seawall
  • Patio
  • Terrace

Utilities

  • Humidifier
  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Gas Water Heater
  • Internet Available

Listing and Financial Details

  • Assessor Parcel Number 38008040001000 &38008990014001

Home Details

Home Type

Single Family

Est. Annual Taxes

$26,776

Year Built

Built in 1968

Lot Details

0

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL CONDO
  • Type Of Property: Residential
  • Architecture Style: Colonial
  • Structure Style: 2 Story
  • Flood Insurance: Not Required
  • Total Tax Amount: 26776
  • Year Built: 1968
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 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
  • Fireplace: Yes
  • Fireplaces: Gas Fireplace, LivRoom Fireplace, MstrBedroom Fireplace, Natural Fireplace
  • Basement: Yes
  • Basement: Block, Finished
  • Bedrooms: 4
  • Bedroom 1: On Main Floor, Dimensions: 15 x 15
  • Bedroom 1 Floor Covering: Carpet
  • Bedroom 2: On 2nd Floor, Dimensions: 19 x 20
  • Bedroom 2 Floor Covering: Carpet
  • Bedroom 3: On 2nd Floor, Dimensions: 13 x 17
  • Bedroom 3 Floor Covering: Carpet
  • Bedroom 4: On 2nd Floor, Dimensions: 17 x 15
  • Bedroom 4 Floor Covering: Carpet
  • Bathrooms Description: Basement Full Bath, MstrBdrm Full Bathroom, Whirlpool/Hot Tub
  • Full Bathrooms: 3
  • Total Bathrooms: 6
  • Below Grade Bathroom: 1
  • Below Grade Bedrooms: 1
  • Bathroom 1: Dimensions: 17 x 17, On Level: Second, Flooring: Granite
  • Bathroom 2: Dimensions: 9 x 6, On Level: Main, Flooring: Granite
  • Bathroom 3: Dimensions: 10 x 4, On Level: Second, Flooring: Ceramic
  • Breakfast Nook: On Main Floor, Dimensions: 12 x 7
  • Breakfast Nook Floor Covering: Wood
  • Dining Room: On Main Floor, Dimensions: 17 x 13
  • Dining Room Floor Covering: Wood
  • Kitchen: On Main Floor, Dimensions: 27 x 12
  • Kitchen Features: Breakfast Nook/Room, Eat-In Kitchen, Formal Dining Room
  • Kitchen Floor Covering: Wood
  • Laundry: On 2nd Floor, Dimensions: 10 x 4
  • Laundry Room Floor Covering: Ceramic
  • Library Den: On Main Floor, Dimensions: 13 x 15
  • Library Den Floor Covering: Carpet
  • Living Room: On Main Floor, Dimensions: 19 x 22
  • Living Room Floor Covering: Wood
  • Sun Room: On Main Floor, Dimensions: 16 x 18
  • Sun Room Floor Covering: Granite
  • Other Room1: Dimensions: 22x16, On Level: Second, Flooring: Carpet
  • Below Grade Sq Ft: 2252
  • Finished Below Grade Sq Ft: 2252
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 5310
  • Total Finished Sq Ft: 7562

Exterior Features

  • Pool: Yes
  • Exterior: Brick
  • Exterior Features: Lawn Sprinkler, Patio, Sidewalks, Terrace
  • Foundation: Basement, Crawl
  • Frontage: 120
  • Road: Curbed, Paved Street
  • Water Features: All Sports Lake, Lake Frontage, Sea Wall, Water View
  • Waterfront: Yes

Garage/Parking

  • Garage: Attached Garage, Electric in Garage, Gar Door Opener, Heated Garage, Side Loading Garage
  • Garage Spaces: 3
  • Garage: Yes

Utilities

  • Heating: Forced Air, Zoned Heating, Air Cleaner, Humidifier
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Gas
  • Cooling: Central A/C

Lot Info

  • Assessor Parcel Number: 38008040001000 &38008990014001
  • Zoning: Residential
  • Lot Dimensions: 120x191
  • Acreage: 0.52
  • Geo Subdivision: MI

Tax Info

  • Summer Tax: Year: 2016, Amount: $14,037.00
  • Winter Tax: Year: 2016, Amount: $12,769.00
  • Taxable Value: 537345
  • Total Tax: Amount: $26,776.00
  • SEV Year: 2017

MLS Schools

  • School District: Grosse Pointe Public Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 30, 2017
Closed on
Oct 25, 2017
Sold by
Kaiser Joseph P and Kaiser Christopher Caldwell
Bought by
Ciaravino Rita
Seller's Agent
Julie Kaiser
Higbie Maxon Agney Inc
Buyer's Agent
Matthew Jankowski
Lucido and Associates, Inc
List Price
$1,790,000
Sold Price
$1,380,000
Premium/Discount to List
-$410,000
-22.91%
Current Estimated Value
$1,919,962

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$539,962
Avg. Annual Appreciation
3.14%

Purchase Details

Listed on
Jun 30, 2017
Closed on
Oct 17, 2017
Sold by
Kaiser Joseph R
Bought by
Kaiser Joseph R
Seller's Agent
Julie Kaiser
Higbie Maxon Agney Inc
Buyer's Agent
Matthew Jankowski
Lucido and Associates, Inc
List Price
$1,790,000
Sold Price
$1,380,000
Premium/Discount to List
-$410,000
-22.91%

Purchase Details

Closed on
Oct 10, 2007
Sold by
Kaiser Joseph P and Kaiser Maureen A
Bought by
Kaiser Joseph P and Joseph P Kaiser Jr Revocable Living Tr
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Ciaravino Rita $1,380,000 First American Title
Kaiser Joseph R -- None Available
Kaiser Joseph P -- None Available
Kaiser Joseph P -- Seaver Title
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/25/2017 10/25/17 Sold $1,380,000 -13.2% $182 / Sq Ft
10/04/2017 10/04/17 Pending -- -- --
09/06/2017 09/06/17 Price Changed $1,590,000 -5.9% $210 / Sq Ft
08/01/2017 08/01/17 Price Changed $1,690,000 -5.6% $223 / Sq Ft
06/30/2017 06/30/17 For Sale $1,790,000 -- $237 / Sq Ft
Source: Michigan Multiple Listing Service

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $20,468 $1,064,700 $0 $0
2024 $20,468 $887,800 $0 $0
2023 $18,751 $784,300 $0 $0
2022 $18,751 $758,500 $0 $0
2021 $34,409 $726,700 $0 $0
2019 $33,834 $660,000 $0 $0
2018 $17,650 $657,000 $0 $0
2017 $25,572 $644,400 $0 $0
2016 $26,807 $642,800 $0 $0
2015 $53,096 $531,000 $0 $0
2013 $51,440 $514,400 $0 $0
2012 $12,906 $504,300 $196,100 $308,200
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 31324117

Michigan Multiple Listing Service

APN: 38-008-04-0001-000