NOT LISTED FOR SALE

570 Ahlstrand Rd Glen Ellyn, IL 60137

Estimated Value: $947,000 - $1,863,000

4 Beds
5 Baths
3,752 Sq Ft
$392/Sq Ft Est. Value

Last Sold November 09, 2018

Last sale price $1,150,000 $307 Per Sq Ft

Est. 28% increase in value since last sale

Current estimated payment $10,850/month

44 Days on Market

Highlights

  • Spa
  • Landscaped Professionally
  • Vaulted Ceiling
  • Arbor View Elementary School Rated A
  • Recreation Room
  • Traditional Architecture

About This Home

As of November 2018

Gorgeous custom home situated on almost 1.5 acres of professionally landscaped gardens on the highly regarded Ahlstrand Road of Glen Ellyn. With over 5,500sqft of finished living space this beauty is sure to please!! 4 bedrooms and 4.1 baths(with optional 5th bedroom in the English basement). Thoughtfully laid out floor plan w/ open concept eat-in kitchen/family room combo, separate formal dining, first floor office w/ additional flex space that could be used as 2nd office or crafting room and a fantastic mudroom off 3 car garage w/ direct access to backyard patio, hot-tub and grilling area. Huge master suite upstairs with sitting area, large master closet and three other bedrooms(one is jack-n-jill and the other w/ en-suite). Huge finished basement w/ exercise room, full bath, bar, plenty of recreation space and storage w/ direct access to garage. Wonderful upgrades like a whole house generator, fire and lawn sprinkler, high efficiency windows, stone fireplace and sound system!

Last Agent to Sell the Property

Matthew Todd

Coldwell Banker Real Estate Group License #475155729 Listed on: 08/11/2018

Coldwell Banker Real Estate Group

Last Buyer's Agent

Luigui Corral

RE/MAX American Dream License #471019538

RE/MAX American Dream

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $31,533

Year Built

  • 2007

Lot Details

  • East or West Exposure
  • Landscaped Professionally
  • Irregular Lot

Parking

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

Home Design

  • Traditional Architecture
  • Slab Foundation
  • Asphalt Shingled Roof
  • Stone Siding
  • Cedar

Interior Spaces

  • Dry Bar
  • Vaulted Ceiling
  • Skylights
  • Wood Burning Fireplace
  • Fireplace With Gas Starter
  • Mud Room
  • Entrance Foyer
  • Sitting Room
  • Breakfast Room
  • Home Office
  • Recreation Room
  • Storage Room
  • Laundry on main level
  • Utility Room with Study Area
  • Home Gym
  • Wood Flooring
  • Storm Screens

Kitchen

  • Walk-In Pantry
  • Butlers Pantry
  • Double Oven
  • Microwave
  • High End Refrigerator
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • Primary Bathroom is a Full Bathroom
  • Dual Sinks
  • Whirlpool Bathtub
  • Shower Body Spray
  • Separate Shower

Finished Basement

  • Exterior Basement Entry
  • Finished Basement Bathroom

Outdoor Features

  • Spa
  • Patio

Utilities

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

Listing and Financial Details

  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Est. Annual Taxes

$31,533

Year Built

2007

Lot Details

0

Parking

3

Listing Details

  • Property Type: Detached Single
  • Age: 11-15 Years
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Number Interior Fireplaces: 1
  • Ownership: Fee Simple
  • Total Full or Half Bathrooms: 4.1
  • Style Of House: Traditional
  • Type Detached: 2 Stories
  • Estimated Year Built: 2007
  • Tax Exemptions: Homeowner
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2007

