Tricia & Pete Hupperich

Broker Associate

  • Listing status icon

    $1,289,900

  • Active | MLS#: 09809594
  • 5Beds
  • 4Baths
  • 4,640Sq Ft

19790 Stone Pond Circle LONG GROVE, IL 60047

Favorite
Share
Close
Info Visit Search

Overview

New Custom Home on 1 acre on premium Cul-de-sac location with amazing views of open space. This custom model is almost finished and features 5 Brs and 4 Full Baths including a 1st floor guest suite. Additionally many upgraded finishing's like moldings, cabinets, granite tops, hardwood floors, fully landscaped lot and 4 car garage. Upstairs master bedroom includes a huge walk-in closet, sitting area and beautiful master bath. 3 additional bedrooms all have walk-in closets and are over-sized. 2nd floor laundry closet. Walk out basement available for finishing leads to lower level patio which steps up to main level patio off kitchen. Beautiful custom home built by Fassbinder Construction.

Listing provided courtesy of: Premier Realty Group, Inc.

General Features

  • Age NEW-Under Construction
  • Apx. Year Built 2018
  • Association Fees 370
  • Assessment Frequency Annual
  • County Lake
  • Extra Equipment Humidifier, Fire Sprinklers, CO Detectors, Sump Pump
  • Full Baths 4
  • Information School Bus Service
  • Number of Rooms 11
  • Property Features New Construction
  • Recent Rehab No
  • Subdivision Long Meadow Farms
  • Tax Year 2016
  • Taxes 7141

Building Features

  • Air Conditioning Central Air
  • Approximate SqFt. 4640
  • Basement Unfinished
  • Disability Access No
  • Exterior Stucco, Stone
  • Garage Onsite Yes
  • Heating Gas, Forced Air
  • House Type 2 Stories
  • Interior Features 1st Floor Bedroom, 2nd Floor Laundry
  • Roofing Wood Shakes/Shingles

Room Features

  • 2nd Bedroom Flooring Carpet
  • 2nd Bedroom Level 2nd BR on 2nd Floor
  • 2nd Bedroom Size 15X13
  • 3rd Bedroom Flooring Carpet
  • 3rd Bedroom Level 3rd BR on 2nd Floor
  • 3rd Bedroom Size 18X16
  • 4th Bedroom Flooring Carpet
  • 4th Bedroom Level 4th BR on 2nd Floor
  • 4th Bedroom Size 18X14
  • Additional Room 5 Great Rm
  • Additional Room 5 Flooring Hardwood
  • Addtitional Room 5 Size 20X18
  • Dining Room Flooring Hardwood
  • Dining Room Size 15X13
  • Kitchen Flooring Hardwood
  • Kitchen Size 17X15
  • Living Room Level Not Applicable
  • Master Bedroom Flooring CARPET
  • Master Bedroom Level Master on 2nd Floor
  • Master Bedroom Size 15X15
  • Other Room 1 Sitting
  • Other Room 1 Flooring Carpet
  • Other Room 1 Size 15X12
  • Other Room 2 Foyer
  • Other Room 2 Flooring Hardwood
  • Other Room 2 Size 11X9
  • Other Room 3 Study
  • Other Room 3 Flooring Hardwood
  • Other Room 3 Size 15X12
  • Other Room 4 5th Bdrm
  • Other Room 4 Flooring Carpet
  • Other Room 4 Size 14X13

Property Features

  • Acreage 1
  • Driveway Asphalt
  • Electricity 200+ Amp Service
  • Foundation Concrete
  • Lot Description Cul-de-sac
  • Lot Dimensions 140X275X151X329
  • Lot Size 1.0-1.99 Acres
  • Sewer Sewer-Public
  • Water Well-Private
  • Waterfront No

Schools

  • High School ADLAI E STEVENSON HIGH SCHOOL
  • High School District 125
  • Elementary School District 96
  • Junior High District 96
  • Elementary School COUNTRY MEADOWS ELEMENTARY SCHOO
  • Junior High TWIN GROVES MIDDLE SCHOOL

Listing agent photo

