Greater Mansfield CT Real Estate $500k +

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 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 24163520

• Commercial
• MLS Status Active
• Year Built 1985
• Bathroom 1
• Square Feet 2,850

Location! Right off the I-95 on/off Ramp, You will find an Exceptional Commercial Property. Located at the end of a cul-de-sac, in an Industrial park setting. This property is 10.48 Acres and has a 2,850 sq. ft. pre-fab metal building, with 450 sq. ft of office space, including a bathroom, a 2,400 sq. ft warehouse with a mezzanine and 2 large loading docks at grade level, offering many possibilities. Most recently, it operated as a Pipe Company warehouse/office and a material yard. Currently there are 2 acres completely fenced in, with a locking gate and plenty of room to expand. With easy highway access, there's many possibilities, subject to approvals.

Listed by Colleen E. Block of Barile Realty Group

MLS Number 24196079

• Single Family
• Square Feet 5,211
• Bedrooms 7
• Bathroom 5
• Year Built 1917

Set on nearly an acre of beautifully landscaped grounds with a private pool, this stately residence seamlessly blends timeless architecture with modern updates in one of West Hartford's most sought-after neighborhoods, just steps from Elizabeth Park. From the moment you step into the gracious foyer, you'll be captivated by soaring ceilings, exquisite architectural details, and the home's remarkable sense of scale. A stunning double staircase creates a dramatic first impression, flanked by an elegant formal dining room and a gracious living room-an ideal setting for welcoming guests and entertaining. At the heart of the home is a beautifully updated kitchen that combines style and function. With quartz countertops, a large island, a pantry, and a dry bar, the room flows effortlessly into the dining room. A warm and inviting family room features a wood-burning fireplace, custom built-ins, and walls of bookshelves. Just beyond, a sun-filled sunroom opens to a bluestone patio overlooking the beautifully landscaped pool, thoughtfully positioned to create a peaceful and private outdoor retreat. Designed for today's lifestyle, the home also offers a spacious mudroom, providing exceptional everyday convenience. Upstairs, the luxurious primary suite is a true sanctuary, complete with a generous bedroom, a private office or dressing room, and a spa-like atmosphere.

Listed by Paula Fahy Ostop of William Raveis Real Estate

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 24189852

• Single Family
• Square Feet 3,350
• Bedrooms 4
• Bathroom 6
• Year Built 1988

Framed by views of Long Island Sound, this extraordinary coastal residence has been thoughtfully reimagined to offer an unparalleled blend of timeless elegance, exceptional craftsmanship, and sophisticated waterfront living. Renovated with impeccable craftsmanship and high end finishes throughout, the open concept floor plan is designed for sophisticated entertaining and comfortable everyday living, with walls of windows capturing spectacular water views. The chef's kitchen showcases custom cabinetry, premium appliances, expansive workspaces, and an oversized island that flows seamlessly into the living area, anchored by a striking stone fireplace. The luxurious primary suite is a private retreat featuring tranquil water views and a spa inspired ensuite with elegant marble flooring and premium finishes. Three additional bedrooms provide exceptional accommodations, including one with a private ensuite bath, while a potential fifth bedroom or finished walkout lower level offers flexibility for guests, a home office, fitness room, or in-law suite. Outdoor living is designed for every season with a spacious Trex deck overlooking Long Island Sound, an expansive paver patio, fully equipped outdoor kitchen, custom fire pit, and inviting spaces for entertaining. Ideally situated along New London's scenic shoreline this move in ready home offers the perfect combination of modern luxury.

Listed by Tammy J. Tinnerello of William Pitt Sotheby's Int'l

MLS Number 24186838

• Commercial
• MLS Status Active
• Year Built 1968
• Bathroom 1
• Square Feet 3,601