Interior Features

  • Interior Property Features: Vaulted/Cathedral Ceilings, Skylight(s), Bar-Dry, Hardwood Floors, 1st Floor Laundry
  • Number Of Rooms: 13
  • Appliances: Oven-Double, Microwave, Dishwasher, High End Refrigerator, Disposal, All Stainless Steel Kitchen Appliances
  • Equipment: Humidifier, Fire Sprinklers, Ceiling Fan, Sump Pump, Sprinkler-Lawn, Air Cleaner, Backup Sump Pump;, Radon Mitigation System(s), Power Generator
  • Fireplace Details: Wood Burning, Gas Starter
  • Fireplace Location: Family Room
  • Basement: Finished, Exterior Access
  • Basement Bathrooms: Yes
  • Bedrooms All Levels: 4
  • Primary Bedroom Bath: Full
  • Bathroom Amenities: Whirlpool, Separate Shower, Double Sink, Full Body Spray Shower
  • Above Grade Bedrooms: 4
  • Laundry: Dimensions: 10X8, On Level: Main Level, Flooring: Ceramic Tile, Windows: Curtains/Drapes
  • Dining Room: Dimensions: 14X13, On Level: Main Level, Flooring: Hardwood, Windows: Curtains/Drapes
  • Kitchen Type: Dimensions: 18X18, On Level: Main Level, Flooring: Hardwood, Windows: Curtains/Drapes
  • Kitchen Type: Island, Pantry-Butler, Pantry-Walk-in
  • Additional Rooms: Breakfast Room, Office, Study, Recreation Room, Sitting Room, Exercise Room, Foyer, Mud Room, Storage
  • Master Bedroom: Dimensions: 20X16, On Level: 2nd Level, Flooring: Carpet, Windows: Curtains/Drapes
  • Additional Room 1 Name: Breakfast Rm, Dimensions: 12X9, On Level: Main Level, Flooring: Hardwood, Windows: Curtains/Drapes
  • Additional Room 2 Name: Office, Dimensions: 14X13, On Level: Main Level, Flooring: Hardwood, Windows: Blinds
  • Bedroom 2: Dimensions: 14X12, On Level: 2nd Level, Flooring: Carpet, Windows: Blinds
  • Additional Room 3 Name: Study, Dimensions: 15X12, On Level: Main Level, Flooring: Hardwood, Windows: Blinds
  • Bedroom 3: Dimensions: 12X12, On Level: 2nd Level, Flooring: Carpet, Windows: Blinds
  • Additional Room 4 Name: Recreation Rm, Dimensions: 29X28, On Level: Basement, Flooring: Carpet, Windows: None
  • Bedroom 4: Dimensions: 14X13, On Level: 2nd Level, Flooring: Carpet, Windows: Blinds
  • Additional Room 5 Name: Sitting, Dimensions: 14X12, On Level: 2nd Level, Flooring: Carpet, Windows: Curtains/Drapes
  • Additional Room 6 Name: Exercise Rm, Dimensions: 13X11, On Level: Basement, Flooring: Carpet, Windows: None
  • Additional Room 7 Name: Foyer, Dimensions: 16X10, On Level: Main Level, Flooring: Hardwood, Windows: None
  • Additional Room 8 Name: Mud, Dimensions: 9X6, On Level: Main Level, Flooring: Ceramic Tile
  • Additional Room 9 Name: Storage, Dimensions: 27X14, On Level: Basement, Flooring: Other, Windows: None
  • Additional Room 10 Name: Bar, Dimensions: 14X12, On Level: Basement, Flooring: Carpet, Windows: None
  • Estimated Sq Ft: 3752
  • Dining Room Type: Separate
  • Family Room: Dimensions: 20X18, On Level: Main Level, Flooring: Hardwood, Windows: Curtains/Drapes

Exterior Features

  • Foundation: Concrete
  • Lot Size: 1.0-1.99 Acres
  • Exterior Building Type: Cedar, Stone
  • Roof Type: Asphalt/Glass (Shingles)
  • Exterior Property Features: Patio, Hot Tub, Storms/Screens
  • Exposure: E (East), W (West)
  • Acreage: 1.4235

Garage/Parking

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

Utilities

  • Air Conditioner: Central Air
  • Water: Lake Michigan
  • Sewer: Sewer-Public, Sewer-Storm
  • Heating Fuel: Gas, Forced Air, 2+ Sep Heating Systems

Schools

  • School District: 87
  • Elementary School: Westfield Elementary School
  • Middle School: Glen Crest Middle School
  • High School: Glenbard South High School
  • Junior High Dist: 89

Lot Info

  • Lot Dimensions: 122X193X198X358X94X63
  • Lot Description: Irregular, Landscaped Professionally
  • Parcel Identification Number: 0526304006

