BEDS5
BATHS4 full 1 partial
SQUARE FEET3,805
MLS#12646236
STATUSContingent
PROPERTY TYPEResidential - Single Family
SUBDIVISIONThree Lakes
SCHOOLDistrict 303
Property Description
Magnificent curb appeal highlights this exceptional all-brick luxury home set on a premium 1.5-acre corner lot in the sought-after Three Lakes subdivision of St. Charles. Offering an ideal blend of elegance, comfort, and functionality, this home is filled with natural light and thoughtfully designed living spaces. The open floor plan is anchored by a dramatic two-story family room with views of the expansive paver patio and private backyard. Designed for both everyday living and entertaining, the gourmet kitchen features high-end appliances, including a warming drawer and pot filler, along with a large island with prep sink and seating plus an adjacent breakfast area. A first-floor office with custom built-in shelving and a walk-in closet offers flexibility as a potential guest or first-floor bedroom. Upstairs, the impressive open staircase leads to a spacious primary suite featuring a sitting area, luxury bath, and oversized walk-in closet. A private princess suite and two additional bedrooms connected by a Jack-and-Jill bath complete the second level. The finished English basement provides exceptional additional living and entertaining space with a theater room, second family room, recreation area, exercise room, and full bath. Outside, the beautifully landscaped yard features zoned irrigation, professional uplighting, and expansive green space extending beyond the privacy evergreens - offering ample room for a pool, sports, or additional outdoor recreation. Recent updates include fresh neutral paint, new carpet, and newer roof and mechanicals. Award winning D303 school district, close to all restaurants and stores on Randall Road, access to I -90, lots of parks, bike trails and the amenities of vibrant St. Charles. This is a rare opportunity to own a truly exceptional home in one of the area's most desirable neighborhoods. Age of updates - Roof 2022, HVAC 2019 & 2021, H2O heater 2025, DW 2025, all Carpet 2026, Ejector pumps 2026, freshly painted throughout.
Property Features
Property Type: Residential - Single Family
Basement: Yes
Basement: Finished, Full, Daylight
Cooling: Central Air, Zoned
Fireplaces: 1
Garage: 3
Heating: Natural Gas, Forced Air, Zoned
Home Style: Traditional
Lot Size: 1.55 Acres
Roof Type: Asphalt
Taxes: $20,786
Year Built: 2002
Amenities
Vaulted Ceiling(s)
Cathedral Ceiling(s)
Dry Bar
1st Floor Bedroom
Built-in Features
Walk-In Closet(s)
High Ceilings
Feature Descriptions
Additional rooms: Foyer, Bedroom 5,Family Room, Exercise Room, Theatre Room, Recreation Room, Breakfast Room
Appliances: Range, Microwave, Dishwasher, High End Refrigerator, Washer, Dryer, Stainless Steel Appliance(s), Range Hood, Water Purifier Owned, Humidifier
Association Includes: None
Bath Features: Whirlpool, Separate Shower, Double Sink
Dining Room: Separate
Exterior: Brick
Fireplace: Attached Fireplace Doors/Screen, Gas Log, Gas Starter
Fireplace Location(s): Family Room
HOA Fee: 275/ Annually
Laundry: Main Level
Lot: Corner Lot, Cul-De-Sac, Landscaped
Lot Dimensions: 158 X 85 X 160 X 289 X 262
Other Equipment: Water-Softener Owned, Central Vacuum, Security System, Ceiling Fan(s), Sump Pump, Sprinkler-Lawn, Backup Sump Pump;, Radon Mitigation System, Security Cameras
Parcel#: 0906102011
Parking: Asphalt, Garage Door Opener, Yes, Garage Owned, Attached, Driveway, Owned, Garage
Security: yes
Sewer: Septic Tank
Total Rooms: 14
Township: St. Charles
Water: Well
Room Sizes
Foyer: 19X09
Bedroom 5: 15X13
Family Room - Down: 22X36
Exercise Room: 12X10
Theatre Room: 19X17
Recreation Room: 13X18
Breakfast Room: 12X11
Bedroom 2: 13X13
Bedroom 3: 14X13
Bedroom 4: 14X13
Dining Room: 14X13
Family Room: 19X20
Kitchen: 19X15
Laundry: 12X7
Living Room: 15X13
Primary Bedroom: 19X14
Local Schools
High School: St Charles North High School
Middle School: Thompson Middle School
Elementary School: Ferson Creek Elementary School
School District: District 303
Listed By / Shown By
Listed By
Agency Name: @properties Christie's International Real Estate
Agency Phone: 630-377-1700
Shown By
Agent Name: Tina Tendall & Amanda Clark
Agent Phone: (815) 621-3063
Agency Title: Gambino Realtors
Estimate Your Payment
Estimated Payment
$ 6,445.30 per month $4,428.75 Principal & Interest $1,732.17 Property Tax $284.38 Homeowner's InsuranceChange Payment Information
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
38w535 Red Bay Court | MLS# 12646236
This single family home located at 38w535 Red Bay Court, Saint Charles, IL 60175 is currently listed for sale with an asking price of $975,000. This property was built in 2002 and has 5 bedrooms and 4 full and 1 partial baths with 3805 sq. ft. 38w535 Red Bay Court is located in the Three Lakes subdivision within the District 303 school district. Search Three Lakes real estate on tina-tendall-amanda-clark.gogambino.com today.