Active Under Contract
Single family home for sale at 400 Dayton Rd, Glastonbury, CT 06073 | MLS# 24201786 | Listing updated on 2026-09-10
Photo 1 of Single family home for sale at 400 Dayton Rd, Glastonbury, CT 06073 | MLS# 24201786 | Listing updated on 2026-09-10
Photo 2 of Single family home for sale at 400 Dayton Rd, Glastonbury, CT 06073 | MLS# 24201786 | Listing updated on 2026-09-10
Photo 3 of Single family home for sale at 400 Dayton Rd, Glastonbury, CT 06073 | MLS# 24201786 | Listing updated on 2026-09-10
Photo 4 of Single family home for sale at 400 Dayton Rd, Glastonbury, CT 06073 | MLS# 24201786 | Listing updated on 2026-09-10
36+
Beds Icon

Street View

$1,500,000

Monthly Est:$7,466

  • Beds Icon2 Beds
  • Beds Icon
    3 Baths
  • Beds Icon2,312sqft

400 Dayton Rd, Glastonbury, CT 06073

$7,466/moEst:

Get Pre-Approved

  • Single Family Residence

  • Built in 1978

  • $-- HOA

  • 24.94 acres lot

  • $649/sq.ft

Description

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 single story home 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.

  • Houzeo last checked: 48 minutes ago
  • Listing updated: September 10, 2026 at 11:13 pm
  • Listing Provided by: Jeffrey Anderson | William Pitt Sotheby's International Realty
  • Source: SMART MLS-CT | MLS#: 24201786 SMART MLS-CT

Property Details

  • Status

    Active Under Contract

  • Type

    Single Family Residence

  • No. of Stories

    -

  • County

    Hartford County

  • City

    Glastonbury

  • Neighborhood

    --

  • Year Built

    1978

  • HOA Fees

    -

  • Finished Area

    2,312 sqft

  • Lot Size

    24.94 acres lot

  • Basement Area

    - sqft

  • MLS Name

    SMART MLS

  • MLS Number

    24201786

  • MLS Status

    Under Contract - Continue to Show

  • Days on Market

    42

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

HOA Management

0

HOA Fees

$-/

Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 2

    Bathrooms: 3

Interior

  • Heating

    Oil, Hot Water

  • Appliances

    Oven/range, Microwave, Refrigerator, Dishwasher, Washer, Electric Dryer

  • Interior Features

    Auto Garage Door Opener, Cable Available, Open Floor Plan

  • Cooling

    Central Air

  • Sewer

    Septic

Construction

  • Year Built

    Year Built: 1978

  • Home type

    Single Family Residence

  • Architectural Style

    Ranch

  • Foundation Details

    Concrete

  • Roof

    Asphalt Shingle

Utilities & Energy

  • Basement

    Full, Storage, Garage Access, Walk Out

  • Water Source

    Private Well

  • Laundry Features

    Main Level

  • Parking Features

    Attached Garage, Paved, Off Street Parking, Driveway

Other Features

  • Subdivision Name

    South Glastonbury

  • Lot Features

    Secluded, City Views, Treed, Rocky, Borders Open Space, Water View

Price History

DateEventPrice

09/10/2026

Source: mls_logoSMART MLS-CT #24201786

Contingent (Active Under Contract)

$1,500,000

$649/sqft

08/28/2026

Source: mls_logoSMART MLS-CT #24201786

Listed for Sale

$1,500,000

$649/sqft

08/26/2026

Source: mls_logoSMART MLS-CT #24201786

Coming Soon

$1,500,000 +140.00%

$649/sqft

07/21/2020

Source: #170299565

Sold

$625,000 -21.78%

$270/sqft

06/06/2020

Source: #170239757

Listing Removed

$799,000

$346/sqft

Nearby Homes

Based on information provided to and compiled by the SMART MLS, Inc. through Oct 08, 2026, 07:30AM. IDX information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS. ©2026 SMART MLS, Inc. All Rights Reserved.

Advertising Broker: Derek Greene | The Greene Realty Group