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
    $2,667,800 Zestimate®
    $284/sqft
    $283/mo HOA

    What's special

    Two-sided fireplaceWaterfront estateFive fireplacesPrimary suiteAll-brick residenceLarge barFull second kitchen
    138 days
    |
    2,285
    |
    28
    |

    Zillow last checked: 8 hours ago

    Listing updated: February 09, 2026 at 10:07pm

    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

    $2,667,800

    $2.53M - $2.80M

    $7,064/mo

    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

    BuyAbility℠ payment

    Est. payment
    $20,086/mo
    Principal & interest
    $14697
    Property taxes
    $5106
    HOA Fees
    $283

      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.

      Local experts in 60175

      Similar homes

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