This home's estimate is 16.3% lower than the average sale price ($338K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate



















197 Turnpike Rd, Ashford, CT 06278
About this home
Probate sale sold as is where is .... beautiful 2.40 acre corner lot with a pond. Do your due diligence .... a lot of potential Limited information. Outbuildings May not be safe. Has knob and tube wiring, needs a septic system and has termite damage. Contents may remain waiting on confirmation CASH ONLY- put your highest and best MAKE AN OFFER! ALL OFFERS SUBJECT TO PROBATE APPROVAL
Redfin Estimate
Earn from this home
List your home with Redfin and save $2,828
List your home for rent
Market trends in 06278, CT
Last updated October 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 197 Turnpike Rd
$95/sq ft
$86/sq ft
$129/sq ft
Tax history for 197 Turnpike 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: Detached Garage
- Garages Number: 1
Interior
- Virtual Tour Information
- Has Virtual Tour
- Interior Information
- Total Rooms: 5
- Interior Features: Open Floor Plan
- Fireplaces Total: 1
- Bathroom Information
- # of Baths (Full): 1
- Bedroom Information
- Beds Total: 2
- Room Information
- Room Count: 1
- Basement Description: Partial With Hatchway
- Has Attic
Exterior
- Exterior Features
- Roof Information: Asphalt Shingle
- Exterior Siding: Wood
- Exterior Features: Shed
- Lot Information
- Lot Description: Open Lot, Corner Lot
- Building Information
- Foundation Type: Stone
- Construction Description: Frame
- Property Information
- Waterfront Description: Pond, View
- Property Type: Single Family For Sale
- Living Area SQFT Per Public Record: 1165
- Driveway Type: Dirt
Financial
- Assessments Information
- Assessed Value: $80,700
Utilities
- Utility Information
- Water Source: Private Well
- Sewage System: Septic
- Hot Water Description: Oil
- Heat Type: Baseboard
- Heat Fuel Type: Oil
- Fuel Tank Location: In Basement
Location
- School Information
- High School: Per Board of Ed
- Elementary School: Per Board of Ed
- Location Information
- State: Connecticut
- Directions: Gps
- Direct Waterfront
- County: Windham
Public facts
- Beds: 2
- Baths: 1.0
- Sq. Ft.: 1,165
- Stories: 1.0
- Parking Spaces: 1
- Basement: Yes
- Accessible: No
- Lot Size: 2.4 acres
- Style: Single Family Residential
- Year Built: 1790
- Year Renovated: —
- County: Windham County
- APN: 1671110
- HOA Dues: —
- Garage: Yes
- Features: Views, Waterfront
Other
- Documents & Disclosures
- Supplement Count Public: 1
Around this home
Schools
- K - 12
- Preschool & daycare
Public PreK-8 • Assigned • 2.0mi
Public 9-12 • Assigned • 8.4mi
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 94° expected this year, 15 days in 30 years
27% chance of strong winds in next 30 years
2 unhealthy days expected this year, 3 days in 30 years
Sun exposure
In this area, properties receive around 8.9 hours in June and 4.4 hours in December, placing it below the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 06278
Home values near 197 Turnpike Rd
| Address | Redfin Estimate |
|---|---|
4 Beds | 3 Baths | 3254 Sq. Ft. | $827,990 |
4 Beds | 2.5 Baths | 1923 Sq. Ft. | $522,352 |
3 Beds | 2.5 Baths | 1976 Sq. Ft. | $539,099 |
3 Beds | 2.5 Baths | 2534 Sq. Ft. | $641,356 |
3 Beds | 2 Baths | 1496 Sq. Ft. | $410,637 |
3 Beds | 1 Baths | 1056 Sq. Ft. | $346,638 |
2 Beds | 1 Baths | 696 Sq. Ft. | $142,404 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 2704 Sq. Ft. | $697,340 |
4 Beds | 3 Baths | 2640 Sq. Ft. | $547,483 |
3 Beds | 1 Baths | 1518 Sq. Ft. | $619,634 |
1 Beds | 1 Baths | 635 Sq. Ft. | $223,644 |
3 Beds | 2 Baths | 1075 Sq. Ft. | $403,192 |
4 Beds | 2 Baths | 1360 Sq. Ft. | $454,594 |
3 Beds | 1 Baths | 1008 Sq. Ft. | $377,035 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 1952 Sq. Ft. | $548,252 |
3 Beds | 1.5 Baths | 1228 Sq. Ft. | $364,549 |
3 Beds | 2.5 Baths | 1402 Sq. Ft. | $623,387 |
4 Beds | 2 Baths | 1755 Sq. Ft. | $404,463 |
2 Beds | 2 Baths | 1008 Sq. Ft. | $240,559 |
3 Beds | 1.5 Baths | 2547 Sq. Ft. | $495,191 |
4 Beds | 1.5 Baths | 1500 Sq. Ft. | $406,177 |
More real estate resources
- Cities
- Counties
- Popular Searches
| Foster homes for sale | |||
| Putnam homes for sale | |||
| Brooklyn homes for sale |
| Worcester County homes for sale | |||
| New Haven County homes for sale | |||
| Middlesex 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