NOT LISTED FOR SALE

3151 Keystone Rd Northbrook, IL 60062

Estimated Value: $1,116,000

5 Beds
6 Baths
6,835 Sq Ft
$163/Sq Ft Est. Value

Last Sold December 20, 2021

Last sale price $1,400,000 $205 Per Sq Ft

Est. 20% decrease in value since last sale

Current estimated payment $6,250/month

85 Days on Market

Highlights

  • Family Room with Fireplace
  • Whirlpool Bathtub
  • Formal Dining Room
  • Hickory Point Elementary School Rated A-
  • Steam Shower
  • Attached Garage

About This Home

As of December 2021

Glenbrook School District #225 was recently rated #2 nationwide, and this quality built residence is in the heart of the District. The stunning brick and stone home has been renovated to perfection inside and out, with grand bridal staircase, two-story great room with stone fireplace, dramatic chandelier, and romantic Juliette balcony off the luxurious master suite. Focal point of the grande entrance is a dazzling large scale chandelier from Restoration Hardware and architectural detail in arched ceilings, pillars and high gloss stone flooring. The masterfully redone kitchen boasts Taj Mahal quartzite island/countertops, new $10,0000 La Cornue oven/range, custom handmade cabinetry, Robert Abbey interior lighting; French Bouvet Hardware throughout the home. First level features a main floor bedroom en suite with tub; large walkout laundry room with a wall of built in cabinetry for great storage. Lower level has undergone $100K recent renovation with custom entertainment room, travertine floors, workout room plus exercise studio with mirrored walls/heated floor, custom bar with underlit Patagonia quartzite countertop and backdrop, full bath with walk-in travertine steam shower, huge walk-in storage closets beautifully finished. There are two separate gravel dog runs, one accessed from lower level and one from the first floor laundry room. NEW within the past 2 years: Illusion window treatments $30,000, all 6 toilets replaced, $7000 furnace 2020; $30,000 Brick Paver driveway, $8000 Bluestone hardscape at front entry, new gutters/downspouts/soffits $18,000; commercial grade carpeting on both staircases $8000; exterior landscape lighting, oversized sconces; Bluestone Patio $40,000 and a $20,105 stained cedar privacy fence around the impeccably landscaped backyard. All appliances have been recently replaced with exception of the SubZero in kitchen; central vacuum system throughout. Attic with pull down stairs in master closet, finished for even more storage. For your Electric cars: 240V / 50 amp / Level 2 Charger hardwired in garage. An exquisite home in strategic location, near Northbrook Park District's West Park with outdoor pool, tennis courts, indoor skating rink...and in sought after School District #27.

Last Listed By

Debra Kruger

Coldwell Banker Realty License #475141093 Listed on: 08/24/2021

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $39

Year Built | Renovated

  • 2001 | 2019

Lot Details

  • 0.41

Parking

  • Attached Garage
  • Garage ceiling height seven feet or more
  • Heated Garage
  • Garage Door Opener
  • Brick Driveway
  • Parking Included in Price

Home Design

  • Brick or Stone Mason

Interior Spaces

  • 6,835 Sq Ft Home
  • 2-Story Property
  • Blinds
  • Window Screens
  • French Doors
  • Family Room with Fireplace
  • Formal Dining Room
  • Finished Basement
  • Finished Basement Bathroom

Bedrooms and Bathrooms

  • Dual Sinks
  • Whirlpool Bathtub
  • Steam Shower

Listing and Financial Details

  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Est. Annual Taxes

$39

Year Built | Renovated

2001 | 2019

Lot Details

0

Parking

3

Listing Details

  • Property Type: Detached Single
  • Property Type: Residential
  • Type Detached: 2 Stories
  • Property Sub Type: 2 Stories
  • Age: 16-20 Years
  • Built Before 1978 (Y/N): No
  • Disability Access and/or Equipped: No
  • General Information: School Bus Service,Commuter Bus,Commuter Train
  • Rebuilt (Y/N): No
  • Rehab (Y/N): Yes
  • Rehab Year: 2019
  • New Construction Y/N: No
  • Directions: Landwehr Road, North of Techny to Keystone Road, East to 3151
  • Lot Size: 60 X 300
  • New Construction: No
  • Ownership: Fee Simple
  • Special Features: None
  • Year Built: 2001
  • Year Renovated: 2019

Interior Features

  • Appliances: Range, Microwave, Dishwasher, High End Refrigerator, Washer, Dryer, Disposal, Range Hood
  • Has Basement: Full
  • Fireplace Features: Gas Log
  • Estimated Total Finished Sq Ft: 6835
  • Assessed Sq Ft: 0
  • Basement Description: Finished
  • Bathroom Amenities: Whirlpool,Steam Shower,Double Sink
  • Basement Bathrooms: Yes
  • Below Grade Bedrooms: 0
  • Dining Room: Separate
  • Total Sq Ft: 4432
  • Fireplace Location: Family Room
  • Total Sq Ft: 4432
  • Upper Level Sq Ft: 2216
  • Attic: Finished,Pull Down Stair
  • Main Level Sq Ft: 2216
  • Door Features: French Doors
  • Window Features: Blinds,Screens,Window Treatments
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Possible Bedrooms: 5
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 2403
  • Fireplaces: 1
  • Interior Amenities: Bar-Dry, Hardwood Floors, Heated Floors, First Floor Bedroom, First Floor Laundry, First Floor Full Bath, Built-in Features, Walk-In Closet(s), Ceiling - 10 Foot, Coffered Ceiling(s), Open Floorplan, Granite Counters
  • Other Equipment: Humidifier, Central Vacuum, Security System, CO Detectors, Sump Pump, Sprinkler-Lawn, Air Purifier, Backup Sump Pump;
  • Dining Room Type: Bedroom 5, Recreation Room, Exercise Room, Utility Room-Lower Level, Walk In Closet, Storage, Foyer

