400 Dayton Road
Glastonbury, Connecticut 06073
- Beds
- 2
- Baths
- 2 | 1
- SqFt
- 2,312
- Acres
- 24.94
- Year Built
- 1978
- Neighborhood
- South Glastonbury
- Property Type
- Single Family

Matt Caiola
Luxury Real Estate Advisor
Request a private showing and get Matt's read on price, condition, and next steps.
About This Home
Exceptionally rare, The Howe Quarry Cliff House is a truly one-of-a-kind property set on 25+ private forested acres, dramatically positioned atop a cliff overlooking the historic quarry and pond. The setting offers remarkable 180-degree unobstructed views stretching from the Hartford skyline to Sleeping Giant in New Haven, the Connecticut River Valley, Portland Bridge, and the rolling fields of South Glastonbury-along with spectacular sunsets night after night. Designed to embrace its extraordinary surroundings, this custom-built ranch captures the views from nearly every room, including dramatic perspectives directly into the Quarry below. From the deck and porch, watch eagles & hawks soar at eye level and enjoy a sense of privacy that is difficult to find, all just minutes from the village of South Glastonbury. Recently renovated from top to bottom, the home blends naturally with its setting through warm, earthy tones, wood cabinetry, wide-board floors, and abundant windows. The main living and dining area features a striking floor-to-ceiling fireplace constructed with stone from the Quarry itself. The primary and guest bedrooms each offer beautifully appointed stone bathrooms inspired by the surrounding landscape. An attached two-car garage is complemented by an additional lower-level garage with direct basement access-ideal for ATVs, outdoor equipment, and recreational gear.
Key Facts
- City/Town
- Glastonbury
- Neighborhood
- South Glastonbury
- Property / Style
- Single Family · Ranch
- Year Built
- 1978
- Days on Market
- 0 days
- Beds
- 2
- Baths
- 2 full · 1 half
- Living Area
- 2,312 sq ft
- Lot Size
- 24.94 acres
- Garage / Parking
- 3 garage · 8 total
- Property Taxes
- $15,837 / Annually
Market Snapshot
The Glastonbury Market
Single Family · trailing 12 months
Active Listings
30
44 under contract
Median List Price
$644,950
30 active listings
Median Closed Price
$625,000
303 sales
Median Days on Market
29
30 active listings
Median $ / Sq Ft
$269
30 active listings
Sale-to-List Ratio
103.7%
303 sales
How this home compares
List Price
$1.50M
vs $644,950 median
2.3× the median
Price / Sq Ft
$649
vs $269 median
2.4× the median
Days on Market
0 days
vs 29 days median
29 days fresher than median
Based on 30 active and 303 closed sales (trailing 12 mo) of single family in Glastonbury. Source: SmartMLS · As of August 27, 2026.
Location
400 Dayton Road, Glastonbury, Connecticut
Estimate Your Payment
Estimated Monthly Payment
Rates: Freddie Mac PMMS via FRED · Updated Aug 20, 2026per month
- Principal & Interest$7,704
- Property Taxes$1,320
- Insurance$500
- HOA$0
Estimates only. Actual rates, taxes, insurance, and HOA fees vary. Consult a lender for current rates.
Location
- City/Town
- Glastonbury
- Neighborhood
- South Glastonbury
- County
- Hartford
Residence
- Property Type
- Single Family
- Style
- Ranch
- Year Built
- 1978
- New Construction
- No/Resale
- Living Area
- 2,312 sq ft
Schools
- Elementary
- Nayaug
- Middle
- Gideon Welles
- High
- Glastonbury
Interior
- Heating
- Hot Water
- Heat Fuel
- Oil
- Cooling
- Central Air
- Fireplaces
- 1
- Laundry
- Main Level
- Laundry Location
- Mudroom
- Appliances
- Oven/RangeMicrowaveRefrigeratorDishwasherWasherElectric Dryer
- Basement
- FullStorageGarage AccessWalk-out
- Interior Features
- Auto Garage Door OpenerCable - AvailableOpen Floor Plan
- Additional Rooms
- FoyerMud RoomWorkshop
- Accessibility
- Accessible Bath
Exterior & Lot
- Lot Size
- 24.94 acres
- Zoning
- CR
- Garage / Parking
- 3 garage spaces8 total parking spacesAttached GaragePavedOff Street ParkingDrivewayPrivatePavedCrushed Stone
- Waterfront
- Direct waterfront
- Waterfront Details
- BrookWalk to WaterView
- Water Source
- Private Well
- Sewer
- Septic
- Construction
- Cedar
- Roof
- Asphalt Shingle
- Foundation
- Concrete
- Lot Description
- SecludedCity ViewsTreedRockyBorders Open SpaceWater View
Listing & Financials
- Property Taxes
- $15,837 / Annually
- Days on Market
- 0
- MLS #
- 24201786
- MLS Status
- Coming Soon
- Financing
- FHA,VA,CHFA
Similar Properties
Homes with a close match in area, property type, and price.
Co-Listed By
Wendy Anderson
William Pitt Sotheby's International Realty
This information is believed to be accurate, but without warranty.
The IDX display contains information sourced from SmartMLS, Inc. as of 8/27/2026. This information is provided for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing or leasing. Data is deemed reliable but is not guaranteed accurate by the MLS, the listing broker, the listing agent, or Matt Caiola. Buyers and tenants should independently verify all information that matters to their decision.
Map locations may be approximate. Any offer of compensation, if applicable, is made only to participants of the MLS where the listing is filed. ©2026 Smart MLS, Inc. All rights reserved.
Data last updated on 8/27/2026 at 3:10 AM UTC.