CROOKES ORCHARD - A LEGACY FARM OF EXTRAORDINARY BEAUTY AND OPPORTUNITY! One of Northeast Connecticut's most beloved agricultural destinations, presents an exceptionally rare opportunity to acquire 153 contiguous acres of working orchard, farmland, and scenic countryside. The property encompasses approximately 32 acres of improved cropland w/sprawling hay fields, picturesque ponds, & Bebbington Brook winding through the landscape, all abutting State Forest & Joshua's Trust protected land. More than 6,000 fruit trees, including 1,200 newly planted, yield 28 heirloom varieties of apples, peaches, & Asian pears. Carefully maintained orchard rows are supported by irrigation systems, while approximately 7 acres are enclosed by new 8-foot deer fencing w/3 double gates. A vibrant dahlia field further enhances the property's beauty & seasonal appeal. At the heart of the farm is the beautifully remodeled 3,601 SF retail farm store, long celebrated for its "Pick Your Own" traditions & broad assortment of locally grown & produced goods. Recent improvements include a turnkey commercial bakery, 2 walk-in coolers, updated office & restroom facilities, new HVAC, new roofs, partially replaced siding, new exterior doors, stone patios, and freshly painted exteriors. An attached glass greenhouse & additional hoop houses significantly extend the growing season. ***CONTINUE READING***

Listed by Kiara C. Rusconi of William Raveis Real Estate

MLS Number 24186879

• Land
• Acreage 153.1
• MLS Status Active
• Other Amenities Waterfront
• Waterfront

CROOKES ORCHARD - A LEGACY FARM OF EXTRAORDINARY BEAUTY AND OPPORTUNITY! One of Northeast Connecticut's most beloved agricultural destinations, presents an exceptionally rare opportunity to acquire 153 contiguous acres of working orchard, farmland, & scenic countryside. The property encompasses approximately 32 acres of improved cropland w/sprawling hay fields, picturesque ponds, & Bebbington Brook winding through the landscape, all abutting State Forest & Joshua's Trust protected land. More than 6,000 fruit trees, including 1,200 newly planted, yield 28 heirloom varieties of apples, peaches, & Asian pears. Carefully maintained orchard rows are supported by irrigation systems, while approximately 7 acres are enclosed by new 8-foot deer fencing w/3 double gates. A vibrant dahlia field further enhances the property's beauty & seasonal appeal. At the heart of the farm is the beautifully remodeled 3,601 SF retail farm store, long celebrated for its "Pick Your Own" traditions & broad assortment of locally grown & produced goods. Recent improvements include a turnkey commercial bakery, 2 walk-in coolers, updated office & restroom facilities, new HVAC, new roofs, partially replaced siding, new exterior doors, stone patios, and freshly painted exteriors. An attached glass greenhouse & additional hoop houses significantly extend the growing season. ***CONTINUE READING***

Listed by Kiara C. Rusconi of William Raveis Real Estate

MLS Number 24198591

• Single Family
• Square Feet 12,196
• Bedrooms 5
• Bathroom 7
• Year Built 2003

Welcome to Viewpoint -an architectural masterpiece blending classic Nantucket shingle-style elegance with unparalleled privacy on a bucolic 24 gated acres. Approached via a gated sweeping drive and a grand porte-cochere, this spectacular 12,000+ sq. ft. estate spans four extraordinary levels, offering breathtaking lake views and private trail access directly to the water. Outside, lush & manicured lawns frame the home - while a Brand New Roof offers peace of mind for the next stewards. Inside, impeccable craftsmanship defines every room, showcased by exquisite millwork, bespoke trim, and a seamless flow between the formal living and dining rooms. The main level is designed for both grand entertaining and daily life, featuring a handsome billiards room, and a chef's kitchen equipped with top-tier appliances and a comprehensive butler's pantry. An elevator seamlessly services the first, second, and lower levels. There is a family room that can function as a living/dining room for more casual living. There is a large mudroom, complete with a half bath and sub-zero fridge. The attached 4 car garage is also heated, features central vac, lighting and can hold up to 5 cars. There is a large coat closet for entertaining large groups, as well as a larger formal half bath. Upstairs, retire to the expansive primary suite-a true sanctuary featuring a lavish en-suite bath, a dedicated dressing room, and a massive walk-in closet.

Listed by Jonathan Archer of William Raveis Real Estate

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. 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