Greater Mansfield CT Real Estate $500k +

MLS Number 24186987

• Commercial
• MLS Status Active
• Year Built 1957
• Square Feet 4,565
• Acreage 15.5

Rare mixed-use farm/commercial opportunity in Andover! This offering combines 11 Bunker Hill Rd with a second Route 6 parcel for a total of 17.1 acres with direct Route 6 access, two large parking areas, and land that mostly abuts the Hop River. The existing 4,565 gross SF building offers a flexible setup with offices, garage/warehouse space, approximately 15' ceiling height, truck dock, cleared work areas, pavilion/patio space, and established tree farm acreage. Ideal for an owner-user, agricultural operator, nursery/landscape business, farm-to-retail concept, contractor, storage/distribution user, agritourism venture, event-forward farm operation, or investor seeking a rare combination of visibility, acreage, existing improvements, and rural New England character. Current land use is 037: Mixed Use-Primary Commercial & Agriculture, supporting the property's blend of business and farm utility. Potential uses may include farming, nursery/tree farm operations, wayside farm stand, retail, office, agricultural sales, contractor/business operations, agritourism, or other mixed-use concepts-subject to buyer due diligence, zoning, wetlands, inland watercourse, and Town approvals. Land, buildings, parking, cleared areas, pavilion, patio, and tree farm are being offered together as one unique Andover opportunity.

Listed by Robert F. Rosa of Berkshire Hathaway NE Prop.

MLS Number 24207605

• Single Family
• Square Feet 3,753
• Bedrooms 4
• Bathroom 4
• Year Built 2003

Welcome to 10 Arden Dr., a 2003 custom-built home with 3,753 sqft of well-designed spaces, stunning details, thoughtful storage, a flexible floor plan, an inground pool and outdoor living spaces, all set on 2.93 private acres set back from the street. From the circular driveway, to the grand foyer with curved staircase & curved walls, with chandelier and decorative mouldings, to the refinished oak floors, central air, central vac, 4 bedrooms, 3 full and 1 half bath, to the new roof & skylights in 2024, soaring ceilings, and the oversized windows flooding the house with natural light, there is so much to love. 1st floor rooms include an office, sun room, living room, family room, media room, dining room, spacious kitchen with island, pantry, breakfast area, kitchen office nook, laundry room, and half bath. 2nd floor has the primary suite, another bedroom with ensuite bath, 2 more bedrooms, and shared bath with double sinks. 3 of the bedrooms have new carpeting installed in 2025, the primary has hardwood floors. There's even a laundry chute & a pulldown attic for storage. Quality details like 2x6 construction, a turret feature, 10ft ceilings in the basement for future living space, a walkout instead of bulkhead, 3-car garage with hot & cold water, dual 330 gallon fuel tanks, driveway lights, security system, irrigation system, covered brick porch and patio installed in 2024 add incredible value that you don't get with new construction. This custom build has it all!

Listed by Lynn P. Minnick of Carl Guild & Associates

MLS Number 24214232

• Single Family
• Square Feet 5,102
• Bedrooms 4
• Bathroom 5
• Year Built 2000

Prepare to be captivated by this stunning, stately brick Colonial, perfectly situated on a beautifully landscaped lot surrounded by mature trees and natural beauty. This exceptional residence offers 5 bedrooms and 4.5 bathrooms, blending timeless elegance with everyday comfort and privacy. Each spacious bedroom features its own ensuite bathroom, providing the ultimate convenience for family and guests alike. The versatile fifth room can easily serve as a private home office, guest suite, or an additional oversized bedroom to fit your lifestyle. From its classic curb appeal to its thoughtfully designed interior, this home is truly one of a kind. Step outside to your own private backyard, where a beautifully finished stone patio and spacious deck create the perfect setting for relaxing or entertaining. Surrounded by mature trees, the expansive yard offers exceptional privacy and plenty of room to add the pool of your dreams, making this outdoor space full of endless possibilities.

Listed by Amy P. Rio of Better Homes and Gardens Real Estate Executive Real Estate

MLS Number 24196261

• Single Family
• Square Feet 3,745
• Bedrooms 3
• Bathroom 3
• Year Built 1977

This extraordinary custom residence seamlessly blends timeless elegance with relaxed sophistication. Originally a log cabin and thoughtfully reimagined into a luxurious estate, the home showcases exceptional craftsmanship, distinctive architectural details, and premium finishes throughout. A stunning wraparound porch with rich mahogany flooring and beadboard ceilings creates an inviting first impression, while the oversized carriage-style two-car garage provides generous space for vehicles and additional storage. Step inside to a dramatic two-story foyer featuring soaring ceilings, travertine flooring, and an elegant marble medallion inlay. Every room reflects meticulous attention to detail, from shadowbox accents, bullnose archways, and custom niches to hand-painted walls and a beautifully frescoed foyer ceiling. The great room is anchored by a floor-to-ceiling stone fireplace, custom handcrafted built-in entertainment center, and striking cherry inlay hardwood flooring that adds warmth and character. French doors on either side of the fireplace fill the space with natural light and provide seamless access to the outdoor entertaining areas. Andersen windows and designer lighting enhance the home's bright, welcoming atmosphere. Designed for both everyday living and entertaining, the chef's kitchen features terra-cotta tile flooring , an oversized center island, handcrafted cabinetry, extra-thick granite countertops, tumbled marble backsplash.

Listed by Thomas Simjian of Keller Williams Coastal

MLS Number 24154585

