NOT LISTED FOR SALE

254 Franklin Rd Glencoe, IL 60022

Estimated Value: $2,328,000 - $2,485,212

4 Beds
4.5 Baths
4,155 Sq Ft
$579/Sq Ft Est. Value

Last Sold January 12, 2024

Last sale price $2,500,000 $602 Per Sq Ft

Est. 4% decrease in value since last sale

Current estimated payment $16,490/month

7 Days on Market

Highlights

  • Landscaped Professionally
  • Community Lake
  • Family Room with Fireplace
  • West School Rated A
  • Property is near a park
  • 2-minute walk to Ravine Bluffs Park

About This Home

As of January 2024

Do not miss this gorgeous, newer construction home with center entry floor plan situated in East Glencoe, walking distance to town, lake and beach, Metra, Botanic Gardens and more...with a true sense of privacy as well! Stunning and significant throughout, enjoy soaring ceilings, over-sized windows, coveted floor plan and three-car garage with one of the spaces attached! This 5-bedroom, 4.5-bathroom home boasts a large, professionally landscaped yard and gardens and a new bluestone patio with a built-in grill station, the perfect spot for entertaining! A rare opportunity to have all you need including a private library/office, generously sized living room and dining room, both with great fireplaces, outstanding family room with vaulted ceilings and a statement fireplace. The family room opens to the fabulous kitchen featuring an island for cooking prep and gathering, and top of the line stainless steel appliances. The first floor is complete with a butler's pantry, breakfast area with custom built-in benches, a large mud/laundry room with utility sink, beverage fridge and custom built-ins, powder room. The second floor features soaring ceilings with great light! You will love the 4 large second floor bedrooms, including an oversized primary suite with two walk-in closets, a spacious bathroom with a large walk-in shower, 2 individual vanities, soaking tub, and a private water closet. The second bedroom has an en-suite bathroom, and two additional bedrooms with a Jack and Jill bathroom. The lower-level retreat offers an abundant amount of space with an open recreation room complete with stone fireplace, a wine closet and plenty of options for games and an additional bedroom with an en-suite bathroom and closet. The bonus room can be used for a home gym or theatre or storage.... whatever your heart desires! A beautiful home in a coveted location!

Last Listed By

Annie flanagan

@properties Christie's International Real Estate License #475148848 Listed on: 08/23/2023

@properties Christie's International Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $31,676

Year Built

  • Built in 2005

Lot Details

  • Lot Dimensions are 80x174x80x167
  • Landscaped Professionally
  • Paved or Partially Paved Lot

Parking

  • 3 Car Garage
  • Garage ceiling height seven feet or more
  • Garage Transmitter
  • Garage Door Opener
  • Driveway
  • Parking Space is Owned

Home Design

  • Shake Roof
  • Concrete Perimeter Foundation
  • Stucco

Interior Spaces

  • 4,155 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Ceiling Fan
  • Wood Burning Fireplace
  • Fireplace With Gas Starter
  • Family Room with Fireplace
  • 4 Fireplaces
  • Living Room with Fireplace
  • Formal Dining Room
  • Home Office
  • Recreation Room
  • Storage Room
  • Wood Flooring
  • Home Security System

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Wine Refrigerator
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 5 Potential Bedrooms
  • Dual Sinks
  • Soaking Tub
  • Steam Shower
  • Separate Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

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

Schools

  • South Elementary School
  • Central Middle School
  • New Trier Twp High School Northfield/Wi

Utilities

  • Forced Air Zoned Cooling and Heating System
  • Humidifier
  • Heating System Uses Natural Gas
  • 200+ Amp Service
  • Lake Michigan Water

Additional Features

  • Brick Porch or Patio
  • Property is near a park

Community Details

Overview

  • Community Lake

Recreation

  • Tennis Courts

Home Details

Home Type

Single Family

Est. Annual Taxes

$31,676

Year Built

