NOT LISTED FOR SALE

123 Aspen Way Deerfield, IL 60015

Estimated Value: $974,000 - $1,842,000

5 Beds
6 Baths
5,041 Sq Ft
$303/Sq Ft Est. Value

Last Sold July 17, 2020

Last sale price $1,235,000 $245 Per Sq Ft

Est. 24% increase in value since last sale

Current estimated payment $11,438/month

33 Days on Market

Highlights

  • Heated Floors
  • Landscaped Professionally
  • Contemporary Architecture
  • South Park Elementary School Rated A
  • Deck
  • Recreation Room

About This Home

As of July 2020

This custom 5 bedroom, 4 full and 2 1/2 bath contemporary home is the ultimate in luxury. Open, modern floor plan with large rooms, 13 foot ceilings, walls of windows and white oak hardwood floors. The cook's kitchen is the perfect spot for entertaining and features include custom wood and stainless steel cabinetry, large center island with seating, granite counters, wine refrigerator, Sub-Zero, Wolf and Miele professional appliances. Expansive great room with french doors to deck is located off the kitchen and dining room. A first floor master suite has a private den/office, 2 walk-in closets and spa-like limestone master bath complete with heated floors, double sinks, soaking tub and huge shower with multiple body sprays. Laundry and mudroom located off 3 car garage. The second floor has bonus loft area and 3 additional bedrooms, 1 with en-suite bath & the other 2 bedrooms share a Jack & Jill bath. The 3,600 sq ft basement is a whole other level of living and includes recreation room, office/exercise room, guest bedroom, full bath and storage. The fenced backyard is an entertainer's dream with deck, fire pit and professionally landscaped yard. This is truly a one of a kind home!

Last Agent to Sell the Property

Beth Wexler

@properties Christie's International Real Estate License #475133132 Listed on: 04/27/2020

@properties Christie's International Real Estate

Co-Listed By

Joey Gault

@properties Christie's International Real Estate License #475135078

Last Buyer's Agent

Glenn Rickel

Redfin Corporation License #471000802

Redfin Corporation

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $41,203

Year Built

  • 2008

Lot Details

  • Fenced Yard
  • Landscaped Professionally

Parking

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

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Stucco Exterior Insulation and Finish Systems
  • Asphalt Shingled Roof
  • Stone Siding

Interior Spaces

  • Built-In Features
  • Vaulted Ceiling
  • Mud Room
  • Entrance Foyer
  • Great Room
  • Breakfast Room
  • Home Office
  • Recreation Room
  • Loft
  • Storage Room
  • Storm Screens

Kitchen

  • Breakfast Bar
  • Walk-In Pantry
  • Butlers Pantry
  • Built-In Double Oven
  • Cooktop with Range Hood
  • Microwave
  • High End Refrigerator
  • Freezer
  • Dishwasher
  • Wine Cooler
  • 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
  • Bidet
  • Dual Sinks
  • Soaking Tub
  • Shower Body Spray
  • Separate Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Finished Basement Bathroom
  • Basement Window Egress

Outdoor Features

  • Deck
  • Fire Pit

Utilities

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

Listing and Financial Details

  • Senior Tax Exemptions
  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Est. Annual Taxes

$41,203

Year Built

2008

Lot Details

0

Parking

3

Listing Details

  • Property Type: Detached Single
  • General Information: School Bus Service, Commuter Train, Interstate Access
  • Age: 11-15 Years
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Ownership: Fee Simple
  • Total Full or Half Bathrooms: 4.2
  • Total Sq Ft: 5041
  • Style Of House: Contemporary
  • Type Detached: 2 Stories
  • Estimated Year Built: 2008
  • Tax Exemptions: Homeowner, Senior
  • Total Sq Ft: 8670
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2008

