NOT LISTED FOR SALE

54 Hennequin Rd Columbia, CT 06237

Estimated Value: $328,029 - $441,000

3 Beds
1 Bath
1,600 Sq Ft
$238/Sq Ft Est. Value

Last Sold April 15, 2020

Last sale price $265,000 $166 Per Sq Ft

Est. 39% increase in value since last sale

Current estimated payment $2,376/month

3 Days on Market

Highlights

  • Beach Front
  • Stables
  • Home fronts a pond
  • Barn
  • Horse Property
  • 5-minute walk to Columbia Recreation Area

About This Home

As of April 2020

FANTASTIC 7.5 ACRE PROPERTY, BRING YOUR HORSES, BRING YOUR CARS AND BOATS, BRING YOUR GARDENING SKILLS IF YOU WANT. PROPERTY BOASTS A 50X25 BARN THAT HAS AN AUTO 12’ GARAGE DOOR, CAN PARK AT LEAST 6 CARS WITH WORKSHOPS ATTACHED. ON THE PROPERTY, IT ALSO HAS A HEATED 2 CAR OVERSIZED GARAGE WITH UPPER LEVEL FOR STORAGE, 2 STORY BARN WITH STALLS, GARDEN SHED. SPECTACULAR MAN MADE POND WITH CUSTOM BRIDGE TO OPEN LAND, SURROUNDED BY 80+ ACRES OF TOWN RECREATION PARK. BEAUTIFUL VICTORIAN GAZEBO AND WONDERFUL ROCK ISLANDS. PROPERTY HAS BEEN USED FOR WEDDINGS AND SPECIAL OCCASIONS IN THE PAST. ALSO ONLY ½ MILE TO COLUMBIA LAKE. AND OF COURSE A 1855 ANTIQUE HOME WITH MANY COMFORTS, NEWER THERMOPANE WINDOWS, WIDE WOOD FLOORS AND SOME OAK WOOD FLOORS, 14X14 FORMAL DINING ROOM WITH CHAIR RAILS AND WIDE WOOD FLOORS, COZY LIVING ROOM WITH WOOD FIREPLACE AND BUILT IN SHELVES AND WIDE WOOD FLOORS. FULLY UPDATED BATH WITH QUARTZ COUNTER, TUB SHOWER AND RADIANT HEATED FLOORS. LAUNDRY SHOOT IN CLOSET. HEATED SUNROOM WITH ELECTRIC HEAT FIREPLACE. IN ADDITION, ENTRANCE TO PRIVATE OFFICE. UPSTAIRS YOU WILL FIND A MASTER BEDROOM WITH NEW OAK FLOORS AND 2 WALK IN CLOSETS WITH AN ADDITIONAL HIDDEN STORAGE AREA. QUAINT SITTING AREA. HOME FEATURES 3 ZONE HEATING AND A GENERAC FULL HOME GENERATOR WITH A 300 GAL PROPANE TANK THAT IS OWNED NOT LEASED.

Last Agent to Sell the Property

Fred Martins

Berkshire Hathaway NE Prop. License #RES.0766105 Listed on: 03/05/2020

Berkshire Hathaway NE Prop.

Last Buyer's Agent

Lisa Sherman

My Realtor, LLC License #REB.0791659

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,493

Year Built

  • Built in 1855

Lot Details

  • 7.35 Acre Lot
  • Home fronts a pond
  • Beach Front
  • Lake Front
  • Stone Wall
  • Open Lot
  • Lot Has A Rolling Slope
  • Cleared Lot
  • Garden
  • Property is zoned RES, AGRICULTURAL

Home Design

  • Antique Architecture
  • Stone Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Clap Board Siding

Interior Spaces

  • 1,600 Sq Ft Home
  • 1 Fireplace
  • Thermal Windows
  • Sitting Room
  • Workshop
  • Heated Enclosed Porch
  • Attic or Crawl Hatchway Insulated
  • Smart Thermostat

Kitchen

  • Oven or Range
  • Electric Range
  • Microwave

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 1 Full Bathroom

Laundry

  • Laundry on lower level
  • Dryer
  • Washer

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Interior Basement Entry

Parking

  • 6 Car Garage
  • Tandem Garage
  • Automatic Garage Door Opener
  • Circular Driveway
  • Gravel Driveway
  • Unpaved Parking

Outdoor Features

  • Walking Distance to Water
  • Horse Property
  • Patio
  • Gazebo
  • Shed

Schools

  • Horace W. Porter Elementary School

Farming

  • Barn
  • Farm

Horse Facilities and Amenities

  • Stables

Utilities

  • Window Unit Cooling System
  • Baseboard Heating
  • Heating System Uses Oil
  • Radiant Heating System
  • Heating System Uses Propane
  • Programmable Thermostat
  • Power Generator
  • Private Company Owned Well
  • Fuel Tank Located in Basement
  • Cable TV Available

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,493

Year Built

Built in 1855

Lot Details

0