Built in 2005

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Type: Detached Single
  • Type Detached: 2 Stories
  • Ownership: Fee Simple
  • New Construction: No
  • Property Sub-Type: 2 Stories
  • Year Built: 2005
  • 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,Interstate Access
  • Rebuilt (Y/N): No
  • Rehab (Y/N): No
  • New Construction Y/N: No
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Range, Microwave, Dishwasher, Refrigerator, Washer, Dryer, Disposal, Wine Refrigerator
  • Basement: Full
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bathrooms: 5
  • Total Bedrooms: 4
  • Fireplace Features: Wood Burning, Gas Starter
  • Fireplaces: 4
  • Interior Amenities: Bar-Wet, Hardwood Floors, First Floor Laundry
  • LivingArea: 4155
  • Other Equipment: Humidifier, Security System, Ceiling Fan(s), Sump Pump
  • Room Type: Bedroom 5, Office, Recreation Room, Storage
  • Estimated Total Finished Sq Ft: 0
  • Basement Description: Finished
  • Bathroom Amenities: Separate Shower,Steam Shower,Double Sink,Soaking Tub
  • Basement Bathrooms: Yes
  • Below Grade Bedrooms: 1
  • Dining Room: Separate
  • Total Sq Ft: 0
  • Fireplace Location: Family Room,Living Room,Basement,Other
  • Total Sq Ft: 0
  • ResoLivingAreaSource: Plans

Exterior Features

  • ExteriorFeatures: Brick Paver Patio
  • Foundation Details: Concrete Perimeter
  • List Price: 2399000
  • Lot Features: Landscaped
  • Roof: Shake
  • Waterfront: No
  • Exterior Building Type: Stucco

Garage/Parking

  • Garage Spaces: 3
  • ParkingTotal: 3
  • Driveway: Asphalt
  • Garage Details: Garage Door Opener(s),Transmitter(s),7 Foot or more high garage door
  • Garage On-Site: Yes
  • Garage Ownership: Owned
  • Garage Type: Attached,Detached
  • Parking: Garage

Utilities

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

Condo/Co-op/Association

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

Fee Information

  • Association Fee Includes: None

Schools

  • Elementary School: South Elementary School
  • High School: New Trier Twp H.S. Northfield/Wi
  • Middle/Junior School: Central School
  • Middle/Junior School District: 35

Lot Info

  • Lot Dimensions: 80X174X80X167
  • Lot Size: .25-.49 Acre
  • Special Assessments: N

Rental Info

  • Board Number: 2

Tax Info

  • Tax Annual Amount: 31676
  • Tax Year: 2013
  • Tax Exemptions: None

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 23, 2023
Closed on
Jan 12, 2024
Sold by
Jennifer Helz Balestrery Trust
Bought by
Degalvao Eduardo Bandiziol and Galvao Clare Mitchell
Seller's Agent
Annie flanagan
@properties Christie's International Real Estate
Buyer's Agent
Karen Mason
@properties Christie's International Real Estate
List Price
$2,399,000
Sold Price
$2,500,000
Premium/Discount to List
$101,000
4.21%
Total Days on Market
7
Views
8
Current Estimated Value
$2,406,071

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$93,929
Avg. Annual Appreciation
3.50%
Original Mortgage
$1,350,000
Outstanding Balance
$1,331,995
Interest Rate
6%
Mortgage Type
New Conventional
Estimated Equity
$1,282,395

Purchase Details

Listed on
May 10, 2015
Closed on
Aug 14, 2015
Sold by
Williams Way Investments Inc Ii
Bought by
Balestrery Jennifer Helz and The Jennifer Helz Balestrery Trust
Seller's Agent
Marion Powers
@properties Christie's International Real Estate
Buyer's Agent
Carma Baker
@properties Christie's International Real Estate
List Price
$1,875,000
Sold Price
$1,750,000
Premium/Discount to List
-$125,000
-6.67%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.36%
Original Mortgage
$1,487,500
Interest Rate
3.25%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Dec 15, 2003
Sold by
Wood Graham Robert and Wood Lynda
Bought by
Williams Way Investments Ii Inc