Tricia & Pete Hupperich

847-865-5162RE/MAX Unlimited Northwest

Ask a Question

Price & Status History

Days on Market

  • This property has been listed on the market for 11 days
  • Average days-on-market for homes between $1,031,920 - $1,547,880 = 116 (in zip code 60047)

Location

The property map location is: Accurate, based on Google's address match.
Listing agent photo

Tricia & Pete Hupperich

847-865-5162RE/MAX Unlimited Northwest

Ask A Question

Community Demographics for Zip Code 60047 (LONG GROVE)

Housing Occupancy
  • Home Owners: 12,082 (80%)
  • Renters: 880 (6%)
  • Vacant: 2,128 (14%)
  • Total Housing Units: 15,090
Households
  • Average Household Size: 3
  • Housing Density (People per square mile): 1,132
Age Range (number of people)
  • Age 0-14: 7,328
  • Age 15-24: 5,729
  • Age 25-39: 7,654
  • Age 40-59: 8,481
  • Age 60-79: 8,339
  • Age 80+: 1,858
  • Total: 39,389

* All numbers in this section are 2016 projections provided by Geolytics Inc

School Information for 60047 (LONG GROVE)

Public Schools in Zip Code 60047 (LONG GROVE)

* This list of schools may not match the property above.

LAKE ZURICH HIGH SCHOOL 300 CHURCH ST LAKE ZURICH, IL 60047 Phone: 8474385155 9th-12th
Grade Size Distribution
  • 9th: 529
  • 10th: 597
  • 11th: 577
  • 12th: 536
School Population
  • Teachers: 130
  • Students per Teacher: 17.2
  • Students: 2239
  • Male/Female: 1085/1132
School District
  • LAKE ZURICH CUSD 95
  • 400 SOUTH OLD RAND RD LAKE ZURICH, IL 60047
  • Phone: 8474382831
District Population
  • Schools: 9
  • Full-Time Teachers: 418
  • Students per Teacher: 15.2
  • Staff: 512
  • Students: 6362
LAKE ZURICH MIDDLE - N CAMPUS 95 HUBBARD LN HAWTHORN WOODS, IL 60047 Phone: 8477193600 6th-8th
Grade Size Distribution
  • 6th: 238
  • 7th: 278
  • 8th: 271
School Population
  • Teachers: 61
  • Students per Teacher: 12.9
  • Students: 787
  • Male/Female: 361/406
School District
  • LAKE ZURICH CUSD 95
  • 400 SOUTH OLD RAND RD LAKE ZURICH, IL 60047
  • Phone: 8474382831
District Population
  • Schools: 9
  • Full-Time Teachers: 418
  • Students per Teacher: 15.2
  • Staff: 512
  • Students: 6362
LAKE ZURICH MIDDLE - S CAMPUS 435 WEST CUBA RD LAKE ZURICH, IL 60047 Phone: 8475407070 6th-8th
Grade Size Distribution
  • 6th: 224
  • 7th: 240
  • 8th: 246
School Population
  • Teachers: 57
  • Students per Teacher: 12.5
  • Students: 710
  • Male/Female: 338/362
School District
  • LAKE ZURICH CUSD 95
  • 400 SOUTH OLD RAND RD LAKE ZURICH, IL 60047
  • Phone: 8474382831
District Population
  • Schools: 9
  • Full-Time Teachers: 418
  • Students per Teacher: 15.2
  • Staff: 512
  • Students: 6362
WOODLAWN MIDDLE SCHOOL 6362 RFD/GILMER RD LONG GROVE, IL 60047 Phone: 8473538500 6th-8th
Grade Size Distribution
  • 6th: 202
  • 7th: 207
  • 8th: 234
School Population
  • Teachers: 45
  • Students per Teacher: 14.3
  • Students: 643
  • Male/Female: 331/305
School District
  • KILDEER COUNTRYSIDE CCSD 96
  • 1050 IVY HALL LN BUFFALO GROVE, IL 60089
  • Phone: 8474594260
District Population
  • Schools: 7
  • Full-Time Teachers: 223
  • Students per Teacher: 14.7
  • Staff: 276
  • Students: 3267
