Off Market May 2018 for $512K

$851,176

Est. refi paymentEst. refi $3,331/mo

•

2,976

sq ft

29 N Farms Rd, Avon, CT 06001

About this home

Relax in the vaulted screened porch after a ride or jog on the bike trail, then go for a swim in the gunite/heated pool! Built in 2017 with Pebble Fina finish (crushed seashells) with an integrated spa & surrounded by large patio and generous fenced yard. Updated nearly throughout with newer baths, painted walls & trim, flat ceilings, lighting, garage doors, security, R-60 foam insulation, thermal windows, even some newer baseboard heating units! This cul-de-sac location is close to everything - schools, shops, library, & Rails-to-Trails path. Large bonus room over 2-bay garage and inviting screened porch overlooking pool, patio, & yard. 1st floor office; granite kitchen with granite and stainless appliances opens to cozy den with fireplace. Hardwood, tile and laminate floors throughout. Lower level workshop offers expansion capabilities. Please see virtual tour for additional photos. Welcome Home!

Subject to SIRVA Relocation addendum and related documents. Central AC to 2nd floor only.

Single-familyProperty Type

1985Year Built

1.12 acresLot Size

$286Est. Price/Sq.Ft.

2 car garageParking

Listed by Charlie Hartigan • William Raveis Real Estate

Bought with Tracey Hollerbach • Coldwell Banker Realty

Source:Smart MLS #170062674

Redfin Estimate

$851,176

$339K since sold in May 2018$13K since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 21.8% higher than the average sale price ($699K) of 6 comparable homes.

SOLD JAN 16, 2026
$497,700
A
4 beds2.5 baths2,927 sq ft
51 Charing CRSS, Avon, CT 06001
SOLD JUL 16, 2026
$758,000
B
4 beds2.5 baths2,908 sq ft
11 Lexington Rd, Avon, CT 06001
SOLD MAY 21, 2026
$559,000
C
4 beds2.5 baths2,194 sq ft
3 Cotswold Way, Avon, CT 06001
SOLD JUN 15, 2026
$850,000
D
4 beds2.5 baths3,834 sq ft
35 High Gate Dr, Avon, CT 06001
SOLD JUL 24, 2026
$690,000
E
4 beds2.5 baths2,991 sq ft
14 Crosswood Rd, Farmington, CT 06032
SOLD MAY 27, 2026
$840,000
F
4 beds2.5 baths3,636 sq ft
84 Hollister Dr, Avon, CT 06001

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$461,234

Est. take-home

List your home with Redfin and save $8,512

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$3,288/mo

Redfin rental estimate

List your home for rent

Market trends in 06001, CT

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

106.4%

0.5% MoM

Median sale price

$635K

$5K MoM

Avg. days on market

24d

8 days MoM

Recently sold homes

23 MoM

New listings for sale

$469,900
2 beds2.5 baths2,516 sq ft
13 Morgan Pl #13, Avon, CT 06001
COMING SOON
$299,000
3 beds2 baths1,929 sq ft
737 Lovely St, Avon, CT 06001
OPEN SUN, 1PM TO 3PM
$435,000
4 beds3 baths2,170 sq ft
5 Overlook Ct #5, Avon, CT 06001
$2,100,000
6 beds6.5 baths8,656 sq ft
21 Breezy Knl, Avon, CT 06001
$545,000
4 beds2 baths2,232 sq ft
39 Sunnybrook Dr, Avon, CT 06001
$764,900
4 beds2.5 baths3,699 sq ft
25 Fenwick Dr, Avon, CT 06001
COMING SOON
$469,900
3 beds1.5 baths1,777 sq ft
55 Sylvan St, Avon, CT 06001
COMING SOON
$525,000
4 beds2.5 baths2,140 sq ft
67 Deepwood Dr, Avon, CT 06001
$449,900
2 beds2.5 baths2,222 sq ft
44 Byron Dr #44, Avon, CT 06001
$194,900
2 beds1.5 baths900 sq ft
239 Old Farms Rd Unit 14C, Avon, CT 06001
See all

Provided by Redfin

Sale history for 29 N Farms Rd

Date

Event

Price

Smart MLS #170062674

May 11, 2018

Sold

$512,000

$172/sq ft

Mar 28, 2018

Pending

—

Mar 18, 2018

Contingent

—

Mar 16, 2018

Listed

$512,000

$172/sq ft

Smart MLS #170057484

Mar 18, 2018

Listing Removed

—

Mar 16, 2018

Contingent

—

Mar 5, 2018

Listed

$519,500

$175/sq ft

Smart MLS #G10047940

Jul 17, 2015

Sold

$489,500

$164/sq ft

Jun 6, 2015

Listing Removed

—

May 28, 2015

Listed

$499,000

$168/sq ft

