$415,000
SOLD JUL 25, 2025

254 Long Hill Rd Coventry, CT 06238

3 Beds
1.5 Baths
1,589 Sq Ft
0.91 Acres

Recently Sold

$261 Per Sq Ft

15% Above List Price

7 Days on Market

Highlights

  • Above Ground Pool
  • Deck
  • Attic
  • George Hersey Robertson School Rated A-
  • Ranch Style House
  • 1 Fireplace

About This Home

As of July 2025

HIGHEST AND BEST MON 6/30 @12PM. Welcome to your own private oasis in Coventry! This charming Ranch-style home is perfectly set on a park like 0.91-acre lot, offering a peaceful setting with modern comforts. Conveniently located close to the UCONN Storrs campus and close to a variety of local restaurants, this home combines tranquility with accessibility. Step inside to a generously sized living room with high ceilings featuring a cozy fireplace, abundant sunlight and a newer ductless AC unit. The open-concept seamlessly connects the living room to the kitchen with space for a dining table too. The kitchen is equipped with SS appliances and loads of cabinet space. A formal dining room adds a touch of elegance for special occasions- or your house plant collection, home office or a reading nook! This home offers 3 bedrooms along with a large full bathroom and an additional updated half bath for added convenience. The two separated basement areas are currently unfinished, one is a potential in-law prepped for plumbing and utilities. Expand! For a LL family room, home gym, or a private home office. Step outside and enjoy your personal retreat. Use your front porch for shade or choose your multi-level back deck to splash right into the above ground pool or watch your dogs play within the pet fence worry free. New liner and pump! NEW Chimney and 2018 SEPTIC TANK. Make your showing appointment today!

Last Agent to Sell the Property

Gabrielle Renaud

Coldwell Banker Realty License #RES.0801396 Listed on: 06/25/2025

Coldwell Banker Realty

Last Buyer's Agent

Bruce Bernier

Coldwell Banker Realty License #RES.0814247

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,909

Year Built

  • Built in 1974

Lot Details

  • 0.91 Acre Lot
  • Garden
  • Property is zoned GR80

Parking

  • Parking Deck

Home Design

  • Ranch Style House
  • Concrete Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Vinyl Siding

Interior Spaces

  • 1,589 Sq Ft Home
  • Ceiling Fan
  • 1 Fireplace

Kitchen

  • Oven or Range
  • Range Hood
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Laundry on lower level
  • Dryer
  • Washer

Attic

  • Storage In Attic
  • Attic or Crawl Hatchway Insulated

Unfinished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Basement Storage

Outdoor Features

  • Above Ground Pool
  • Deck
  • Exterior Lighting
  • Rain Gutters
  • Porch

Schools

  • Coventry High School

Utilities

  • Central Air
  • Mini Split Air Conditioners
  • Hot Water Heating System
  • Heating System Uses Oil
  • Private Company Owned Well
  • Hot Water Circulator
  • Fuel Tank Located in Basement

Listing and Financial Details

  • Assessor Parcel Number 1612720

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,909

Year Built

Built in 1974

Lot Details

0

Listing Details

  • Neighborhood: N/A
  • Property Type: Single Family For Sale
  • Style: Ranch
  • Sq Ft Est Heated Above Grade: 1589
  • Total Sq Ft: 1589
  • Year Built: 1974
  • New Construction: No/Resale
  • Remarks Public Addendum: HIGHEST AND BEST MON 6/30 @12PM.
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Directions: The property along the street is in Andover, the house and 90% of property is in Coventry- GPS May bring you to 254 Long Hill Rd, Andover. Destination will be the same.
  • Financing Used: VA
  • In Law Apartment: Possible
  • Street Type: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 3
  • Total Bathrooms: 2
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Fireplaces: 1
  • Attic Description: Storage Space, Access Via Hatch
  • Basement Description: Full, Unfinished, Storage, Full With Walk-Out
  • Appliances: Oven/Range, Range Hood, Refrigerator, Dishwasher, Washer, Dryer
  • Laundry Room Info: Lower Level
  • Attic: Yes

