Greater Mansfield CT Real Estate $500k +

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 24180508

• Single Family
• Square Feet 3,723
• Bedrooms 4
• Bathroom 4
• Year Built 1989

Extraordinary Waterfront Estate. Set on an exceptional 5.5-acre private lot with 265 feet of shoreline frontage, this completely rebuilt luxury residence offers a rare opportunity to own one of Woodstock's premier lakefront properties. Arrive via a long, newly paved private driveway that winds through a tranquil setting before revealing this stunning waterfront retreat. Offering 3,971 square feet, 4 bedrooms, and 4 bathrooms, the home was rebuilt from the ground up with next level quality and craftsmanship. Designed for both elegant entertaining and everyday enjoyment, the layout includes a formal dining room, spacious family room, custom mudroom, and a beautiful living room with propane fireplace overlooking Quasset Lake. The showpiece kitchen is truly one-of-a-kind, featuring handcrafted cabinetry by a New York artisan cabinet maker, thick quartzite countertops, premium built-in appliances, and a dramatic tray ceiling with custom white oak detailing. Luxury finishes continue throughout with veneer plaster walls, custom white oak vanities, a professionally designed primary closet, handmade laundry room cabinetry, and architectural flangeless LED lighting seamlessly integrated into the wood ceilings. Built with 2x6 construction, engineered floor systems, 2x12 roof rafters, red cedar siding and trim, central air, all-new heating and cooling systems, underground 400-amp service, and an automatic whole-house generator. Step outside and embrace the ultimate lake lifestyle.

Listed by Skyla Gagnon of RE/MAX Bell Park Realty

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

MLS Number 24189420

• Single Family
• Square Feet 6,344
• Bedrooms 6
• Bathroom 8
• Year Built 1973

Perfectly positioned alongside the Hartford Golf Club, 82 Ledyard Road is a remarkable custom-built residence that seamlessly blends luxury, comfort, and versatility. Thoughtfully designed with exceptional craftsmanship and timeless appeal, this expansive home offers a flexible floor plan tailored to today's modern lifestyle. Elegant living spaces unfold throughout the home, anchored by a dramatic family room that serves as the heart of the residence. Bathed in natural light and designed for effortless entertaining. The kitchen, dining room and living room have direct access to one of the decks that overlooks the golf course, creating exceptional spaces for al fresco dining, morning coffee, or evening gatherings. The chef's kitchen is equally impressive, featuring abundant workspace and storage, a generous dining area, and seamless connectivity to the family room through a gracious wet bar and coffee bar. A rare offering, the home provides the convenience of one-level living while accommodating a variety of lifestyle needs. The main level has a luxurious primary suite featuring a spacious walk-in closet, steam shower, jacuzzi tub, and a private sitting room with views of the golf course. The main level also has a handsome home office, an expansive sunroom, and two powder rooms. The second floor offers four generously sized bedrooms, including two with en-suite baths and two connected by a Jack-and-Jill bath.

Listed by Paula Fahy Ostop of William Raveis Real Estate

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 24140199

• Single Family
• Square Feet 6,517
• Bedrooms 5
• Bathroom 5
• Year Built 2026

Experience luxury and privacy in this new construction estate set on 3.24 secluded acres in East Haddam, surrounded by protected open space. Offering over 6,000 sq ft, this custom home combines refined craftsmanship with modern comfort. The layout includes 5 bedrooms, 4.5 baths, and 3 fireplaces, creating warm, inviting spaces perfect for both everyday living and elegant entertaining. A chef's kitchen with premium cabinetry and stone counters opens to expansive living and dining areas flooded with natural light and serene wooded views. The first-class primary suite features a spa-inspired bath and generous walk-in closets. Additional flexible rooms allow for a home office, media space, or library, and high-end finishes elevate every detail throughout the home. The property provides ample room for future outdoor enhancements such as a pool, patio, or gardens, offering endless possibilities for creating your ideal retreat. This rare setting delivers unmatched tranquility while remaining close to local amenities and attractions. Multiple house plans, layouts, and architectural styles are available, allowing buyers to tailor the design to their needs. Builder can customize finishes, square footage, and features to create a truly personalized luxury estate. A premier opportunity to build your dream home in one of Connecticut's most scenic and private locations

Listed by Wesley B. Jenks of Jenks Realty

MLS Number 170365405

• Commercial
• MLS Status Active
• Year Built 1975
• Square Feet 15,408
• Acreage 0.5

NNN Key Bank investment opportunity. Value Added Opportunity with a vacant unit and tenants paying below market rent. Great location on Route 195, near East Brook Mall, Natchaug Hospital, and Windham Hosptial. Nearby Eastern Connecticut State University and the University of Connecticut.

Listed by David Mieczynski of National Realty Advisors LLC

MLS Number 24199269

• Commercial
• MLS Status Active
• Year Built 1973
• Square Feet 18,622
• Acreage 0.37

Rare opportunity to acquire a highly visible 18,622 SF mixed-use investment/owner-user property on the Silas Deane Hwy in Wethersfield. Offered at $1,895,000, this two-building property combines established retail and professional/medical office tenants with renovated vacant space available for an owner-user or additional rental income. Current tenant mix includes restaurant, retail/pawn and pediatric/medical office uses. Significant recent capital improvements include a NEW ELEVATOR, roof improvements/repairs, approximately $100,000 in newly installed HVAC systems and completely renovated vacant space. Approx. 6,000 SF retail and 12,000 SF office/professional space with subdividable options. Features include central air, natural gas heat, public water/sewer, paved parking, multiple entrances/exits and excellent Silas Deane Hwy visibility. Strong value-add opportunity to lease remaining vacancy and increase income, or occupy available space while benefiting from existing tenants. Ideal for investment, owner-user, retail, medical or professional office use.

Listed by Tyler DeVecchis of Century 21 AllPoints Realty