COUNTRY MEADOWS ELEM SCHOOL 6360 RFD/GILMER RD LONG GROVE, IL 60047 Phone: 8473538600 1st-5th
Grade Size Distribution
  • 1st: 76
  • 2nd: 68
  • 3rd: 75
  • 4th: 72
  • 5th: 78
School Population
  • Teachers: 30
  • Students per Teacher: 12.3
  • Students: 369
  • Male/Female: 191/161
School District
  • KILDEER COUNTRYSIDE CCSD 96
  • 1050 IVY HALL LN BUFFALO GROVE, IL 60089
  • Phone: 8474594260
District Population
  • Schools: 7
  • Full-Time Teachers: 223
  • Students per Teacher: 14.7
  • Staff: 276
  • Students: 3267
KILDEER COUNTRYSIDE ELEM SCHOOL 3100 OLD MCHENRY RD LONG GROVE, IL 60047 Phone: 8476343243 1st-5th
Grade Size Distribution
  • 1st: 101
  • 2nd: 108
  • 3rd: 93
  • 4th: 100
  • 5th: 111
School Population
  • Teachers: 35
  • Students per Teacher: 14.7
  • Students: 513
  • Male/Female: 238/245
School District
  • KILDEER COUNTRYSIDE CCSD 96
  • 1050 IVY HALL LN BUFFALO GROVE, IL 60089
  • Phone: 8474594260
District Population
  • Schools: 7
  • Full-Time Teachers: 223
  • Students per Teacher: 14.7
  • Staff: 276
  • Students: 3267
ISAAC FOX ELEMENTARY SCHOOL 395 WEST CUBA RD LAKE ZURICH, IL 60047 Phone: 8475407020 PreK-5th
Grade Size Distribution
  • PreK: 8
  • Knd: 63
  • 1st: 65
  • 2nd: 97
  • 3rd: 76
  • 4th: 95
  • 5th: 81
School Population
  • Teachers: 30
  • Students per Teacher: 16.2
  • Students: 485
  • Male/Female: 213/259
School District
  • LAKE ZURICH CUSD 95
  • 400 SOUTH OLD RAND RD LAKE ZURICH, IL 60047
  • Phone: 8474382831
District Population
  • Schools: 9
  • Full-Time Teachers: 418
  • Students per Teacher: 15.2
  • Staff: 512
  • Students: 6362
MAY WHITNEY ELEM SCHOOL 120 CHURCH ST LAKE ZURICH, IL 60047 Phone: 8474382351 PreK-5th
Grade Size Distribution
  • PreK: 6
  • Knd: 51
  • 1st: 76
  • 2nd: 73
  • 3rd: 90
  • 4th: 78
  • 5th: 63
School Population
  • Teachers: 31
  • Students per Teacher: 14.1
  • Students: 437
  • Male/Female: 197/221
School District
  • LAKE ZURICH CUSD 95
  • 400 SOUTH OLD RAND RD LAKE ZURICH, IL 60047
  • Phone: 8474382831
District Population
  • Schools: 9
  • Full-Time Teachers: 418
  • Students per Teacher: 15.2
  • Staff: 512
  • Students: 6362
SARAH ADAMS ELEMENTARY SCHOOL 555 OLD MILL GRV RD LAKE ZURICH, IL 60047 Phone: 8474385986 PreK-5th
Grade Size Distribution
  • PreK: 11
  • Knd: 67
  • 1st: 75
  • 2nd: 63
  • 3rd: 89
  • 4th: 79
  • 5th: 86
School Population
  • Teachers: 29
  • Students per Teacher: 16.2
  • Students: 470
  • Male/Female: 213/241
School District
  • LAKE ZURICH CUSD 95
  • 400 SOUTH OLD RAND RD LAKE ZURICH, IL 60047
  • Phone: 8474382831
District Population
  • Schools: 9
  • Full-Time Teachers: 418
  • Students per Teacher: 15.2
  • Staff: 512
  • Students: 6362
