NOT LISTED FOR SALE

84 Dundee Ln Barrington, IL 60010

Estimated Value: $3,503,791 - $7,607,000

6 Beds
10 Baths
13,000 Sq Ft
$380/Sq Ft Est. Value

Sale Details

Date Sold: March 18, 2020

Last sale price $4,050,000 $312 Per Sq Ft

Est. 22% increase in value since last sale

Current estimated payment $32,107 / mo

63 Days on Market

Highlights

  • Lake Front
  • Horses Allowed On Property
  • Heated Floors
  • Grove Avenue Elementary School Rated A+
  • In Ground Pool
  • Recreation Room

About This Home

As of March 2020

Redefining luxury in Barrington Hills, this exquisite custom home offers architecture that is elegant and timeless, authentic and yet unbuttoned in just the right way. Set on a magnificent 5 acre waterfront lot with towering trees and pristinely manicured lawns, this residence represents the ultimate in beauty and lifestyle. Gracious proportions, stylish finishes and solid craftsmanship are evident throughout this property that boasts 22 rooms including 6 bedrooms, 7 full and 3 half baths, 10 fireplaces and 3 laundry rooms. This amazing home is ideal for large scale entertaining and relaxed family fun, featuring grand sized formal rooms, enormous family room, striking kitchen, his and her offices and first floor master bedroom suite with private terrace and luxury master bath with his and her walk-in closets. The second level offers four secondary bedroom suites each with private sitting rooms, en suite baths and walk-in closets. The seamlessly flowing floor plan can be accessed via elevator or the custom curved staircase. Fall in love with the walkout lower level with multiple entertaining, recreation and game rooms including a sports court, exercise and pool room. The amazing lifestyle continues outdoors to gorgeous terraces and patios, stunning infinity edge pool, spa and fabulous water views. A truly extraordinary offering.

Last Agent to Sell the Property

John Morrison

@properties Christie's International Real Estate License #471000101 Listed on: 10/10/2019

@properties Christie's International Real Estate

Last Buyer's Agent

John Morrison

@properties Christie's International Real Estate License #471000101 Listed on: 10/10/2019

@properties Christie's International Real Estate

Home Details

Home Type

  • Single Family

Year Built

  • 2015

Lot Details

  • Lake Front
  • Wooded Lot

HOA Fees

  • $25 per month

Parking

  • Attached Garage
  • Garage ceiling height seven feet or more
  • Heated Garage
  • Garage Transmitter
  • Garage Door Opener
  • Circular Driveway
  • Parking Included in Price
  • Garage Is Owned

Home Design

  • Slab Foundation
  • Wood Shingle Roof
  • Stone Siding

Interior Spaces

  • Elevator
  • Wet Bar
  • Built-In Features
  • See Through Fireplace
  • Gas Log Fireplace
  • Sitting Room
  • Dining Area
  • Home Office
  • Recreation Room
  • Game Room
  • Utility Room with Study Area
  • Home Gym
  • Water Views
  • Finished Basement
  • Finished Basement Bathroom

Kitchen

  • Breakfast Bar
  • Walk-In Pantry
  • Butlers Pantry
  • Double Oven
  • Range Hood
  • Microwave
  • High End Refrigerator
  • Freezer
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Heated Floors

Bedrooms and Bathrooms

  • Main Floor Bedroom
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Bathroom on Main Level
  • Dual Sinks
  • Soaking Tub
  • Steam Shower
  • Separate Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Pool

  • In Ground Pool
  • Spa

Outdoor Features

  • Balcony
  • Patio
  • Fire Pit
  • Outdoor Grill

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Gas
  • Radiant Heating System
  • Well
  • Private or Community Septic Tank

Additional Features

  • Property is near bus stop
  • Horses Allowed On Property

Home Details

Home Type

Single Family

Year Built

2015

Lot Details

5.3 Acres

HOA Fees

$25 per month

Parking

4

