NOT LISTED FOR SALE

200 Dundee Rd Barrington, IL 60010

Estimated Value: $1,142,000 - $1,243,146

4 Beds
4 Baths
3,232 Sq Ft
$370/Sq Ft Est. Value

Last Sold November 18, 2020

Last sale price $910,000 $282 Per Sq Ft

Est. 31% increase in value since last sale

Current estimated payment $7,990/month

29 Days on Market

Highlights

  • Horses Allowed On Property
  • Second Kitchen
  • Landscaped Professionally
  • Countryside Elementary School Rated A
  • Updated Kitchen
  • Mature Trees

About This Home

As of November 2020

Experience the best of both country and suburban living in this completely updated 4 bedroom, 4 bathroom all brick ranch-style farmhouse with a walkout lower level; nestled amongst 5+ acres of trees and rolling hills in the desirable Barrington Hills community. Bring your hobby or animals - all kinds of livestock are welcome here! The land comes with a new heated barn with 6 dutch door matted stalls, wide concrete aisle, water, hay storage, workshop, feed room and tack room with HVAC; all weather paddock; three fenced grass pastures with large run-ins make rotational grazing simple; deluxe chicken coop with flat panel heaters, temperature controlled exhaust fan and storage closet; and fenced gardening space that keeps crops out of reach from free-ranging chicken and ducks. The barn can double as a party space, car storage or workshop; while the coop can double as a shed or playhouse. Modern day living is just around the corner with acclaimed schools, country clubs, shopping, dining and entertainment. Step into a welcoming vaulted foyer, flanked by the library/office and dining room. The library/office features french doors for privacy when working from home; and a wall of built-in shelving and cabinets for storing books or displaying heirlooms. Beyond the foyer lies the great room and kitchen - both spaces boast vaulted ceilings for added spaciousness. Sliding barn doors with hand forged handles can be opened to create one seamless living space or closed to section off each space. The new farmhouse-style kitchen features charming checkerboard floors, sage green cabinets, caesarstone countertops, deep farmhouse sink and Viking appliances. A new butler's pantry with wine fridges and ample storage connects the kitchen to the dining room, making entertaining a breeze. Gorgeous 3-season screened porch with wraparound windows, skylights, vaulted ceilings, electric stove heater; and adjacent raised deck overlook a professionally landscaped perennial garden. Rest and relax in a spacious master suite with a new air tub, glass-enclosed shower, double vanities and two walk-in closets. Two additional bedrooms that share a new full marble bathroom complete the main level of the home. The walkout lower level, fully finished with 9' ceilings and a wall of windows that fill the space with natural light, features an ensuite bedroom, basement kitchen, exercise room, recreation room and access to the outdoor patio - ideal for an in-law arrangement or guest quarters. Additional updates to the home includes: new wood floors, new light fixtures, door hardware, newer HVAC and newer roof.

Last Agent to Sell the Property

Sheryl Graff

Compass License #475156206 Listed on: 09/10/2020

Compass

Last Buyer's Agent

Patti Boulahanis

RE/MAX Suburban License #475133390

RE/MAX Suburban

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $20,117

Year Built | Renovated

  • 1991 | 2015

Lot Details

  • Southern Exposure
  • Landscaped Professionally
  • Mature Trees
  • Wooded Lot

Parking

  • Attached Garage
  • Garage Door Opener
  • Circular Driveway
  • Gravel Driveway
  • Parking Included in Price
  • Garage Is Owned

Home Design

  • Walk-Out Ranch
  • Brick Exterior Construction
  • Slab Foundation
  • Asphalt Shingled Roof

Interior Spaces

  • Wet Bar
  • Vaulted Ceiling
  • Attached Fireplace Door
  • Gas Log Fireplace
  • Library
  • Recreation Room
  • Screened Porch
  • Home Gym
  • Wood Flooring

Kitchen

  • Updated Kitchen
  • Second Kitchen
  • Breakfast Bar
  • Walk-In Pantry
  • Butlers Pantry
  • Oven or Range
  • Range Hood
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Stainless Steel Appliances
  • Kitchen Island
  • Built-In or Custom Kitchen Cabinets

Bedrooms and Bathrooms

  • In-Law or Guest Suite
  • Dual Sinks
  • Whirlpool Bathtub
  • Separate Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Exterior Basement Entry
  • 9 Foot Basement Ceiling Height
  • Finished Basement Bathroom

Utilities

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