SETH PAINE ELEM SCHOOL 50 MILLER RD LAKE ZURICH, IL 60047 Phone: 8474382163 PreK-5th
Grade Size Distribution
  • PreK: 10
  • Knd: 67
  • 1st: 91
  • 2nd: 68
  • 3rd: 73
  • 4th: 78
  • 5th: 69
School Population
  • Teachers: 30
  • Students per Teacher: 15.2
  • Students: 456
  • Male/Female: 222/225
School District
  • LAKE ZURICH CUSD 95
  • 400 SOUTH OLD RAND RD LAKE ZURICH, IL 60047
  • Phone: 8474382831
District Population
  • Schools: 9
  • Full-Time Teachers: 418
  • Students per Teacher: 15.2
  • Staff: 512
  • Students: 6362
SPENCER LOOMIS ELEMENTARY SCHOOL 1 HUBBARD LN HAWTHORN WOODS, IL 60047 Phone: 8477193300 PreK-5th
Grade Size Distribution
  • PreK: 3
  • Knd: 56
  • 1st: 53
  • 2nd: 61
  • 3rd: 79
  • 4th: 93
  • 5th: 78
School Population
  • Teachers: 27
  • Students per Teacher: 15.7
  • Students: 423
  • Male/Female: 197/215
School District
  • LAKE ZURICH CUSD 95
  • 400 SOUTH OLD RAND RD LAKE ZURICH, IL 60047
  • Phone: 8474382831
District Population
  • Schools: 9
  • Full-Time Teachers: 418
  • Students per Teacher: 15.2
  • Staff: 512
  • Students: 6362

Private Schools in Zip Code 60047 (LONG GROVE)

* This list of schools may not match the property above.

ST. FRANCIS DE SALES SCHOOL 11 S Buesching Rd Lake Zurich, IL 60047 Phone: 8474387921 K-8th
Grade Size Distribution
  • Knd: 61
  • 1st: 65
  • 2nd: 67
  • 3rd: 67
  • 4th: 62
  • 5th: 59
  • 6th: 66
  • 7th: 66
  • 8th: 65
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 578
ST. MATTHEW LUTHERAN SCHOOL 24480 Old McHenry Rd Lake Zurich, IL 60047 Phone: 8474386103 K-8th
Grade Size Distribution
  • Knd: 17
  • 1st: 20
  • 2nd: 19
  • 3rd: 20
  • 4th: 15
  • 5th: 12
  • 6th: 14
  • 7th: 8
  • 8th: 3
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 128
LONG GROVE COUNTRY SCHOOL 20400 Old Hicks Rd Long Grove, IL 60047 Phone: 8474384834 PreK-K
Grade Size Distribution
  • PreK: 88
  • Knd: 10
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 98
MONTESSORI SCHOOL OF LONG GROV 1115 Robert Parker Coffin Rd Long Grove, IL 60047 Phone: 8476340430 PreK-6th
Grade Size Distribution
  • PreK: 63
  • Knd: 20
  • 1st: 8
  • 2nd: 13
  • 3rd: 8
  • 4th: 9
  • 5th: 7
  • 6th: 3
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 131
MONTESSORI WORLD OF DISCOVERY 1660 CHECKER RD Long Grove, IL 60047 Phone: 8478089662 PreK-K
Grade Size Distribution
  • PreK: 100
  • Knd: 25
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 125
Quentin Road Bible Church School 60 Quentin Rd Lake Zurich, IL 60047 Phone: 8474384494
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 0

* School data provided by US Department of Education


The data relating to real estate for sale on this website comes in part from the Broker Reciprocity program of Midwest Real Estate Data LLC. Real estate listings held by brokerage firms other than RE/MAX Northern Illinois are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the names of the listing brokers. © 2017 Midwest Real Estate Data LLC. All rights reserved. Information Deemed Reliable but Not Guaranteed. Listing information from this property search is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. NOTICE: Many homes contain recording devices, and buyers should be aware they may be recorded during a showing.

* Rates and payment information listed in the mortgage calculator are provided as for general reference only. Specific mortgage information should be verified with a qualified lending professional