NOT LISTED FOR SALE

4160 Walters Ave Northbrook, IL 60062

Estimated Value: $2,620,000 - $3,245,000

7 Beds
9 Baths
8,700 Sq Ft
$323/Sq Ft Est. Value

Last Sold November 21, 2016

Last sale price $1,650,000 $190 Per Sq Ft

Est. 70% increase in value since last sale

Current estimated payment $18,618/month

127 Days on Market

Highlights

  • Home Theater
  • In Ground Pool
  • Contemporary Architecture
  • Hickory Point Elementary School Rated A-
  • Landscaped Professionally
  • Property is near a park

About This Home

As of November 2016

DRAMATIC PRICE REDUCTION! $10K AGENT BONUS IF CLOSED BY NOV. 1st. This spectacular 8700+ sq. ft. custom built home sits on a beautifully landscaped 1.2 acre estate. Designed for personal enjoyment or entertaining large groups both outside and in. The impressive outside offers a magnificent pool, hot tub + two water falls, reflecting pond, lighted tennis court, large gazebo, and huge-outdoor kitchen with BBQ and bar, with additional lawn space. The interior features an exquisite first floor master suite with two-story his and her walk-in closets, cathedral ceilings, a breath taking great room, a dining room that seats 24, and a huge kitchen with adjoining sun-filled breakfast room overlooking the grounds. Upstairs you will find 4 en-suite bedrooms all with walk-in closets with an additional media room for the kids to gather. 4700 sq. ft. lower level with a 15 seat retro home theater, family room with full bar, office, exercise room, game room and 2 additional bedrooms and full baths.

Last Agent to Sell the Property

Lori Stiff

Coldwell Banker Residential Listed on: 04/22/2016

Last Buyer's Agent

Marla Schneider

Coldwell Banker Realty License #475127366

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $39,501

Year Built

  • 1994

Lot Details

  • Southern Exposure
  • East or West Exposure
  • Fenced Yard
  • Landscaped Professionally

Parking

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

Home Design

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

Interior Spaces

  • Wet Bar
  • Bar Fridge
  • Vaulted Ceiling
  • Skylights
  • See Through Fireplace
  • Gas Log Fireplace
  • Breakfast Room
  • Home Theater
  • Den
  • Game Room
  • Utility Room with Study Area
  • Home Gym

Kitchen

  • Breakfast Bar
  • Walk-In Pantry
  • Butlers Pantry
  • Double Oven
  • Microwave
  • Bar Refrigerator
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • Main Floor Bedroom
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Bathroom on Main Level
  • Bidet
  • Dual Sinks
  • Whirlpool Bathtub
  • Steam Shower
  • Separate Shower

Laundry

  • Dryer
  • Washer

Finished Basement

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

Pool

  • In Ground Pool
  • Spa

Outdoor Features

  • Brick Porch or Patio
  • Outdoor Grill

Utilities

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

Additional Features

  • North or South Exposure
  • Property is near a park

Listing and Financial Details

  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Est. Annual Taxes

$39,501

Year Built

1994

Lot Details

0

Parking

4

Listing Details

  • Property Type: Detached Single
  • General Information: School Bus Service
  • Age: 21-25 Years
  • Full Bathrooms: 8
  • Half Bathrooms: 1
  • Number Interior Fireplaces: 4
  • Ownership: Fee Simple
  • Total Full or Half Bathrooms: 8.1
  • Style Of House: Contemporary
  • Type Detached: 2 Stories
  • Estimated Year Built: 1994
  • Tax Exemptions: Homeowner
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 1994

Interior Features

  • Interior Property Features: Vaulted/Cathedral Ceilings, Skylight(s), Hot Tub, Bar-Wet, 1st Floor Bedroom, 1st Floor Full Bath
  • Number Of Rooms: 18
  • Living Room: Dimensions: 28X25, On Level: Main Level, Flooring: Marble, Windows: Shades
  • Appliances: Oven-Double, Oven/Range, Microwave, Dishwasher, Refrigerator, Refrigerator-Bar, Washer, Dryer, Disposal
  • Equipment: Humidifier, Central Vacuum, TV-Cable, Security System, Intercom, Ceiling Fan, Sump Pump, Sprinkler-Lawn, Air Cleaner
  • Fireplace Details: See through/Multi Sided, Gas Logs, Gas Starter
  • Fireplace Location: Family Room, Living Room, Master Bedroom, Basement
  • Basement: Full
  • Basement: Finished
  • Basement Bathrooms: Yes
  • Bedrooms All Levels: 7
  • Below Grade Bedrooms: 2
  • Primary Bedroom Bath: Full
  • Bathroom Amenities: Whirlpool, Separate Shower, Steam Shower, Double Sink, Bidet
  • Above Grade Bedrooms: 5
  • Laundry: Dimensions: 10X14, On Level: Basement, Flooring: Ceramic Tile
  • Dining Room: Dimensions: 30X16, On Level: Main Level, Flooring: Marble
  • Kitchen Type: Dimensions: 19X15, On Level: Main Level, Flooring: Marble, Windows: Shades
  • Kitchen Type: Eating Area-Table Space, Island, Pantry-Butler, Pantry-Walk-in
  • Additional Rooms: 5th Bedroom, 6th Bedroom, 7th Bedroom, Breakfast Room, Den, Exercise Room, Game Room, Media Room, Pantry, Study, Theatre Room, Walk In Closet
  • Master Bedroom: Dimensions: 33X32, On Level: Main Level, Flooring: Carpet, Windows: Shades
  • Additional Room 1 Name: Breakfast Rm, Dimensions: 19X16, On Level: Main Level, Flooring: Marble, Windows: Shades
  • Additional Room 2 Name: 5th Bdrm, Dimensions: 16X14, On Level: 2nd Level, Flooring: Carpet, Windows: Plantation Shutters
  • Bedroom 2: Dimensions: 16X14, On Level: 2nd Level, Flooring: Carpet, Windows: Plantation Shutters
  • Additional Room 3 Name: Media Rm, Dimensions: 19X14, On Level: 2nd Level, Flooring: Carpet, Windows: Plantation Shutters
  • Bedroom 3: Dimensions: 16X14, On Level: 2nd Level, Flooring: Carpet, Windows: Plantation Shutters
  • Additional Room 4 Name: 7th Bdrm, Dimensions: 16X14, On Level: Basement, Flooring: Carpet
  • Bedroom 4: Dimensions: 16X14, On Level: 2nd Level, Flooring: Carpet, Windows: Plantation Shutters
  • Additional Room 5 Name: Den, Dimensions: 16X15, On Level: Main Level, Flooring: Marble
  • Additional Room 6 Name: 6th Bdrm, Dimensions: 19X14, On Level: Basement, Flooring: Carpet
  • Additional Room 7 Name: Theater Rm, Dimensions: 24X20, On Level: Basement, Flooring: Carpet
  • Additional Room 8 Name: Study, Dimensions: 23X15, On Level: Basement, Flooring: Carpet
  • Additional Room 9 Name: Exercise Rm, Dimensions: 21X14, On Level: Basement, Flooring: Carpet, Windows: Shades
  • Additional Room 10 Name: Game Rm, Dimensions: 19X12, On Level: Basement, Flooring: Carpet
  • Estimated Sq Ft: 8700
  • Dining Room Type: Separate
  • Family Room: Dimensions: 33X24, On Level: Basement, Flooring: Carpet

