This home's estimate is 17% higher than the average sale price ($352K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
140 Farnham Rd, South Windsor, CT 06074
About this home
Stunning one floor living in desirable South Windsor neighborhood! Completely remodeled and open concept Ranch with 3 BRs and 1.5 bathrooms. Step inside to a fully remodeled living space with brand new, shaker style white cabinets, all newer black stainless steel appliances, center island with bar seating, well appointed granite counters, undermount lighting & switches, wine rack, & stylish brick and chic subway tile backsplash. Dinette area with slider to deck provides ample natural light. Kitchen opens to sundrenched living room with hardwood floors, TV wall mount & surround speakers included! Spacious MBR with hardwood floors, recessed and dimmer lights, TV mount, 2 closets and a remodeled half bath. Home boasts recessed lighting throughout, fresh neutral paint, all new craftsman style trim, & c/air. Smart home features too! Nest thermostat & Ring security camera, & Samsung Wiseview security system. Front to back mudroom with pellet stove. Attached 1 car garage with finished back room, perfect for a coat closet or extra fridge. Relax on your oversized back, Trex deck complete with retractable awning. Fully fenced in yard, large garden bed, & storage shed. Partially finished basement that's clean and bright! Washer/dryer included with gas dryer hookup available. Convenient location with Rye St Park a short walk away. Easy highway access. Move right in!
Redfin Estimate
Earn from this home
List your home with Redfin and save $4,123
List your home for rent
Market trends in 06074, CT
Last updated October 2026
Buyer's Market
Seller's Market
Seller's market
- OPEN TODAY, 1PM TO 2PM
See all
Provided by Redfin
Sale history for 140 Farnham Rd
$274/sq ft
$268/sq ft
$186/sq ft
Tax history for 140 Farnham 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: 1
Interior
- Virtual Tour Information
- Has Virtual Tour
- Interior Information
- Total Rooms: 6
- Laundry Room Info: Lower Level
- Interior Features: Auto Garage Door Opener, Cable - Available, Open Floor Plan
- Lock(s), Security System, Thermostat(s)
- Cooling System: Ceiling Fans, Central Air
- Appliances Included: Gas Range, Microwave, Refrigerator, Dishwasher, Washer, Dryer
- Bathroom Information
- # of Baths (Full): 1
- # of Baths (Half): 1
- Bedroom Information
- Beds Total: 3
- Room Information
- Rooms Additional: Breezeway
- Room Count: 5
- Basement Description: Full
- Has Attic
- Attic Description: Access Via Hatch
Exterior
- Exterior Features
- Roof Information: Asphalt Shingle
- Exterior Siding: Vinyl Siding
- Exterior Features: Awnings, Deck, Garden Area, Gutters, Lighting, Shed
- Lot Information
- Lot Description: Open Lot, In Subdivision, Fence - Full
- Building Information
- Foundation Type: Concrete
- Construction Description: Frame
- Color: White
- Property Information
- Property Type: Single Family For Sale
- Living Area SQFT Per Public Record: 1230
- Driveway Type: Private, Paved
Financial
- Assessments Information
- Assessed Value: $129,500
Utilities
- Utility Information
- Water Source: Public Water Connected
- Sewage System: Public Sewer Connected
- Hot Water Description: Tankless Hotwater
- Heat Type: Baseboard
- Heat Fuel Type: Natural Gas
- Energy Features: Extra Insulation, Programmable Thermostat, Storm Doors, Thermopane Windows
Location
- School Information
- High School: South Windsor
- Elementary School: Per Board of Ed
- Location Information
- State: Connecticut
- Nearby Amenities: Basketball Court, Golf Course, Park, Playground/Tot Lot
- Directions: Rye St TO Farnham (Just after Dower Rd)
- County: Hartford
Public facts
- Beds: 3
- Baths: 1.5
- Sq. Ft.: 1,230
- Stories: 1.0
- Lot Size: 0.45 acres
- Style: Single Family Residential
- Year Built: 1958
- Year Renovated: —
- County: Hartford County
- APN: 714799
Other
- Documents & Disclosures
- Supplement Count Public: 1
Around this home
Schools
- K - 12
- Preschool & daycare
Public K-5 • Assigned • 1.6mi
Public 6-8 • Assigned • 4.0mi
Public 9-12 • Assigned • 2.2mi
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, 16 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 9.1 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 06074
Home values near 140 Farnham Rd
| Address | Redfin Estimate |
|---|---|
3 Beds | 1 Baths | 1208 Sq. Ft. | $305,494 |
3 Beds | 2 Baths | 1008 Sq. Ft. | $364,308 |
3 Beds | 1 Baths | 1248 Sq. Ft. | $378,252 |
3 Beds | 1 Baths | 1328 Sq. Ft. | $360,634 |
2 Beds | 2.5 Baths | 1208 Sq. Ft. | $370,250 |
3 Beds | 1 Baths | 1008 Sq. Ft. | $318,813 |
4 Beds | 2.5 Baths | 2290 Sq. Ft. | $452,220 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 1 Baths | 1008 Sq. Ft. | $344,472 |
3 Beds | 1 Baths | 1272 Sq. Ft. | $358,602 |
3 Beds | 1.5 Baths | 1900 Sq. Ft. | $428,658 |
3 Beds | 1 Baths | 1272 Sq. Ft. | $355,923 |
3 Beds | 1 Baths | 1248 Sq. Ft. | $365,143 |
3 Beds | 1.5 Baths | 1276 Sq. Ft. | $396,798 |
3 Beds | 1 Baths | 984 Sq. Ft. | $344,659 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 1 Baths | 1248 Sq. Ft. | $389,247 |
3 Beds | 1 Baths | 1008 Sq. Ft. | $371,682 |
3 Beds | 1 Baths | 1328 Sq. Ft. | $370,607 |
3 Beds | 2 Baths | 1008 Sq. Ft. | $349,856 |
3 Beds | 1 Baths | 1248 Sq. Ft. | $356,595 |
3 Beds | 1 Baths | 1008 Sq. Ft. | $341,754 |
3 Beds | 1.5 Baths | 1328 Sq. Ft. | $393,447 |
More real estate resources
- Cities
- Counties
- Popular Searches
| West Hartford homes for sale | |||
| Manchester homes for sale | |||
| Hartford homes for sale |
| Worcester County homes for sale | |||
| Fairfield 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