• Listing status icon

    $1,799,900

  • Active | MLS#: 09199928
  • 6Beds
  • 8Baths
  • 11,554Sq Ft

5N155 Prairie Rose Drive ST. CHARLES, IL 60175

Favorite
Share
Close
Info Visit Search
My Property Finder members always view full listing details. Login or Register

Overview

Exquisite French Provincial Estate featuring 11000+ sq ft of PURE LUXURY! Sensational gourmet kitchen, 6 en-suite bdrms & spectacular W/O lower level w/spacious kitchen & bar area, theater, wine cellar & pool room! RESORT-like FORMER MODEL boasts gorgeous views, expansive in-ground pool, hot tub, deck & fire pit area. Feel like you are vacationing everyday at this tranquil, private 1 acre EXQUISITE residence!

Listing provided courtesy of: Coldwell Banker Residential

General Features

  • Additional Sales Info List Agent Must Accompany
  • Age 6-10 Years
  • Apx. Year Built 2006
  • Association Fees 1600
  • Assessment Frequency Annual
  • County Kane
  • Full Baths 6
  • Half Baths 2
  • Information School Bus Service,Commuter Train,Interstate Access
  • Number of Rooms 14
  • Property Features Waterfront
  • Recent Rehab No
  • Style of House French Provincial
  • Subdivision PRAIRIE LAKES
  • Tax Year 2015
  • Taxes 41375.78

Building Features

  • Air Conditioning Central Air
  • Appliances Oven-Double, Microwave, Dishwasher, Refrigerator-Bar, Washer, Dryer, Disposal
  • Approximate SqFt. 11554
  • Basement Finished, Exterior Access
  • Bathroom Amenities Whirlpool, Separate Shower, Double Sink
  • Disability Access No
  • Exterior Brick, Stone, Limestone
  • Fireplace Location/Type Gas Logs,Gas Starter
  • Garage Onsite Yes
  • Garage Type Garage Door Opener(s), Transmitter(s), Heated, 7+ Ft. High Garage Door
  • Heating Gas, Forced Air
  • House Type 2 Stories
  • Interior Features Bar-Wet, Hardwood Floors, Heated Floors, 1st Floor Bedroom, 1st Floor Laundry, 2nd Floor Laundry
  • Roofing Asphalt/Glass (Shingles)

Room Features

  • 2nd Bedroom Flooring Carpet
  • 2nd Bedroom Level 2nd BR on 2nd Floor
  • 2nd Bedroom Size 16X14
  • 3rd Bedroom Flooring Carpet
  • 3rd Bedroom Level 3rd BR on 2nd Floor
  • 3rd Bedroom Size 24X18
  • 4th Bedroom Flooring Carpet
  • 4th Bedroom Level 4th BR on 2nd Floor
  • 4th Bedroom Size 26X16
  • Dining Room Separate
  • Dining Room Flooring Hardwood
  • Dining Room Size 19X15
  • Family Room Flooring Carpet
  • Family Room Size 20X17
  • Kitchen Eating Area-Breakfast Bar, Eating Area-Table Space, Island, Pantry-Butler
  • Kitchen Flooring Other
  • Kitchen Size 29X24
  • Living Room Flooring Hardwood
  • Living Room Level Main Level
  • Living Room Size 21X16
  • Master Bedroom Flooring CARPET
  • Master Bedroom Level Master on 2nd Floor
  • Master Bedroom Size 26X19
  • Other Room 1 5th Bdrm
  • Other Room 1 Flooring Carpet
  • Other Room 1 Size 16X15
  • Other Room 2 6th Bdrm
  • Other Room 2 Flooring Carpet
  • Other Room 2 Size 24X15
  • Other Room 3 Study
  • Other Room 3 Flooring Hardwood
  • Other Room 3 Size 18X13
  • Other Room 4 Great Rm
  • Other Room 4 Flooring Carpet
  • Other Room 4 Size 31X23

Property Features

  • Acreage 0.93
  • Electricity 200+ Amp Service
  • Exterior Features Deck, Patio, Hot Tub, Porch Screened, Pool In-Ground
  • Foundation Concrete
  • Lot Description Fenced Yard, Landscaped Professionally, Pond, Water View
  • Lot Dimensions 130X255X207X255
  • Lot Size .50-.99 Acres
  • Sewer Sewer-Public
  • Water Public
  • Waterfront Yes

Schools

  • High School ST CHARLES NORTH HIGH SCHOOL
  • High School District 303
  • Elementary School District 303
  • Junior High District 303
  • Elementary School BELL-GRAHAM ELEMENTARY SCHOOL
  • Junior High THOMPSON MIDDLE SCHOOL

