This home's estimate is 55.2% higher than the average sale price ($777K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
197 N Farms Rd, Middlebury, CT 06762
About this home
Enjoy this custom built, architecturally designed, one owner home at the end of cul-de-sac road in desirable area of Middlebury. Professionally landscaped on almost 3 acres bordered by acres of land trust. This home has been totally remodeled and features 4+ BRS, 3.5 baths, office, sunroom,3 F/Ps, Viking kitchen & media room. Fabulous Gunite salt water heated pool with hot tub and cascading waterfall. Large Trex deck & bluestone patio with awnings. Freshly painted exterior, new roof & new central air systems. This home has all of the amenities including instant hot water, pot filler, combination steam convection oven, and much more. Minutes to I-84 & easy access to New York & Massachusetts. Call for private showing. Owner/agent.
Redfin Estimate
Earn from this home
List your home with Redfin and save $12,059
Get cash now or lower your monthly rate
List your home for rent
Market trends in 06762, CT
Last updated July 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 197 N Farms Rd
$246/sq ft
$246/sq ft
$246/sq ft
$51/sq ft
$81/sq ft
Tax history for 197 N Farms 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
- Interior Information
- Total Rooms: 11
- Laundry Room Location: First Floor
- Laundry Room Info: Main Level
- Interior Features: Auto Garage Door Opener, Cable - Available, Open Floor Plan, Security System
- In-Law Access: Possible
- Appliances, Electric Outlet(s)
- Fireplaces Total: 2
- Cooling System: Ceiling Fans, Central Air, Split System
- Appliances Included: Gas Range, Wall Oven, Microwave, Range Hood, Refrigerator, Dishwasher, Disposal, Instant Hot Water Tap, Washer, Electric Dryer
- Bathroom Information
- # of Baths (Full): 3
- # of Baths (Half): 1
- Bedroom Information
- Beds Total: 4
- Room Information
- Room Count: 15
- Basement Description: Full, Concrete Floor, Interior Access, Garage Access
- Has Attic
- Attic Description: Pull-Down Stairs
Exterior
- Exterior Features
- Roof Information: Asphalt Shingle
- Exterior Siding: Clapboard, Cedar, Wood
- Exterior Features: Awnings, Deck, Gutters, Lighting, Patio, Porch-Enclosed, Sidewalk, Stone Wall, Underground Utilities
- Lot Information
- Lot Description: On Cul-De-Sac, Level Lot
- Pool Information
- Swimming Pool
- Pool Description: In Ground Pool, Spa, Heated, Salt Water, Safety Fence, Gunite, Solar Cover
- Building Information
- Foundation Type: Concrete
- Construction Description: Frame, Brick
- Color: Gray
- Property Information
- Property Type: Single Family For Sale
- Living Area SQFT Per Public Record: 3454
Financial
- Assessments Information
- Assessed Value: $394,700
Utilities
- Utility Information
- Water Source: Private Well
- Sewage System: Septic
- Hot Water Description: Oil
- Heat Type: Baseboard, Hot Water
- Heat Fuel Type: Oil
- Fuel Tank Location: In Basement
- Energy Features: Programmable Thermostat, Ridge Vents, Thermopane Windows
Location
- School Information
- Middle Jr High School: Memorial
- High School: Pomperaug
- Elementary School: Long Meadow
- Location Information
- State: Connecticut
- Nearby Amenities: Basketball Court, Golf Course, Health Club, Lake, Library, Park, Private School(s), Tennis Courts
- Directions: Route 64 to Charcoal Ave. right hand turn onto Breakneck Hill Rd then left on on North Farm Road. At end of cul-de-sac.
- County: New Haven
Public facts
- Beds: 4
- Baths: 3.5
- Sq. Ft.: 3,908
- Stories: 2.0
- Lot Size: 2.83 acres
- Style: Single Family Residential
- Year Built: 1987
- Year Renovated: —
- County: New Haven County
- APN: 1192038
Other
- Documents & Disclosures
- Supplement Count Public: 1
Around this home
Schools
Public PreK-5 • Assigned • 3.4mi
Public 6-8 • Assigned • 2.2mi
Public 9-12 • Assigned • 3.6mi
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 97° expected this year, 15 days in 30 years
26% chance of strong winds in next 30 years
1 unhealthy days expected this year, 1 days in 30 years
Sun exposure
In this area, properties receive around 8.8 hours in June and 4.3 hours in December, placing it below the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 06762
Home values near 197 N Farms Rd
| Address | Redfin Estimate |
|---|---|
4 Beds | 2.5 Baths | 2913 Sq. Ft. | $905,241 |
3 Beds | 2.5 Baths | 2971 Sq. Ft. | $806,859 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 5 Baths | 4321 Sq. Ft. | $1,103,887 |
4 Beds | 2.5 Baths | 2889 Sq. Ft. | $760,840 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 3 Baths | 4134 Sq. Ft. | $989,378 |
4 Beds | 2.5 Baths | 3301 Sq. Ft. | $760,557 |
More real estate resources
- Cities
- Counties
- Popular Searches
| New Haven homes for sale | |||
| Trumbull homes for sale | |||
| Milford homes for sale |
| Westchester County homes for sale | |||
| Nassau County homes for sale | |||
| Suffolk County 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