NOT LISTED FOR SALE

Estimated Value: $4,883,763 - $7,188,000

4 Beds
10 Baths
13,000 Sq Ft
$472/Sq Ft Est. Value

Last Sold September 15, 2020

Last sale price $4,500,000 $346 Per Sq Ft

Est. 36% increase in value since last sale

Current estimated payment $38,278/month

322 Days on Market

Highlights

  • Lake Front
  • Beach Access
  • Sauna
  • Indian Trail Elementary School Rated A
  • In Ground Pool
  • 2-minute walk to Moraine Beach

About This Home

As of September 2020

Spectacular lake front views from this newly remodeled luxurious home. Features include a grand entrance with elevator, incredible architectural details, and multiple balconies and outdoor opportunities. Large gourmet kitchen with island, upscale finishes and appliances, and breakfast room adjacent to open family room. Formal living room with tray ceilings, fireplace, and dining room with beautiful lake views. Main level office with wet bar and fireplace, mud room, laundry, and two powder rooms complete the 1st floor. 2nd floor features stunning master wing with panoramic lake views, sitting room, fireplace, balcony, and abundant closet space. Luxury master bath facing the lake with high end shower, soaking tub, and double vanity. 3 additional ensuite bedrooms, library/den, and additional office on 2nd level. Lower level with kitchen, wine cellar, ex room, sauna, locker room, and guest suite with full bath. Luxurious outdoor pool with bluestone patio and table land. 4 car heated garage

Last Agent to Sell the Property

Margie Brooks

Baird & Warner License #475121853 Listed on: 08/19/2019

Baird & Warner

Last Buyer's Agent

Mary Grant

@properties Christie's International Real Estate License #475124370

@properties Christie's International Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $140,009

Year Built

  • Built in 2001 | Remodeled in 2018

Lot Details

  • 0.9 Acre Lot
  • Lake Front
  • Cul-De-Sac
  • Dog Run
  • Landscaped Professionally
  • Wooded Lot

Parking

  • 4 Car Attached Garage
  • Heated Garage
  • Garage Transmitter
  • Brick Driveway
  • Parking Included in Price

Home Design

  • Rubber Roof

Interior Spaces

  • 13,000 Sq Ft Home
  • 2-Story Property
  • Elevator
  • Wet Bar
  • Vaulted Ceiling
  • Skylights
  • Wood Burning Fireplace
  • Attached Fireplace Door
  • Gas Log Fireplace
  • Electric Fireplace
  • Family Room with Fireplace
  • 5 Fireplaces
  • Living Room with Fireplace
  • Formal Dining Room
  • Home Office
  • Library
  • Recreation Room
  • Bonus Room
  • Sauna
  • Home Gym
  • Heated Floors
  • Water Views
  • Home Security System

Kitchen

  • Breakfast Bar
  • Double Oven
  • Indoor Grill
  • Cooktop with Range Hood
  • Microwave
  • High End Refrigerator
  • Freezer
  • Dishwasher
  • Wine Refrigerator
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 5 Potential Bedrooms
  • Fireplace in Primary Bedroom
  • Dual Sinks
  • Soaking Tub
  • Double Shower
  • Steam Shower
  • Shower Body Spray
  • Separate Shower

Laundry

  • Laundry in unit
  • Sink Near Laundry
  • Gas Dryer Hookup

Finished Basement

  • English Basement
  • Basement Fills Entire Space Under The House
  • Exterior Basement Entry
  • Sump Pump
  • Fireplace in Basement
  • Finished Basement Bathroom

Outdoor Features

  • In Ground Pool
  • Beach Access
  • Balcony
  • Deck
  • Patio
  • Outdoor Grill

Schools

  • Indian Trail Elementary School
  • Edgewood Middle School
  • Highland Park High School

Utilities

  • Zoned Heating and Cooling
  • Heating System Uses Natural Gas
  • 400 Amp
  • Power Generator
  • Lake Michigan Water

Home Details

Home Type

Single Family

Est. Annual Taxes

$140,009

Year Built

Built in 2001 | Remodeled in 2018

Lot Details

0

Parking

4

Listing Details

  • Property Type: Residential
  • Property Type: Detached Single
  • Type Detached: 2 Stories
  • Ownership: Fee Simple
  • New Construction: No
  • Property Sub-Type: 2 Stories
  • Year Built: 2001
  • Age: 16-20 Years
  • Built Before 1978 (Y/N): No
  • Disability Access and/or Equipped: No
  • General Information: School Bus Service
  • Rebuilt (Y/N): No
  • Rehab (Y/N): Yes
  • Rehab Year: 2018
  • Special Features: None
  • Property Sub Type: Detached
  • Year Renovated: 2018

Interior Features

  • Appliances: Double Oven, Range, Microwave, Dishwasher, Refrigerator, High End Refrigerator, Freezer, Disposal, Indoor Grill, Wine Refrigerator, Cooktop, Range Hood
  • Basement: Full, English
  • Full Bathrooms: 7
  • Half Bathrooms: 3
  • Total Bathrooms: 10
  • Total Bedrooms: 4
  • Fireplace Features: Wood Burning, Attached Fireplace Doors/Screen, Electric, Gas Log, Gas Starter
  • Fireplaces: 5
  • Interior Amenities: Vaulted/Cathedral Ceilings, Skylight(s), Sauna/Steam Room, Bar-Wet, Elevator, Heated Floors
  • LivingArea: 13000
  • Other Equipment: Security System, Sump Pump, Generator
  • Room Type: Eating Area, Office, Library, Bonus Room, Recreation Room, Exercise Room, Bedroom 5, Kitchen
  • Estimated Total Finished Sq Ft: 0
  • Basement Description: Finished,Exterior Access
  • Bathroom Amenities: Separate Shower,Steam Shower,Double Sink,Full Body Spray Shower,Double Shower,Soaking Tub
  • Basement Bathrooms: Yes
  • Below Grade Bedrooms: 1
  • Dining Room: Separate
  • Fireplace Location: Family Room,Living Room,Master Bedroom,Basement,Other
  • Total Sq Ft: 0

