Greater Mansfield CT Real Estate $500k +

MLS Number 24173092

• Commercial
• MLS Status Active
• Year Built 1949
• Square Feet 14,459
• Acreage 0.38

109 Talcott Road offers a rare opportunity for both owner-users and investors seeking a flexible commercial property in a prime West Hartford location. This well-positioned asset features a functional mix of industrial and office space, making it ideal for a wide range of business uses. The first floor includes a welcoming reception area, five private offices, and a flexible open workspace that seamlessly combines office and industrial use. A break area with two half bathrooms adds convenience for staff, while two loading docks and three drive-in doors provide excellent access for operations, storage, and logistics. The second floor offers large open-concept office space, a private office, and two additional half bathrooms. This level is well suited for administrative, or collaborative workspace needs. Whether you're looking to establish a new operation, expand your current footprint, or add a versatile property to your portfolio, this building provides the adaptability to meet your needs. Its location in a strong and desirable market adds long-term value and appeal. Opportunities like this are hard to find. For additional information schedule a private showing today!

Listed by Lyle Rotondo of Berkshire Hathaway NE Prop.

MLS Number 24165689

• Single Family
• Square Feet 2,009
• Bedrooms 3
• Bathroom 3
• Year Built 1900

Rare direct waterfront retreat on the Niantic River in Waterford's coveted Oswegatchie neighborhood. This 3-bedroom, 3-bath home offers sweeping, unobstructed views of the Niantic River to Oswegatchie Hills Nature Preserve and a private fixed dock with approximately 24" draft at low tide. Enjoy the rare privilege of fishing from your own dock while bald eagles drift over the protected landscape of Oswegatchie Hills. The residence features 1,325 sq ft above grade plus 684 sq ft of finished walk-out lower-level living space, creating flexibility for guests, entertaining, or extended stays. Significant recent upgrades and thoughtfully designed hardscaping enhance both comfort and outdoor enjoyment. A separate climate-controlled office in the boathouse with heat, A/C, electricity, and CAT6 ethernet adds a distinctive bonus for working from home or pursuing creative interests. Enjoy morning coffee on the deck and spectacular sunset views over the river. Proven short-term rental history adds appeal for investors or those seeking a part-time coastal getaway. Just minutes to downtown Niantic, beaches, the boardwalk, dining, shopping, Pfizer, Electric Boat, Sub Base, the US Coast Guard Academy, and New London train service, with convenient access to both Boston and New York. Rarely does a property combine direct boating access to Long Island Sound, protected natural views, and such close proximity to shoreline amenities and major employers.

Listed by Amy F. Jones of Berkshire Hathaway NE Prop.

MLS Number 24195347

• Single Family
• Square Feet 3,904
• Bedrooms 5
• Bathroom 5
• Year Built 2026

BRAND NEW CONSTRUCTION home in South Windsor Welcome to this stunning Contemporary Raised Ranch residence built in 2026, offering 3,904 square feet of elegant living space on a private .74-acre lot. Featuring 12 spacious rooms, including four full baths, one half bath, and epoxy-coated three-car garages, this home seamlessly blends modern luxury with timeless craftsmanship. Step inside to discover 9' upper ceilings, 9' and 9'9" lower ceilings an expansive first-floor primary suite with walk-in Custom closet. Rain-inspired showers with modern wall hung vanities. Two gas fireplaces, this home also features a luxurious in-law suite perfect for guests or extended family with Juliet door, Custom closet, Cafe' Appliances, Solid wood saker doors, custom trim, open floor plan and much, much more... Enjoy the beauty of the outdoors with an 8' deep pool, two story shed with the potential of a pool house and office/family cave, with views that provide both tranquility and privacy, all while being close to local amenities. Energy efficiency is at the forefront with Natural Gas HVAC, heating in the basement, on-demand and gas hot water systems, and a SimpliSafe security system with cameras and active recording. This is more than just a home-it's a lifestyle of comfort, privacy, and sophistication

Listed by Clifford Knight of Agnelli Real Estate

MLS Number 24148759

• Land
• Acreage 103.76
• MLS Status Active
• Other Amenities Waterfront
• Zoning R-80

