Stunning new construction. Extraordinary design, finishes and craftsmanship with meticulous attention to detail. Taxes will be determined upon completion.
Under contract
$3,500,000
24 Tide Mill Terrace, Fairfield, CT 06824
5beds
5,033sqft
Single Family Residence
Built in 2027
10,454 Square Feet Lot
$-- Zestimate®
$695/sqft
$-- HOA
What's special
Extraordinary design
- 32 days
- 82
- 2
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#: 24194823
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
| Date | Event | Price |
|---|---|---|
| 7/31/2026 | Pending sale | $3,500,000$695/sqft |
Source: | ||
| 7/28/2026 | Listed for sale | $3,500,000+250%$695/sqft |
Source: | ||
| 9/18/2025 | Sold | $1,000,000+0.5%$199/sqft |
Source: | ||
| 5/31/2025 | Pending sale | $995,000$198/sqft |
Source: | ||
| 3/31/2025 | Listed for sale | $995,000$198/sqft |
Source: | ||
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.Climate risks
Neighborhood: 06824
Nearby schools
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.










