This home's estimate is 41.8% higher than the average sale price ($437K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
242 Turnpike Rd, Ashford, CT 06278
About this home
Horses,chickens,& cows oh my! Family farm on 46 pastoral acres, 4 open fields perfect for grazing & planting,barn w/elec & h2o,2 additional outbuildings, pond,stonewalls, spectacular view,new windows, hw floors,eat-in kitchen,screen porch,min from i-84
Redfin Estimate
Earn from this home
List your home with Redfin and save $6,196
Get cash now or lower your monthly rate
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 242 Turnpike Rd
$214/sq ft
$223/sq ft
Tax history for 242 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: Barn, Detached Garage
- Garages Number: 1
Interior
- Interior Information
- Total Rooms: 6
- Laundry Room Location: First Floor
- Interior Features: Cable - Available
- Appliances Included: Oven/Range, Range Hood
- Bathroom Information
- # of Baths (Full): 1
- Bedroom Information
- Beds Total: 3
- Room Information
- Room Count: 7
- Basement Description: Concrete Floor, Full With Walk-Out, Unfinished
- Has Attic
- Attic Description: Walk-up
Exterior
- Exterior Features
- Exterior Siding: Shingle
- Exterior Features: Barn, Stone Wall, Storage Building
- Lot Information
- Lot Description: Farm Land, Lightly Wooded, Rolling
- Building Information
- Color: red
- Property Information
- Property Type: Single Family For Sale
- Property Info: Horse Property
- Driveway Type: Asphalt, Paved
Financial
- Assessments Information
- Assessed Value: $132,880
- Rental Information
- Lease Purchase YN: No
Utilities
- Utility Information
- Water Source: Private Well
- Sewage System: Cesspool
- Hot Water Description: Oil
- Heat Type: Baseboard, Radiator
- Heat Fuel Type: Oil
- Fuel Tank Location: Above Ground
- Energy Features: Thermopane Windows
Location
- School Information
- High School: Boe
- Elementary School: Ashford
- Location Information
- State: Connecticut
- Directions: Exit 71 off route 84 to 320n to turnpike rd (route 89)
- County: Windham
Public facts
- Beds: 3
- Baths: 1.0
- Sq. Ft.: 1,518
- Stories: 2.0
- Lot Size: 43.8 acres
- Style: Single Family Residential
- Year Built: 1800
- Year Renovated: —
- County: Windham County
- APN: 1671089
Other
- Documents & Disclosures
- Supplement Count Public: 1
Around this home
Schools
- K - 12
- Preschool & daycare
Public PreK-8 • Assigned • 2.2mi
Public 9-12 • Assigned • 8.4mi
Lifestyle
Provided by Walk Score and Local Logic
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 242 Turnpike Rd
| Address | Redfin Estimate |
|---|---|
4 Beds | 3 Baths | 3254 Sq. Ft. | $827,990 |
3 Beds | 2.5 Baths | 1952 Sq. Ft. | $548,252 |
3 Beds | 2.5 Baths | 1962 Sq. Ft. | $490,701 |
3 Beds | 1.5 Baths | 1765 Sq. Ft. | $560,777 |
4 Beds | 2.5 Baths | 2420 Sq. Ft. | $551,851 |
3 Beds | 2 Baths | 1075 Sq. Ft. | $403,192 |
3 Beds | 1.5 Baths | 2095 Sq. Ft. | $547,876 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 3 Baths | 3025 Sq. Ft. | $894,835 |
4 Beds | 2.5 Baths | 1923 Sq. Ft. | $522,352 |
3 Beds | 1.5 Baths | 1228 Sq. Ft. | $364,549 |
3 Beds | 2.5 Baths | 2534 Sq. Ft. | $641,356 |
4 Beds | 2 Baths | 1755 Sq. Ft. | $404,463 |
2 Beds | 2 Baths | 1008 Sq. Ft. | $240,559 |
4 Beds | 2 Baths | 1360 Sq. Ft. | $454,594 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 2704 Sq. Ft. | $697,340 |
4 Beds | 3 Baths | 2640 Sq. Ft. | $547,483 |
3 Beds | 2.5 Baths | 1976 Sq. Ft. | $539,099 |
2 Beds | 1 Baths | 1165 Sq. Ft. | $282,805 |
3 Beds | 2 Baths | 1496 Sq. Ft. | $410,637 |
3 Beds | 1 Baths | 1056 Sq. Ft. | $346,638 |
3 Beds | 1.5 Baths | 2547 Sq. Ft. | $495,191 |
More real estate resources
- Counties
- Cities
- Popular Searches
| Worcester County homes for sale | |||
| New Haven County homes for sale | |||
| Middlesex County homes for sale |
| Foster homes for sale | |||
| Putnam homes for sale | |||
| Brooklyn 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