Ask a Question

Price & Status History

Days on Market

  • This property has been listed on the market for 279 days
  • Average days-on-market for homes between $1,439,920 - $2,159,880 = 140 (in zip code 60175)

Location

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

Walk Score

Get the Walk Score Report

Ask A Question

Local:

Demographics
Schools
Days on Market

Community Demographics for Zip Code 60175 (ST. CHARLES)

  • Housing Occupancy

    Home Owners
    8,245
    78%
    Renters
    613
    6%
    Vacant
    1,754
    17%
    Total Housing Units
    10,612
  • Households

    Average Household Size
    3.14
    Housing Density (People per square mile)
    843

Age Range (number of people)

Age 0-14
6,453
Age 15-24
4,430
Age 25-39
5,564
Age 40-59
5,913
Age 60-79
5,251
Age 80+
1,255
Total
28,866

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

School Information for 60175 (ST. CHARLES)

Public Schools in Zip Code 60175 (ST. CHARLES)

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

  • ST CHARLES NORTH HIGH SCHOOL
    255 RED GATE RD SAINT CHARLES, IL 60175
    Phone: 6304435700
    9th-12th
  • Grade Size Distribution
    • 9th
    • 514
    • 10th
    • 550
    • 11th
    • 546
    • 12th
    • 534
    • Teachers: 142
    • Students per Teacher: 15.1
    • Students: 2144
    • Male/Female: 1033/1099
    • District: ST CHARLES CUSD 303, 201 SOUTH 7TH ST SAINT CHARLES, IL 60174
    • Phone: 6305133030
    • Schools: 17
    • Full-Time Teachers: 871
    • Students per Teacher: 15.9
    • Staff: 1040
    • Students: 13876
  • BELL-GRAHAM ELEMENTARY SCHOOL
    4N505 FOX MILL BLVD SAINT CHARLES, IL 60175
    Phone: 6307626670
    PreK-5th
  • Grade Size Distribution
    • PreK
    • 2
    • Knd
    • 76
    • 1st
    • 91
    • 2nd
    • 92
    • 3rd
    • 92
    • 4th
    • 105
    • 5th
    • 117
    • Teachers: 34
    • Students per Teacher: 16.9
    • Students: 575
    • Male/Female: 245/285
    • District: ST CHARLES CUSD 303, 201 SOUTH 7TH ST SAINT CHARLES, IL 60174
    • Phone: 6305133030
    • Schools: 17
    • Full-Time Teachers: 871
    • Students per Teacher: 15.9
    • Staff: 1040
    • Students: 13876
  • FERSON CREEK SCHOOL
    38W160 BOLCUM RD SAINT CHARLES, IL 60175
    Phone: 6305134480
    PreK-5th
  • Grade Size Distribution
    • PreK
    • 32
    • Knd
    • 94
    • 1st
    • 102
    • 2nd
    • 105
    • 3rd
    • 108
    • 4th
    • 110
    • 5th
    • 117
    • Teachers: 34
    • Students per Teacher: 19.6
    • Students: 668
    • Male/Female: 274/367
    • District: ST CHARLES CUSD 303, 201 SOUTH 7TH ST SAINT CHARLES, IL 60174
    • Phone: 6305133030
    • Schools: 17
    • Full-Time Teachers: 871
    • Students per Teacher: 15.9
    • Staff: 1040
    • Students: 13876
  • Private Schools in Zip Code 60175 (ST. CHARLES)

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

    • GLENWOOD SCH FOR BOYS W CAMPUS
      41 W 400 SILVER GLEN St Charles, IL 60175
      Phone: 8474640136
      3rd-8th
    • Grade Size Distribution
      • 3rd
      • 4
      • 4th
      • 6
      • 5th
      • 14
      • 6th
      • 11
      • 7th
      • 11
      • 8th
      • 18
      • Teachers: 0
      • Students per Teacher: N/A
      • Students: 64
    • ST. CHARLES ACADEMY
      ST CHARLES, IL 60175
      Phone: 6307621492
      PreK-7th
    • Grade Size Distribution
      • Knd
      • 5
      • 1st
      • 6
      • 2nd
      • 11
      • 3rd
      • 8
      • 4th
      • 10
      • 5th
      • 14
      • 6th
      • 8
      • 7th
      • 9
      • Teachers: 0
      • Students per Teacher: N/A
      • Students: 71

    * 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.

* 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