Beautiful 100+ acre farm in prime section of upper bracket homes, ideal for future subdivision, equestrian estate or private family compound or preserve, 40 to 50% under crop management with remainder wooded with multiple hidden fields, terrain is level sloping with manmade farm pond, approx. 900 feet frontage and legal R.O.W. between 2 farm houses plus add'l. 45 feet on White Plain Road at the eastern end of property. 60% =/- is bordered by stone wall and contains abundant wildlife. This farm must be seen to be fully appreciated. Current taxes have PA-490 exemption.

Listed by Derek Greene of Derek Greene

MLS Number 24177885

• Single Family
• Square Feet 2,900
• Bedrooms 4
• Bathroom 3
• Year Built 2026

Set on a private lot with a beautiful barn and surrounded by peaceful nature, this exceptional new construction home offers a rare combination of quality craftsmanship, modern finishes, and timeless character. Thoughtfully designed with upgraded details throughout, the home features hardwood flooring, custom tile work, quartz countertops, and a spacious, functional layout ideal for both everyday living and entertaining. The barn adds incredible versatility and charm, offering endless possibilities for livestock, storage, hobbies, workshop space, or recreational use. With a setting that provides both privacy and convenience, this is a truly unique opportunity to own a newly built home with distinctive features rarely found together. A one-of-a-kind property that blends modern comfort with the character and flexibility of country living.

Listed by Traci L. Pazzaglia of Berkshire Hathaway NE Prop.

MLS Number 24145176

• Commercial
• MLS Status Active
• Year Built 1945
• Bathroom 1
• Square Feet 3,000

Two tenant Retail property. Both tenants are mon-mon; Bakery & a takeout restaurant. New Roof and HVAC. Just off Route 2. Total 3,000sf on 0.19 acre corner lot. Zone TC - Town Center. Offers 15 off-street parking spaces. 60' Road frontage on Hebron Ave. Public Water/Sewer. Heats with gas and forced air; Central A/C. For Sale $1,050,000. BY SPECIAL PERMIT: Businesses, Multi-Family, Tym, Mixed-use, Museum, Office, Personal Service, Place of Worship, Retail, Restaurant, Theatre, Recreation...

Listed by Norman B. Peck of Signature Properties of N.E.

MLS Number 24188198

• Single Family
• Square Feet 7,370
• Bedrooms 5
• Bathroom 5
• Year Built 1987

Escape to your own private resort at 40 Ferncliff Drive-a stunning contemporary ranch set on 1.5 secluded, wooded acres. This Santa Barbara-style retreat blends dramatic architecture, sun-drenched spaces, and seamless indoor-outdoor living. A custom Wolfworks kitchen with bamboo cabinetry, concrete countertops, high-end appliances, and a large island opens to both the elegant dining area with wet bar and the bright family room with skylights, surround sound, and a custom fireplace. The serene first-floor primary suite offers a gas fireplace, deck access, two walk-in closets, and a luxurious spa bath. A built-in office, two additional bedrooms, and a mudroom with laundry and 3-car garage access complete the main level. The expansive walk-out lower level is a true retreat, featuring a family room with fireplace, game room, fitness room, cabana room with wet bar, two more bedrooms, two full baths, and a second kitchen. Indulge in your private spa with a sauna, steam shower, and Jacuzzi, then step outside to the heated inground pool and lush grounds. With four fireplaces, a whole-house generator, central sound, and thoughtful custom details throughout, this exceptional property delivers resort-style living just minutes from shopping, dining, and top West Hartford schools.

Listed by Sid. Siddiqui of Eagle Eye Realty PLLC

MLS Number 24183252

• Land
• Acreage 3.3
• MLS Status Active
• Zoning RR-80/RA 40

Rare opportunity to own a 3.3-acre parcel with multiple zoning designations (GC-60, RR-80, and RA-40) and approximately 80.78 feet of road frontage. Buyer to perform all due diligence regarding zoning requirements, permitted uses, and development potential. Well and septic systems would be required. Electrical service has been extended to the existing on-site cell tower, which is subject to a current lease agreement. The property offers a wooded setting while remaining conveniently located near area beaches, Stonington Borough, major transportation routes including Interstate 95, and Foxwoods Resort Casino.

Listed by Jackson Switz and Thomas Switz of Switz Real Estate Associates