New Listing
$1,200,000
 $6,442 est/mo Sourced by Back At You

241 Old Farms Road,Glastonbury, CT 06073

Glastonbury, CT 06073

Share:

Description

Experience timeless elegance and exceptional craftsmanship in this stunning, close to newly built, 5-bedroom, 4.5-bath home, blending luxurious finishes with modern functionality. A dramatic two-story foyer welcomes you to beautifully appointed interiors featuring coffered ceilings, a graceful barrel archway, oak floors, and exquisite custom millwork. Designed for everyday living and entertaining, the showstopping designer kitchen boasts premium appliances, elegant countertops, and an oversized eat-in dining area overlooking the living room, creating a seamless, open-concept gathering place. An entertainer's delight perfect for gatherings or a relaxed evening at home. A stylish mudroom with custom built-in bench seating adds convenience and organization, while a first-floor bedroom with a full bath offers flexibility for guests, multigenerational living, or even a home office. Upstairs, the luxurious primary suite provides a private retreat, complete with an impressive, oversized walk-in closet that offers the space and storage anyone would dream of. The walk-out basement presents endless possibilities for additional living space, a home gym, recreation area, or a potential media room. An in-ground sprinkler system adds convenience to outdoor maintenance. Combining classic sophistication with modern colonial design, this exceptional home offers upscale finishes, thoughtful details, and inviting spaces designed for comfortable living and effortless entertaining.

Details

MLS #24216897
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusComing Soon
Year2025
Days On Site4
Listing Provided ByBerkshire Hathaway NE Prop. | Melissa Fox

Features

Bed(s)5
Bath(s) 5 Total
SQ Feet3,749
Garage3
BasementY
ZoningRR
Acreage1.67
Golf CourseYes

Interior

Total Rooms8
Cooling SystemCentral Air
Interior FeaturesAuto Garage Door Opener, Cable - Available
Appliances IncludedGas Range, Wall Oven, Microwave, Refrigerator, Dishwasher, Washer, Dryer, Wine Chiller
Fireplaces Total1
Laundry Room InfoUpper Level

Exterior

Exterior FeaturesUnderground Utilities, Sidewalk, Deck, Gutters, Lighting, Underground Sprinkler
Roof InformationAsphalt Shingle
Foundation TypeConcrete

Parking

Garage & ParkingAttached Garage
Garages Number3

Utilities

Sewage SystemSeptic
Energy FeaturesEnergy Star Rated, Thermopane Windows

Taxes

Tax YearJuly 2026-June 2027
Property Tax19702

Area Information

StateCT
CountyHartford
CityGlastonbury
Zip Code06073
AreaSouth Glastonbury
School DistrictPer Board of Ed
Elementary SchoolPer Board of Ed
High SchoolGlastonbury
Listing VS Median (in 06073)
Price:
$1,200,000
low | high
Med:
$554,000
100% of Average
sqft:
3,749
low | high
Med:
2,592
80.861563083489% of Average
$ / sqft:
$320
low | high
Med:
$214
83.225758744856% of Average
On site:
4
low | high
Med:
74
5.405405405405% of Average
Sourced by Back At You

Market Activity 06073

Request a showing

Request a showing

Contact


Additional Information


Showing Information


Submit Form

Required Field
By submitting, you agree to receive promotional texts and/or calls from Andrew Abu Inc at the number provided. Message/data rates may apply. Consent is not a condition of purchase, and you can opt out anytime by replying STOP.
The data relating to real estate for sale on this website appears in part through the SMARTMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SMARTMLS through a licensing agreement. Listing information is from various brokers who participate in the SMARTMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed. Copyright 2021 SmartMLS, Inc.

Contact

Learn More About This Property

StateCT
CountyHartford
CityGlastonbury
Zip Code06073
AreaSouth Glastonbury
School DistrictPer Board of Ed
Elementary SchoolPer Board of Ed
High SchoolGlastonbury
Listing VS Median (in 06073)
Price:
$1,200,000
low | high
Med:
$554,000
100% of Average
sqft:
3,749
low | high
Med:
2,592
80.861563083489% of Average
$ / sqft:
$320
low | high
Med:
$214
83.225758744856% of Average
On site:
4
low | high
Med:
74
5.405405405405% of Average
Sourced by Back At You
Listing Updated: October 29, 2026 at 7:27:52 PM PDT