NOT LISTED FOR SALE

Estimated Value: $2,535,000 - $3,401,000

6 Beds
8 Baths
15,000 Sq Ft
$191/Sq Ft Est. Value

Last Sold April 24, 2017

Last sale price $2,400,000 $160 Per Sq Ft

Est. 19% increase in value since last sale

Current estimated payment $19,205/month

178 Days on Market

Highlights

  • Home Theater
  • Landscaped Professionally
  • Recreation Room
  • Countryside Elementary School Rated A
  • Deck
  • Vaulted Ceiling

About This Home

As of April 2017

Absolutely stunning country estate in Barrington Hills. Built in finest European style and quality. Mahogany doors & trim, heated patio, sidewalk & garage apron. Huge 3 car and 2 car garages. 1st floor & 2nd floor master suites. Full size elevator. Exceptional walk-out lower level with high ceilings, bar, theater, exercise room. Home features large rooms and exceptional finishes. Radiant floors. Too much to even try to list!

Last Agent to Sell the Property

John Morrison

@properties Christie's International Real Estate License #471000101 Listed on: 04/11/2016

@properties Christie's International Real Estate

Last Buyer's Agent

Dean Tubekis

Coldwell Banker Realty License #475137834

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Year Built

  • 2008

Lot Details

  • Landscaped Professionally

Parking

  • Attached Garage
  • Garage ceiling height seven feet or more
  • Heated Garage
  • Garage Transmitter
  • Garage Door Opener
  • Driveway
  • Garage Is Owned

Home Design

  • Mediterranean Architecture
  • Slab Foundation
  • Slate Roof
  • Stone Siding
  • Stucco Exterior

Interior Spaces

  • Vaulted Ceiling
  • Skylights
  • Wood Burning Fireplace
  • Gas Log Fireplace
  • Breakfast Room
  • Home Theater
  • Home Office
  • Recreation Room
  • Sun or Florida Room
  • Utility Room with Study Area
  • Home Gym
  • Finished Basement
  • Finished Basement Bathroom

Kitchen

  • Walk-In Pantry
  • Butlers Pantry
  • Double Oven
  • Indoor Grill
  • Microwave
  • Freezer
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • Main Floor Bedroom
  • Primary Bathroom is a Full Bathroom
  • Bidet
  • Dual Sinks
  • Whirlpool Bathtub
  • Separate Shower

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Balcony
  • Deck
  • Patio

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Hot Water Heating System
  • Heating System Uses Gas
  • Individual Controls for Heating
  • Well
  • Private or Community Septic Tank

Listing and Financial Details

  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Year Built

2008

Lot Details

0

Parking

5

Listing Details

  • Property Type: Detached Single
  • General Information: School Bus Service
  • Age: 6-10 Years
  • Full Bathrooms: 7
  • Half Bathrooms: 1
  • Number Interior Fireplaces: 4
  • Ownership: Fee Simple
  • Total Full or Half Bathrooms: 7.1
  • Style Of House: Mediter./Spanish
  • Type Detached: 2 Stories
  • Estimated Year Built: 2008
  • Tax Exemptions: Homeowner
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2008

