This home's estimate is 14.5% lower than the average sale price ($874K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
674 Opening Hill Rd, Madison, CT 06443
About this home
Private and serene describe this unique 4 bedroom contemporary cape, located on an almost 2 acre interior lot in Madison, South of Route 80. This custom built home offers a 2 story foyer, first floor bedroom with full bathroom, large kitchen with breakfast nook, office, family room, full dining room and formal living room all on the first floor. On the second floor you will find the primary bedroom suite; complete with vaulted ceilings, a Palladian window, huge walk-in closet, full bathroom with skylights, a whirlpool tub and walk-in shower. The laundry is located outside the primary bedroom. There are 2 other bedrooms on the second floor. One has vaulted ceilings and a Palladian window. 2 car attached garage and flat backyard. This is a unique home in a private, but convenient setting. 10 minutes to town and beaches. Time to call this house your home!
Redfin Estimate
Earn from this home
List your home with Redfin and save $7,476
Get cash now or lower your monthly rate
List your home for rent
Market trends in 06443, CT
Last updated August 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 674 Opening Hill Rd
$228/sq ft
$233/sq ft
$195/sq ft
$202/sq ft
$106/sq ft
$19/sq ft
Tax history for 674 Opening Hill Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Parking
- Garage Information
- Garage & Parking: Attached Garage
- Garages Number: 2
Interior
- Virtual Tour Information
- Has Virtual Tour
- Interior Information
- Total Rooms: 10
- Laundry Room Location: In Hallway outside Primary bedroom
- Laundry Room Info: Upper Level
- Interior Features: Auto Garage Door Opener, Cable - Available
- In-Law Apartment: Possible
- Fireplaces Total: 1
- Cooling System: Central Air
- Appliances Included: Electric Range, Microwave, Refrigerator, Disposal, Washer, Dryer
- Bathroom Information
- # of Baths (Full): 3
- Bedroom Information
- Beds Total: 4
- Room Information
- Rooms Additional: Foyer
- Room Count: 10
- Basement Description: Full With Hatchway, Unfinished, Concrete Floor, Interior Access, Storage
- Has Attic
- Attic Description: Access Via Hatch
Exterior
- Exterior Features
- Roof Information: Asphalt Shingle
- Exterior Siding: Clapboard, Wood
- Exterior Features: Deck, Lighting, Sidewalk, Stone Wall
- Lot Information
- Lot Description: Interior Lot, Dry, Corner Lot, Level Lot, Lightly Wooded
- Building Information
- Foundation Type: Concrete
- Construction Description: Frame
- Color: Sage
- Property Information
- Radon Mitigation Air
- Property Type: Single Family For Sale
- Living Area SQFT Per Public Record: 2568
- Driveway Type: Shared, Asphalt
Financial
- Assessments Information
- Assessed Value: $274,500
Utilities
- Utility Information
- Water Source: Private Well
- Sewage System: Septic
- Hot Water Description: Oil
- Heat Type: Hot Air
- Heat Fuel Type: Oil
- Fuel Tank Location: In Basement
- Energy Features: Thermopane Windows
Location
- School Information
- Middle Jr High School: Brown
- Intermediate School: Per Board of Ed
- High School: Daniel Hand
- Elementary School: Per Board of Ed
- Location Information
- State: Connecticut
- Nearby Amenities: Golf Course, Health Club, Medical Facilities, Playground/Tot Lot, Public Pool, Shopping/Mall, Stables/Riding, Tennis Courts
- Directions: 79 North to left on Overbrook. Right at stop sign. Right onto Opening Hill Rd to #674 on the right. First house on right on private road.
- County: New Haven
Public facts
- Beds: 4
- Baths: 3.0
- Sq. Ft.: 2,568
- Stories: 2.0
- Lot Size: 1.91 acres
- Style: Single Family Residential
- Year Built: 1993
- Year Renovated: —
- County: New Haven County
- APN: 1160019
Other
- Documents & Disclosures
- Supplement Count Public: 1
Around this home
Schools
Public K-3 • Assigned • 0.9mi
Public 6-8 • Assigned • 3.8mi
Public 9-12 • Assigned • 3.9mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 93° expected this year, 17 days in 30 years
67% chance of strong winds in next 30 years
5 unhealthy days expected this year, 8 days in 30 years
Sun exposure
In this area, properties receive around 8.9 hours in June and 4.5 hours in December, which is comparable to the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 06443
Home values near 674 Opening Hill Rd
| Address | Redfin Estimate |
|---|---|
4 Beds | 2.5 Baths | 2200 Sq. Ft. | $627,069 |
3 Beds | 2.5 Baths | 1248 Sq. Ft. | $514,651 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2 Baths | 1650 Sq. Ft. | $533,929 |
4 Beds | 3 Baths | 3347 Sq. Ft. | $915,984 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2 Baths | 1215 Sq. Ft. | $519,646 |
3 Beds | 2 Baths | 2857 Sq. Ft. | $622,008 |
More real estate resources
- Zip Codes
- Cities
- Minor Civil Divisions
- Popular Searches
| 07940 homes for sale | |||
| 07960 homes for sale | |||
| 07928 homes for sale | |||
| 07932 homes for sale |
| Montclair homes for sale | |||
| Summit homes for sale | |||
| New York homes for sale |
| Bloomfield Township homes for sale | |||
| Piscataway Township homes for sale | |||
| Livingston Township homes for sale | |||
| West Orange Township homes for sale | |||
| Wayne Township homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.




































United States
Canada