Home Financials for this Owner

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

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
Degalvao Eduardo Bandiziol $2,500,000 Chicago Title Insurance Compan
Balestrery Jennifer Helz $1,750,000 Ct
Williams Way Investments Ii Inc $871,000 Cti
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Degalvao Eduardo Bandiziol $1,350,000
Previous Owner Balestrery Jennifer Helz $1,487,500
Previous Owner Williams Way Investments Ii Inc $1,443,973
Previous Owner Lemer Stanley I $1,400,000
Previous Owner Williams Way Investments Ii Inc $1,439,600
Previous Owner Williams Way Investments Ii Inc $653,250
Previous Owner Wood Graham R $113,500
Previous Owner Wood Graham Robert $500,000
Previous Owner Wood Graham Robert $100,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/12/2024 01/12/24 Sold $2,500,000 +4.2% $602 / Sq Ft
08/30/2023 08/30/23 Pending -- -- --
08/23/2023 08/23/23 For Sale $2,399,000 +37.1% $577 / Sq Ft
09/08/2015 09/08/15 Sold $1,750,000 -5.4% $421 / Sq Ft
07/09/2015 07/09/15 Pending -- -- --
06/23/2015 06/23/15 Price Changed $1,849,000 -1.4% $445 / Sq Ft
05/10/2015 05/10/15 For Sale $1,875,000 -- $451 / 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 $37,048 $162,000 $29,568 $132,432
2023 $37,048 $162,000 $29,568 $132,432
2022 $37,048 $162,000 $29,568 $132,432
2021 $34,542 $120,483 $28,224 $92,259
2020 $36,184 $130,000 $28,224 $101,776
2019 $34,570 $139,785 $28,224 $111,561
2018 $37,825 $148,796 $24,192 $124,604
2017 $38,433 $155,618 $24,192 $131,426
2016 $37,248 $160,634 $24,192 $136,442
2015 $31,508 $120,299 $20,496 $99,803
2014 $30,729 $120,299 $20,496 $99,803
2013 $31,676 $130,000 $20,496 $109,504
Source: Public Records

Agents Affiliated with this Home

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

Map

Similar Homes in Glencoe, IL

  • 847 Valley Rd, Glencoe, IL 60022

    $2,425,000

    • 4 Beds
    • 6 Baths
    • 5,424 Sq Ft
    • 847 Valley Rd
    • Glencoe, IL

    Under Contract During Private - Architecturally significant brick and limestone 2 story home designed by award-winning architect, Michael Hershenson and completed in 2001, situated on beautiful professionally landscaped 66x210 property with a Brussels Block stone paver patio (2022). Meticulously maintained by sole owners with many upgrades. Interior features barrel vaulted entry-way ceiling,

    Beverly Fleischman Coldwell Banker Realty

    Section Image
  • 416 Madison Ave, Glencoe, IL 60022

    $2,499,000

    • 4 Beds
    • 5.5 Baths
    • 4,800 Sq Ft
    • 416 Madison Ave
    • Glencoe, IL

    Introducing exquisite new construction in Glencoe's highly coveted President streets. Extraordinary opportunity to customize your dream home! Boasting 6 bedrooms/ 5.1 baths expanding across 4800 square feet of luxury promising unparalleled craftsmanship & design. Stunning & spacious main floor featuring formal living, dining, family room, custom mudroom all with 9-6 ft ceilings, engineered

    Rachel Moltz @properties Christie's International Real Estate

    Section Image
  • 150 Linden Ave, Glencoe, IL 60022

    $2,395,000

    • 4 Beds
    • 4.5 Baths
    • 4,971 Sq Ft
    • 150 Linden Ave
    • Glencoe, IL

    Proposed New Construction~ Sophisticated farmhouse with a welcoming front porch with a metal roof and approximately 4500 sq ft of finished space situated on a deep 55 X 180 lot. Get in while there is still time to customize and make this your dream home. Super desirable location with close proximity to town, parks, schools, public transportation and the beach for both Hubbard Woods and Glencoe.

    Susan Maman @properties Christie's International Real Estate

    Section Image

Source: Midwest Real Estate Data (MRED)

MLS Number: 11867619

Midwest Real Estate Data (MRED)

APN: 05-06-304-019-0000