This well maintained 3,000 sq ft Colonial is located on a cul-de-sac, friendly neighborhood in the heart of Avon - Walking Distance to Rails to Trails, Town Pool, and schools. Enjoy the screened porch overlooking the large quiet backyard. Minutes to shopping and Rt 84. Enjoy the spacious eat in kitchen with all new stainless steel appliances and granite countertops open to the cozy family room with fireplace. Bonus room steps from the kitchen with vaulted ceilings - could be home office, music room, play room, exercise room...Great Space. There is a Formal Dining Room and Living Room (or 1st floor office) This home features a Mudroom and 1/2 bath accessible from backyard and garage. The Second floor features a large master bedroom with an additional Fireplace and remodeled master bath with tiled shower and double sinks. There are 3 additional bedrooms and second remodeled full bath with tub on upper level. Ready to move right in!

Public Records

Jan 25, 2000

Sold

$370,000

$124/sq ft

Public Records

Jul 16, 1992

Sold

$332,750

$112/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$12,031 (+3.7%)

$123,550 + $267,700

$391,250

2024

$11,604 (+11.1%)

$123,550 + $267,700

$391,250

2023

$10,448 (+2.3%)

$95,550 + $199,670

$295,220

2022

$10,218 (+2.4%)

$95,550 + $199,670

$295,220

2021

$9,979 (+4.0%)

$95,550 + $196,160

$291,710

2020

$9,597

$95,550 + $196,160

$291,710

2019

$9,597 (−0.4%)

$95,550 + $196,160

$291,710

2018

$9,631 (+7.9%)

$106,050 + $201,150

$307,200

2017

$8,926 (+3.6%)

$106,050 + $185,740

$291,790

2016

$8,614 (+4.2%)

$106,050 + $185,740

$291,790

2014

$8,263

$106,050 + $185,740

$291,790

Tax history for 29 N Farms Rd

Year

Property tax

Land + Additions

Assessment*

2025

$12,031 (+3.7%)

$123,550 + $267,700

$391,250

2024

$11,604 (+11.1%)

$123,550 + $267,700

$391,250

2023

$10,448 (+2.3%)

$95,550 + $199,670

$295,220

2022

$10,218 (+2.4%)

$95,550 + $199,670

$295,220

2021

$9,979 (+4.0%)

$95,550 + $196,160

$291,710

2020

$9,597

$95,550 + $196,160

$291,710

2019

$9,597 (−0.4%)

$95,550 + $196,160

$291,710

2018

$9,631 (+7.9%)

$106,050 + $201,150

$307,200

2017

$8,926 (+3.6%)

$106,050 + $185,740

$291,790

2016

$8,614 (+4.2%)

$106,050 + $185,740

$291,790

2014

$8,263

$106,050 + $185,740

$291,790

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Permits

Beds

Baths

2.5

Stories

Lot width

—

Lot depth

—

Lot size

1.12 Acres

Year renovated

—

Sq. Ft.

2,976

Year built

1985

Style

Single Family Residential

County

Hartford County

APN

438539

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 10, 2026.

Mar 30, 2023 • Active

Mechanical

Install a central cooling system with externally insulated and sealed metal main ducts and flexible register connectors. The project includes a Lennox brand condenser, air handler, and controls, along with new electrical service from the panel to the units.

Electrical

HVAC

Mar 28, 2023 • Active

Electrical

Install new electrical service from the panel to the condenser and air handler.

Electrical

Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.

Property details

Parking

Garage Information
Garage & Parking: Attached Garage
Garages Number: 2

Interior

Interior Information
Total Rooms: 9
Laundry Room Location: Clothes Washer & Dryer included
Laundry Room Info: Main Level
Interior Features: Auto Garage Door Opener, Cable - Available, Security System
In-Law Apartment: No
Thermostat(s)
Fireplaces Total: 2
Cooling System: Attic Fan, Central Air
Appliances Included: Electric Cooktop, Wall Oven, Microwave, Refrigerator, Dishwasher, Washer, Dryer

Bathroom Information
# of Baths (Full): 2
# of Baths (Half): 1

Bedroom Information
Beds Total: 4

Room Information
Rooms Additional: Foyer, Mud Room
Room Count: 9
Basement Description: Full With Hatchway, Unfinished
Has Attic
Attic Description: Access Via Hatch

Exterior

Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Clapboard, Brick
Exterior Features: French Doors, Patio, Porch-Screened

Lot Information
Lot Description: On Cul-De-Sac, Cleared, Level Lot, Fence - Full

Pool Information
Swimming Pool
Pool Description: In Ground Pool, Spa, Heated, Gunite

Building Information
Foundation Type: Concrete
Construction Description: Frame

Property Information
Radon Mitigation Air
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 2976
Driveway Type: Paved

Financial

Assessments Information
Assessed Value: $291,790

Utilities

Utility Information
Water Source: Public Water Connected
Sewer Usage Fee Annual: $375
Sewage System: Public Sewer Connected
Hot Water Description: 40 Gallon Tank
Heat Type: Baseboard, Hot Water
Heat Fuel Type: Oil
Fuel Tank Location: In Basement
Energy Features: Programmable Thermostat, Storm Doors, Thermopane Windows

Location