Exterior Features

  • Foundation: Concrete
  • Lot Size: 1.0-1.99 Acres
  • Exterior Building Type: Brick, EIFS (e.g. Dryvit)., Stone
  • Roof Type: Asphalt/Glass (Shingles)
  • Exterior Property Features: Hot Tub, Brick Paver Patio, Pool In-Ground, Outdoor Grill
  • Exposure: N (North), S (South), E (East), W (West)
  • Acreage: 1.19

Garage/Parking

  • Number of Cars: 4
  • 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: 4
  • Driveway: Brick, Circular, Side Drive
  • Garage Ownership: Owned

Utilities

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

Schools

  • School District: 225
  • Elementary School: HICKORY POINT ELEMENTARY SCHOOL
  • Middle School: WOOD OAKS JUNIOR HIGH SCHOOL
  • High School: GLENBROOK NORTH HIGH SCHOOL
  • Junior High Dist: 27

Lot Info

  • Lot Dimensions: 200X260
  • Lot Description: Fenced Yard, Landscaped Professionally, Park Adjacent
  • Parcel Identification Number: 04073000160000

Tax Info

  • Taxes: 30637

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 8, 2024
Sold by
Shen Michael M and Shen Ruth
Bought by
Ruth T Shen Revocable Trust and Shen
Current Estimated Value
$2,812,816

Purchase Details

Listed on
Apr 22, 2016
Closed on
Oct 31, 2016
Sold by
Barrish Bryan G and Barrish Juliana R
Bought by
Shen Michael M and Shen Ruth
Seller's Agent
Lori Stiff
Coldwell Banker Residential
Buyer's Agent
Marla Schneider
Coldwell Banker Realty
List Price
$1,899,000
Sold Price
$1,650,000
Premium/Discount to List
-$249,000
-13.11%

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 1, 1998
Sold by
The Coleman Group Inc
Bought by
Rosenberg David and Rosenberg Effie

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$300,000
Interest Rate
7.04%
Mortgage Type
Unknown

Purchase Details

Closed on
Oct 5, 1993
Sold by
Albany Bank & Trust Company Na
Bought by
Barrish Bryan G and Barrish Juliana R
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
Ruth T Shen Revocable Trust -- None Listed On Document
Shen Michael M $1,650,000 Fidelity National Title
Rosenberg David $400,000 Cti
Barrish Bryan G $350,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Shen Michael M $1,320,000
Previous Owner Barrish Bryan G $1,862,800
Previous Owner Barrish Bryan G $2,000,000
Previous Owner Barrish Bryan G $2,000,000
Previous Owner Barrish Bryan G $2,000,000
Previous Owner Barrish Bryan G $2,000,000
Previous Owner Rosenberg David $300,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/21/2016 11/21/16 Sold $1,650,000 -5.6% $190 / Sq Ft
08/27/2016 08/27/16 Pending -- -- --
08/12/2016 08/12/16 Price Changed $1,747,000 -6.8% $201 / Sq Ft
06/16/2016 06/16/16 Price Changed $1,874,000 -1.3% $215 / Sq Ft
04/22/2016 04/22/16 For Sale $1,899,000 -- $218 / 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 $39,501 $172,664 $43,860 $128,804
2023 $38,131 $172,664 $43,860 $128,804
2022 $38,131 $172,664 $43,860 $128,804
2021 $30,807 $125,021 $36,120 $88,901
2020 $30,406 $125,021 $36,120 $88,901
2019 $29,683 $137,386 $36,120 $101,266
2018 $38,003 $157,676 $30,960 $126,716
2017 $36,937 $157,676 $30,960 $126,716
2016 $35,653 $164,786 $30,960 $133,826
2015 $31,383 $131,194 $25,800 $105,394
2014 $30,637 $131,194 $25,800 $105,394
2013 $29,759 $131,194 $25,800 $105,394
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD09204360

Midwest Real Estate Data (MRED)

APN: 04-07-300-016-0000