Additional Features

  • Deck
  • Horses Allowed On Property

Listing and Financial Details

  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Est. Annual Taxes

$20,117

Year Built | Renovated

1991 | 2015

Lot Details

0

Parking

3

Listing Details

  • Property Type: Detached Single
  • General Information: School Bus Service
  • Recent Rehab: Yes
  • Age: 26-30 Years
  • Full Bathrooms: 4
  • Number Interior Fireplaces: 2
  • Ownership: Fee Simple
  • Rehab Year: 2015
  • Square Footage Comments: Above grade is 3,232 sq ft and finished walk-out basement is 2,000 sq ft approximately
  • Total Full or Half Bathrooms: 4
  • Total Sq Ft: 3232
  • Style Of House: Walk-Out Ranch
  • Type Detached: 1 Story
  • Estimated Year Built: 1991
  • Tax Exemptions: Homeowner
  • Total Sq Ft: 3232
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 1991
  • Year Renovated: 2015

Interior Features

  • Interior Property Features: Vaulted/Cathedral Ceilings, Bar-Wet, Hardwood Floors, In-Law Arrangement, 1st Floor Laundry
  • Number Of Rooms: 11
  • Appliances: Oven/Range, Microwave, Dishwasher, Refrigerator, Washer, Dryer, All Stainless Steel Kitchen Appliances, Wine Cooler/Refrigerator, Range Hood
  • Equipment: Water-Softener Rented, Central Vacuum, CO Detectors, Ceiling Fan, Sump Pump
  • Fireplace Details: Attached Fireplace Doors/Screen, Gas Logs
  • Fireplace Location: Family Room, Basement
  • Basement: Finished, Exterior Access, 9 ft + pour
  • Basement Bathrooms: Yes
  • Bedrooms All Levels: 4
  • Bathroom Amenities: Whirlpool, Separate Shower, Double Sink
  • Above Grade Bedrooms: 4
  • Laundry: Dimensions: 18X9, On Level: Main Level, Flooring: Porcelain Tile
  • Dining Room: Dimensions: 19X14, On Level: Main Level, Flooring: Hardwood
  • Kitchen Type: Dimensions: 18X13, On Level: Main Level, Flooring: Porcelain Tile
  • Kitchen Type: Eating Area-Table Space, Island, Pantry-Butler, Pantry-Closet, Custom Cabinetry, Updated Kitchen
  • Additional Rooms: 2nd Kitchen, Recreation Room, Library, Exercise Room, Deck, Screened Porch
  • Master Bedroom: Dimensions: 22X14, On Level: Main Level, Flooring: Hardwood
  • Additional Room 1 Name: 2nd Kitchen, Dimensions: 15X14, On Level: Walkout Basement, Flooring: Ceramic Tile
  • Additional Room 2 Name: Recreation Rm, Dimensions: 40X19, On Level: Walkout Basement, Flooring: Carpet
  • Bedroom 2: Dimensions: 19X11, On Level: Main Level, Flooring: Hardwood
  • Additional Room 3 Name: Library, Dimensions: 18X13, On Level: Main Level, Flooring: Hardwood
  • Bedroom 3: Dimensions: 16X12, On Level: Main Level, Flooring: Hardwood
  • Additional Room 4 Name: Exercise Rm, Dimensions: 28X12, On Level: Walkout Basement, Flooring: Wood Laminate
  • Bedroom 4: Dimensions: 30X13, On Level: Walkout Basement, Flooring: Carpet
  • Additional Room 6 Name: Deck, Dimensions: 22X15, On Level: Main Level
  • Additional Room 7 Name: Screened Porch, Dimensions: 19X15, On Level: Main Level
  • Estimated Sq Ft: 3232
  • Estimated Total Finished Sq Ft: 5232
  • Basement Finished Sq Ft: 2000
  • Upper Level Sq Ft: 3232
  • Dining Room Type: Separate
  • Family Room: Dimensions: 31X20, On Level: Main Level, Flooring: Hardwood

Exterior Features

  • Foundation: Concrete
  • Lot Size: 5.0-5.99 Acres
  • Exterior Building Type: Brick
  • Roof Type: Asphalt/Glass (Shingles)
  • Exterior Property Features: Deck, Porch Screened, Brick Paver Patio
  • Exposure: S (South)
  • Acreage: 5.691