Interior Features

  • Interior Property Features: Vaulted/Cathedral Ceilings, Hardwood Floors, Heated Floors, 1st Floor Bedroom, 1st Floor Laundry, 1st Floor Full Bath, Built-in Features, Walk-In Closet(s)
  • Number Of Rooms: 13
  • Appliances: Oven-Double, Microwave, Dishwasher, High End Refrigerator, Freezer, Washer, Dryer, Disposal, Wine Cooler/Refrigerator, Cooktop, Oven/Built-in, Range Hood, Other
  • Equipment: Humidifier, Central Vacuum, TV-Cable, Security System, CO Detectors, Sump Pump, Sprinkler-Lawn, Air Cleaner, Backup Sump Pump;, Power Generator, Multiple Water Heaters
  • Basement: Full
  • Basement: Finished, Egress Window
  • Basement Bathrooms: Yes
  • Bedrooms All Levels: 5
  • Below Grade Bedrooms: 1
  • Primary Bedroom Bath: Full
  • Bathroom Amenities: Separate Shower, Double Sink, Bidet, Full Body Spray Shower, Soaking Tub
  • Above Grade Bedrooms: 4
  • Laundry: Dimensions: 14X8, On Level: Main Level, Flooring: Hardwood, Windows: None
  • Dining Room: Dimensions: 14X16, On Level: Main Level, Flooring: Hardwood, Windows: Curtains/Drapes
  • Kitchen Type: Dimensions: 20X22, On Level: Main Level, Flooring: Hardwood, Windows: None
  • Kitchen Type: Eating Area-Breakfast Bar, Eating Area-Table Space, Island, Pantry-Butler, Pantry-Closet
  • Additional Rooms: Great Room, Loft, Den, 5th Bedroom, Breakfast Room, Office, Foyer, Recreation Room, Mud Room, Storage
  • Master Bedroom: Dimensions: 19X16, On Level: Main Level, Flooring: Carpet
  • Additional Room 1 Name: Great Rm, Dimensions: 28X29, On Level: Main Level, Flooring: Hardwood, Windows: Curtains/Drapes
  • Additional Room 2 Name: Loft, Dimensions: 14X11, On Level: 2nd Level, Flooring: Carpet
  • Bedroom 2: Dimensions: 16X13, On Level: 2nd Level, Flooring: Carpet
  • Additional Room 3 Name: Den, Dimensions: 13X17, On Level: Main Level, Flooring: Carpet, Windows: Shades
  • Bedroom 3: Dimensions: 15X12, On Level: 2nd Level, Flooring: Carpet
  • Additional Room 4 Name: 5th Bdrm, Dimensions: 12X22, On Level: Basement, Flooring: Carpet, Windows: Shades
  • Bedroom 4: Dimensions: 15X11, On Level: 2nd Level, Flooring: Carpet
  • Additional Room 5 Name: Breakfast Rm, Dimensions: 21X9, On Level: Main Level, Flooring: Hardwood, Windows: Curtains/Drapes
  • Additional Room 6 Name: Office, Dimensions: 17X20, On Level: Basement, Flooring: Carpet, Windows: Shades
  • Additional Room 7 Name: Foyer, Dimensions: 14X11, On Level: Main Level, Flooring: Hardwood, Windows: None
  • Additional Room 8 Name: Recreation Rm, Dimensions: 49X44, On Level: Basement, Flooring: Carpet, Windows: Shades
  • Additional Room 9 Name: Mud, Dimensions: 6X16, On Level: Main Level, Flooring: Hardwood, Windows: None
  • Additional Room 10 Name: Storage, Dimensions: 9X22, On Level: Basement, Flooring: Carpet, Windows: None
  • Estimated Sq Ft: 5041
  • Estimated Total Finished Sq Ft: 8670
  • Basement Sq Ft: 3629
  • Basement Finished Sq Ft: 3629
  • Main Level Sq Ft: 3629
  • Upper Level Sq Ft: 1412
  • Dining Room Type: Separate

Exterior Features

  • Foundation: Concrete
  • Lot Size: .25-.49 Acre
  • Exterior Building Type: EIFS (e.g. Dryvit)., Stone
  • Roof Type: Asphalt/Glass (Shingles)
  • Exterior Property Features: Deck, Storms/Screens, Fire Pit
  • Acreage: 0.373

Garage/Parking

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

Utilities

  • Electricity: Circuit Breakers, 400 Amp Service or Greater
  • Air Conditioner: Central Air, Zoned
  • Water: Lake Michigan
  • Sewer: Sewer-Public
  • Heating Fuel: Gas, Forced Air, Zoned

Condo/Co-op/Association

  • Assessed Sq Ft: 5041

Schools

  • School District: 113
  • Elementary School: South Park Elementary School
  • Middle School: Charles J Caruso Middle School
  • High School: Deerfield High School
  • Junior High Dist: 109

Lot Info

  • Lot Dimensions: 120 X 135
  • Lot Description: Fenced Yard, Landscaped Professionally
  • Parcel Identification Number: 16323120510000
  • Zero Lot Line: No

Tax Info

  • Taxes: 37215.02

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 27, 2020
Closed on
Jul 9, 2020
Sold by
Hpffenberg Steven M and Hoffenberg Steven M
Bought by
Spenkuch Jorg Ludwig and Cartier Jacqueline Leigh
Seller's Agent
Beth Wexler
@properties Christie's International Real Estate
Buyer's Agent
Glenn Rickel
Redfin Corporation
List Price
$1,275,000
Sold Price
$1,235,000
Premium/Discount to List
-$40,000
-3.14%
Current Estimated Value
$1,526,105

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$291,105
Avg. Annual Appreciation
4.13%
Original Mortgage
$864,500
Interest Rate
2.9%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 22, 2006
Sold by
Hoffenberg Joyce and Joyce Shaevitz Declaration Of
Bought by
Declaratio Hoffenberg Steven M and Declaratio Steven M Hoffenberg

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,006,823
Interest Rate
6.77%
Mortgage Type
Construction
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
Spenkuch Jorg Ludwig $1,235,000 Proper Title Llc
Declaratio Hoffenberg Steven M -- Chicago Title Insurance Co
Hoffenberg Joyce -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Spenkuch Jorg Ludwig $864,500
Previous Owner Declaratio Hoffenberg Steven M $1,006,823
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
07/17/2020 07/17/20 Sold $1,235,000 -3.1% $245 / Sq Ft
05/30/2020 05/30/20 Pending -- -- --
04/27/2020 04/27/20 For Sale $1,275,000 -- $253 / 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 $41,203 $464,592 $82,879 $381,713
2023 $39,792 $445,865 $79,538 $366,327
2022 $39,792 $426,042 $85,432 $340,610
2021 $37,566 $410,762 $82,368 $328,394
2020 $35,683 $411,626 $82,541 $329,085
2019 $37,215 $437,938 $82,401 $355,537
2018 $35,793 $438,743 $87,339 $351,404
2017 $35,506 $437,343 $87,060 $350,283
2016 $34,540 $453,587 $83,768 $369,819
2015 $36,572 $426,183 $78,707 $347,476
2014 $29,118 $367,848 $79,270 $288,578
2012 $31,525 $364,603 $78,571 $286,032
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD10699363

Midwest Real Estate Data (MRED)

APN: 16-32-312-051