Exterior Features

  • Roof: Shake
  • Exterior Features: Balcony, Patio, Porch, Dog Run, Brick Paver Patio, Storms/Screens
  • Foundation Details: Concrete Perimeter
  • Exterior Building Type: Brick,Stone
  • Lot Features: Fenced Yard, Landscaped
  • Waterfront: No

Garage/Parking

  • Number of Cars: 3
  • Driveway: Brick
  • Garage Details: Garage Door Opener(s),Heated,7 Foot or more high garage door
  • Garage On-Site: Yes
  • Garage Ownership: Owned
  • Garage Type: Attached
  • Parking: Garage
  • Garage Spaces: 3

Utilities

  • Cooling: Central Air, Zoned
  • Heating: Natural Gas
  • Electric: 200+ Amp Service
  • Sewer: Public Sewer
  • Water Source: Lake Michigan

Condo/Co-op/Association

  • Master Association Fee: No
  • Master Association Fee Frequency: Not Required
  • Association Fee Frequency: Not Applicable
  • Community Features: Park, Tennis Court(s), Curbs, Sidewalks, Street Lights, Street Paved

Fee Information

  • Association Fee Includes: None

Schools

  • Elementary School: Hickory Point Elementary School
  • High School: Glenbrook North High School
  • Elementary School #2: Shabonee School
  • Junior High Dist: 225
  • Middle Or Junior School: Wood Oaks Junior High School

Lot Info

  • Lot Size: .50-.99 Acre
  • Special Assessments: N
  • Additional Parcels: Yes

Rental Info

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

Tax Info

  • Tax Exemptions: Homeowner
  • Tax Annual Amount: 23071.28
  • Tax Year: 2020

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 24, 2021
Closed on
Jan 18, 2022
Sold by
Shlofrock John S and Shlofrock Melissa
Bought by
Marks Benjamin and Nankin Julie Avner
Seller's Agent
Debra Kruger
Coldwell Banker Realty
Buyer's Agent
Jerald Kost
Jerald Kost
List Price
$1,595,000
Sold Price
$1,400,000
Premium/Discount to List
-$195,000
-12.23%
Total Days on Market
85
Current Estimated Value
$1,116,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$284,000
Avg. Annual Appreciation
-5.65%
Original Mortgage
$1,260,000
Outstanding Balance
$1,180,049
Interest Rate
3.11%
Estimated Equity
-$33,049

Purchase Details

Closed on
Sep 25, 2003
Sold by
Degeorge Pinsler Steven C and Degeorge Pinsler Laura
Bought by
Shlofrock John S

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

Similar Homes in the area

  • 3706 Miller Dr, Glenview, IL 60026

    $1,199,000

    • 5 Beds
    • 6 Baths
    • 4,046 Sq Ft
    • 3706 Miller Dr
    • Glenview, IL

    Welcome to 3706 Miller Drive, a beautifully designed and meticulously maintained home offering five bedrooms, four full bathrooms, and two half bathrooms across over 4,000 square feet of finished living space. Located in one of Glenview's most desirable neighborhoods, this custom residence seamlessly blends comfort, function, and style, making it ideal for both everyday living and entertaining.

    Marla Schneider Coldwell Banker Realty

    Section Image
  • 2601 Mulberry Ln, Northbrook, IL 60062

    $855,000

    • 4 Beds
    • 5 Baths
    • 2,912 Sq Ft
    • 2601 Mulberry Ln
    • Northbrook, IL

    Bright and cheerful home in the the coveted Sunset Fields neighborhood. This stone and sided home has been beautifully updated and very well maintained. The first floor has a flexible floor plan to accommodate many living arrangements. The spacious living room has a gorgeous bay window with seating area, a gas log fireplace and hardwood floors. The dining room, with sliding glass doors opens to

    Sarah Dwyer Compass

    Section Image
  • 2025 Maplewood Rd, Northbrook, IL 60062

    $1,079,000

    • 5 Beds
    • 5 Baths
    • 3,239 Sq Ft
    • 2025 Maplewood Rd
    • Northbrook, IL

    Don't miss the vast, manicured gardens (over a 1/2 acre) and picturesque curb appeal of this 5 bed/5 bath Glenbrook Countryside estate in Northbrook. The marble entryway welcomes you into a first floor flow that has it all - living room, full bath, bedroom/office, separate dining room, custom built-in eat-in kitchen with a fabulous view, and a family room with classic built-ins and fireplace.

    Megan Weber Dream Town Real Estate

    Section Image

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
Marks Benjamin -- --
Marks Benjamin -- --
Shlofrock John S $737,500 M G R Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Marks Benjamin $1,260,000
Previous Owner Shlofrock John S $681,000
Previous Owner Shlofrock John S $813,000
Previous Owner Shlofrock John S $100,000
Previous Owner Shlofrock John S $914,200
Previous Owner Pinsler Steven C $595,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/20/2021 12/20/21 Sold $1,400,000 -12.2% $205 / Sq Ft
11/18/2021 11/18/21 Pending -- -- --
08/24/2021 08/24/21 For Sale $1,595,000 -- $233 / 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 $171 $171 --
2023 $39 $171 $171 --
2022 $39 $171 $171 $0
2021 $37 $148 $148 $0
2020 $37 $148 $148 $0
2019 $33 $148 $148 $0
2018 $0 $1 $1 $0
2017 $0 $1 $1 $0
2016 $0 $1 $1 $0
2015 $0 $1 $1 $0
2014 -- $1 $1 $0
2013 -- $1 $1 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: 11165508

Midwest Real Estate Data (MRED)

APN: 04-17-200-022-0000