Garage/Parking

  • Number of Cars: 3
  • Parking: Garage
  • Garage Type: Attached
  • Garage Details: Garage Door Opener(s)
  • Garage On Site: Yes
  • Number Garage Spaces: 3
  • Driveway: Asphalt, Gravel, Circular
  • Parking Included In Price: Yes
  • Garage Ownership: Owned

Utilities

  • Electricity: Circuit Breakers
  • Air Conditioner: Central Air
  • Water: Well-Private
  • Sewer: Septic-Private
  • Heating Fuel: Gas, Forced Air

Condo/Co-op/Association

  • Assessed Sq Ft: 3232

Schools

  • School District: 220
  • Elementary School: Countryside Elementary School
  • Middle School: Barrington Middle School Prairie
  • High School: Barrington High School
  • Junior High Dist: 220

Lot Info

  • Lot Dimensions: 629X762X442X136X300
  • Lot Description: Horses Allowed, Landscaped Professionally, Wooded, Mature Trees
  • Parcel Identification Number: 01164030280000

Tax Info

  • Taxes: 15140.74

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 10, 2020
Closed on
Nov 7, 2020
Sold by
Wegbreit Samuel and Wegbreit Elizabeth
Bought by
Atamian Joseph and Atamian Hilary H
Seller's Agent
Sheryl Graff
Compass
Buyer's Agent
Patti Boulahanis
RE/MAX Suburban
List Price
$949,000
Sold Price
$910,000
Premium/Discount to List
-$39,000
-4.11%
Current Estimated Value
$1,194,537

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$284,537
Avg. Annual Appreciation
5.67%
Original Mortgage
$728,000
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Listed on
Apr 22, 2014
Closed on
Jul 10, 2014
Sold by
Schmidt Lawrence and Schmidt Susan
Bought by
Wegbreit Samuel and Wegbreit Elizabeth
Seller's Agent
Andy Murphy
Century 21 Integra
Buyer's Agent
Kerry Luitgaarden
@properties
List Price
$720,000
Sold Price
$670,000
Premium/Discount to List
-$50,000
-6.94%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.93%

Purchase Details

Closed on
Oct 6, 2011
Sold by
Schmidt Lawrence and Schmidt Susan
Bought by
Schmidt Lawrence P and Schmidt Susan M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$380,000
Interest Rate
2.62%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 5, 2011
Sold by
Schmidt Lawrence P and Schmidt Susan M
Bought by
Schmidt Lawrence and Schmidt Susan

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$380,000
Interest Rate
2.62%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 2, 2010
Sold by
Schmidt Lawrence P and Schmidt Susan
Bought by
The Lawrence & Susan Schmidt Revocable L

Purchase Details

Closed on
Dec 29, 1995
Sold by
Lasalle National Trust Na
Bought by
A & D Classic Enterprises Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$225,000
Interest Rate
7.36%
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
Atamian Joseph $910,000 Chicago Title
Wegbreit Samuel $670,000 Precision Title
Schmidt Lawrence P -- Prism Title
Schmidt Lawrence -- Prism Title
The Lawrence & Susan Schmidt Revocable L -- None Available
A & D Classic Enterprises Inc $235,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Atamian Joseph $728,000
Previous Owner Schmidt Lawrence P $380,000
Previous Owner A & D Classic Enterprises Inc $225,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
11/18/2020 11/18/20 Sold $910,000 -4.1% $282 / Sq Ft
10/09/2020 10/09/20 Pending -- -- --
09/10/2020 09/10/20 For Sale $949,000 +41.6% $294 / Sq Ft
07/10/2014 07/10/14 Sold $670,000 -6.9% $207 / Sq Ft View Prior Sale
06/06/2014 06/06/14 Pending -- -- --
04/22/2014 04/22/14 For Sale $720,000 -- $223 / 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 $20,117 $84,000 $24,790 $59,210
2023 $19,640 $84,000 $24,790 $59,210
2022 $19,640 $84,000 $24,790 $59,210
2021 $16,868 $63,005 $24,790 $38,215
2020 $15,565 $63,005 $24,790 $38,215
2019 $15,141 $70,006 $24,790 $45,216
2018 $14,767 $67,000 $18,592 $48,408
2017 $14,456 $67,000 $18,592 $48,408
2016 $13,870 $67,000 $18,592 $48,408
2015 $16,141 $67,000 $12,395 $54,605
2014 $16,142 $69,698 $12,395 $57,303
2013 $15,490 $69,698 $12,395 $57,303
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD10852739

Midwest Real Estate Data (MRED)

APN: 01-16-403-028-0000