Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 644 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 644 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 644 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1088 Center Drive
South Elgin, IL 60177

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,897,500
Beds: 9
Baths: 10
Status: Active
SqFt: 12095
Agency: Keller Williams Inspire

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 18 acre(s)
Property Type: Residential
Year Built: 1988
Notes: *St. Charles Schools D303* Experience the epitome of country living on this expansive 18-acre compound, boasting a plethora of recreational amenities and multiple well-appointed dwellings. Whether you're a fan of fishing, swimming, snowmobiling, or horseback riding, this compound offers a wide array of opportunities to indulge in your favorite outdoor activities. The ranch home, spanning 4,390 square feet, features 3 bedrooms, 2.5 baths, a rejuvenating sauna, an attached 2.25 car garage, and a luxurious saltwater pool. Adjacent to the pool is a 728 sq ft pool house equipped with a full bath, a well-appointed kitchen, ample storage, and a built-in gas grill. For automotive enthusiasts, there's a detached 2,000 sq ft garage with loft storage space and double-height ceilings designed to accommodate car lifts. Just across the driveway, the elegant two-story home, constructed in 2006, spans 5,897 square feet. It features an attached 3.5 car garage, 5 bedrooms, including a first-floor master ensuite, and 4.5 bathrooms. The home boasts a gourmet kitchen, a full finished basement with a wet bar, wine cellar, and a game room. Notable features include 10' ceilings throughout, 8' solid sapele wood doors, and radiant heated floors in all bathrooms, the basement, and the garage. Further enhancing the property is a 1,080 sq ft ranch guest house nestled amidst the scenic landscape. This charming guest house offers 2 bedrooms, 1 bathroom, a full basement, and an inviting enclosed front porch. Additional storage space is provided by a separate barn, ideal for housing recreational vehicles, yard equipment, and various outdoor gear. Or for horses and other animals. Outdoor enthusiasts will revel in the beauty of the property, which includes stunning decks, inviting patios, a well-maintained garden area, Brewster Creek with a picturesque wooden bridge, a spring-fed pond, 3 acres of natural fen, wooded expanses, an artesian spring, and easy access to adjacent Kane County bike trails. This property is served by Anderson Elementary, Wredling Middle School, and St. Charles North High School, with bus service provided. Value added features: (2021) Ranch: New pool chlorinator, 2 story: 2nd zone AC, Nest thermostat; (2020) 2 story: Timbertech deck; (2019) Ranch: Washer & Dryer; (2018) Ranch: Diving board, 2 story: Interior painting & trim, Miele dishwasher; (2017) Ranch: Composite deck off master bedroom, 2 story: Washer; (2014) Ranch: 20KW generator; (2010) 2 story: Generator; (2008) Ranch Complete tear-off/replace roof, Barn roof; (2006) 2 Story: 2nd zone water heater.
MlsNumber: 11909541


Listing Provided By: Keller Williams Inspire, original listing
Name: Keller Williams Inspire
Phone: (630) 377-6200
Office Name: Keller Williams Inspire - Geneva
Office Phone: (630) 262-9500
Agent Name: Katie Fish
Disclaimer: Copyright © 2024 Midwest Real Estate Data, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 644 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Larry Lazar
Larry Lazar
ASCIICharles Rutenberg Realty
Mobile: (312) 933-7822

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App