Tax Info

  • Taxes: 26075

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jul 28, 2023
Sold by
Jham Andre and Jham Raquel
Bought by
Andre C Jham Revocable Trust and Jham
Total Days on Market
44
Current Estimated Value
$1,470,277

Purchase Details

Listed on
Aug 11, 2018
Closed on
Nov 5, 2018
Sold by
Jochums Richard O and Jochums Melissa S
Bought by
Jham Andre
Seller's Agent
Matthew Todd
Coldwell Banker Real Estate Group
Buyer's Agent
Luigui Corral
RE/MAX American Dream
List Price
$1,250,000
Sold Price
$1,150,000
Premium/Discount to List
-$100,000
-8%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.79%
Original Mortgage
$920,000
Interest Rate
4.62%
Mortgage Type
New Conventional

Purchase Details

Listed on
Sep 4, 2013
Closed on
Dec 6, 2013
Sold by
James Dennis B and James Kathleen A
Bought by
Jochums Richard O and Jochums Melissa S
Seller's Agent
Pattie Murray
Berkshire Hathaway HomeServices Chicago
Buyer's Agent
Jude Murray
RE/MAX of Naperville
List Price
$1,250,000
Sold Price
$1,200,000
Premium/Discount to List
-$50,000
-4%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-0.86%
Original Mortgage
$885,000
Interest Rate
4.14%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 15, 2006
Sold by
Declaration Newton Wannetta R and Declaration Wannetta R Newton
Bought by
James Dennis B and James Kathleen A

Home Financials for this Owner

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

Purchase Details

Closed on
Dec 29, 2000
Sold by
Newton Wannetta R
Bought by
Newton Wannetta R and Nickel Barbara
Source: Public Records

