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 24189396

• Single Family
• Square Feet 2,343
• Bedrooms 4
• Bathroom 2
• Year Built 1984

Four heated garage bays. Over 12 private acres. A brook with its own dam. This is a rare opportunity to own an updated home with an exceptional workshop and endless room to live, work, and play. The heated and air-conditioned garage features four bays, an office loft, air compressor, and dedicated paint bay. Whether you're restoring cars, operating a trade business, storing equipment, or simply need premium workspace, this setup is hard to find. The fully remodeled home offers 4 bedrooms, 2 full baths, and approximately 2,800 square feet. The great room features cathedral ceilings, exposed beams, a fireplace, and walls of glass overlooking the property. The kitchen includes a cozy sitting area with a wood stove, while the dining area is framed by a large picture window. A first-floor bedroom with patio access and a full bath offer flexibility for guests, multigenerational living, a home office, or convenient one-level living. Upstairs, the primary suite includes a soaking tub beneath its own window. Outside, open meadow leads to wooded trails, with a private brook and dam creating a truly unique setting. There's room for horses, hobby farming, gardens, or simply enjoying the privacy. Recent updates include a new roof, Buderus oil furnace, and fresh interior paint. Minutes from the Rhode Island line, this one-of-a-kind property offers privacy, land, and a workshop that's nearly impossible to replicate.

Listed by Sheena Ruggirello of Real Broker CT,LLC

MLS Number 24192580

• Single Family
• Square Feet 5,400
• 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 and Diana Pagano of Better Homes and Gardens Real Estate Executive Real Estate

MLS Number 24197037

• Single Family
• Square Feet 2,995
• Bedrooms 4
• Bathroom 3
• Year Built 2023

Just two years young, 37 Luca Lane is an exceptional custom residence where impeccable craftsmanship, refined finishes, and architectural detail define every space. Thoughtfully designed and meticulously appointed, this home offers an extraordinary level of quality rarely found in newer construction. The custom kitchen serves as the centerpiece of the home, appointed with luxury appliances, abundant custom cabinetry, an oversized island, a spacious pantry, and a layout designed for effortless entertaining. Rich 6-inch white oak flooring extends throughout the main level, while extensive recessed lighting enhances the home's bright, sophisticated aesthetic. The living room is anchored by a custom-ordered fireplace with an upgraded mantel, creating an elegant focal point, while a private first-floor study offers the ideal setting for a home office or library. The primary suite is a true retreat, featuring a magnificent walk-in dressing room and a luxurious en suite complete with heated floors, dual vanities, and an imported tile shower. Generously proportioned secondary bedrooms provide exceptional comfort, while the second-floor laundry room is finished with marble flooring. A spacious bonus room offers remarkable versatility and can easily serve as a fourth bedroom, media room, fitness studio, or additional living space. Constructed with uncompromising attention to quality, the home features

Listed by Nikki M. Defrancesco of Coldwell Banker Realty

MLS Number 24158875

• Commercial
• MLS Status Active
• Year Built 1900
• Bathroom 3
• Square Feet 2,679

Unique mixed-use opportunity in Glastonbury's Town Center (TC) zone. This property features two buildings offering flexible commercial and residential potential. The front building is a zoned commercial and residential. It's currently set up for office use, however, plumbing and electrical are available to convert back to residential. The rear building offers additional commercial space suitable for a variety of businesses including fitness or yoga studio, spa or salon, medical, office or workshop possibilities. Excellent visibility along New London Turnpike with approximately 146 feet of frontage and strong exposure to high volume daily traffic. Ideal for investors, owner-occupants, or businesses seeking a live/work setup. Projected rental potential of approximately $3,000/month for the front building and $2,000/month for the rear building. Ample parking and convenient access to surrounding commercial areas and major routes. Glastonbury is one of Connecticut's most desirable areas, and opportunities to invest in the town's hub are rare. Bring your vision and unlock this property's full potential. Schedule a tour today.

Listed by Tony Opalenik of Eagle Eye Realty PLLC

MLS Number 24197157

• Commercial
• MLS Status Active
• Year Built 1964
• Bathroom 29
• Square Feet 23,064

Exceptional redevelopment opportunity in Hartford's desirable West End. This 23,064 SF, two-story office building presents outstanding potential for an office-to-multifamily conversion. The property was previously approved for a 29-unit apartment conversion, providing a significant head start for developers. The approved unit mix consisted of 27 one-bedroom apartments with projected rents of approximately $1,300 per month and 2 two-bedroom apartments with projected rents of approximately $1,500 per month. Situated on approximately 0.60 acres with ample off-street parking (roughly 30+ spaces), the property is ideally positioned for investors seeking to capitalize on Hartford's continued demand for quality rental housing. Redevelopment opportunities of this scale and location are increasingly difficult to find, making this an exceptional value-add development opportunity. The property offers a substantial footprint, flexible floor plan, and a prominent location along Farmington Avenue with convenient access to Downtown Hartford, West Hartford Center, major highways, public transportation, hospitals, and major employers.

Listed by Amanda R. Faroni-Sheehan of Oxford Realty

MLS Number 24197162

• Multi Family Multi-Family For Sale
• Square Feet 23,064
• Acreage 0.6
• Bedrooms 3
• Bathroom 2

Exceptional redevelopment opportunity in Hartford's desirable West End. This 23,064 SF, two-story office building presents outstanding potential for an office-to-multifamily conversion. The property was previously approved for a 29-unit apartment conversion, providing a significant head start for developers. The approved unit mix consisted of 27 one-bedroom apartments with projected rents of approximately $1,300 per month and 2 two-bedroom apartments with projected rents of approximately $1,500 per month. Situated on approximately 0.60 acres with ample off-street parking (roughly 30+ spaces), the property is ideally positioned for investors seeking to capitalize on Hartford's continued demand for quality rental housing. Redevelopment opportunities of this scale and location are increasingly difficult to find, making this an exceptional value-add development opportunity. The property offers a substantial footprint, flexible floor plan, and a prominent location along Farmington Avenue with convenient access to Downtown Hartford, West Hartford Center, major highways, public transportation, hospitals, and major employers.

Listed by Amanda R. Faroni-Sheehan of Oxford Realty