Stunning waterfront custom home truly shows pride of ownership! This home shows like new and takes "immaculate condition" to another level! Appx 10,000 sq. ft on 3 levels - including walkout LL. Wonderful for entertaining-spacious formal Dining Rm. Dramatic 2-story Great Rm with Wet Bar. Enjoy cooking in this gourmet Kitchen with custom cherry cabinetry. The walkout Lower Level is a retreat; wet bar w/ wine cellar, Family Rm and Game Rm areas, Spa Bath and Exercise Rm. Enjoy the privacy & beauty of this 2.85 acre home site!
Single-familyProperty Type
2000Year Built
$180Price/Sq.Ft.
$140/moHOA Dues
5 car garageParking
Listed by Gwendolyn James• Weichert, Realtors - All Pro
Crane Road Estates, located between Crane Road and Randall Road, is a residential and suburban St. Charles neighborhood with curving streets and a wooded-edge feel. The streetscape leans toward late-20th-century single-family homes with generous setbacks and mature trees. Neighborhood character concentrates around the Crane Rd & Main St corridor, where traffic, storefront signage, and commuter rhythm set the pace. Community touchstones nearby include The Arcada Theatre, Pollyanna Brewing Company, and the St. Charles History Museum. Fox River paths and downtown blocks add a walk-and-bike counterpoint to the quieter interior streets. Daily routines often orbit parks, schools, and errands along Randall Road’s retail spine.
Provided by Walk Score and Local Logic
Offer insights
4N675 Old Farm Rd · $1,799,000
$1.77M and above
75% chance or better to win
Why $1.77M+ is a strong offer
SALE-TO-LIST
100.7%
Most homes are selling 1% above list price.
LIST PRICE
$1,799,000
Median list price in this area is $443,374. (75% lower than this home)
About offer insights
Property details
Interior
Exterior
Finance
Kitchen
Bathroom
Living
Interior features
Hot tub
Skylights
Finished full basement with walkout access
11 total rooms
Five fireplaces located in family room, living room, master bedroom, basement and another room
Bedrooms
4 bedrooms total
Master bedroom on the second floor
Three additional bedrooms on the second floor
Bathrooms
4 full bathrooms
2 half bathrooms
Master bath features whirlpool, separate shower and double sink
Basement has a bathroom
Kitchen
Kitchen with island
Double oven
Microwave
Dishwasher
Refrigerator
Disposal
Trash compactor
Ceramic tile flooring in the kitchen
Laundry & utility
Main-level laundry room
Laundry room with ceramic tile flooring
Flooring
Hardwood flooring in many main-level rooms
Carpet in certain bedrooms, recreation and exercise rooms
Ceramic tile in kitchen and select rooms
Heating & cooling
Natural gas heating with forced air
Multiple heating systems (more than one)
Central air conditioning with zoned controls
Exterior features
Water view with a pond on the property
Wooded lot
Located on a paved street
Lot between 2.0 and 2.99 acres
Home design
Detached single-family home
Two-story design
Fee simple ownership with homeowner association
Approximately 26–30 years old
Parking
Attached garage with 5 garage spaces
Asphalt driveway
Total parking for 5 vehicles
Construction
Brick and stone construction
Utilities
Well water
Septic tank sewage
200+ amp electric service with circuit breakers
HOA & community
Annual association fee of $1,677
Association fee covers unspecified other items
Community amenities include a lake
Other
School bus service available
Subdivision: Crane Road Estates
Electricity and solar
View estimated energy costs and solar savings for this home
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.
MRED as Distributed by MLS Grid #11804719
Jan 31, 2024
Sold (MLS) (Closed)
$1,165,000
$117/sq ft
Dec 18, 2023
Contingent (Contingent - Continue to Show)
—
Nov 1, 2023
Price Changed
$1,195,000
$120/sq ft
Jul 25, 2023
Price Changed
$1,295,000
$130/sq ft
Jun 21, 2023
Listed (Active)
$1,395,000
$140/sq ft
MRED as Distributed by MLS Grid #09490471
Apr 10, 2018
Sold (MLS) (Closed Sale)
$929,900
$93/sq ft
Feb 12, 2018
Contingent
—
Oct 31, 2017
Price Changed
$989,900
$99/sq ft
Jul 18, 2017
Price Changed
$995,000
$100/sq ft
Jun 10, 2017
Price Changed
$1,150,000
$115/sq ft
Jan 31, 2017
Listed (New)
$1,395,000
$140/sq ft
MRED as Distributed by MLS Grid #09143482
Sep 27, 2016
Listing Removed
—
Feb 19, 2016
Listed (New)
*
MRED as Distributed by MLS Grid #08627238
Nov 9, 2015
Listing Removed
—
May 28, 2014
Listed (New)
*
MRED as Distributed by MLS Grid #08288888
May 28, 2014
Listing Removed
—
Mar 11, 2013
Listed (New)
*
MRED as Distributed by MLS Grid #07852130
Mar 11, 2013
Listing Removed
—
Jul 8, 2011
Listed (New)
*
Public Records
Mar 29, 1999
Sold
$548,333
$55/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$29,736 (−17.7%)
$99,558 + $451,637
$551,195
2024
$36,152 (+4.4%)
$99,558 + $451,637
$551,195
2023
$34,617 (+2.5%)
$91,733 + $416,140
$507,873
2022
$33,773 (+4.8%)
$82,102 + $372,451
$454,553
2021
$32,212 (+0.6%)
$103,626 + $330,228
$433,854
2020
$32,013 (+1.7%)
$98,776 + $314,773
$413,549
2019
$31,477 (+4.3%)
$95,015 + $302,788
$397,803
2018
$30,189 (+2.2%)
$95,015 + $302,788
$397,803
2017
$29,525 (−21.2%)
$101,557 + $278,051
$379,608
2016
$37,445 (+3.8%)
$98,085 + $268,545
$366,630
2015
$36,068 (+16.2%)
$94,640 + $334,409
$429,049
2013
$31,037 (−1.1%)
$94,556 + $271,725
$366,281
2012
$31,368 (−17.8%)
$94,556 + $271,725
$366,281
2011
$38,167 (+5.8%)
$129,784 + $265,298
$395,082
2010
$36,091 (+8.3%)
$139,235 + $398,728
$537,963
2009
$33,317 (+0.8%)
$139,235 + $398,728
$537,963
2008
$33,064 (+10.9%)
$141,069 + $425,959
$567,028
2007
$29,814
$141,069 + $376,560
$517,629
Public record
Public record
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
2.78 Acres
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Kane County
APN
0921203001
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 24, 2026.
May 24, 2021 • Active
Residential repair
Tear off and replace the roof on a residential building.
Roofing
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Climate risks
3/10 Flood Factor
Estimated 10-14% chance of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
2/10 Heat Factor
7 days above 101° expected this year, 14 days in 30 years
2/10 Wind Factor
0% chance of strong winds in next 30 years
4/10 Air Factor
3 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
St Charles, IL • 60175
Average low and high temperatures (°F)
28
14
37
20
54
33
62
43
70
49
80
62
84
67
81
63
79
57
67
47
49
36
34
21
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
90/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.2 hrs
5.6 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 4N675 Old Farm Rd
$1,734,490
$65K under list price of $1.80M
Nearby comparable homes
The Redfin Estimate uses 5 recent nearby sales, priced between $1.4M to $3.0M.