Listing Details

  • Property Type: Detached Single
  • General Information: School Bus Service, Commuter Bus
  • Age: 1-5 Years
  • Full Bathrooms: 7
  • Half Bathrooms: 3
  • Number Interior Fireplaces: 9
  • Ownership: Fee Simple w/ HO Assn.
  • Total Full or Half Bathrooms: 7.3
  • Type Detached: 2 Stories
  • Estimated Year Built: 2015
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2015

Interior Features

  • Interior Property Features: Bar-Wet, Elevator, Hardwood Floors, Heated Floors, 1st Floor Bedroom, 1st Floor Laundry, 2nd Floor Laundry, 1st Floor Full Bath, Built-in Features, Walk-In Closet(s)
  • Number Of Rooms: 17
  • Living Room: Dimensions: 20X15, On Level: Main Level, Flooring: Hardwood
  • Appliances: Oven-Double, Oven/Range, Microwave, Dishwasher, High End Refrigerator, Freezer, Washer, Dryer, Disposal, All Stainless Steel Kitchen Appliances, Range Hood
  • Equipment: Humidifier, Water-Softener Owned, Sump Pump, Sprinkler-Lawn, Backup Sump Pump;, Power Generator, Multiple Water Heaters
  • Fireplace Details: See through/Multi Sided, Gas Logs, Gas Starter
  • Attic: Unfinished
  • Fireplace Location: Living Room, Master Bedroom
  • Basement: Finished
  • Basement Bathrooms: Yes
  • Bedrooms All Levels: 6
  • Primary Bedroom Bath: Full
  • Bathroom Amenities: Separate Shower, Steam Shower, Double Sink, Soaking Tub
  • Above Grade Bedrooms: 6
  • Laundry: Dimensions: 14X10, On Level: Main Level, Flooring: Hardwood
  • Dining Room: Dimensions: 20X15, On Level: Main Level, Flooring: Hardwood
  • Kitchen Type: Dimensions: 22X18, On Level: Main Level, Flooring: Hardwood
  • Kitchen Type: Eating Area-Breakfast Bar, Island, Pantry-Butler, Pantry-Walk-in
  • Additional Rooms: 5th Bedroom, Exercise Room, 6th Bedroom, Recreation Room, Game Room, Sitting Room, Eating Area, Office, Study
  • Master Bedroom: Dimensions: 27X20, On Level: Main Level, Flooring: Hardwood
  • Additional Room 1 Name: 5th Bdrm, Dimensions: 16X15, On Level: 2nd Level, Flooring: Carpet
  • Additional Room 2 Name: Exercise Rm, Dimensions: 23X18, On Level: Walkout Basement, Flooring: Carpet
  • Bedroom 2: Dimensions: 20X15, On Level: 2nd Level, Flooring: Carpet
  • Additional Room 3 Name: 6th Bdrm, Dimensions: 18X14, On Level: Walkout Basement, Flooring: Carpet
  • Bedroom 3: Dimensions: 19X15, On Level: 2nd Level, Flooring: Carpet
  • Additional Room 4 Name: Recreation Rm, Dimensions: 30X24, On Level: Walkout Basement, Flooring: Other
  • Bedroom 4: Dimensions: 20X14, On Level: 2nd Level, Flooring: Carpet
  • Additional Room 5 Name: Game Rm, Dimensions: 21X19, On Level: Walkout Basement, Flooring: Other
  • Additional Room 6 Name: Sitting, Dimensions: 17X15, On Level: 2nd Level, Flooring: Hardwood
  • Additional Room 7 Name: Eating Area, Dimensions: 18X12, On Level: Main Level, Flooring: Hardwood
  • Additional Room 8 Name: Office, Dimensions: 15X12, On Level: Main Level, Flooring: Hardwood
  • Additional Room 9 Name: Study, Dimensions: 24X15, On Level: Main Level, Flooring: Hardwood
  • Estimated Sq Ft: 13000
  • Dining Room Type: Separate
  • Family Room: Dimensions: 28X24, On Level: Main Level, Flooring: Hardwood

