Date
Details
Price
Change
Source
7/27/2026
Listed
$3,500,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/6
$3,500,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/6
Property Description
Stunning new construction. Extraordinary design, finishes and craftsmanship with meticulous attention to detail.
Full Property Details
Full Property Details for 24 Tide Mill Terrace
General
- Price: $3,500,000
- Taxes: (July 2026-June 2027)
- Status: Under Contract
- Type: Single Family
- Source: SMARTMLS
- MLS ID: 24194823
- Updated: 7/31/2026
- Added to Site: 11 day(s) ago
Interior
- Number of Rooms: 14
- Rooms/Areas: Foyer, Laundry Room
- Interior Features: Cable - Pre-wired, Humidifier, Open Floor Plan, Security System
- Fireplace: Yes
- Number of Fireplaces: 1
- Appliances: Electric Cooktop, Wall Oven, Microwave, Range Hood, Refrigerator, Dishwasher
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 4
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 5
- Primary Bedroom: Primary Bedroom - Bedroom Suite, Full Bath, Walk-In Closet, Hardwood Floor, Upper
- Bedroom 1: Bedroom - Laminate Floor, Lower
- Bedroom 2: Bedroom - Jack & Jill Bath, Hardwood Floor, Upper
- Bedroom 3: Bedroom - Full Bath, Hardwood Floor, Upper
- Bedroom 4: Bedroom - Jack & Jill Bath, Hardwood Floor, Upper
Other Rooms
- Great Room: Great Room - 9 ft+ Ceilings, Gas Log Fireplace, Hardwood Floor, Main
- Kitchen: Kitchen - 9 ft+ Ceilings, Quartz Counters, Island, Pantry, Patio/Terrace, Hardwood Floor, Main
- Dining Room: Dining Room - 9 ft+ Ceilings, Hardwood Floor, Main
- Den: Den - Laminate Floor, Lower
- Study: 9 ft+ Ceilings, Built-Ins, Hardwood Floor, Main
- Game room: Yes
- Game Room: Rec/Play Room - Laminate Floor, Lower
- Rec Room: Laminate Floor, Lower
- Laundry: Upper Level
Additional Information
- Pool: Yes
- Pool Description: Heated, In Ground Pool
Exterior
- Exterior Features: Underground Utilities, Gutters, Underground Sprinkler, Patio
- Color: Grey
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 2
- Total Spaces: 3
- Parking: Attached Garage, Paved, Driveway
Location
- County: Fairfield
- Neighborhood: Sasco
- Driving Directions: As per GPS
School Information
- Elementary School: Mill Hill
- High School: Fairfield Ludlowe
Community
- Community Name: Sasco
Heating & Cooling
- Cooling Type: Central Air, Zoned
- Heating Type: Hot Air, Zoned, Natural Gas
- Heating Fuel: Natural Gas
- Water Heater: Natural Gas, Tankless Hotwater
Utilities
- Sewer: Public Sewer Connected
- Water: Public Water Connected
Structural Information
- Architectural Style: Colonial
- Construction Status: To Be Built
- Exterior Const.: Shingle, Hardie Board
- Basement Desc.: Full, Heated, Fully Finished, Cooled, Liveable Space, Full With Walk-Out
- Roof: Asphalt Shingle
- Attic: Yes
- Square Feet: 5,033
- Above Ground: 3,737 Sq. Ft.
- Below Ground: 1,296 Sq. Ft.
- Year Built: 2027
Lot Features
- Lot Size (Acres): 0.24
- Driveway/Sidewalk: Private, Paved
- Zoning: A
- Lot Description: Level Lot, On Cul-De-Sac, Professionally Landscaped
Water Features
- Water Front Desc.: Beach Rights
Green Features
- Energy Features: Generator, Programmable Thermostat, Ridge Vents, Thermopane Windows
Financial Considerations
- Assessment Amount: $999,999
- Tax Year: July 2026-June 2027
Disclosures and Reports
- Property ID: 999999999
Listed by Higgins Group Bedford Square, Susan Tracy and Higgins Group Bedford Square, Cheryl Tara
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 24 Tide Mill Terrace —
Susan Tracy
Higgins Group Bedford Square
Cheryl Tara
Higgins Group Bedford Square
Agent Contact: (203) 856-8628 Office Contact: (203) 226-0300
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 24 Tide Mill Terrace
School District:Fairfield School District
| Name | Grades | Distance |
|---|---|---|
Mill Hill School 635 Mill Hill Terrace, Fairfield, CT 06890 | K-5 | 0.7 mi |
Roger Ludlowe Middle School 689 Unquowa Road, Fairfield, CT 06824 | 6-8 | 0.9 mi |
Fairfield Ludlowe High School 785 Unquowa Road, Fairfield, CT 06824 | 9-12 | 0.9 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 24 Tide Mill Terrace
Estimate the Cost
Estimate the Cost for 24 Tide Mill Terrace
Home Warranty : Included
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 9 hours ago
- 4Beds
- 5Total Baths
- 3,744Sq. Ft.
Listed by Cindy Raney & Team (203) 625-1025
- Single Family
- Active
- Updated 19 hours ago
- 5Beds
- 5Total Baths
- 6,166Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 4 days ago
- 2Beds
- 1Total Bath
- 900Sq. Ft.
Listed by The Lage Team at Coldwell Banker Realty (203) 521-7757
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 2Total Baths
- 2,019Sq. Ft.
- Apartment
- Active
- Updated 4 days ago
- 2Beds
- 1Total Bath
- 700Sq. Ft.
- Condo
- Active
- Updated 3 days ago
- 2Beds
- 2Total Baths
- 1,128Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 2Beds
- 3Total Baths
- 2,812Sq. Ft.
Listed and Sold by Team Bondi at Coldwell Banker Realty
- Single Family
- Closed
- 5Beds
- 5Total Baths
- 4,692Sq. Ft.
Listed by Cindy Raney & Team
Sold by Megan Donofrio
Sold by Megan Donofrio
24 Tide Mill Terrace, Fairfield, CT 06824 (MLS# 24194823) is a Single Family property with 5 bedrooms, 4 full bathrooms and 1 partial bathroom. 24 Tide Mill Terrace is currently listed for $3,500,000 and was received on July 27, 2026. Want to learn more about 24 Tide Mill Terrace? Do you have questions about finding other Single Family real estate for sale in Fairfield? You can browse all Fairfield real estate or contact a Coldwell Banker agent to request more information.