Similar Homes in Glen Ellyn, IL

  • 874 Walnut St, Glen Ellyn, IL 60137

    $1,785,000

    • 4 Beds
    • 4.5 Baths
    • 5,000 Sq Ft
    • 874 Walnut St
    • Glen Ellyn, IL

    Welcome to 874 Walnut, a luxury new construction home crafted by an award-winning Glen Ellyn builder with over 30 years of excellence. This elegant 5-bedroom, 4.5-bath home offers a spacious open layout, including four bedrooms on the second floor with an indulgent primary suite, a private bath in one of the bedrooms, and a shared Jack-and-Jill bath for the other two. The finished basement

    Deb Ritter Keller Williams Premiere Properties

    Section Image
  • 33 Sunset Ave, Glen Ellyn, IL 60137

    $1,350,000

    • 4 Beds
    • 4.5 Baths
    • 4,865 Sq Ft
    • 33 Sunset Ave
    • Glen Ellyn, IL

    A Serene Woodland Retreat with Room to Roam! Stunning 4,865 SF of exceptional living on nearly 1/2 acre of park-like, professionally landscaped grounds-fully renovated in 2005 by highly regarded C & C Shenuk Construction. Backing to neighbors' deep yards & additional green space, this private, wooded setting offers unmatched serenity and space for entertaining, play, and relaxation. The open

    Cindy Purdom RE/MAX Suburban

    Section Image
  • 714 Turner Ave, Glen Ellyn, IL 60137

    $1,699,000

    • 6 Beds
    • 4.5 Baths
    • 4,581 Sq Ft
    • 714 Turner Ave
    • Glen Ellyn, IL

    Reimagined Colonial Masterpiece featured on the 2019 Glen Ellyn Infant Welfare House Walk, this exceptional home blends timeless character with stunning 2017 renovations, offering nearly 4,600 square feet of beautifully inspired space in a coveted location steps from Ben Franklin Elementary, downtown Glen Ellyn and walkable to Glenbard West. Designed with intention and elevated by Park &

    Cindy Purdom RE/MAX Suburban

    Section Image
  • 345 Scott Ave, Glen Ellyn, IL 60137

    $1,535,000

    • 4 Beds
    • 4.5 Baths
    • 3,953 Sq Ft
    • 345 Scott Ave
    • Glen Ellyn, IL

    Welcome to 345 Scott... a home with fabulous curb appeal, charm, style and a hard to find open floor plan located within blocks of Ben Franklin Elementary! Built in 2007 with over 4900 square feet of finished space, this home welcomes you with its wrap around porch and continues when you enter into the oversized foyer that opens into all the first floor living spaces! The first floor features a

    Renee Hughes Compass

    Section Image
  • 299 Cottage Ave, Glen Ellyn, IL 60137

    $1,625,000

    • 4 Beds
    • 4.5 Baths
    • 4,300 Sq Ft
    • 299 Cottage Ave
    • Glen Ellyn, IL

    JUST COMPLETED, NEW CONSTRUCTION. READY TO MOVE IN. Brand New Luxury Living in Glen Ellyn Introducing a stunning 4-bedroom, 4.1-bathroom home in the heart of Glen Ellyn. This brand new construction, built by Savvy Development LLC, offers the perfect blend of modern luxury and classic charm. Key Features: Custom Finishes: Personalized touches throughout the home, including a custom-built

    David Jaracz Savvy Properties Inc

    Section Image
  • 369 Hawthorne Blvd, Glen Ellyn, IL 60137

    $1,625,000

    • 6 Beds
    • 6 Baths
    • 5,080 Sq Ft
    • 369 Hawthorne Blvd
    • Glen Ellyn, IL

    Spacious, Fully Renovated Home on Oversized Glen Ellyn Lot - Walk to Town, Train& Schools! This stunning, fully remodeled home offers over 5,000sqft of finished living space and sits on an extra-wide 100' x 150' (0.34 acre) lot in the heart of Glen Ellyn. Inside, you'll find 6 bedrooms (5 upstairs, 1 in the walkout basement), 4 full bathrooms, and 2 half baths. The gourmet kitchen is a

    Mairead Resch Illinois Real Estate Partners Inc

    Section Image
  • 471 Stagecoach Run, Glen Ellyn, IL 60137

    $1,450,000

    • 4 Beds
    • 4.5 Baths
    • 4,477 Sq Ft
    • 471 Stagecoach Run
    • Glen Ellyn, IL

    Luxury meets modern elegance in this fully updated, custom brick, absolutely stunning home in the serene Stacy Woods community in Glen Ellyn. There's no time to talk about how great the location is (near highways, minutes from downtown Glen Ellyn, Metra etc.) because you'll run out of breath just reading the features. Enter this custom home to be met by luxurious porcelain tiles and a sweeping

    Leena Suleiman Village Realty, Inc.

    Section Image

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
Andre C Jham Revocable Trust -- None Listed On Document
Jham Andre $1,150,000 Fidelity National Title
Jochums Richard O $1,200,000 Fidelity National Title
James Dennis B $750,000 None Available
Newton Wannetta R -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Jham Andre C $818,200
Previous Owner Jham Andre $875,000
Previous Owner Jham Andre $920,000
Previous Owner Jochums Richard O $885,000
Previous Owner James Dennis B $950,000
Previous Owner James Dennis B $125,500
Previous Owner James Dennis B $1,337,839
Previous Owner James Dennis B $775,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/09/2018 11/09/18 Sold $1,150,000 -8.0% $307 / Sq Ft
09/24/2018 09/24/18 Pending -- -- --
08/11/2018 08/11/18 For Sale $1,250,000 +4.2% $333 / Sq Ft
12/06/2013 12/06/13 Sold $1,200,000 -4.0% $321 / Sq Ft
10/25/2013 10/25/13 Pending -- -- --
09/04/2013 09/04/13 For Sale $1,250,000 -- $334 / 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
2023 $31,533 $464,480 $68,000 $396,480
2022 $29,675 $438,970 $64,280 $374,690
2021 $25,953 $369,710 $62,750 $306,960
2020 $26,069 $358,940 $62,170 $296,770
2019 $25,446 $349,470 $60,530 $288,940
2018 $28,188 $383,460 $57,030 $326,430
2017 $26,075 $369,320 $54,930 $314,390
2016 $25,705 $354,570 $52,740 $301,830
2015 $24,974 $330,570 $50,310 $280,260
2014 $24,982 $324,310 $65,030 $259,280
2013 $24,182 $325,290 $65,230 $260,060
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: MRD10048993

Midwest Real Estate Data (MRED)

APN: 05-26-304-006