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 24074696

• Commercial
• MLS Status Active
• Year Built 1999
• Bathroom 6
• Square Feet 11,783

Taylor Brooke Vineyard, Winery, Brewery, and Residence presents a rare opportunity to acquire 43 picturesque acres in Woodstock, Connecticut. This offering includes three distinct structures: a 7,122 GSF winery with a state-of-the-art wine-making facility layout, tasting pavilion, retail space, and cocktail bar; a 5,884 GSF brewery featuring a beer production facility layout, commercial kitchen, taproom, retail space, and outdoor patio; and a 2400 SF custom-built grand Cape residence. The sale encompasses (Real Estate Only) the vineyard(5.19 Acres of mature vines), winery, brewery, residence offered at $2,100,000. In addition to the Real Estate offering the business assets offering includes all equipment and furnishings $569,007 a current Product inventory. product recipes, wholesale distribution network, brand rights, goodwill and 80 hours of transitional operational consulting $230,993. Total turn-key offering with Real Estate, Business assets, product inventory and transitional consulting $2,900,000.

Listed by Michael J. Collins of Berkshire Hathaway NE Prop.

MLS Number 24166242

• Commercial
• MLS Status Active
• Year Built 1989
• Square Feet 20,358
• Acreage 0.63

Positioned on the Hartford/West Hartford line, 67 Prospect Avenue offers a rare opportunity to acquire a 20,000+ square foot Class B office asset in one of Central Connecticut's most accessible and desirable business corridors. With strong fundamentals, on-site parking, elevator and proximity to major economic hubs, this property is ideal for both investors and owner-users seeking scale, visibility, and long-term upside. The property's highlights include: 60 on-site parking spaces (strong parking ratio for the area), strategic location on the West Hartford / Hartford line, location that is minutes to Downtown Hartford, West Hartford Center, and Blue Back Square, immediate access to I-84, Route 9, and I-91, flexible layout suitable for multi-tenant or single-user occupancy, is ideal for professional services, medical office, or institutional users, and strong regional demographics and workforce access. This biggest draw is the opportunity for value-add potential through lease-up or repositioning.

Listed by Rachael Cisz and Elizabeth Barnum of Serhant Connecticut,LLC

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