• Commercial
• MLS Status Active
• Year Built 1908
• Bathroom 1
• Square Feet 4,109

Rare opportunity to acquire the iconic Arch Street Tavern, a well-known restaurant, bar, and live entertainment venue located in the heart of downtown Hartford. Situated directly across from the Front Street Entertainment District and within walking distance of the XL Center, this landmark property benefits from exceptional visibility and event-driven foot traffic. The venue features a commercial kitchen, bar facilities, dining areas, entertainment stage, and flexible event space. Ideal opportunity for restaurateurs, hospitality groups, investors, or entertainment operators seeking a premier downtown location. Long-established destination with strong regional recognition and multiple revenue opportunities. Confidential offering. Additional information available upon request.

Listed by Richard D. Ziff of Agnelli Real Estate

MLS Number 24198521

• Single Family
• Square Feet 4,114
• Bedrooms 5
• Bathroom 4
• Year Built 1855

Exceptional 1855 Greek Revival set in a prestigious Middlebury neighborhood, surrounded by the natural beauty of Flanders Preserve and Middlebury Land Trust land. This 5-bedroom, 31/2-bath architectural stunner is sited on 3.21 beautifully landscaped acres with mature trees, stone walls, perennial gardens and rolling open lawn, offering privacy and a feeling of escape and tranquility. The home includes wide-board floors, three fireplaces and a remarkable series of covered porches and "piazzas" capturing the romance of 19th-century country living. There is effortless flow from the gorgeous sunroom, with walls of windows, into the formal living room, dining room and large entertaining kitchen. A main-floor laundry room, enormous utility room, pantry and powder room add convenience. The primary suite offers a private retreat, with an en-suite bath and adjoining sitting room or study, flanked by two covered porches. Outside, a charming secluded wading pool with fountain provides a wonderfully relaxed setting for summer gatherings, cocktails and afternoons spent enjoying the gardens. A detached 2-car garage with bonus unfinished loft space invites a future artist studio. An exceptional opportunity to bring this distinctive home to the next level. 2 hrs to NYC. Subject to Probate.

Listed by Rebecca L. Doh and Jackson McCard of W. Raveis Lifestyles Realty

MLS Number 24210054

• Single Family
• Square Feet 1,104
• Bedrooms 1
• Bathroom 2
• Year Built 1961

Come see the inspiration of two nature lovers who have created a private wildlife sanctuary unlike any other. This 70.75 acre parcel is comprised of two lots with considerable frontage on two quiet roads. By the spring-fed deep-water pond you will find a Thoreau-like cabin for tranquil moments pondering. Just off one road is a 24x18 carriage barn with electric for your new hobby: woodworking? And off the other roadway is a sugarhouse look-alike with natural cedar plank siding a cupola, field stone fireplace and a raised seam roof...inside you will find a post & beam addition (2020), the possibilities here are endless: think garage or maybe a cathedral ceiling living room?! Inside could be used as a nature center with hardwood and slate tile floors throughout, or maybe a hunting cabin. Why not, the owners have seen the likes of moose here! There is a "bachelors" kitchen with stainless sink/countertop an electric stove and fridge. A possible bedroom/office has a bath with shower, and the more public space has a handicap accessible half bath. Downstairs is a full basement for all those toys you will soon accumulate!

Listed by Stephanie J. Gosselin and Cyrille L. Bosio of Berkshire Hathaway NE Prop.

MLS Number 24141554

• Commercial
• MLS Status Active
• Year Built 1968
• Acreage 0.43

LOCATION LOCATION LOCATION. This high traffice count location can be yours. Successful retail location for many years. Formerly a leather goods retail outlet before current use. The building underwent a complete make over approximately 5 years ago before current tenat moved in. All newer HVAC mechanicals. Building will be conveyed without a tenant and vacant. With the LARGE parking lot and design of the buidling there is a potential for the new owner to divide into Two or more units. Ideal for a Retail or office space. Act now.

Listed by Dale R. Masslon of KW Legacy Partners

MLS Number 24208389

• Single Family
• Square Feet 3,488
• Bedrooms 4
• Bathroom 5
• Year Built 2003

Exquisite custom home on dead-end street set on 4 acres. Breathtaking view of Fawn Brook Greenway. Location, privacy and large lot size make this one of a kind. Open and spacious floor plan. Kitchen has gorgeous granite counters, stainless appliances, and island with high-counter seating and prep sink. Openness from kitchen through dining nook into high ceiling family room with beautiful windows and natural light create a warm inviting atmosphere. Elegant dining room for formal dining and entertaining. Flush hearth fireplace, charming powder room and study/home office. Central A/C and central vacuum. Luxurious master bedroom, guest room with en-suite bathroom and two additional bedrooms connected by Jack and Jill bath. Master has tray ceilings and lounge area and bath elegantly styled with dual marble-top vanities, glass walk-in shower and Jacuzzi tub. Finished walkout basement with half bath has custom fabricated mahogany bar and bar back, granite counters and matching entertainment system cabinetry. All floors built-in audio speakers. Family room and basement separate built-in surround sound system and integrated "invisible" subwoofer. Deep three bay garage, cabinets, workbench, extra storage above doors and utility sink. Large multi-level Trex deck, expansive lawn with irrigation. This distinctive property offers exceptional comfort and sophistication in a tranquil, private setting with easy Route 2 access and 15 minute drive to multiple town centers. Will go fast.

Listed by Derek Greene of Derek Greene