$699,900
$50K PRICE DROP

Estimated payment $4,539/month

Total Views 11,360
4 Beds
2.5 Baths
2,622 Sq Ft
$267 Price per Sq Ft

Highlights

  • 2.23 Acre Lot
  • Open Floorplan
  • Deck
  • Union School Rated A
  • Colonial Architecture
  • Property is near golf course, public transit, and shops

About This Home

Welcome to 243 Brickyard Road, completely renovated from top to bottom on 2.27 acres bordering the Farmington Canal Heritage Trail open space. This is not a flip but a thoughtfully transformed home, where every major component has been updated thoroughly and carefully. This beautifully reimagined 4-bedroom, 2.5-bath home offers the perfect blend of modern updates, quality craftsmanship, and natural beauty, designed for years of comfortable living. The home's exterior was refreshed in early 2025 with brand-new vinyl siding and a new roof. Striking black architectural shingles create a beautiful contrast against the crisp white siding, giving the home timeless curb appeal. A new front walk and welcoming Trex entry deck provide an inviting first impression for family and guests alike. Inside, virtually every surface and system has been updated. Brand-new hardwood floors, installed and finished in 2026, flow throughout the home. The stunning new kitchen serves as the heart of the home, featuring white cabinetry, beautiful countertops, a classic subway-tile backsplash, stainless-steel appliances, a large center island highlighted by elegant pendant lighting, and an externally vented range hood. On the second floor, there is a primary bedroom with a walk-in closet and a large bath. There are 3 additional bedrooms. All baths have been renovated with new fixtures and tile flooring, creating fresh and stylish spaces throughout the home. Major mechanical improvements provide peace of mind for years to come. Baseboard hot water heat and central air conditioning ensure year-round comfort and efficiency. What makes 243 Brickyard Road special is not simply the list of improvements, but the care and investment behind them. Skilled craftsmen, contractors, and tradespeople worked together to bring this home back to life, creating a property that feels both new and enduring. A standout feature of the home is the enormous basement with unusually high ceilings and a full walk-up staircase that opens to a standard exterior door. that provides convenient access to the yard. Whether you're envisioning additional finished living space, a home theater, fitness area, hobby room, or simply exceptional storage, this versatile space offers endless possibilities. Located in one of Farmington's most desirable communities, this is more than a renovated house-it is an opportunity to begin your next chapter in a home where so much has already been thoughtfully done for you. Simply move in, unpack, and enjoy.

Listing Agent

Michael Daly

Berkshire Hathaway NE Prop. Brokerage Phone: (860) 729-7433 License #RES.0810652 Listed on: 06/03/2026

Berkshire Hathaway NE Prop.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,355

Year Built

  • Built in 1984

Lot Details

  • 2.23 Acre Lot
  • Property is zoned R40

Home Design

  • Colonial Architecture
  • Concrete Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Vinyl Siding

Interior Spaces

  • 2,622 Sq Ft Home
  • Open Floorplan
  • Pendant Lighting
  • 1 Fireplace
  • Mud Room
  • Entrance Foyer
  • Concrete Flooring
  • Laundry on lower level

Kitchen

  • Electric Range
  • Range Hood
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Unfinished Basement

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

Parking

  • 2 Car Garage
  • Parking Deck
  • Automatic Garage Door Opener
  • Shared Driveway

Outdoor Features

  • Deck
  • Rain Gutters

Location

  • Property is near golf course, public transit, and shops

Utilities

  • Central Air
  • Hot Water Heating System
  • Heating System Uses Oil
  • Oil Water Heater
  • Fuel Tank Located in Basement
  • Cable TV Available

Community Details

  • Public Transportation

Listing and Financial Details

  • Assessor Parcel Number 1985946

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,355

Year Built

Built in 1984

Lot Details

2.23 Acres