Exterior Features

  • Foundation: Concrete
  • Lot Size: 5.0-5.99 Acres
  • Exterior Building Type: Stone
  • Roof Type: Wood Shakes/Shingles
  • Waterfront: Yes
  • Exterior Property Features: Balcony, Patio, Hot Tub, Pool In-Ground, Outdoor Grill, Fire Pit
  • Acreage: 5.3

Garage/Parking

  • Parking: Garage
  • Garage Type: Attached
  • Garage Details: Garage Door Opener(s), Transmitter(s), Heated, 7 Foot or more high garage door
  • Garage On Site: Yes
  • Number Garage Spaces: 4.5
  • Driveway: Asphalt, Circular
  • Parking Included In Price: Yes
  • Garage Ownership: Owned

Utilities

  • Electricity: Circuit Breakers, 400 Amp Service or Greater
  • Air Conditioner: Central Air, Zoned
  • Water: Well-Private
  • Sewer: Septic-Private
  • Heating Fuel: Gas, Forced Air, Radiant, 2+ Sep Heating Systems, Zoned

Condo/Co-op/Association

  • Fee Frequency: Annual
  • Assessment Association Fees: 300
  • Management Phone: 000-000-0000

Schools

  • Junior High Dist: 220

Lot Info

  • Lot Dimensions: 312X790X453X445
  • Lot Description: Horses Allowed, Lake Front, Water View, Wooded
  • Parcel Identification Number: 01112020160000

Tax Info

  • Taxes: 55269

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 10, 2019
Closed on
Mar 13, 2020
Sold by
Schmidt Robert and Schmidt Elizabeth
Bought by
Sandhu Aqeel A and Sandhu Mariam R
Seller's Agent
John Morrison
@properties Christie's International Real Estate
Buyer's Agent
John Morrison
@properties Christie's International Real Estate
List Price
$4,750,000
Sold Price
$4,050,000
Premium/Discount to List
-$700,000
-14.74%
Current Estimated Value
$4,944,930

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$894,930
Avg. Annual Appreciation
3.33%
Original Mortgage
$3,640,950
Outstanding Balance
$3,162,317
Interest Rate
2.87%
Mortgage Type
New Conventional
Estimated Equity
$1,782,614

Purchase Details

Closed on
Aug 30, 2012
Sold by
Lageschulte Jack and Lageschulte Marilyn
Bought by
Schmidt Robert and Schmidt Elizabeth

Purchase Details

Closed on
May 2, 2000
Sold by
Wessling Richard
Bought by
Lageschulte Jack

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$488,200
Interest Rate
7.83%
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Sandhu Aqeel A $4,050,000 Proper Title
Schmidt Robert $950,000 First American Title Insuran
Lageschulte Jack $610,500 Burnet Title Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Sandhu Aqeel A $3,640,950
Previous Owner Lageschulte Jack $488,200
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/18/2020 03/18/20 Sold $4,050,000 -14.7% $312 / Sq Ft
12/12/2019 12/12/19 Pending -- -- --
10/10/2019 10/10/19 For Sale $4,750,000 -- $365 / Sq Ft
Source: Midwest Real Estate Data (MRED)

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 $70,385 $391,000 $21,090 $369,910
2024 $70,385 $297,206 $23,087 $274,119
2023 $68,689 $297,206 $23,087 $274,119
2022 $68,689 $297,206 $23,087 $274,119
2021 $49,180 $183,698 $23,086 $160,612
2020 $47,732 $183,698 $23,086 $160,612
2019 $46,418 $204,109 $23,086 $181,023
2018 $56,512 $243,251 $17,315 $225,936
2017 $55,269 $243,251 $17,315 $225,936
2016 $75,293 $350,144 $17,315 $332,829
2015 $2,781 $11,543 $11,543 $0
2014 $2,776 $11,543 $11,543 $0
2013 $21,946 $95,017 $11,543 $83,474
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD10543907

Midwest Real Estate Data (MRED)

APN: 01-11-202-016-0000

Your Personal Tour Guide

Ask me questions while you tour the home.