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

• Commercial
• MLS Status Active
• Year Built 1920
• Bathroom 1
• Square Feet 2,400

Introducing a prime opportunity for investors! Oversized 3 bay commercial garage perfect for a mechanic, contractor or investor! This property is located on a corner lot with frontage on Kelsey St and Rocky hill ave. Excellent location, close to everything! Great income from 8 bay garages in rear of property, ample space for parking. The versatile zoning offers multiple possibilities for business use. Spacious oversized lot! Please inquire with agent for details regarding the possible subdivide/development to build 2 multi family properties. This property can be the home of your next thriving business venture!

Listed by Niccolo Saraceno of eXp Realty

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 24149116

• Commercial
• MLS Status Active
• Year Built 1925
• Bathroom 7
• Square Feet 5,381

Exceptional mixed-use investment opportunity featuring two buildings on one lot with a total of 6 units-2 commercial and 4 residential-offering endless potential. The front building spans approximately 3,635 sq ft and includes a well-established jewelry storefront with a long-term tenant of over 20 years, along with a laundromat storefront owned and operated by the seller. Above the commercial space are two spacious residential units, featuring 4 bedrooms on the second floor and 3 bedrooms on the third floor. The rear building is a two-family residential property totaling approximately 1,746 sq ft, offering two-bedroom apartments on both the first and second floors. Both buildings feature separate entrances and fully independent utilities. The laundromat business is included in the sale and is equipped with 10 washers and 10 dryers, making this a turnkey income-producing asset in a prime Hartford location.

Listed by Carmen Valeria V Palacios-Quintana and Enrique Quintana of Premier Properties of CT

MLS Number 24074507

• Land
• Acreage 19.37
• MLS Status Active
• Other Amenities Waterfront
• Zoning MD Medium Density

41 lot approved sub-division (detached single family units). Town water & sewer reserved for project. Close to I-395 and Route 12. Total of 19.37 acres. For Sale $750,000. DIRECTIONS: I-395 S Exit 43. Turn left on Attawaugan Crossing Rd. Go straight on Ballouville Rd. Just past Church St. on left. I-395 N Exit 43. Turn right on Attawaugan Crossing Rd. Go straight on Ballouville Rd. Just past Church St. on left.

Listed by Norman B. Peck of Signature Properties of N.E.

MLS Number 24201272

• Single Family
• Square Feet 3,226
• Bedrooms 4
• Bathroom 5
• Year Built 2005

Stunning Extra Large Modern Colonial - 3,226 Sq Ft of Exceptional Living Space near Mystic. Welcome to this impressive modern colonial offering 3,226 square feet of beautifully designed living space. Step into the massive two story grand foyer, featuring an open staircase and ceramic tile flooring that sets the tone for the scale and elegance found throughout the home. The extra-large kitchen is a true centerpiece, equipped with cherry cabinetry, higher end appliances, and direct access to a 25' x 16' living room with a propane fireplace-perfect for gatherings and everyday comfort. A formal dining room measuring 14' x 12' showcases 9 foot ceilings and crown molding throughout the first floor, adding a refined touch. The main level also includes a 12' x 12' playroom or office, offering flexible use, and an exceptional 9' x 9' walk in pantry loaded with shelving for maximum storage. This home features 4 full baths and 1 half bath. The second floor of the main house offers 3 bedrooms and 2 full baths, including a spacious primary suite. The primary bathroom is truly grand, measuring 20' x 14', and includes a large jacuzzi tub. A two car garage provides convenience and storage, and above it you'll find a full size bedroom with its own full bathroom and walk in closet, ideal for guests, extended family, or private living quarters. From the breakfast nook, step out onto the 28' x 12' composite deck, overlooking a fenced grassy play area perfect for little ones or pets.

Listed by Monique Rouillard and Michael Rouillard of Signature Properties of N.E.