NOT LISTED FOR SALE

151 N Berteau Ave Elmhurst, IL 60126

Estimated Value: $1,071,000 - $1,540,000

4 Beds
4.5 Baths
4,018 Sq Ft
$348/Sq Ft Est. Value

Sale Details

Date Sold: January 28, 2015

Last sale price $821,500 $204 Per Sq Ft

Est. 70% increase in value since last sale

Current estimated payment $9,452 / mo

Highlights

  • Landscaped Professionally
  • Family Room with Fireplace
  • Traditional Architecture
  • Field Elementary School Rated A
  • Recreation Room
  • Wood Flooring

About This Home

As of January 2015

Walk To Town From This 4,000 Sq FT Outstanding Family Home. Brick & Stone. 3 Car Garage. Open Floor Plan. Formal Living & Dining. Gourmet Kitchen. Enormous Family Rm. 1st Floor Office. Mud Rm. Master Suit w/Spa Bath. Spacious Bedrooms. 3 Bathrooms up. Finished Basement w/Great Wet Bar, Rec Room, Game Area, 5th Bedrm, Storage/craft rm. Prvt (Park-Like) Back Yard W/Paver Patio. Great Home, Great Finishes, Great Area

Last Agent to Sell the Property

Tim Schiller

@properties Christie's International Real Estate License #475127707 Listed on: 12/04/2014

@properties Christie's International Real Estate

Co-Listed By

Amy Schiller

@properties Christie's International Real Estate License #475102253

Last Buyer's Agent

Lisa McNicholas

Keller Williams Premiere Properties License #471008639

Keller Williams Premiere Properties

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,632

Year Built

  • Built in 2004

Lot Details

  • 9,544 Sq Ft Lot
  • Lot Dimensions are 50 x 175
  • Landscaped Professionally
  • Paved or Partially Paved Lot

Parking

  • 3 Car Attached Garage
  • Garage Transmitter
  • Garage Door Opener
  • Driveway
  • Parking Included in Price

Home Design

  • Traditional Architecture
  • Brick or Stone Mason
  • Asphalt Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 4,018 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Bar
  • Wood Burning Fireplace
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Recreation Room
  • Game Room
  • Lower Floor Utility Room
  • Storage Room
  • Utility Room with Study Area
  • Storm Screens

Flooring

  • Wood
  • Laminate

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 5 Potential Bedrooms
  • Dual Sinks
  • Whirlpool Bathtub
  • Separate Shower

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

  • Basement Fills Entire Space Under The House
  • Fireplace in Basement
  • Finished Basement Bathroom

Outdoor Features

  • Patio

Schools

  • Field Elementary School
  • Sandburg Middle School
  • York Community High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Lake Michigan Water

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,632

Year Built

Built in 2004

Lot Details

9,544 Sq Ft Lot

Parking

3

Listing Details

  • Property Type: Residential
  • Property Type: Detached Single
  • Type Detached: 2 Stories
  • Ownership: Fee Simple
  • ArchitecturalStyle: Traditional
  • New Construction: No
  • Property Sub-Type: 2 Stories
  • Year Built: 2004
  • Age: 6-10 Years
  • Built Before 1978 (Y/N): No
  • Disability Access and/or Equipped: No
  • General Information: School Bus Service,Commuter Bus,Commuter Train,Interstate Access
  • Rehab (Y/N): No
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Basement: Full
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bathrooms: 5
  • Total Bedrooms: 4
  • Fireplace Features: Wood Burning
  • Fireplaces: 2
  • Interior Amenities: Bar-Wet, Hardwood Floors, Wood Laminate Floors, First Floor Laundry
  • LivingArea: 4018
  • Room Type: Bedroom 5, Breakfast Room, Game Room, Recreation Room, Study, Storage, Utility Room-Lower Level
  • Basement Description: Finished
  • Bathroom Amenities: Whirlpool,Separate Shower,Double Sink
  • Basement Bathrooms: Yes
  • Below Grade Bedrooms: 1
  • Dining Room: Separate
  • Fireplace Location: Family Room,Basement

Exterior Features

  • ExteriorFeatures: Patio, Storms/Screens
  • Foundation Details: Concrete Perimeter
  • Lot Features: Landscaped
  • Roof: Asphalt
  • Waterfront: No
  • Exterior Building Type: Brick,Stone

