Presenting an exquisite waterfront estate showcasing unparalleled architectural design and exceptional craftsmanship. This all-brick residence is situated on a sprawling 2.84-acre lot, graced with mature trees and serene gardens. Nestled within the prestigious Crane Road Estates, this property offers a rare combination of privacy and proximity, located mere minutes from downtown St. Charles. Spanning over 10,000 square feet of meticulously maintained living space across three levels, this estate is a testament to refined luxury. Highlights include five fireplaces, masterful millwork, and an attached five-car garage. The impressive two-story family room, with expansive windows, a built-in wet bar, and a striking floor-to-ceiling fireplace, serves as the centerpiece of the home. Adjacent is a gourmet kitchen featuring custom cherry cabinetry, premium Dacor and Bosch appliances, four ovens, warming drawers, and a generously sized Subzero refrigerator and freezer. The property extends its sophistication to the outdoors, with a private and elegant courtyard, perfect for morning coffee or intimate gatherings. The expansive formal dining room further enhances the home's entertainment appeal. The primary suite is a true retreat, complete with a two-sided fireplace, a sitting area, a private balcony with pond views, and a spa-inspired bathroom. Thoughtfully designed walk-in closets with organizational systems ensure both practicality and style. The walk-out lower level offers extensive entertainment amenities, including recreational and game rooms, a large bar, a wine cellar, a full second kitchen, a sauna, and a private spa bath. Exterior living spaces are equally impressive, providing a seamless connection to nature and situated across from the Forest Preserve and nearby bike trails. This estate not only delivers superior quality and design but is also complemented by its location within the boundaries of acclaimed schools, including Wild Rose Elementary, Wredling Middle School, and St. Charles North High School. This is a unique opportunity to acquire a residence that defines luxury living at its finest.
Closed
Street View
$1,315,000
4N675 Old Farm Rd, St Charles, IL 60175
4beds
7,018sqft
Single Family Residence
Built in 2000
2.84 Acres Lot
$2,652,800 Zestimate®
$187/sqft
$6,796 Estimated rent
Home value
$2,652,800
$2.52M - $2.79M
$6,796/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$6,796/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$6,796/mo
Rent Zestimate®
Refinance and save
$11,315/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$11,315/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listing courtesy of:
Maureen Hale 630-300-8955,
Coldwell Banker Realty
Bought with:
Gwendolyn James
Weichert, Realtors - All Pro
Source: MRED as distributed by MLS GRID,MLS#: 12319432
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Primary bedroom
- Features: Flooring (Carpet), Window Treatments (Curtains/Drapes), Bathroom (Full)
- Level: Second
- Area: 340 Square Feet
- Dimensions: 20X17
Bedroom 2
- Features: Flooring (Carpet), Window Treatments (Curtains/Drapes)
- Level: Second
- Area: 320 Square Feet
- Dimensions: 20X16
Bedroom 3
- Features: Flooring (Carpet), Window Treatments (Curtains/Drapes)
- Level: Second
- Area: 195 Square Feet
- Dimensions: 15X13
Bedroom 4
- Features: Flooring (Carpet), Window Treatments (All)
- Level: Second
- Area: 154 Square Feet
- Dimensions: 14X11
Bar entertainment
- Features: Flooring (Ceramic Tile)
- Level: Basement
- Area: 270 Square Feet
- Dimensions: 18X15
Dining room
- Features: Flooring (Hardwood), Window Treatments (Curtains/Drapes)
- Level: Main
- Area: 437 Square Feet
- Dimensions: 23X19
Exercise room
- Features: Flooring (Other)
- Level: Basement
- Area: 238 Square Feet
- Dimensions: 17X14
Family room
- Features: Flooring (Hardwood)
- Level: Main
- Area: 506 Square Feet
- Dimensions: 23X22
Kitchen
- Features: Kitchen (Island), Flooring (Ceramic Tile), Window Treatments (Curtains/Drapes)
- Level: Main
- Area: 378 Square Feet
- Dimensions: 21X18
Laundry
- Features: Flooring (Ceramic Tile)
- Level: Main
- Area: 88 Square Feet
- Dimensions: 11X8
Living room
- Features: Flooring (Hardwood)
- Level: Main
- Area: 182 Square Feet
- Dimensions: 14X13
Recreation room
- Features: Flooring (Carpet)
- Level: Basement
- Area: 506 Square Feet
- Dimensions: 23X22
Study
- Features: Flooring (Hardwood), Window Treatments (Curtains/Drapes)
- Level: Main
- Area: 195 Square Feet
- Dimensions: 15X13
Sun room
- Features: Flooring (Hardwood), Window Treatments (All)
- Level: Main
- Area: 252 Square Feet
- Dimensions: 18X14
Heating
- Natural Gas, Forced Air, Sep Heating Systems - 2+
Cooling
- Central Air, Zoned
Appliances
- Included: Double Oven, Microwave, Dishwasher, Refrigerator, Disposal, Trash Compactor
- Laundry: Main Level
Features
- Cathedral Ceiling(s), Wet Bar, Pantry
- Flooring: Hardwood
- Windows: Skylight(s)
- Basement: Finished,Full,Walk-Out Access
- Number of fireplaces: 5
- Fireplace features: Family Room, Living Room, Master Bedroom, Basement, Other
Interior area
- Total structure area: 0
- Total interior livable area: 7,018 sqft
Property
Parking
- Total spaces: 5
- Parking features: Asphalt, Brick Driveway, Garage Door Opener, On Site, Other, Attached, Garage
- Attached garage spaces: 5
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: No Disability Access
Features
- Stories: 2
- Patio & porch: Deck, Patio
- Exterior features: Balcony
- Has view: Yes
- View description: Water, Side(s) of Property
- Water view: Water,Side(s) of Property
- Waterfront features: Pond
Lot
- Size: 2.84 Acres
- Features: Wooded
Details
- Parcel number: 0921203001
- Special conditions: List Broker Must Accompany
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Brick, Stone
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2000
- Major remodel year: 2016
Utilities & green energy
- Electric: Circuit Breakers, 200+ Amp Service
- Sewer: Septic Tank
- Water: Well
Community & neighborhood
Community
- Community features: Lake, Street Paved
Location
- Region: St Charles
- Subdivision: Crane Road Estates
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $3,400 annually
- Services included: Other
Other
Other facts
- Listing terms: Conventional
- Ownership: Fee Simple
Price history
| Date | Event | Price |
|---|---|---|
| 5/15/2026 | Listing removed | $2,850,000$406/sqft |
Source:  MRED as distributed by MLS GRID #12495139 Report a problem | ||
| 2/5/2026 | Price change | $2,850,000-7.6%$406/sqft |
Source: MRED as distributed by MLS GRID #12495139 Report a problem | ||
| 10/14/2025 | Listed for sale | $3,085,000+134.6%$440/sqft |
Source: MRED as distributed by MLS GRID #12495139 Report a problem | ||
| 6/26/2025 | Sold | $1,315,000-11.7%$187/sqft |
Source: MRED as distributed by MLS GRID #12319432 Report a problem | ||
| 5/22/2025 | Contingent | $1,490,000$212/sqft |
Source: MRED as distributed by MLS GRID #12319432 Report a problem | ||
| 4/26/2025 | Listed for sale | $1,490,000$212/sqft |
Source: MRED as distributed by MLS GRID #12319432 Report a problem | ||
| 4/12/2025 | Contingent | $1,490,000$212/sqft |
Source: MRED as distributed by MLS GRID #12319432 Report a problem | ||
| 4/3/2025 | Listed for sale | $1,490,000+27.9%$212/sqft |
Source: MRED as distributed by MLS GRID #12319432 Report a problem | ||
| 1/31/2024 | Sold | $1,165,000-2.5%$166/sqft |
Source: MRED as distributed by MLS GRID #11804719 Report a problem | ||
| 12/18/2023 | Contingent | $1,195,000$170/sqft |
Source: MRED as distributed by MLS GRID #11804719 Report a problem | ||
| 11/1/2023 | Price change | $1,195,000-7.7%$170/sqft |
Source: MRED as distributed by MLS GRID #11804719 Report a problem | ||
| 7/25/2023 | Price change | $1,295,000-7.2%$185/sqft |
Source: MRED as distributed by MLS GRID #11804719 Report a problem | ||
| 6/21/2023 | Listed for sale | $1,395,000+50%$199/sqft |
Source: MRED as distributed by MLS GRID #11804719 Report a problem | ||
| 4/11/2018 | Sold | $930,000-6.1%$133/sqft |
Source: Public Record Report a problem | ||
| 4/11/2018 | Listed for sale | $989,900$141/sqft |
Source: Coldwell Banker Residential #09490471 Report a problem | ||
| 2/12/2018 | Pending sale | $989,900$141/sqft |
Source: Coldwell Banker Residential Brokerage - St Charles #09490471 Report a problem | ||
| 10/31/2017 | Price change | $989,900-0.5%$141/sqft |
Source: Coldwell Banker Residential Brokerage - St Charles #09490471 Report a problem | ||
| 7/18/2017 | Price change | $995,000-13.5%$142/sqft |
Source: Coldwell Banker Residential Brokerage - St Charles #09490471 Report a problem | ||
| 6/10/2017 | Price change | $1,150,000-17.6%$164/sqft |
Source: Coldwell Banker Residential Brokerage - St Charles #09490471 Report a problem | ||
| 1/31/2017 | Listed for sale | $1,395,000-7%$199/sqft |
Source: Coldwell Banker Residential Brokerage - St Charles #09490471 Report a problem | ||
| 9/27/2016 | Listing removed | $1,500,000$214/sqft |
Source: RE/MAX Excels #09143482 Report a problem | ||
| 2/19/2016 | Listed for sale | $1,500,000-8.8%$214/sqft |
Source: RE/MAX Excels #09143482 Report a problem | ||
| 11/10/2015 | Listing removed | $1,645,000+58.9%$234/sqft |
Source: RE/MAX Excels #08627238 Report a problem | ||
| 7/29/2015 | Sold | $1,035,000-37.1%$147/sqft |
Source: Public Record Report a problem | ||
| 5/29/2014 | Price change | $1,645,000-17.5%$234/sqft |
Source: RE/MAX Excels #08627238 Report a problem | ||
| 3/12/2013 | Price change | $1,995,000-8.3%$284/sqft |
Source: RE/MAX Excels #08288888 Report a problem | ||
| 7/9/2011 | Listed for sale | $2,175,000+574.4%$310/sqft |
Source: RE/MAX Excels #07852130 Report a problem | ||
| 3/29/1999 | Sold | $322,500$46/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $36,152 +4.4% | $507,873 +11.7% |
| 2023 | $34,617 +2.5% | $454,553 +4.8% |
| 2022 | $33,773 +4.8% | $433,854 +4.9% |
| 2021 | $32,212 +6.2% | $413,549 +1.9% |
| 2020 | $30,325 +1.8% | $405,838 +2% |
| 2019 | $29,789 -1.3% | $397,803 +4.8% |
| 2018 | $30,189 +8.8% | $379,608 +3.5% |
| 2017 | $27,737 -24.2% | $366,630 -14.5% |
| 2016 | $36,568 | $429,049 +9.4% |
| 2015 | -- | $392,022 +8.9% |
| 2014 | -- | $359,852 -1.8% |
| 2013 | -- | $366,281 -7.3% |
| 2012 | -- | $395,082 -21% |
| 2011 | -- | $500,202 -7% |
| 2010 | -- | $537,963 -2.6% |
| 2009 | -- | $552,600 -2.5% |
| 2008 | -- | $567,028 +9.5% |
| 2007 | -- | $517,629 +3% |
| 2006 | -- | $502,749 -1.9% |
| 2005 | -- | $512,722 +4.5% |
| 2004 | -- | $490,482 +16.1% |
| 2003 | -- | $422,627 +1.2% |
| 2002 | -- | $417,759 +2.2% |
| 2001 | -- | $408,625 +151.2% |
| 2000 | -- | $162,652 |
Find assessor info on the county website
Neighborhood: 60175
Nearby schools
GreatSchools rating
- 9/10Wild Rose Elementary SchoolGrades: K-5Distance: 0.9 mi
- 7/10Thompson Middle SchoolGrades: 6-8Distance: 1.7 mi
- 8/10St Charles North High SchoolGrades: 9-12Distance: 0.9 mi
Schools provided by the listing agent
- Elementary: Wild Rose Elementary School
- Middle: Haines Middle School
- High: St Charles North High School
- District: 303
Source: MRED as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,652,800
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,652,800
- Illinois
- Kane County
- Saint Charles
- 60175
- 4N675 Old Farm Rd