Skip main navigation
Active
    • $1,999,000

    4N675 Old Farm Rd, St Charles, IL 60175

    4beds
    10,000sqft
    : 
    $13,584/mo
    Get pre-qualified
    Single Family Residence
    Built in 2000
    10,000 Square Feet Lot
    $1,925,600 Zestimate®
    $200/sqft
    $140/mo HOA

    What's special

    Waterfront custom homeWet barWalkout lower levelSpa bath
    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!
    --
    on Zillow
    |
    761
    views
    |
    24
    saves
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Gwendolyn James 773-637-6500,

    Weichert, Realtors - All Pro

    Source: MRED as distributed by MLS GRID,MLS#: 12702666MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 6
      • Full bathrooms: 4
      • 1/2 bathrooms: 2
      Rooms
      • Room types: Exercise Room, Recreation Room, Study, Sun Room
      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 (Carpet)
      • 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
      • 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: 10,000 sqft

      Property

      Parking
      • Total spaces: 5
      • Parking features: Asphalt, Yes, Attached, Garage
      • Attached garage spaces: 5
      Accessibility
      • Accessibility features: No Disability Access
      Features
      • Stories: 2
      • Has spa: Yes
      • Spa features: Indoor Hot Tub
      • Has view: Yes
      • View description: Water, Side(s) of Property
      • Has water view: Yes
      • Water view: Water,Side(s) of Property
      • Waterfront features: Pond
      Lot
      • Size: 10,000 Square Feet
      • Features: Wooded
      Details
      • Parcel number: 0921203001
      • Special conditions: Exceptions-Call List Office,List Broker Must Accompany

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Brick, Stone
      Condition
      • New construction: No
      • Year built: 2000

      Utilities & green energy

      • Electric: Circuit Breakers, 200+ Amp Service
      • Sewer: Septic Tank
      • Water: Well

      Community & HOA

      Community
      • Features: Lake, Street Paved
      • Subdivision: Crane Road Estates
      HOA
      • Has HOA: Yes
      • Services included: Other
      • HOA fee: $1,677 annually
      Location
      • Region: St Charles

      Financial & listing details

      • Price per square foot: $200/sqft
      • Tax assessed value: $1,523,619
      • Annual tax amount: $34,000
      • Date on market: 7/13/2026
      • Ownership: Fee Simple w/ HO Assn.

        Estimated market value

        $1,925,600

        $1.83M - $2.02M

        $5,833/mo

        Price history

        DateEventPrice
        5/15/2026Listing removed$2,850,000$285/sqft
        Source: MRED as distributed by MLS GRID #12495139 Report a problem
        2/5/2026Price change$2,850,000-7.6%$285/sqft
        Source: MRED as distributed by MLS GRID #12495139 Report a problem
        10/14/2025Listed for sale$3,085,000+134.6%$309/sqft
        Source: MRED as distributed by MLS GRID #12495139 Report a problem
        6/26/2025Sold$1,315,000-11.7%$132/sqft
        Source: MRED as distributed by MLS GRID #12319432 Report a problem
        5/22/2025Contingent$1,490,000$149/sqft
        Source: MRED as distributed by MLS GRID #12319432 Report a problem
        4/26/2025Listed for sale$1,490,000$149/sqft
        Source: MRED as distributed by MLS GRID #12319432 Report a problem
        4/12/2025Contingent$1,490,000$149/sqft
        Source: MRED as distributed by MLS GRID #12319432 Report a problem
        4/3/2025Listed for sale$1,490,000+27.9%$149/sqft
        Source: MRED as distributed by MLS GRID #12319432 Report a problem
        1/31/2024Sold$1,165,000-2.5%$117/sqft
        Source: MRED as distributed by MLS GRID #11804719 Report a problem
        12/18/2023Contingent$1,195,000$120/sqft
        Source: MRED as distributed by MLS GRID #11804719 Report a problem
        11/1/2023Price change$1,195,000-7.7%$120/sqft
        Source: MRED as distributed by MLS GRID #11804719 Report a problem
        7/25/2023Price change$1,295,000-7.2%$130/sqft
        Source: MRED as distributed by MLS GRID #11804719 Report a problem
        6/21/2023Listed for sale$1,395,000+50%$140/sqft
        Source: MRED as distributed by MLS GRID #11804719 Report a problem
        4/11/2018Sold$930,000-6.1%$93/sqft
        Source: Public Record Report a problem
        4/11/2018Listed for sale$989,900$99/sqft
        Source: Coldwell Banker Residential #09490471 Report a problem
        2/12/2018Pending sale$989,900$99/sqft
        Source: Coldwell Banker Residential Brokerage - St Charles #09490471 Report a problem
        10/31/2017Price change$989,900-0.5%$99/sqft
        Source: Coldwell Banker Residential Brokerage - St Charles #09490471 Report a problem
        7/18/2017Price change$995,000-13.5%$100/sqft
        Source: Coldwell Banker Residential Brokerage - St Charles #09490471 Report a problem
        6/10/2017Price change$1,150,000-17.6%$115/sqft
        Source: Coldwell Banker Residential Brokerage - St Charles #09490471 Report a problem
        1/31/2017Listed for sale$1,395,000-7%$140/sqft
        Source: Coldwell Banker Residential Brokerage - St Charles #09490471 Report a problem
        9/27/2016Listing removed$1,500,000$150/sqft
        Source: RE/MAX Excels #09143482 Report a problem
        2/19/2016Listed for sale$1,500,000-8.8%$150/sqft
        Source: RE/MAX Excels #09143482 Report a problem
        11/10/2015Listing removed$1,645,000+58.9%$165/sqft
        Source: RE/MAX Excels #08627238 Report a problem
        7/29/2015Sold$1,035,000-37.1%$104/sqft
        Source: Public Record Report a problem
        5/29/2014Price change$1,645,000-17.5%$165/sqft
        Source: RE/MAX Excels #08627238 Report a problem
        3/12/2013Price change$1,995,000-8.3%$200/sqft
        Source: RE/MAX Excels #08288888 Report a problem
        7/9/2011Listed for sale$2,175,000+574.4%$218/sqft
        Source: RE/MAX Excels #07852130 Report a problem
        3/29/1999Sold$322,500$32/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax 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

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 60175

        Getting around

        3 / 100
        Car-Dependent
        42 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        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.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Saint Charles Topics

                Search
                Updates
                Favorites
                Plan
                Inbox