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;

41w070 Brown Road
St. Charles, IL 60175

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,075,000
Beds: 6
Baths: 6
Status: Active
SqFt: 3920
Agency: Executive Realty Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2000
Notes: Gorgeous Custom-Built Home approx. 5,140 SF. So much more than just a home, Live, Work & Play Retreat! Interior/Exterior updated, renovated and maintained by Custom Home builder owner. 3 Full Kitchens, 6 Bedrooms, 6 Baths, Perfect Work from home office (700 sq. ft.) over Detached garage or Studio/Man cave Space. Multi-generational Home with In-Law arrangement in English Basement with direct entry from Attached garage (Kitchen, full bath, separate laundry, bedroom, Den set up). In Ground pool w/auto cover, patio with Gazebo, Large deck off main Kitchen, Separate Built-in grill w/Fire pit Patio for additional entertaining, Huge Multifunction Sport Court (basketball, Pickle ball, Volleyball, w/outdoor lighting), 2+ Acre lot with huge backyard, professionally maintained. 6 Security cameras to Allow for full view of pool/outside from anywhere. 5 Car Garage: a hobbyist's dream with large detached, heated 2+ car garage and 3 car attached garage with showroom epoxy floor finish. Top Rated St. Charles Schools #303. Picturesque Wrap around porch to watch sunsets and the beautiful neighborhood around you. *Kitchens include a total of 4 Refrigerators * 3 Ovens * 3 Microwaves * Granite Counters * Custom Cabinets *** *MAIN LEVEL offers Main Kitchen with Large Island/breakfast bar, Family Rm, Office/Den, DR, 1st Floor Bedroom/Library with HW Floors & Built-In Book Shelving Units, with adjacent Full Bathroom, 3" Oak Flooring recently refinished, Custom Mudroom & Laundry Room *SECOND FLOOR has 4 BR's & 3 Full Baths = Primary Bedrm with large On-Suite bathrm, Includes 2 Huge walk-in closets, 2nd Bedrm w/On-suite bathrm, 2 other bedrms share large shower hall bath. *English Basement Includes Large Natural light Family room with Gas Fireplace and IN-LAW SUITE with Full Kit., BR, Den, BA, & Laundry RM. *UTILITIES include 2 A/C ('21 & '22) Main House * 4 Furnaces = Main Level, Lower Level, Garage & Suite in Garage(Mini split Heat/AC) * 3 Water Heaters ('21 & '22, 2-50 gallon HWH's main house, 1 Tankless High Efficient HWH detached garage) * 2 Fireplaces * All this Set On 2+ Acres of Outdoor Paradise including a Sport Court, In-Ground Heated Fiberglass 18x38 Pool with Winter Cover & Summer Built-In Auto Cover ('18), Outdoor Built-in Grill and Patio with Fire Pit, Maintenance Free Decks & Railings ('21), Gazebo ('22), 20 KW Natural Gas Generator ('17), New Roof & Gutters ('22), Exterior Painted ('22), New Shutters ('22), Landscaping ('17), Overhead Garage Doors ('21 & '22), Side Entry Doors ('22), Epoxy Coated Attached 3 Car Garage ('23), Replaced Well Pump ('23), Under-Ground Dog Fence * Whole House Alarm System with 6 Security Cameras = 2 Ring & 4 Comcast Connected to Police Notification*With Comcast Service*
MlsNumber: 12031635


Listing Provided By: Executive Realty Group, original listing
Name: Executive Realty Group
Phone: (630) 894-1030
Office Name: Executive Realty Group LLC
Office Phone: (630) 894-1030
Agent Name: Rosa Wayda
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