Greater Mansfield CT Real Estate $500k +

MLS Number 24115029

• Single Family
• Square Feet 7,772
• Bedrooms 5
• Bathroom 6
• Year Built 1850

Reimagined in the early 1900s and surrounded by natural beauty, this extraordinary 41-acre estate offers unmatched privacy, timeless architecture, and refined craftsmanship. The 7,772 sq ft stone residence, crowned with a slate roof, is framed by rolling fields, mature trees, and manicured gardens. Inside, hand-carved moldings, elegant fireplaces, and artisan details reflect a level of quality rarely found today. The chef's kitchen features a Thermador gas range and oven, double wall ovens, soapstone countertops a well-appointed butler's pantry, and an original Walker & Pratt Manufacturing Co. wood-burning cooking stove-both a functional centerpiece and a striking architectural feature. An impressive full-service bar makes entertaining effortless, while the screened porch with chevron brick flooring overlooks the gardens and grounds. Outdoor amenities include a heated fiberglass-lined pool, an original sauna room opening directly to the pool area, a greenhouse, and a two-car garage with a full loft. Bordered in part by protected land, including preserved acreage across the road, the setting offers exceptional privacy and a true sense of retreat. Whether enjoyed as a primary residence or a luxurious escape from the city, this exceptional estate presents a rare combination of seclusion, beauty, and timeless appeal.

Listed by Kristen Kaskela of Berkshire Hathaway NE Prop.

MLS Number 24177394

• Commercial
• MLS Status Active
• Year Built 1955
• Square Feet 11,692
• Acreage 1.5

Welcome to 1170 Ellington Rd - this architecturally distinctive Gambrel-style office building sits on a beautifully landscaped site in an established South Windsor corridor! Red brick, white dormers, and a gabled front entry give the property great curb appeal. Two stories of well-maintained Class B office space sit behind a generous parking lot with frontage on Ellington Road, proximate to I-291, I-84, and Bradley International Airport. A portion of the building (~51%), well-suited for a variety of educational, social services, and professional uses, is in the process of being leased to the South Windsor Board of Education - a creditworthy municipal anchor. The remainder is remarkably configurable: open spans that can be carved into smaller professional suites or kept as larger spaces. That flexibility opens the door to an unusually wide range of uses - a private school, early-childhood center, or district administrative offices; a cluster of medical, therapy, or counseling practices; a fitness, dance, or yoga studio; a martial arts academy; a worship space; or a polished headquarters office for an operator working within the region's logistics corridor. South Windsor itself is among the most affluent and stable towns in the Hartford metro - strong schools, professional demographics, and consistent recognition as one of the region's best places to live. A rare opportunity to own a distinctive building with in-place income and plenty of options!

Listed by Lisa Cozzi of Century 21 AllPoints Realty

MLS Number 24173038

• Single Family
• Square Feet 2,078
• Bedrooms 3
• Bathroom 3
• Year Built 1955

Set along a quiet private road just minutes from the historic villages of Mystic and Stonington, this exceptional waterfront property offers over two acres of privacy and natural beauty, surrounded by Quiambaug Cove. Designed for effortless single-level living, the home features three bedrooms and three full baths with spacious interiors that embrace the surrounding coastal setting. Sun-filled living and dining areas are thoughtfully positioned to capture water views from nearly every room, while the open floor plan creates an inviting atmosphere for both everyday living and entertaining. Two fireplaces add warmth and character, including one in the living room and another in the primary suite. A generously sized bedroom with its own private waterfront deck offers flexible use as a guest suite, artist studio, or home office. Sliding doors open to an expansive full-length deck overlooking the cove, creating seamless indoor-outdoor living. From your private dock enjoy easy access to Long Island Sound and beyond or a peaceful afternoon kayaking, swimming or tubing in the cove. Mature landscaping and the tranquil shoreline setting provide a rare sense of peace and seclusion, all within close proximity to Mystic and Stonington's renowned restaurants, marinas, and shops. A rare opportunity to create your ideal coastal retreat in one of the area's most picturesque waterfront settings.

Listed by Jon Arruda of William Pitt Sotheby's Int'l

MLS Number 24135276

• Land
• Acreage 168.4
• MLS Status Active
• Subdivision Pleasant Valley Farm
• Waterfront

One of the most beautiful farms in Connecticut. Ten Mile river runs thru the property plus small brook and 3+/- acre pond large area of cultivated land leased to area farmer, some stonewalls, grass pasture etc. Ideal for Equestrian Estate, working farm, subdivision or High End Adult Housing Development (this would require certain zoning text changes or additions to permit this type of development. The farm is teeming with all sorts of wildlife ideal for very exclusive game club.

Listed by Derek Greene of Derek Greene

MLS Number 24163655

• Land
• Acreage 58.76
• MLS Status Active
• Other Amenities Waterfront
• Zoning RD

This established quarry offers a prime opportunity to acquire a profitable and permitted operation in the high-demand world of tan stone which is the most versatile material in the aggregate and masonry world. Because it's a neutral earthy tone, it blends seamlessly into both natural landscapes and modern architectural designs. Slabs, Thin Wall, and Wall Stone are just an example of the products mined from this quarry. It is equipped to handle large-scale projects and become a productive aspect of a company's granite quarry opportunities. Minutes from Rt 395, the quarry is easily accessible. Site tours can be scheduled at your convenience. This is also listed as part of 4 properties - MLS 2411289 which is just under a total of 100 acres. The other properties include 100 Hubbard Hill 8.8 acres, 24 Klocek Rd which includes 2 houses and various buildings on 11.2 acres and 25 Klocek Rd 22.51 acres. Development may be an option. You will need to do your due diligence.

Listed by Jill B. Pilgrim of William Pitt Sotheby's Int'l

MLS Number 24166663

• Commercial
• MLS Status Active
• Year Built 1900
• Bathroom 4
• Square Feet 12,311

Positioned in the heart of New London's thriving waterfront district, this fully renovated mixed-use asset offers investors a rare opportunity to acquire a stabilized, income-producing property with long-term upside. Overlooking the Thames River, the property combines historic New England charm with modern functionality in one of southeastern Connecticut's most desirable coastal markets. The three-story granite and brick building encompasses approximately 12,311 square feet and was completely gut-renovated in 2019. The renovation modernized all major systems while carefully preserving the building's original architectural character. As a result, the property delivers both aesthetic appeal and operational efficiency, appealing to today's residential and commercial tenants. The asset features a well-balanced and diversified income stream, consisting of eight residential apartments, two retail storefronts, and one industrial/flex unit. This mix of uses provides multiple revenue channels and helps mitigate risk by reducing reliance on any single tenant category. The residential units benefit from strong demand driven by the property's walkable location, waterfront setting, and scenic river views. Tenants are drawn to the combination of lifestyle and convenience, with immediate access to downtown amenities, dining, and entertainment. The commercial spaces offer excellent visibility and frontage, making them highly attractive for retail, service-based businesses, or flex .

Listed by Ilir Dedvukaj of Lakeshore Realty