School Information
Middle Jr High School: Avon
Intermediate School: Thompson
High School: Avon
Elementary School: Pine Grove

Location Information
State: Connecticut
Nearby Amenities: Basketball Court, Golf Course, Health Club, Library, Medical Facilities, Park, Public Pool, Tennis Courts
Directions: Scoville Road to North Farms.
County: Hartford

Public facts

Beds: 4
Baths: 2.5
Sq. Ft.: 2,976
Stories: 2.0
Lot Size: 1.12 acres
Style: Single Family Residential
Year Built: 1985
Year Renovated: —
County: Hartford County
APN: 438539

Home facts updated by county records on Jul 10, 2026

Around this home

Schools

Pine Grove School

Public K-4 • Assigned • 0.4mi

8/10

Avon Middle School

Public 7-8 • Assigned • 1.5mi

9/10

Avon High School

Public 9-12 • Assigned • 0.9mi

10/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

4/10 Heat Factor

7 days above 95° expected this year, 16 days in 30 years

6/10 Wind Factor

27% chance of strong winds in next 30 years

2/10 Air Factor

2 unhealthy days expected this year, 2 days in 30 years

Provided by First Street

Historical weather

Avon, CT • 06001

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 8.9 hours in June and 4.3 hours in December, placing it below the U.S. average for solar exposure.

8.9 hrs

4.3 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$809,000 – $979,000

Reach more buyers when you sell with Redfin. Save up to $8,512 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

NEW 24 HRS AGO

$539,000

4 beds3 baths1,983 sq ft

20 Wyndwood Rd, Farmington, CT 06032

$959,900

4 beds4.5 baths4,838 sq ft

5 Biltmore Ct, Avon, CT 06001

$1,395,000

7 beds5 baths6,144 sq ft

14 Vermillion Dr, Avon, CT 06001

$965,000

5 beds5.5 baths4,552 sq ft

46 Henderson Dr, Avon, CT 06001

3D WALKTHROUGH

$699,900

4 beds2.5 baths2,622 sq ft

243 Brickyard Rd, Farmington, CT 06032

$524,900

4 beds2.5 baths2,172 sq ft

44 W District Rd, Unionville, CT 06085

New listings for sale in 06001

$469,900

2 beds2.5 baths2,516 sq ft

13 Morgan Pl #13, Avon, CT 06001

COMING SOON

$299,000

3 beds2 baths1,929 sq ft

737 Lovely St, Avon, CT 06001

OPEN SUN, 1PM TO 3PM

$435,000

4 beds3 baths2,170 sq ft

5 Overlook Ct #5, Avon, CT 06001

$2,100,000

6 beds6.5 baths8,656 sq ft

21 Breezy Knl, Avon, CT 06001

$545,000

4 beds2 baths2,232 sq ft

39 Sunnybrook Dr, Avon, CT 06001

$764,900

4 beds2.5 baths3,699 sq ft

25 Fenwick Dr, Avon, CT 06001

COMING SOON

$469,900

3 beds1.5 baths1,777 sq ft

55 Sylvan St, Avon, CT 06001

COMING SOON3D WALKTHROUGH

$525,000

4 beds2.5 baths2,140 sq ft

67 Deepwood Dr, Avon, CT 06001

$449,900

2 beds2.5 baths2,222 sq ft

44 Byron Dr #44, Avon, CT 06001

Home values near 29 N Farms Rd

Data from public records.

Address	Redfin Estimate
22 North Farms Rd, Avon, CT 4 Beds \| 4 Baths \| 3296 Sq. Ft.	$880,596
15 North Farms Rd, Avon, CT 4 Beds \| 3 Baths \| 3644 Sq. Ft.	$846,059

Address	Redfin Estimate
23 North Farms Rd, Avon, CT 3 Beds \| 2.5 Baths \| 3056 Sq. Ft.	$766,910
68 North Farms Rd, Avon, CT 3 Beds \| 3.5 Baths \| 3589 Sq. Ft.	$865,966

Address	Redfin Estimate
59 North Farms Rd, Avon, CT 4 Beds \| 4 Baths \| 3688 Sq. Ft.	$966,024
36 North Farms Rd, Avon, CT 3 Beds \| 2.5 Baths \| 2536 Sq. Ft.	$736,209

Property information provided by Smart MLS when last listed in 2018. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

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.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Hartford County	Agents near me	Westport, CT homes for sale	Hartford County Housing Market
Houses for sale near me	Greenwich, CT homes for sale	New Haven, CT homes for sale
Land for sale near me	Stamford, CT homes for sale	Milford, CT homes for sale
Open Houses near me	West Hartford, CT homes for sale	Hartford County Property Records
Condos for sale near me	Norwalk, CT homes for sale	CT New Listings

Worcester County homes for sale
Fairfield County homes for sale
Suffolk County homes for sale

West Hartford homes for sale
Hartford homes for sale
Middletown homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 06001, CT

Sale history for 29 N Farms Rd

Tax history for 29 N Farms Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 06001

Home values near 29 N Farms Rd

More real estate resources