• 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
  • 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 2016
  • Taxes 42006.20

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
  • Additional Room 5 Game Rm
  • Additional Room 5 Flooring Carpet
  • Addtitional Room 5 Size 18X16
  • 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 460 days
  • Average days-on-market for homes between $1,439,920 - $2,159,880 = 234 (in zip code 60175)

Location

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

Ask A Question

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
School Population
  • Teachers: 142
  • Students per Teacher: 15.1
  • Students: 2144
  • Male/Female: 1033/1099
School District
  • ST CHARLES CUSD 303
  • 201 SOUTH 7TH ST SAINT CHARLES, IL 60174
  • Phone: 6305133030
District Population
  • 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
School Population
  • Teachers: 34
  • Students per Teacher: 16.9
  • Students: 575
  • Male/Female: 245/285
School District
  • ST CHARLES CUSD 303
  • 201 SOUTH 7TH ST SAINT CHARLES, IL 60174
  • Phone: 6305133030
District Population
  • 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
School Population
  • Teachers: 34
  • Students per Teacher: 19.6
  • Students: 668
  • Male/Female: 274/367
School District
  • ST CHARLES CUSD 303
  • 201 SOUTH 7TH ST SAINT CHARLES, IL 60174
  • Phone: 6305133030
District Population
  • 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
School Population
  • 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
School Population
  • 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