Exterior Features

  • Exterior Features: Porch, Deck, Gutters, Garden Area, Lighting
  • Exterior Siding: Vinyl Siding
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Not Applicable
  • Swimming Pool: Yes
  • Pool: Above Ground Pool
  • Construction Description: Frame

Garage/Parking

  • Garage And Parking: None

Utilities

  • Cooling System: Ceiling Fans, Central Air, Split System
  • Heat Type: Hot Water
  • Heat Fuel Type: Oil
  • Fuel Tank Location: In Basement
  • Hot Water Description: Domestic
  • Water Source: Private Well
  • Sewer: Septic

Lot Info

  • Acres: 0.91
  • Lot Description: Fence - Partial Fence - Electric Pet Cleared
  • Zoning: GR80
  • Parcel #: 1612720

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 5909

MLS Schools

  • Elementary School: Per Board of Ed
  • High School: Coventry

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 25, 2025
Closed on
Jul 25, 2025
Sold by
Fretz Lori A
Bought by
Ferraro Matthew
Seller's Agent
Gabrielle Renaud
Coldwell Banker Realty
Buyer's Agent
Bruce Bernier
Coldwell Banker Realty
List Price
$360,000
Sold Price
$415,000
Premium/Discount to List
$55,000
15.28%
Views
104
Current Estimated Value
$415,722

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$722
Avg. Annual Appreciation
0.51%
Original Mortgage
$260,000
Outstanding Balance
$259,113
Interest Rate
6.84%
Mortgage Type
Future Advance Clause Open End Mortgage
Estimated Equity
$156,609

Purchase Details

Closed on
Aug 1, 2024
Sold by
Fretz Lori Lt and Fretz
Bought by
Fretz Lori A

Purchase Details

Closed on
May 21, 2021
Sold by
Fretz Lori
Bought by
Lori Fretz Lt and Fretz

Purchase Details

Listed on
May 17, 2018
Closed on
Aug 2, 2018
Sold by
Markie Deborah and Markie Dana M
Bought by
Fretz Lori
Seller's Agent
Bonnie Burleigh
Countryside Realty
Buyer's Agent
John Gerardi
William Raveis Real Estate
List Price
$269,900
Sold Price
$262,500
Premium/Discount to List
-$7,400
-2.74%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.48%
Original Mortgage
$249,375
Interest Rate
4.5%
Mortgage Type
New Conventional
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 Type Sale Price Title Company
Warranty Deed $415,000 --
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Warranty Deed $262,500 --
Warranty Deed $262,500 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $260,000 Future Advance Clause Open End Mortgage
Previous Owner $249,375 New Conventional
Previous Owner $199,447 No Value Available
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/25/2025 07/25/25 Sold $415,000 +15.3% $261 / Sq Ft
07/02/2025 07/02/25 Pending -- -- --
06/25/2025 06/25/25 For Sale $360,000 +37.1% $227 / Sq Ft
08/01/2018 08/01/18 Sold $262,500 -2.7% $165 / Sq Ft View Prior Sale
05/20/2018 05/20/18 For Sale $269,900 -- $170 / 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,909 $248,700 $47,900 $200,800
2024 $5,343 $160,400 $41,700 $118,700
2023 $5,091 $160,400 $41,700 $118,700
2022 $4,996 $160,400 $41,700 $118,700
2021 $4,996 $160,400 $41,700 $118,700
2020 $5,000 $160,400 $41,700 $118,700
2019 $5,171 $160,600 $41,700 $118,900
2018 $4,395 $136,500 $41,700 $94,800
2017 $4,368 $136,500 $41,700 $94,800
2016 $4,259 $136,500 $41,700 $94,800
2015 $4,259 $136,500 $41,700 $94,800
2014 $4,319 $151,700 $51,600 $100,100
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 24106761

SmartMLS

APN: COVE-000021-000008-000135