THIS NEWLY UPDATED RIVERFRONT FARMHOUSE WITH DIRECT FARMINGTON RIVER ACCESS & WALKING TRAIL TO COLLINSVILLE CENTER HAS 3 BEDROOMS PLUS OFFICE/NURSERY, 2.5 BATHS, 2,080 sq ft, 2.92 ACRES, & IS LOADED WITH HISTORIC CHARM & CHARACTER. FLOWERING GARDENS GREET YOUR ARRIVAL TO THIS SWEET 1860 COLONIAL. QUAINT COUNTRY KITCHEN BOASTS RARE CHESTNUT BEAM BLENDED WITH NEW STAINLESS STEEL APPLIANCES, CHEERFUL WHITE CABINETRY & COZY EAT IN AREA. ADJOINING FAMILY ROOM ADDITION WITH STUNNING RIVER VIEW OFFERS GENEROUSLY SIZED GATHERING AREA WITH ATRIUM DOOR TO LET IN THE SUMMER BREEZES & PELLET STOVE FOR COZY WINTER NIGHTS. FRONT PORTICO ENTRY OPENS TO FORMAL LIVING AND ADJOINING DINING ROOM; ALL WITH GLEAMING HARDWOOD FLOORS. ENJOY THE END OF THE DAY ON YOUR DELIGHTFUL SCREENED PORCH TO UNWIND, READ A BOOK OR WATCH THE FARMINGTON RIVER FLOW UNDER THE SHADE OF TREES THAT SURROUND THE WONDERFUL L-SHAPED DECK. AN UPDATED HALF BATH COMPLETES THE 1ST FLOOR. UPSTAIRS, THE SUN FILLED MASTER SUITE ENJOYS RIVER VIEWS, SKYLIT CATHEDRAL CEILING, BRAND NEW MASTER BATHROOM, 2 CLOSETS & HARDWOOD FLOORS. THERE ARE 2 ADDITIONAL COTTAGE STYLE BEDROOMS FOR FAMILY OR GUESTS, A BRIGHT OFFICE/NURSERY ROOM, & A SPACIOUS LAUNDRY. A 2ND FULL BATH COMPLETES THE 2ND FLOOR. BASEMENT PLUS HEATED WORKOUT/HOBBY ROOM AS WELL AS A RUSTIC BARN & 2 CAR GARAGE PROVIDE AMPLE STORAGE SPACE FOR ALL YOUR OUTDOOR HOBBY EQUIPMENT. ALL WITHIN A 2 MIN DRIVE TO COLLINSVILLE CNTR OR 1 MILE WALKING TRAIL ALONG THE FARMINGTON RIVER.
Single-familyProperty Type
1860Year Built
2.92 acresLot Size
$281Est. Price/Sq.Ft.
2 car garageParking
Listed by Fred Romano• Flat Fee Realty LLC
Bought with William Glanville• Berkshire Hathaway NE Prop.
Source:Smart MLS #170405262
Redfin Estimate
$583,889
$184K since sold in September 2021$4,000 since August
Recently sold homes
Estimate history
Homes for sale
This home's estimate is 3.4% higher than the average sale price ($565K) of 6 comparable homes.
ADORABLE RIVERFRONT FARMHOUSE LOADED WITH HISTORIC CHARM & CHARACTER RARELY FOUND. FLOWERING GARDENS GREET YOUR ARRIVAL TO THIS SWEET 1860 COLONIAL. THE QUAINT COUNTRY KITCHEN BOASTS A RARE CHESTNUT BEAM, CHEERFUL WHITE CABINETRY, BREAKFAST BAR & COZY EATING AREA. THE ADJOINING FAMILY ROOM ADDITION OFFERS A GENEROUSLY SIZED GATHERING AREA W/ATRIUM DOOR TO LET IN THE SUMMER BREEZES & PELLET STOVE FOR COZY WINTER NIGHTS. THE FRONT PORTICO ENTRY OF THIS HOME OPENS TO THE FORMAL LIVING & ADJOINING DINING ROOM W/GLEAMING HARDWOOD FLOORS & SWEET CORNER HUTCH. SAVOR SUMMER DAYS ON THE DELIGHTFUL SCREENED PORCH WHICH PLAYS SONGS OF SLAMMING SCREEN DOORS & CHIRPING CRICKETS. READ A NOVEL OR WATCH THE FARMINGTON RIVER FLOW UNDER THE SHADE OF TREES THAT SURROUND THE WONDERFUL L-SHAPED DECK. UPSTAIRS THE SUNFILLED MASTER SUITE ENJOYS RIVER VIEWS, SKYLIT CATHEDRAL CEILING & HIS/HERS WALK-IN CLOSETS. PAINTED WOOD FLOORS GIVE THE TWO ADDITIONAL BEDROOMS & STUDY/HOBBY ROOM A COTTAGE STYLE & OFFER RETREATS FOR FAMILY & GUESTS. TWO SEPARATE BASEMENTS, A RUSTIC BARN (AS IS) & 2 CAR GARAGE PROVIDE AMPLE STORAGE SPACES FOR ALL YOUR OUTDOOR HOBBY EQUIPMENT...BIKES, KAYAKS, FISHING GEAR, GARDENING TOOLS, ETC. NUMEROUS HOMEOWNER IMPROVEMENTS INCLUDE WALL A/C UNITS (2014) UPGRADED ELECTRIC TO 200 AMPS (2014) ADDED INSULATION (2014) 275 GALLON OIL TANK (2011) HARDWOOD FLOORS ON 1ST REFINISHED (2008) PEERLESS CAST IRON BOILER (2005) 25 YR ARCHITECTURAL ROOF (2002) WELL & PUMP (1999)
Public Records
May 29, 1992
Sold
$175,000
$84/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$8,306 (+5.0%)
$98,000 + $172,120
$270,120
2024
$7,909 (+2.7%)
$98,000 + $168,640
$266,640
2023
$7,702 (+2.2%)
$87,500 + $130,140
$217,640
2022
$7,533 (+2.0%)
$87,500 + $130,140
$217,640
2021
$7,385 (+4.0%)
$87,500 + $128,370
$215,870
2020
$7,102
$87,500 + $128,370
$215,870
2019
$7,102 (+11.5%)
$87,500 + $128,370
$215,870
2018
$6,369 (+2.5%)
$80,500 + $122,660
$203,160
2017
$6,215 (+4.2%)
$80,500 + $122,660
$203,160
2016
$5,962 (+5.8%)
$80,500 + $121,480
$201,980
2014
$5,633
$80,500 + $118,420
$198,920
Tax history for 245 New Rd
Year
Property tax
Land + Additions
Assessment*
2025
$8,306 (+5.0%)
$98,000 + $172,120
$270,120
2024
$7,909 (+2.7%)
$98,000 + $168,640
$266,640
2023
$7,702 (+2.2%)
$87,500 + $130,140
$217,640
2022
$7,533 (+2.0%)
$87,500 + $130,140
$217,640
2021
$7,385 (+4.0%)
$87,500 + $128,370
$215,870
2020
$7,102
$87,500 + $128,370
$215,870
2019
$7,102 (+11.5%)
$87,500 + $128,370
$215,870
2018
$6,369 (+2.5%)
$80,500 + $122,660
$203,160
2017
$6,215 (+4.2%)
$80,500 + $122,660
$203,160
2016
$5,962 (+5.8%)
$80,500 + $121,480
$201,980
2014
$5,633
$80,500 + $118,420
$198,920
*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
3
Baths
2.5
Stories
2
Lot width
—
Lot depth
—
Lot size
2.92 Acres
Year renovated
—
Sq. Ft.
2,080
Year built
1860
Style
Multi-Family (2-4 Unit)
County
Hartford County
APN
438669
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 10, 2026.
Nov 10, 2025 • Active
Electrical
Install a roof-mounted photovoltaic solar system on a residential building. No structural upgrades are included.
Electrical
Solar
May 20, 2025 • Active
Mechanical
Replace the existing oil boiler with a new Energy Kinetics System 2000 EK-1F boiler.
HVAC
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: Detached Garage
Garages Number: 2
Interior
Interior Information
Total Rooms: 8
Laundry Room Info: Upper Level
Interior Features: Cable - Pre-wired
In-Law Apartment: No
Cooling System: Central Air
Appliances Included: Gas Range, Range Hood, Refrigerator, Icemaker, Dishwasher, Washer, Dryer