NOT LISTED FOR SALE

Estimated Value: $2,101,000 - $2,318,000

5 Beds
6 Baths
4,359 Sq Ft
$508/Sq Ft Est. Value

Last Sold November 13, 2012

Last sale price $1,750,000 $401 Per Sq Ft

Est. 27% increase in value since last sale

Current estimated payment $15,287/month

119 Days on Market

Highlights

  • Lake Front
  • Second Kitchen
  • Heated Floors
  • Indian Trail Elementary School Rated A
  • In Ground Pool
  • Landscaped Professionally

About This Home

As of November 2012

Sip lemonade on the front porch while friends and family play on the front lawn overlooking the lake. This secluded home, where Sheridan Road comes to a dead-end,has 13 rms, 5 bdrms, 4.2 ba. Perfect for entertaining, it has rooom for everyone, inside and out. Elegant rms with fab views, wonderful deck and pool, pool house with kitchen and half ba. Your own resort when you pull into the driveway!

Last Agent to Sell the Property

Paula Weiss

Coldwell Banker Residential Listed on: 04/16/2012

Co-Listed By

Daverille Sher

Coldwell Banker Residential

Last Buyer's Agent

Hope Abels

Property Details

Home Type

  • Other

Est. Annual Taxes

  • $44,244

Year Built

  • 1920

Lot Details

  • Lake Front
  • Cul-De-Sac
  • Landscaped Professionally

Parking

  • Attached Garage
  • Driveway
  • Parking Included in Price

Home Design

  • Cedar

Interior Spaces

  • Skylights
  • Entrance Foyer
  • Breakfast Room
  • Formal Dining Room
  • Library
  • Screened Porch
  • Home Gym
  • Water Views
  • Partially Finished Basement
  • Basement Fills Entire Space Under The House
  • Laundry on main level

Kitchen

  • Second Kitchen
  • Breakfast Bar
  • Kitchen Island

Flooring

  • Wood
  • Heated Floors

Bedrooms and Bathrooms

  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Steam Shower
  • Separate Shower

Outdoor Features

  • In Ground Pool
  • Deck

Utilities

  • Hot Water Heating System
  • Lake Michigan Water

Property Details

Home Type

Other

Est. Annual Taxes

$44,244

Year Built

1920

Lot Details

0

Parking

2

Listing Details

  • Property Type: Detached Single
  • Built Before 1978 (Y/N): Yes
  • Recent Rehab: Yes
  • Architectural Style: Traditional
  • Type Detached: 3 Stories
  • Special Features: None
  • Year Built: 1920

Interior Features

  • Appliances: Oven-Double, Oven/Range, Microwave, Dishwasher, Refrigerator, Washer, Dryer, Disposal
  • Fireplaces: 2
  • Interior Property Features: Skylight(s), Hardwood Floors, Heated Floors, 1st Floor Laundry
  • Number Of Rooms: 13
  • Attic: Finished
  • Fireplace Location: Family Room, Living Room
  • Basement: Full
  • Basement: Partially Finished
  • Bedrooms All Levels: 5
  • Master Bedroom Level: 2nd Level
  • Master Bedroom Size: 22X16
  • Master Bedroom Flooring: Carpet
  • Primary Bedroom Bath: Full
  • Second Bedroom Level: 2nd Level
  • Second Bedroom Size: 17X15
  • Second Bedroom Flooring: Carpet
  • Third Bedroom Level: 2nd Level
  • Third Bedroom Size: 10X12
  • Third Bedroom Flooring: Carpet
  • Fourth Bedroom Level: 2nd Level
  • Fourth Bedroom Size: 11X11
  • Fourth Bedroom Flooring: Carpet
  • Bathroom Amenities: Separate Shower, Steam Shower
  • Living Room Level: Main Level
  • Living Room Size: 30X20
  • Living Room Flooring: Hardwood
  • Dining Room: Separate
  • Dining Room Level: Main Level
  • Dining Room Size: 20X16
  • Dining Room Flooring: Hardwood
  • Family Room Level: Main Level
  • Family Room Size: 24X15
  • Family Room Flooring: Hardwood
  • Kitchen Type: Eating Area-Table Space, Island
  • Kitchen Level: Main Level
  • Kitchen Size: 11X17
  • Kitchen Flooring: Ceramic Tile
  • Additional Rooms: 2nd Kitchen, 5th Bedroom, Breakfast Room, Exercise Room, Foyer, Library, Screened Porch, Walk In Closet
  • Additional Room 1 Name: 5th Bdrm
  • Additional Room 1 Level: 3rd Level
  • Additional Room 1 Size: 12X8
  • Additional Room 1 Flooring: Carpet
  • Additional Room 2 Name: Breakfast Rm
  • Additional Room 2 Level: Main Level
  • Additional Room 2 Size: 16X12
  • Additional Room 2 Flooring: Ceramic Tile
  • Additional Room 3 Name: Foyer
  • Additional Room 3 Level: Main Level
  • Additional Room 3 Size: 12X10
  • Additional Room 3 Flooring: Hardwood
  • Additional Room 4 Name: Exercise Rm
  • Additional Room 4 Level: Basement
  • Additional Room 4 Size: 29X9
  • Additional Room 4 Flooring: Carpet
  • Additional Room 5 Name: Library
  • Additional Room 5 Level: Main Level
  • Additional Room 5 Size: 14X10
  • Additional Room 5 Flooring: Hardwood
  • Additional Room 6 Name: Screened Porch
  • Additional Room 6 Level: Main Level
  • Additional Room 6 Size: 24X9
  • Additional Room 6 Flooring: Hardwood
  • Additional Room 7 Name: Walk in Closet
  • Additional Room 7 Level: 3rd Level
  • Additional Room 7 Size: 13X11
  • Additional Room 7 Flooring: Carpet
  • Additional Room 9 Name: 2nd Kitchen
  • Additional Room 9 Level: Main Level
  • Additional Room 9 Size: 6X8
  • Additional Room 9 Flooring: Ceramic Tile