Exterior Features

  • ExteriorFeatures: Balcony, Deck, Patio, Dog Run, Pool In-Ground, Outdoor Grill
  • Lot Features: Beach, Cul-De-Sac, Lake Front, Landscaped, Water View, Wooded
  • OtherStructures: Kennel/Dog Run
  • Roof: Rubber
  • Waterfront: Yes
  • Exterior Building Type: Stucco,Stone

Garage/Parking

  • Garage Spaces: 4
  • Number of Cars: 4
  • Driveway: Brick
  • Garage Details: Transmitter(s),Heated
  • Garage On-Site: Yes
  • Garage Ownership: Owned
  • Garage Type: Attached
  • Parking: Garage

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air, Zoned
  • Electric: 400 Amp Service or Greater
  • Heating: Natural Gas
  • Laundry Features: Gas Dryer Hookup, In Unit, Sink
  • Water Source: Lake Michigan

Condo/Co-op/Association

  • Association Fee Frequency: Not Applicable
  • Master Association Fee: No

Fee Information

  • Association Fee Includes: None

Schools

  • Elementary School: Indian Trail Elementary School
  • High School: Highland Park High School
  • Middle/Junior School: Edgewood Middle School

Lot Info

  • Lot Size Acres: 0.9047
  • Lot Dimensions: 39409
  • Lot Size: 1.0-1.99 Acres
  • Special Assessments: N

Rental Info

  • Board Number: 2
  • Is Parking Included in Price: Yes

Tax Info

  • Tax Annual Amount: 140008.9
  • Tax Year: 2019

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 19, 2019
Closed on
Sep 5, 2020
Sold by
Greenhill Michael Louis and Greenhill Debra Merle
Bought by
Foglia Kymberly A and The Kymberly A Foglia Trust
Seller's Agent
Margie Brooks
Baird & Warner
Buyer's Agent
Mary Grant
@properties Christie's International Real Estate
List Price
$6,950,000
Sold Price
$4,500,000
Premium/Discount to List
-$2,450,000
-35.25%
Current Estimated Value
$6,139,921

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,639,921
Avg. Annual Appreciation
6.26%

Purchase Details

Closed on
Feb 28, 2010
Sold by
Revoca Greenhill Michael Louis
Bought by
Greenhill Michael Louis and Greenhill Debra Merle

Purchase Details

Closed on
Jan 11, 2007
Sold by
Greenhill Michael Louis
Bought by
Greenhill Michael Louis and Greenhill Debra Merle

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000,000
Interest Rate
6.27%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan

Purchase Details

Closed on
Jul 11, 2006
Sold by
Greenhill Michael and Greenhill Debra
Bought by
Revoca Greenhill Michael Louis and Michael Louis Greenhill Revocable Trust

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$4,500,000
Interest Rate
8%
Mortgage Type
Unknown

Purchase Details

Closed on
May 17, 2006
Sold by
Chicago Title Land Trust Co
Bought by
Greenhill Michael and Greenhill Debra

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$4,500,000
Interest Rate
8%
Mortgage Type
Unknown

Purchase Details

Closed on
Dec 29, 1999
Sold by
The Northern Trust Company
Bought by
Chicago Title Land Trust Company and Trust #1107795

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$975,000
Interest Rate
7.76%

Purchase Details

Closed on
Jun 29, 1998
Sold by
Merricks James W
Bought by
Merricks James W and The Northern Trust Company
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
Foglia Kymberly A $4,500,000 Near North National Title
Greenhill Michael Louis -- None Available
Greenhill Michael Louis -- None Available
Greenhill Michael Louis -- Ctc
Revoca Greenhill Michael Louis -- None Available
Greenhill Michael $5,750,000 Chicago Title Land Trust Co
Chicago Title Land Trust Company $1,505,000 --
Merricks James W -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Greenhill Michael Louis $1,000,000
Previous Owner Greenhill Michael $4,500,000
Previous Owner Chicago Title Land Trust Company $975,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
09/15/2020 09/15/20 Sold $4,500,000 -9.1% $346 / Sq Ft
07/06/2020 07/06/20 Pending -- -- --
07/02/2020 07/02/20 Price Changed $4,950,000 -10.0% $381 / Sq Ft
01/23/2020 01/23/20 Price Changed $5,500,000 -6.8% $423 / Sq Ft
10/07/2019 10/07/19 Price Changed $5,900,000 -15.1% $454 / Sq Ft
08/19/2019 08/19/19 For Sale $6,950,000 -- $535 / 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 $198,821 $2,514,388 $543,935 $1,970,453
2023 $139,726 $2,266,440 $490,297 $1,776,143
2022 $139,726 $1,551,595 $538,619 $1,012,976
2021 $128,400 $1,499,850 $520,656 $979,194
2020 $136,717 $1,649,835 $520,656 $1,129,179
2019 $140,009 $1,740,268 $518,220 $1,222,048
2018 $60,942 $1,481,316 $409,970 $1,071,346
2017 $110,658 $1,472,774 $407,606 $1,065,168
2016 $106,795 $1,506,669 $388,048 $1,118,621
2015 $103,672 $1,786,820 $360,539 $1,426,281
2014 $29,175 $1,583,673 $458,626 $1,125,047
2012 $142,063 $1,802,083 $461,302 $1,340,781
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD10489964

Midwest Real Estate Data (MRED)

APN: 16-14-403-007