Listing Details

  • Neighborhood: N/A
  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 2622
  • Total Sq Ft: 2622
  • Year Built: 1984
  • New Construction: No/Resale
  • Nearby Amenities: Commuter Bus, Golf Course, Library, Medical Facilities, Private School(s), Public Rec Facilities, Public Transportation, Shopping/Mall
  • Remarks Public Addendum: Major mechanical improvements provide peace of mind for years to come. Baseboard hot water heat and central air conditioning ensure year-round comfort and efficiency. What makes 243 Brickyard Road special is not simply the list of improvements, but the care and investment behind them. Skilled craftsmen, contractors, and tradespeople worked together to bring this home back to life, creating a property that feels both new and enduring. A standout feature of the home is the enormous basement with unusually high ceilings and a full walk-up staircase that opens to a standard exterior door. that provides convenient access to the yard. Whether you're envisioning additional finished living space, a home theater, fitness area, hobby room, or simply exceptional storage, this versatile space offers endless possibilities. Located in one of Farmington's most desirable communities, this is more than a renovated house-it is an opportunity to begin your next chapter in a home where so much has already been thoughtfully done for you. Simply move in, unpack, and enjoy.
  • Direct Waterfront: No
  • Encumbrances Restrictions: Easements
  • Home Warranty Offered: No
  • Directions: Per GPS
  • In Law Apartment: No
  • Street Type: Road
  • Office Attribution Contact: (860) 633-3674
  • Reserve Prospect: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 4
  • Total Bathrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Fireplaces: 1
  • Basement Description: Full, Unfinished, Hatchway Access, Interior Access, Concrete Floor
  • Interior Amenities: Auto Garage Door Opener, Cable - Available, Open Floor Plan
  • Appliances: Electric Range, Microwave, Range Hood, Refrigerator, Dishwasher, Disposal
  • Additional Rooms: Foyer, Mud Room
  • Laundry Room Location: Second Floor
  • Laundry Room Info: Lower Level, Upper Level
  • Attic: No

Exterior Features

  • Exterior Features: Deck, Gutters
  • Exterior Siding: Vinyl Siding
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Not Applicable
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 2
  • Driveway Type: Shared, Paved, Asphalt
  • Total Parking Spaces: 4
  • Garage And Parking: Attached Garage, Paved, Driveway

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Water
  • Heat Fuel Type: Oil
  • Fuel Tank Location: In Basement
  • Hot Water Description: Oil, Domestic
  • Water Source: Public Water Connected
  • Sewer: Septic

Schools

  • Intermediate School: Per Board of Ed

Lot Info

  • Acres: 2.23
  • Lot Description: Treed Borders Open Space Level Lot
  • Flood Zone: No
  • Zoning: R40
  • Parcel #: 1985946

Tax Info

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

MLS Schools

  • Elementary School: Per Board of Ed
  • Middle Jr High School: Per Board of Ed
  • High School: Per Board of Ed

Map

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

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $8,355 $313,880 $108,640 $205,240
2024 $7,988 $313,880 $108,640 $205,240
2023 $7,599 $313,880 $108,640 $205,240
2022 $7,110 $242,480 $92,280 $150,200
2021 $6,986 $242,480 $92,280 $150,200
2020 $6,831 $244,210 $94,010 $150,200
2019 $6,831 $244,210 $94,010 $150,200
2018 $6,638 $244,210 $94,010 $150,200
2017 $6,676 $250,220 $97,380 $152,840
2016 $6,451 $250,220 $97,380 $152,840
2015 $6,258 $250,220 $97,380 $152,840
2014 $6,115 $250,210 $97,370 $152,840
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
07/10/2026 07/10/26 Price Changed $699,900 -6.7% $267 / Sq Ft
06/03/2026 06/03/26 For Sale $749,900 -- $286 / Sq Ft
Source: SmartMLS

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Warranty Deed $248,336 --
Deed $25,000 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Closed $250,000 Credit Line Revolving
Previous Owner $248,580 Stand Alone Refi Refinance Of Original Loan
Previous Owner $275,000 No Value Available
Previous Owner $230,000 No Value Available
Previous Owner $200,000 No Value Available
Source: Public Records

Source: SmartMLS

MLS Number: 24180861

SmartMLS

APN: FARM-000014-000005-000002

Your Personal Tour Guide

Ask me questions while you tour the home.