Skip main navigation
Under contract
  • $3,500,000

    24 Tide Mill Terrace, Fairfield, CT 06824

    5beds
    5,033sqft
    : 
    $23,209/mo
    Get pre-qualified
    Single Family Residence
    Built in 2027
    10,454 Square Feet Lot
    $-- Zestimate®
    $695/sqft
    $-- HOA

    What's special

    Extraordinary design
    Stunning new construction. Extraordinary design, finishes and craftsmanship with meticulous attention to detail. Taxes will be determined upon completion.
    31 days
    |
    166
    |
    3
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Susan Tracy (203)856-8628,

    Higgins Group Bedford Square 203-226-0300,

    Cheryl Tara 203-913-0768,

    Higgins Group Bedford Square

    Source: Smart MLS,MLS#: 24194823MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 5
      • Full bathrooms: 4
      • 1/2 bathrooms: 1
      Rooms
      • Room types: Laundry
      Primary bedroom
      • Features: Bedroom Suite, Full Bath, Walk-In Closet(s), Hardwood Floor
      • Level: Upper
      Bedroom
      • Features: Full Bath, Hardwood Floor
      • Level: Upper
      Bedroom
      • Features: Jack & Jill Bath, Hardwood Floor
      • Level: Upper
      Bedroom
      • Features: Jack & Jill Bath, Hardwood Floor
      • Level: Upper
      Bedroom
      • Features: Laminate Floor
      • Level: Lower
      Den
      • Features: Laminate Floor
      • Level: Lower
      Dining room
      • Features: High Ceilings, Hardwood Floor
      • Level: Main
      Great room
      • Features: High Ceilings, Gas Log Fireplace, Hardwood Floor
      • Level: Main
      Kitchen
      • Features: High Ceilings, Quartz Counters, Kitchen Island, Pantry, Patio/Terrace, Hardwood Floor
      • Level: Main
      Rec play room
      • Features: Hardwood Floor
      • Level: Third,Upper
      Rec play room
      • Features: Laminate Floor
      • Level: Lower
      Study
      • Features: High Ceilings, Built-in Features, Hardwood Floor
      • Level: Main
      Heating
      • Forced Air, Zoned, Natural Gas
      Cooling
      • Central Air, Zoned
      Appliances
      • Included: Electric Cooktop, Oven, Microwave, Range Hood, Refrigerator, Dishwasher, Gas Water Heater, Tankless Water Heater, Humidifier
      • Laundry: Upper Level
      Features
      • Wired for Data, Open Floorplan, Entrance Foyer
      • Windows: Thermopane Windows
      • Basement: Full,Heated,Finished,Cooled,Liveable Space
      • Attic: Partially Finished,Walk-up
      • Number of fireplaces: 1
      Interior area
      • Total structure area: 5,033
      • Total interior livable area: 5,033 sqft
      • Finished area above ground: 3,737
      • Finished area below ground: 1,296

      Property

      Parking
      • Total spaces: 3
      • Parking features: Attached, Paved, Driveway, Private
      • Attached garage spaces: 2
      • Has uncovered spaces: Yes
      Features
      • Patio & porch: Patio
      • Exterior features: Rain Gutters, Underground Sprinkler
      • Has private pool: Yes
      • Pool features: Heated, In Ground
      • Waterfront features: Beach Access
      Lot
      • Size: 10,454 Square Feet
      • Features: Level, Cul-De-Sac, Landscaped
      Details
      • Parcel number: 999999999
      • Zoning: A
      • Other equipment: Generator

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence
      Materials
      • Shingle Siding, HardiPlank Type
      • Foundation: Concrete Perimeter, Masonry
      • Roof: Asphalt
      Condition
      • To Be Built
      • New construction: Yes
      • Year built: 2027
      Details
      • Warranty included: Yes

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Underground Utilities
      Green energy
      • Energy efficient items: Thermostat, Ridge Vents, Windows

      Community & HOA

      Community
      • Features: Golf, Health Club, Library, Near Public Transport, Shopping/Mall
      • Security: Security System
      • Subdivision: Sasco
      HOA
      • Has HOA: No
      Location
      • Region: Fairfield

      Financial & listing details

      • Price per square foot: $695/sqft
      • Tax assessed value: $999,999
      • Annual tax amount: $999,999
      • Date on market: 7/28/2026

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        7/31/2026Pending sale$3,500,000$695/sqft
        Source: Smart MLS #24194823 Report a problem
        7/28/2026Listed for sale$3,500,000+250%$695/sqft
        Source: Smart MLS #24194823 Report a problem
        9/18/2025Sold$1,000,000+0.5%$199/sqft
        Source: Smart MLS #24084380 Report a problem
        5/31/2025Pending sale$995,000$198/sqft
        Source: Smart MLS #24084380 Report a problem
        3/31/2025Listed for sale$995,000$198/sqft
        Source: Smart MLS #24084380 Report a problem

        Public tax history

        Tax history is unavailable.

        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.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 06824

        Getting around

        59 / 100
        Somewhat Walkable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Mill Hill
        • High: Fairfield Ludlowe

        Source: Smart MLS. 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