Agent profile image in chat bubble
Agent profile image in chat header

IDX Support

sales rep | Brivity IDX

Agent profile image in message

39 W675 Goldenrod Dr , St. Charles, IL 60175
$1,500,000
Est. Payment: $8,048.21/mo
6 Bed
5 Bath
6747 Sqft
0.46 Acres
Status: active | Days on site: 15
Get Pre-Qualified
132 - 7679,268141
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from IDX Support, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.

House Description

Located in the highly sought-after Prairie Lakes community, this exceptional, nearly all-brick Derrico-built home showcases timeless craftsmanship, a finished walkout lower level, an oversized four-car garage, and peaceful lake views from both the front and back of the home. A grand two-story foyer welcomes you with rich hardwood flooring that flows throughout the main level. The distinguished executive office is enhanced by extensive custom millwork and built-in cabinetry, creating an elegant and functional workspace. The impressive family room features a soaring boxed-beam ceiling, a dramatic floor-to-ceiling exposed brick fireplace, and oversized windows that flood the space with natural light. The luxury kitchen is thoughtfully designed for both everyday living and effortless entertaining, featuring a grand center island, custom cabinetry, and granite countertops. The elegant dining room showcase exquisite architectural detailing and abundant natural light, creating inviting spaces for both intimate gatherings and larger celebrations. The main level also offers the option to add a second laundry area, providing additional flexibility for everyday living. The luxurious primary suite is a true private retreat, complete with its own fireplace and direct access to a private balcony overlooking the backyard. The spa-inspired ensuite features dual vanities, elegant finishes, and a spacious walk-in closet with custom built-ins, along with a second-floor laundry room located within the primary suite. The additional bedrooms are generously sized and appointed with detailed ceilings and walk-in closets, including a private ensuite and a Jack-and-Jill bath. A versatile first-floor bedroom with access to a full bath is ideal for guests or multigenerational living. The space can also serve as a formal living room, offering flexibility to suit your lifestyle. The finished walkout lower level expands the home's exceptional living space, featuring a spacious family room anchored by a beautiful brick fireplace, a private bar area, a generously sized bedroom, a full bathroom, and a versatile flex room ideal as a home gym, office, game room, or hobby space. A dedicated storage room and separate utility room housing the furnace and tankless gas water heater add valuable functionality and organization. The walkout lower level opens to a brick paver patio overlooking the beautifully landscaped backyard, creating a seamless indoor-outdoor living experience. Meticulously maintained grounds, exceptional architectural details, custom finishes, and a premier Prairie Lakes location complete this remarkable home, offering the perfect blend of luxury, comfort, and functionality. Ideally located near downtown St. Charles, this home offers easy access to exceptional dining, boutique shopping, scenic trails, and beautiful parks. Situated within the highly desirable District 303 school system, this location provides the perfect combination of convenience, community, and top-rated education. A rare opportunity to enjoy an elevated lifestyle in one of St. Charles' most sought-after areas.

Highlights

Listed by Kari Kohler , 630-673-4586 and Melanie Chavez , (630) 746-2244 Coldwell Banker Realty , 630-377-1771. Midwest Real Estate Data mls logo

Property Type

Residential

Lot/Acreage
0.46

HOA Fee

2044 Annually

Year Built

2007

County

Kane

Area

Campton Hills / St. Charles

Neighborhood

Prairie Lakes

School District

303

Listing ID

12724769

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:6
  • ▪ Bathrooms:5
  • ▪ Full Bathrooms:5
Appliances:Range, Microwave, Dishwasher, High End Refrigerator, Washer, Dryer, Stainless Steel Appliance(s), Wine Refrigerator, Humidifier, Intercom,CO Detectors,Ceiling Fan(s),Fan-Attic Exhaust,Sump Pump,Sprinkler-Lawn,Multiple Water Heaters
Air Cond:Central Air
Fireplaces:Gas Starter
Floor:Hardwood,Carpet
Below Ground Sq Ft:2324
Basement:Finished,Rec/Family Area,Storage Space,Full,Walk-Out Access
Other:
  • ▪ Additional:Wet Bar, 1st Floor Bedroom, 1st Floor Full Bath, Built-in Features, Walk-In Closet(s), Coffered Ceiling(s), Separate Dining Room, Pantry
Water:Shared Well

Exterior Features

Lot:Garden
Lot Dimensions:94 X 189 X 91 X 198
Garage Capacity:4
Roof:Asphalt
Others:
  • ▪ Additional:Fire Pit
Sewer:Public Sewer
Parking Features:Asphalt,Garage Door Opener,Yes,Garage Owned,Attached,Garage
Principal Interest
$8,048
Taxes
$2,059
HOA
$2,044

Home Price

$1,500,000

Loan Details

30 yrs
7.08%

Down Payment

20%
$300,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$8,048.21

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $8,048.21 $2,059.09 $2,044.00 $12,151.29
Yearly $96,578.48 $24,709.02 $24,528.00 $145,815.50
Total $2,897,354.51 $741,270.60 $735,840.00 $4,374,465.11
Lender profile image
Master Chief
Lender
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Oct 2026

Average Price

All Price Ranges
N/A
Oct 2026

Average Days on Market

All Price Ranges
N/A
Oct 2026
Market insight data is pulled from the same city as the listing being viewed (St. Charles, IL).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Based on information submitted to the MRED as of the date listed below. All data is obtained from various sources and has not been, and will not be, verified by broker or MRED. MRED 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. IDX information 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. Data is deemed reliable but is not guaranteed by MTP or MRED. The use of the MRED 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.

Based on information submitted to the MLS GRID as of the date listed below. 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. 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. Some listings have been excluded from this website.

IDX service by Blueroof 360

Data last updated: 2026-10-27T00:56:05.000Z

© 2026 Midwest Real Estate Data

MLS Logo - Midwest Real Estate Data