Greater Mansfield CT Real Estate $500k +

MLS Number 24206353

• Single Family
• Square Feet 3,661
• Bedrooms 5
• Bathroom 4
• Year Built 1747

Welcome To 538 Main St, An Extraordinary Waterfront Residence At The Very End Of Historic Old Wethersfield's Most Prestigious Neighborhood. This Iconic Home Offers Sweeping Views Of Wethersfield Cove With Access To The Connecticut River, Set On 1.27 Acres Of Beautifully Manicured Grounds. With Water Views From Nearly Every Room, This One-Of-A-Kind Property Blends Timeless Charm With Modern Sophistication. The Rear Of The Home Has Been Fully Gutted To The Studs And Thoughtfully Redesigned With Exquisite Finishes. Both The Main Level Bath And Luxurious Primary Ensuite Have Been Fully Remodeled, Offering Spa-Inspired Comfort And Design. The Island Kitchen, Gas Cooktop, Double Ovens, And Pantry Is A Chef's Dream. The Versatile Open Layout Includes A First Floor Bedroom And Full Bath, Along With A Private Master Suite Boasting A Massive Custom Closet Dressing Room And Elegant Bath Retreat. Entertain On The Stone Terrace, Stroll Through Gardens, Or Unwind On The Expansive Balcony Overlooking The Sunset Water. Features Include A Heated 2-Car Garage, Carport, Updated Mechanicals. Situated In The Heart Of Old Wethersfield's Historic District, You're Just A Short Stroll From Shops, Restaurants, And Seasonal Events. Launch Your Kayak, Motor Boat, Or Bike Right From Your Doorstep And Embrace The Best Of Connecticut. This Is More Than A Home - It's A Legacy. Whether You're Seeking For Waterfront Living Or Potential Income-Producing Luxury Airbnb, This Once-In-A-Lifetime Property Delivers.

Listed by Michael H. Truong of eXp Realty

MLS Number 24173954

• Land
• Acreage 1.36
• MLS Status Active
• Other Amenities Waterfront
• Zoning R40

1.36 Acres of land on 972 Long Cove Road, Ledyard must be sold with 1528 Route 12 Ledyard. MLS# 24173284, zoned Residential. 2,400 SF commercial building with overhead doors, 14' ceiling, 4 handicap bathrooms. Situated on 3 acres. Zoned GFDD (Gales Ferry Development District). Formerly Barkin Barley. Building was built in 2024. 972 Long Cove Road is 1.36 acres of land in R40 zone. Properties are being sold together for a total of 5.24 acres. Great redevelopment opportunity. Located 2 1/2 miles from I-95.

Listed by Constance Howard of U.S. Properties Real Estate Services,LLC

MLS Number 24173284

• Commercial
• MLS Status Active
• Year Built 2024
• Square Feet 2,400
• Acreage 5.24

2,400 SF commercial building with overhead doors, 14' ceiling, 4 handicap bathrooms. Situated on 3 acres. Zoned GFDD (Gales Ferry Development District). Formerly Barkin Barley. Building was built in 2024. 972 Long Cove Road is 1.36 acres of land, zoned Residential. Properties are being sold together for a total of 5.24 acres. Great redevelopment opportunity. Located 2 1/2 miles from I-95. See MLS #24173954.

Listed by Constance Howard of U.S. Properties Real Estate Services,LLC

MLS Number 24200192

• Commercial
• MLS Status Active
• Year Built 2002
• Bathroom 1
• Square Feet 3,325

Own a piece of Northern Connecticut's commercial corridor - business and real estate together in one rare offering! Somers Wine & Liquor has spent years building a devoted customer base along CT Route 190, the well-traveled east-west route linking Tolland County to northern Hartford County. Beyond the thriving beer, wine, and spirits shop, the property offers a second retail space (formerly an ice cream shop, currently used for storage) and an attached greenhouse - both ripe for reactivation. With generous parking and a dedicated loading area, this neighborhood plaza is ready for an owner-operator to grow the existing business or reimagine the site entirely. Endless possibilities for expansion, redevelopment, or additional income streams!

Listed by Aimee Nieroda of Naples Realty Group,LLC

MLS Number 170578568

• Commercial
• MLS Status Active
• Year Built 1875
• Square Feet 11,656
• Acreage 0.08

Four story, 11,656 SF commercial building in the heart of downtown gutted and ready for buildout. City approvals for 9 apartments and 2 commercial spaces. 2,919 SF basement. 2021 appraisal available as well as architectural renderings. Great visibility and development opportunity in close proximity to the Amtrak station and future USCG Museum.

Listed by Constance Howard and Susan Howard Cihocki of U.S. Properties Real Estate Services,LLC

MLS Number 24205864

• Land
• Acreage 2.56
• MLS Status Active
• Other Amenities Golf, Waterfront
• Zoning SU

Rare fully entitled, shovel-ready development opportunity in Colchester, CT. 31 Parum Road is a 2.56-acre site (111,439 SF) with Planning & Zoning approval for a 30-unit multifamily building under C.G.S. 8-30g. Base suburban zoning permits only 10 units - the approved affordable housing set-aside is what unlocks the additional 20 units, creating significant embedded value. Approvals, architecture, civil, MEP, survey, and geotech all convey with the sale. Public water and sewer are already in the road. 444.7 ft of frontage on Route 354. Unit mix of 18 one-bedroom and 12 two-bedroom units across a 3-story building with walk-out lower level, 25,202 SF net rentable. Site sits near the Route 2/Route 11 interchange, minutes to shopping and under 30 minutes to Hartford. Offered at $750,000 ($25,000 per approved unit) - priced below comparable approved sites in the region. Full Offering Memorandum available upon request.

Listed by Ryan J. O'Keeffe and Joseph Salzillo of Salzillo Realty Company

MLS Number 24154466

• Commercial
• MLS Status Active
• Year Built 1938
• Bathroom 3
• Square Feet 3,288

Turnkey opportunity to own The Hartford Road Cafe, a profitable, long established fully operational restaurant offered with real estate included. Features include a full-service bar, two fireplaces, spacious indoor seating, and a large three-season patio for outdoor dining and events. Prime Manchester location with easy access to I-384, I-84 and I-91 and ample on-site parking. Building has been well maintained with updated mechanicals and central air. Sale includes the business, building, furniture, fixtures, equipment, and decor for immediate operation. Private 2nd level offers a 3/4 bathroom, Private office and additional storage.Basement provides extensive storage and essential equipment. Financials available to qualified buyers.

Listed by Dale J. Bunn of Riverview Realty,LLC

MLS Number 24163317

• Commercial
• MLS Status Active
• Year Built 1962
• Square Feet 9,765
• Acreage 0.65

Federal Tax Benefits In Opportunity Zone! Possible Car Wash, Package Store, Retail location. 9756 SF on .65 acres with 180 feet of road frontage and a 17,300-traffic count on West Main, (CT RT 82).

Listed by Maxwell Lyman and Ron Lyman of Lyman Real Estate