CT Shoreline Real Estate

Home-Search

Save
Ask
Tour
Hide
Share
$1,200,000
2 Days On Site

241 Old Farms Road
Glastonbury, CT 06073

Single Family Residence|Coming Soon
5
Beds
5
Total Baths
4
Full Baths
1
Partial Bath
3,749
SqFt
$320
/SqFt
2025
Built
County:
Hartford
Listing courtesy of Melissa Fox of Berkshire Hathaway NE Prop. Office Phone: (860) 633-3674 Broker Contact: (860) 212-3665
Call Now: 203-641-3233
Is this the listing for you? We can help make it yours.
203-641-3233
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

Enter an interest rate to see your estimated monthly payment.
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

Experience timeless elegance and exceptional craftsmanship in this stunning, fairly new built, 5-bedroom, 4.5-bath home, thoughtfully designed with luxurious finishes and modern functionality throughout. A dramatic two-story foyer welcomes you into beautifully appointed interiors featuring coffered ceilings, a graceful barrel archway, and pristine custom millwork. The designer kitchen is a true showstopper boasting exquisite marble countertops, premium appliances, and upscale details, perfect for either everyday living or entertaining. Additional highlights include a stylish mudroom with built-in bench seating, allowing for style and convenience when arriving home. A first-floor bedroom with a full bath offer the ideal flexibility for either guests, multigenerational living, or even a private home office. Upstairs, you will find a luxurious primary suite offering the perfect, private retreat designed for comfort and relaxation.. The walk-out basement presents an exciting opportunity to create additional living space tailored to your needs, whether envisioned as a recreation room, home gym, or entertainment area. The lawn features an elaborate in-ground sprinkler system that adds convenience to this exceptional property. Combining timeless sophistication, contemporary modern design, this home offers the appeal of close to new construction at its finest with the quality and style that today's buyers are searching for. Professional photos to come.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,200,000
Days On Site 
2 Days
Bedrooms 
5
Inside Area (SqFt) 
3,749 sqft
Total Baths 
5
Full Baths 
4
Partial Baths 
1
Lot Size 
1.67 Acres
Year Built 
2025
MLS Number 
24216897
Status 
Coming Soon
Property Tax 
$19,702
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
2 hours agoListing updated with changes from the MLS
9 hours agoStatus changed to Coming Soon
2 days agoListing first seen on site
General Features
Acres 
1.67
Attached Garage 
Yes
Foundation 
Concrete Perimeter
Garage 
Yes
Garage Spaces 
3
Parking 
Garage Door OpenerAttached
Property Sub Type 
Single Family Residence
Sewer 
Septic Tank
SqFt Total 
3749
Style 
Colonial
Utilities 
Underground Utilities
Water Source 
Well
Zoning 
RR
Interior Features
Appliances 
DishwasherDryerGas RangeMicrowaveRefrigeratorOvenWasherWine Cooler
Basement 
FullWalk-Out AccessUnfinished
Cooling 
Central Air
Fireplace 
Yes
Fireplaces 
1
Heating 
PropaneForced Air
Interior 
Entrance Foyer
Laundry Features 
Laundry Room
Formal Dining Room 
Level - Main
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
StoneVinyl SidingFrame
Lot Features 
Cul-De-SacSloped
Patio And Porch 
Deck
Roof 
Asphalt
Community Features
Accessibility Features 
Accessible Full Bath
Community Features 
GolfPool
Schools
School District
Unknown
Elementary School
Per Board of Ed
Middle School
Smith
High School
Glastonbury
Listing courtesy of Melissa Fox of Berkshire Hathaway NE Prop. Office Phone: (860) 633-3674 Broker Contact: (860) 212-3665



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 2026 SmartMLS, Inc.
Last checked: 2026-10-26 11:07 AM UTC.

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share
Scroll to Top