Exterior Features

  • Roof: Asphalt/Glass (Shingles)
  • Lot Size: .50-.99 Acre
  • Exterior Building Type: Cedar
  • Waterfront: Yes
  • Exterior Property Features: Deck, Porch, Porch Screened, Pool In-Ground

Garage/Parking

  • Number of Cars: 2.2
  • Parking: Garage
  • Garage Type: Attached
  • Garage On Site: Yes
  • Number Garage Spaces: 2.2
  • Driveway: Asphalt
  • Parking Included In Price: Yes

Utilities

  • Cooling: Central Air
  • Electricity: Circuit Breakers, 200+ Amp Service
  • Water: Lake Michigan
  • Sewer: Sewer-Public
  • Heating Fuel: Hot Water/Steam

Schools

  • Junior High Dist: 112

Lot Info

  • Lot Dimensions: 99X233X103X260
  • Lot Description: Cul-de-sac, Lake Front, Landscaped Professionally, Water View

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 16, 2012
Closed on
Nov 13, 2012
Sold by
Gerstein Melvyn A and Gerstein Dolores J
Bought by
Kessler Arthur J and Bloom Wendy L
Seller's Agent
Paula Weiss
Coldwell Banker Residential
Buyer's Agent
Hope Abels
List Price
$2,199,000
Sold Price
$1,750,000
Premium/Discount to List
-$449,000
-20.42%
Current Estimated Value
$2,216,139

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$466,139
Avg. Annual Appreciation
1.84%
Original Mortgage
$1,000,000
Interest Rate
3.35%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Aug 26, 2011
Sold by
Gerstein Dolores J and Gerstein Revocable F Dolores J
Bought by
Gerstein Melvyn A and Gerstein Dolores J

Purchase Details

Closed on
May 12, 2011
Sold by
Gerstein Melvyn A and Gerstein Dolores J
Bought by
Gerstein Dolores J and Gerstein Revocable F Dolores J

Purchase Details

Closed on
Mar 24, 1995
Sold by
Gerstein Melvyn A and Gerstein Dolores J
Bought by
Gerstein Dolores J
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
Kessler Arthur J $262,500 None Available
Gerstein Melvyn A -- None Available
Gerstein Dolores J -- None Available
Gerstein Dolores J -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Closed Kessler Arthur J $1,000,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/13/2012 11/13/12 Sold $1,750,000 -12.5% $401 / Sq Ft
08/13/2012 08/13/12 Pending -- -- --
08/09/2012 08/09/12 Price Changed $1,999,999 -4.8% $459 / Sq Ft
07/12/2012 07/12/12 Price Changed $2,100,000 -4.5% $482 / Sq Ft
04/16/2012 04/16/12 For Sale $2,199,000 -- $504 / Sq Ft
Source: Midwest Real Estate Data (MRED)

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
2024 $44,244 $556,719 $273,449 $283,270
2023 $49,319 $512,349 $246,484 $265,865
2022 $49,319 $553,666 $270,776 $282,890
2021 $45,486 $535,202 $261,746 $273,456
2020 $44,014 $535,202 $261,746 $273,456
2019 $42,525 $532,699 $260,522 $272,177
2018 $22,598 $575,533 $288,741 $286,792
2017 $40,831 $572,214 $287,076 $285,138
2016 $39,300 $544,759 $273,302 $271,457
2015 $37,987 $506,140 $253,927 $252,213
2014 $33,562 $415,885 $249,460 $166,425
2012 $32,014 $418,311 $250,915 $167,396
Source: Public Records

Agents Affiliated with this Home

See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD08046675

Midwest Real Estate Data (MRED)

APN: 16-14-401-012