Interior Features

  • Interior Property Features: Vaulted/Cathedral Ceilings, Skylight(s), 1st Floor Bedroom
  • Number Of Rooms: 16
  • Living Room: Dimensions: 18X14, On Level: Main Level, Flooring: Hardwood, Windows: Blinds
  • Appliances: Oven-Double, Microwave, Dishwasher, Refrigerator, Freezer, Washer, Dryer, Disposal, Grill-Indoor
  • Equipment: Humidifier, Water-Softener Owned, Central Vacuum, Security System, Intercom, CO Detectors, Ceiling Fan, Sump Pump, Air Cleaner
  • Fireplace Details: Wood Burning, Gas Logs
  • Attic: Pull Down Stair, Unfinished
  • Fireplace Location: Family Room, Basement
  • Basement: Finished
  • Basement Bathrooms: Yes
  • Bedrooms All Levels: 6
  • Primary Bedroom Bath: Full
  • Bathroom Amenities: Whirlpool, Separate Shower, Double Sink, Bidet
  • Above Grade Bedrooms: 6
  • Laundry: Dimensions: 15X12, On Level: Main Level, Flooring: Stone, Windows: Blinds
  • Dining Room: Dimensions: 18X14, On Level: Main Level, Flooring: Hardwood, Windows: Blinds
  • Kitchen Type: Dimensions: 20X18, On Level: Main Level, Flooring: Hardwood, Windows: Blinds
  • Kitchen Type: Pantry-Butler, Pantry-Walk-in
  • Additional Rooms: 5th Bedroom, 6th Bedroom, Breakfast Room, Exercise Room, Office, Recreation Room, Study, Sun/Florida Room, Theatre Room
  • Master Bedroom: Dimensions: 22X20, On Level: Main Level, Flooring: Hardwood, Windows: None
  • Additional Room 1 Name: Study, Dimensions: 17X14, On Level: Main Level, Flooring: Hardwood, Windows: Blinds
  • Additional Room 2 Name: Office, Dimensions: 31X22, On Level: 2nd Level, Flooring: Hardwood, Windows: Blinds
  • Bedroom 2: Dimensions: 23X17, On Level: 2nd Level, Flooring: Hardwood, Windows: None
  • Additional Room 3 Name: 5th Bdrm, Dimensions: 17X14, On Level: 2nd Level, Flooring: Hardwood, Windows: Blinds
  • Bedroom 3: Dimensions: 17X15, On Level: 2nd Level, Flooring: Hardwood, Windows: None
  • Additional Room 4 Name: 6th Bdrm, Dimensions: 20X18, On Level: Walkout Basement, Flooring: Carpet, Windows: Blinds
  • Bedroom 4: Dimensions: 20X14, On Level: 2nd Level, Flooring: Hardwood, Windows: None
  • Additional Room 5 Name: Breakfast Rm, Dimensions: 14X20, On Level: Main Level, Flooring: Hardwood, Windows: Blinds
  • Additional Room 6 Name: Theater Rm, Dimensions: 19X15, On Level: Walkout Basement, Flooring: Carpet, Windows: None
  • Additional Room 7 Name: Exercise Rm, Dimensions: 20X15, On Level: Walkout Basement, Flooring: Carpet, Windows: Blinds
  • Additional Room 8 Name: Recreation Rm, Dimensions: 47X23, On Level: Walkout Basement, Flooring: Carpet, Windows: Blinds
  • Additional Room 9 Name: Bar, Dimensions: 21X15, On Level: Walkout Basement, Flooring: Ceramic Tile, Windows: None
  • Additional Room 10 Name: Sunroom, Dimensions: 17X26, On Level: Main Level, Flooring: Ceramic Tile, Windows: Blinds
  • Estimated Sq Ft: 15000
  • Dining Room Type: Separate
  • Family Room: Dimensions: 22X21, On Level: Main Level, Flooring: Hardwood, Windows: Blinds

Exterior Features

  • Foundation: Concrete
  • Lot Size: 5.0-5.99 Acres
  • Exterior Building Type: Stucco, Stone
  • Roof Type: Slate
  • Exterior Property Features: Balcony, Deck, Patio
  • Acreage: 5.67

Garage/Parking

  • Number of Cars: 5
  • 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: 5
  • Driveway: Concrete
  • Garage Ownership: Owned

Utilities

  • Electricity: Circuit Breakers, 200+ Amp Service
  • Air Conditioner: Central Air, Zoned
  • Water: Well-Private
  • Sewer: Septic-Private
  • Heating Fuel: Gas, Forced Air, Hot Water/Steam, 2+ Sep Heating Systems, Indv Controls, Zoned

Schools

  • Junior High Dist: 220

Lot Info

  • Lot Dimensions: 480 X 480
  • Lot Description: Landscaped Professionally
  • Parcel Identification Number: 2030376006

Tax Info

  • Taxes: 52352

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 11, 2016
Closed on
Apr 24, 2017
Sold by
Untiedt Olga and Pinderski Jerome W
Bought by
Trehan Sunil K and Trehan Sangita W
Seller's Agent
John Morrison
@properties Christie's International Real Estate
Buyer's Agent
Dean Tubekis
Coldwell Banker Realty
List Price
$2,525,000
Sold Price
$2,400,000
Premium/Discount to List
-$125,000
-4.95%
Current Estimated Value
$2,858,491

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$458,491
Avg. Annual Appreciation
2.03%
Original Mortgage
$420,000
Outstanding Balance
$285,569
Interest Rate
4.3%
Mortgage Type
Commercial
Estimated Equity
$2,572,922

Purchase Details

Closed on
Oct 20, 2016
Sold by
Untiedt Olga M and Untiedt Jerome A
Bought by
Untiedt Olga M and Pinderski Jerome W
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
Trehan Sunil K $2,400,000 Fidelity National Title
Untiedt Olga M -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Trehan Sunil K $420,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/24/2017 04/24/17 Sold $2,400,000 -5.0% $160 / Sq Ft
10/06/2016 10/06/16 Pending -- -- --
04/11/2016 04/11/16 For Sale $2,525,000 -- $168 / 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 $51,092 $718,250 $94,140 $624,110
2023 $55,716 $642,384 $84,196 $558,188
2022 $61,407 $754,091 $104,538 $649,553
2021 $59,506 $702,526 $97,390 $605,136
2020 $60,632 $677,656 $93,942 $583,714
2019 $59,660 $751,847 $125,197 $626,650
2018 $56,631 $694,546 $115,655 $578,891
2017 $53,585 $654,306 $108,954 $545,352
2016 $51,205 $613,680 $102,189 $511,491
2013 -- $572,484 $95,329 $477,155
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD09190815

Midwest Real Estate Data (MRED)

APN: 20-30-376-006