Garage/Parking

  • Garage Spaces: 3
  • Number of Cars: 3
  • Driveway: Concrete
  • Garage Details: Garage Door Opener(s),Transmitter(s)
  • Garage On-Site: Yes
  • Garage Ownership: Owned
  • Garage Type: Attached
  • Parking: Garage

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Natural Gas, Forced Air
  • Water Source: Lake Michigan

Condo/Co-op/Association

  • Association Fee Frequency: Not Applicable
  • Community Features: Sidewalks, Street Lights, Street Paved
  • Master Association Fee: No

Fee Information

  • Association Fee Includes: None

Schools

  • Elementary School: FIELD ELEMENTARY SCHOOL
  • High School: YORK COMMUNITY HIGH SCHOOL
  • Middle/Junior School: SANDBURG MIDDLE SCHOOL

Lot Info

  • Lot Size Acres: 0.2191
  • Lot Dimensions: 50 X 175
  • Lot Size: Less Than .25 Acre
  • Special Assessments: N

Rental Info

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

Tax Info

  • Tax Annual Amount: 14631.58
  • Tax Year: 2012

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 4, 2014
Closed on
Jan 23, 2015
Sold by
Bought by
Seller's Agent
Tim Schiller
@properties Christie's International Real Estate
Buyer's Agent
Lisa McNicholas
Keller Williams Premiere Properties
List Price
$870,000
Sold Price
$821,500
Premium/Discount to List
-$48,500
-5.57%
Current Estimated Value
$1,399,018

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$577,518
Avg. Annual Appreciation
4.76%
Original Mortgage
$657,200
Outstanding Balance
$506,342
Interest Rate
4%
Mortgage Type
New Conventional
Estimated Equity
$892,676

Purchase Details

Closed on
Mar 2, 2012
Sold by
Bought by

Purchase Details

Closed on
Mar 26, 2004
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$333,700
Interest Rate
5.65%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Aug 27, 2003
Sold by
Bought by

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 14, 2002
Sold by
Bought by

Purchase Details

Closed on
Jun 10, 2002
Sold by
Bought by
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$821,500 First American Title Ins Co
-- None Available
-- None Available
$720,000 Metropolitan Title Company
$250,000 Git
-- --
$204,000 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $657,200
Previous Owner $333,700
Previous Owner $187,500
Closed $242,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
01/28/2015 01/28/15 Sold $821,500 -5.6% $204 / Sq Ft
12/04/2014 12/04/14 Pending -- -- --
12/04/2014 12/04/14 For Sale $870,000 -- $217 / Sq Ft
Source: Midwest Real Estate Data (MRED)

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $23,269 $394,106 $102,755 $291,351
2023 $21,639 $364,440 $95,020 $269,420
2022 $20,879 $350,320 $91,340 $258,980
2021 $20,371 $341,610 $89,070 $252,540
2020 $19,592 $334,130 $87,120 $247,010
2019 $19,198 $317,670 $82,830 $234,840
2018 $17,307 $285,370 $78,400 $206,970
2017 $16,944 $271,940 $74,710 $197,230
2016 $16,607 $256,180 $70,380 $185,800
2015 $16,467 $238,660 $65,570 $173,090
2014 $15,175 $202,920 $52,060 $150,860
2013 $15,007 $205,780 $52,790 $152,990
Source: Public Records

Agents Affiliated with this Home

  • Tim Schiller

    Seller's Agent in 2015

    Tim Schiller

    @ Properties

    (630) 992-0582

    931 Total Sales

    Tim Schiller
    Section Image
  • Amy Schiller

    Seller Co-Listing Agent in 2015

    Amy Schiller

    @ Properties

    (630) 814-4065

    63 Total Sales

    Amy Schiller
    Section Image

  • L

    Buyer's Agent in 2015

    Lisa McNicholas

    Keller Williams Premiere Properties

    Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: 08796730

Midwest Real Estate Data (MRED)

APN: 06-01-211-006

Illinois DuPage County Elmhurst 60126

151 N Berteau Ave, Elmhurst, IL

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Midwest Real Estate Data (MRED) All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website.
Listings courtesy of Midwest Real Estate Data (MRED) as distributed by MLS GRID.
Based on information submitted to the MLS GRID

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.