Skip main navigation
Active
  • Price cut: $235K (2/5)
    $2,850,000

    4N675 Old Farm Rd, St Charles, IL 60175

    4beds
    10,024sqft
    : 
    Single Family Residence
    Built in 2000
    2.83 Acres Lot
    $-- Zestimate®
    $284/sqft
    $283/mo HOA

    What's special

    Two-sided fireplaceWaterfront estateFive fireplacesPrimary suiteAll-brick residenceLarge barFull second kitchen
    184 days
    |
    1,315
    |
    28
    |

    Zillow last checked:

    Listing updated:

    Listing courtesy of:

    Gwendolyn James 773-637-6500,

    Weichert, Realtors - All Pro

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

    Tour with a local agent

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 6
      • Full bathrooms: 4
      • 1/2 bathrooms: 2
      Rooms
      • Room types: Study, Exercise Room, Kitchen, Recreation Room
      Primary bedroom
      • Features: Flooring (Carpet), Window Treatments (Window Treatments), Bathroom (Full)
      • Level: Second
      • Area: 340 Square Feet
      • Dimensions: 20X17
      Bedroom 2
      • Features: Flooring (Carpet), Window Treatments (Window Treatments)
      • Level: Second
      • Area: 320 Square Feet
      • Dimensions: 20X16
      Bedroom 3
      • Features: Flooring (Carpet), Window Treatments (Window Treatments)
      • Level: Second
      • Area: 195 Square Feet
      • Dimensions: 15X13
      Bedroom 4
      • Features: Flooring (Carpet), Window Treatments (Window Treatments)
      • 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 (Eating Area-Breakfast Bar), Flooring (Ceramic Tile), Window Treatments (Curtains/Drapes)
      • Level: Main
      • Area: 378 Square Feet
      • Dimensions: 21X18
      Kitchen 2nd
      • Features: Flooring (Other)
      • Level: Basement
      • Area: 221 Square Feet
      • Dimensions: 17X13
      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
      Heating
      • Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: High End Refrigerator
      Features
      • Cathedral Ceiling(s), Sauna, Open Floorplan, Pantry
      • Windows: Skylight(s)
      • Basement: Finished,Walk-Out Access
      Interior area
      • Total structure area: 0
      • Total interior livable area: 10,024 sqft

      Property

      Parking
      • Total spaces: 5
      • Parking features: Asphalt, Yes, Attached, Garage
      • Attached garage spaces: 5
      Accessibility
      • Accessibility features: No Disability Access
      Features
      • Stories: 3
      • Has view: Yes
      • View description: Front of Property
      • Water view: Front of Property
      Lot
      • Size: 2.83 Acres
      Details
      • Parcel number: 0921203001
      • Special conditions: List Broker Must Accompany

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Brick
      Condition
      • New construction: No
      • Year built: 2000
      • Major remodel year: 2016

      Utilities & green energy

      • Sewer: Septic Tank
      • Water: Well

      Community & HOA

      HOA
      • Has HOA: Yes
      • Services included: None
      • HOA fee: $3,400 annually
      Location
      • Region: St Charles

      Financial & listing details

      • Price per square foot: $284/sqft
      • Tax assessed value: $1,523,619
      • Annual tax amount: $36,152
      • Date on market: 10/14/2025
      • Ownership: Fee Simple
      Get pre-qualifiedBe ready to make an offer.
      Connect with an agentGet info on this home, tour, and more.
      Calculate monthly paymentSee if you can afford this home.

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        Price history
        DateEventPrice
        2/5/2026Price change$2,850,000-7.6%$284/sqft
        Source: MRED as distributed by MLS GRID #12495139 Report a problem
        10/14/2025Listed for sale$3,085,000+134.6%$308/sqft
        Source: MRED as distributed by MLS GRID #12495139 Report a problem
        6/26/2025Sold$1,315,000-11.7%$131/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%$116/sqft
        Source: MRED as distributed by MLS GRID #11804719 Report a problem
        12/18/2023Contingent$1,195,000$119/sqft
        Source: MRED as distributed by MLS GRID #11804719 Report a problem
        11/1/2023Price change$1,195,000-7.7%$119/sqft
        Source: MRED as distributed by MLS GRID #11804719 Report a problem
        7/25/2023Price change$1,295,000-7.2%$129/sqft
        Source: MRED as distributed by MLS GRID #11804719 Report a problem
        6/21/2023Listed for sale$1,395,000+50%$139/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%$99/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%$139/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%$164/sqft
        Source: RE/MAX Excels #08627238 Report a problem
        7/29/2015Sold$1,035,000-37.1%$103/sqft
        Source: Public Record Report a problem
        5/29/2014Price change$1,645,000-17.5%$164/sqft
        Source: RE/MAX Excels #08627238 Report a problem
        3/12/2013Price change$1,995,000-8.3%$199/sqft
        Source: RE/MAX Excels #08288888 Report a problem
        7/9/2011Listed for sale$2,175,000+574.4%$217/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

        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
        $19,707/mo
        Principal & interest
        $14318
        Property taxes
        $5106
        HOA Fees
        $283
        More affordability tools

          Climate risks

          Neighborhood: 60175

          Getting around

          3 / 100
          Car-Dependent
          42 / 100
          Somewhat Bikeable

          Nearby schools

          GreatSchools rating
          Schools provided by the listing agent
          • 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.

          A local lender can help you make sure your offer is ready when you are.

          Browse local experts

          Similar homes

          Skip to the end of the carouselSkip to the beginning of the carousel