Listing Details

  • Property Type: Single Family For Sale
  • Style: Antique
  • Sq Ft Est Heated Above Grade: 1600
  • Public Record Living Room Sq Ft: 1178
  • Total Sq Ft: 1600
  • Year Built: 1855
  • Nearby Amenities: Basketball Court, Lake, Library, Medical Facilities, Playground/Tot Lot, Public Rec Facilities, Tennis Courts
  • Remarks Public Addendum: SEPTIC SYSTEM WAS REPLACED 17 YEARS AGO, ROOF ON HOME IS A 50 YEAR SHINGLE THAT IS 3 YEARS OLD. BASEMENT HAS CURTAIN DRAIN INSTALLED. A PLACE YOU CAN ENJOY NATURE AND LIVE COMFORTABLY. YOU SHOULD COME LOOK. GREAT PRICE FOR WHAT YOU ARE GETTING.
  • Direct Waterfront: No
  • Home Warranty Offered: Yes
  • Radon Mitigation Air Ynu: No
  • Radon Mitigation Water Ynu: No
  • Public Record Gross Sq Ft: 2304
  • Directions: 384 EAST TO RT 6 EAST RIGHT ON JONATHAN TRUMBULL HWY RIGHT ON LAKE ROAD LEFT ON HENNEQUIN RD
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 10
  • Total Bedrooms: 3
  • Total Bathrooms: 1.00
  • Full Bathrooms: 1
  • Fireplaces: 1
  • Attic Description: Access Via Hatch
  • Basement Description: Full With Hatchway, Unfinished, Interior Access
  • Interior Amenities: Auto Garage Door Opener, Cable - Pre-wired
  • Appliances: Electric Range, Oven/Range, Microwave, Refrigerator, Washer, Dryer
  • Additional Rooms: Sitting Room, Workshop
  • Laundry Room Location: LAUNDRY SHOOT IN BATHROOM
  • Laundry Room Info: Lower Level
  • Attic: Yes
  • Home Automation: Thermostat(s)

Exterior Features

  • Exterior Features: Barn, Garden Area, Gazebo, Patio, Porch-Heated, Shed, Stable, Stone Wall
  • Exterior Siding: Clapboard
  • Foundation Type: Stone
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Pond, Lake, Beach, Walk to Water
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

  • Garage Parking Info: Tandem, Barn, Unpaved
  • Garages Number: 6
  • Driveway Type: Private, Circular, Gravel

Utilities

  • Cooling System: Window Unit
  • Heat Type: Baseboard, Radiant
  • Heat Fuel Type: Oil, Propane
  • Fuel Tank Location: In Basement
  • Hot Water Description: Domestic
  • Water Source: Private Well
  • Sewer: Septic

Condo/Co-op/Association

  • HOA: No
  • Special Association Assessment Y: No

Schools

  • Intermediate School: Per Board of Ed

Green Features

  • Energy Features: Generator, Programmable Thermostat, Thermopane Windows

Lot Info

  • Acres: 7.3500
  • Lot Description: Farm Land, Open Lot, Cleared, Rolling
  • Flood Zone: No
  • Zoning: RES, AGRICULTURAL
  • Property Info: Horse Property

Tax Info

  • Tax Year: July 2019-June 2020
  • Property Tax: 4493
  • Mil Rate Base: 29.330
  • Assessor Parcel Number: 2204014

MLS Schools

  • Elementary School: Horace W. Porter
  • Middle Jr High School: Per Board of Ed
  • High School: Per Board of Ed

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 5, 2020
Closed on
Apr 14, 2020
Sold by
Belanger Robert N and Belanger Astrid S
Bought by
Tuttle Robert C
Seller's Agent
Fred Martins
Berkshire Hathaway NE Prop.
Buyer's Agent
Lisa Sherman
My Realtor, LLC
List Price
$258,883
Sold Price
$265,000
Premium/Discount to List
$6,117
2.36%
Current Estimated Value
$368,205

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$103,205
Avg. Annual Appreciation
6.63%
Original Mortgage
$263,200
Outstanding Balance
$232,273
Interest Rate
3.2%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$148,984
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Tuttle Robert C $265,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Tuttle Robert C $263,200
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/15/2020 04/15/20 Sold $265,000 +2.4% $166 / Sq Ft
03/05/2020 03/05/20 For Sale $258,883 -- $162 / Sq Ft
Source: SmartMLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $5,262 $179,760 $60,620 $119,140
2024 $5,055 $179,760 $60,620 $119,140
2023 $4,658 $179,760 $60,620 $119,140
2022 $4,650 $179,760 $60,620 $119,140
2021 $4,493 $153,200 $61,600 $91,600
2020 $4,493 $153,200 $61,600 $91,600
2019 $4,493 $153,200 $61,600 $91,600
2018 $4,493 $153,200 $61,600 $91,600
2017 $4,424 $153,200 $61,600 $91,600
2016 $4,330 $157,800 $61,600 $96,200
2015 $4,281 $157,800 $61,600 $96,200
2014 $4,281 $157,800 $61,600 $96,200
Source: Public Records

Agents Affiliated with this Home

  • Fred Martins

    Seller's Agent in 2020

    Fred Martins

    Berkshire Hathaway Home Services

    (860) 841-9333

    33 Total Sales

    Fred Martins
    Section Image
  • Lisa Sherman

    Buyer's Agent in 2020

    Lisa Sherman

    My Realtor, LLC

    (860) 682-5157

    69 Total Sales

    Lisa Sherman
    Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170278885

SmartMLS

APN: COLU-000016-000000-000022

Connecticut Tolland County Columbia 06237

54 Hennequin Rd, Columbia, CT

Not Listed for Sale

Detached

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

SmartMLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes