Greater Mansfield CT Real Estate $500k +

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

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 24183501

• Single Family
• Square Feet 2,000
• Bedrooms 4
• Bathroom 3
• Year Built 2026

Discover an exceptional To Be Built opportunity at 0 Shennecossett Road, where coastal convenience, modern design, and everyday luxury come together on a prime corner lot moments from the beach and Shennecossett Golf Course. This 2,000 sq. ft. modern farmhouse is thoughtfully designed with 4 bedrooms, 3 bathrooms, a 2-car garage, a covered front porch, and a rear deck - perfect for relaxed mornings, effortless entertaining, and enjoying the best of the shoreline lifestyle. White oak hardwood flooring runs throughout the entire home, giving a modern yet warm and inviting feel that ties every space together, while tile flooring in all three full bathrooms adds a polished, spa-like touch. The flexible first-floor layout features two bedrooms, both with ensuite bathrooms, offering an ideal setup for guest accommodations or multigenerational living. Upstairs, two additional bedrooms and a full bathroom create a separate space for family, guests, work-from-home needs, or quiet relaxation. The unfinished basement offers even more room to grow, with potential for a home office, gym, media space, or future recreation area. Close to Pfizer, Electric Boat, beaches, shopping, dining, and just minutes from Mystic, this is what Groton shoreline living is all about. To Be Built by Caulkins Homes, an experienced local design and build company with nearly 40 years of experience. First rendering - custom options available.

Listed by Heather M. Caulkins of William Pitt Sotheby's Int'l

MLS Number 24197545

• Multi Family Multi-Family For Sale
• Square Feet 3,673
• Acreage 3.8
• Bedrooms 4
• Year Built 1880

Distinctive mixed-use property believed to date to the 1800s and extensively renovated around 2021. Blends historic post-and-beam character with modern updates, offering residential living plus studio, workshop, office, brewing, and creative spaces. Residential areas feature exposed posts and beams, wide-plank pine floors, shiplap, barn doors, butcher-block shelving, and cathedral ceilings. Kitchens include custom hickory and white shaker cabinetry, large center island, leathered granite counters, farmhouse sinks, stainless appliances, and matte-black fixtures. One area was a former display kitchen; renovations added a bedroom, large closet, and living space. Commercial, first floor temperature-controlled space. Walkout basement has concrete floors, substantial storage, multiple exterior doors, and ~8-ft ceilings. Systems include mini-splits, natural-gas heat, second-floor air handler, three-phase power, newer electrical panel, hybrid heat-pump water heater, UV filtration, new well pump, spray-foam insulation, and updated PVC plumbing. Exterior offers greenhouse/sunroom, pergola, large paver area, extensive newer decking, storage shed, private well, and multiple walkouts. Owner estimates parking for ~50 vehicles. Original cupola available for reinstallation.

Listed by Anthony Chabot of Chabot & Associates Real Estate