Condos

MLS Number 24018448

• Single Family
• Square Feet 10,662
• Bedrooms 10
• Bathroom 8
• Year Built 1902

In a world where luxury knows no bounds, there's one property that stands out above the rest. Welcome to Rogers Island - where dreams become reality. Enveloped by the tranquil waters of Long Island Sound, this 7.65-acre haven features an exquisite 8,746-square-foot renovated main residence, complemented by a four-bedroom waterfront guest house with a wraparound porch. Unwind poolside in the elegant pool house, engage in spirited matches on tennis court, immerse yourself in the lush beauty of the formal gardens, meandering trails, and serene koi pond. With three private beaches, two docks, a putting green, an artist's studio, staff quarters, and a greenhouse, every aspect of refined living is meticulously curated. From sunlit afternoons by the pool, to enchanting evenings under the stars, Rogers Island offers a lifestyle beyond compare. This is more than just a property, it is a legacy, waiting to be yours.

Listed by Jennifer Leahy of Douglas Elliman of Connecticut

MLS Number 170616953

• Land
• Acreage 426.5
• MLS Status Active
• Other Amenities Golf, Waterfront
• Zoning R

Seller states they will consider all offers to purchase on this property! Only 15 minutes from the home of over 100 insurance companies in Hartford CT ! Now available is a 426 acre parcel of land very close to the town center in Marlborough, Connecticut. Just down the street from the town resident only water front recreation area, as pictured. This quiet country land parcel has town approvals for a golf course/housing project. Complete plans are available. The owners will also consider selling subdivided smaller parcels. The project plans show that the residential component of the project consists of 84 single-family lots (about half of these lots will border the golf course and 12 will be on a ridge with distant scenic views); and 112 town homes targeted, but not restricted to the active adult market with unit sizes starting at 2,500 square feet (most of the town homes will have unobstructed views of the golf course). The residential component of the subject will use about 135 acres with an additional 120 acres allocated to undisturbed open space. The proposed 7,010-yard, par 71, 18-hole, championship golf course designed by the Roger Rulewich Group will encompass about 157 acres. The subject was approved under the Town of Marlborough's Open Space Conservation Area Regulation (OSCAR). Note- signs (4) mark approximate north and southern road locations on South road and Ogden Lord roads.----- Live on site Drone tours available

Listed by Tracy S. Gallagher of Coldwell Banker Realty

MLS Number 24018210

• Commercial
• MLS Status Active
• Year Built 1999
• Bathroom 2
• Square Feet 10,125

Unbelievable redevelopment opportunity at major signalized corner on the busy, growing retail corridor of the berlin turnpike. 6.48 acres +/- (3 parcel) site sits on the nw quadrant of the berlin turnpike & deming road. Flat, clean and ready to develop. Sellers will entertain your solid offers. Great location for restaurant, medical walk in clinic, hotel, retail and also mixed use developments welcome.

Listed by Andrea Laviero Krawiecki of East Coast Real Est Assoc. LLC

MLS Number 170364551

• Commercial
• MLS Status Active
• Year Built 1885
• Square Feet 81,312
• Acreage 0.42

OPPORTUNITY ZONE! 5 Story brick office building consisting of 81,312 SF. Originally department store in downtown New London. It now consists of retail space on the first floor and numerous offices on the upper floors. It would be an ideal apartment building and the owner has already completed some apartments. The first floor has a magnificent atrium with entrances from State Street and Masonic Street.

Listed by Constance Howard and Susan Howard of US Properties

MLS Number L10060067

• Land
• Acreage 644.16
• MLS Status Active
• Subdivision Tri-Lakes,LLC
• Waterfront

50 ACRE SECLUDED LAKE ON 644 ACRE WILDERNESS TRACT including 3 smaller ponds, 2 streams in Connecticut's quiet Northeast corner. Absolute peace, quiet and security with no public access. With 9,000' of direct water frontage, the lake affords numerous building sites some with sunrise/sunset views along with private boating, swimming and fishing. For the nature lover, this is heaven on earth with abundant wildlife, no traffic noise, unparalleled star gazing. Miles of gravel roads provide vehicular access to the interior hidden lake and ponds. For the developer, the entire tract is approved for 135 cluster lots (30 lots in Phase 1 completely engineered). Zoning regulations allow and recorded engineering data indicate the feasibility for various other uses including family compound, large estate lots, recreational, corporate headquarters, etc. A monolith tower in a remote corner not visible from a vast majority of the property provides strong cell service. Seller options: 244+/- acres with 15 acre pond $2,500,000 (Listing # 170604362) or 400+/- acres with big lake and 2 smaller ponds $4,500,000 (Listing # 170604053). Distance to Providence 20 miles, Foxwoods Casino 30 mi, Hartford 45 miles, Boston 55 miles, New York City 145 miles. Several major airports are within one hour's drive. Local airstrips are also available for smaller aircraft.

Listed by J. Thomas Mettling of J. Thomas Mettling

MLS Number 24050599

• Commercial
• MLS Status Active
• Year Built 1968
• Bathroom 5
• Square Feet 72,932

Prime Investment Opportunity in Asylum Hill! Welcome to a lucrative venture in the heart of Hartford's vibrant Asylum Hill! Presenting an exceptional chance to own not just one, but 68 units nestled in an unbeatable location, just moments away from key amenities such as bus lines, hospitals, and the bustling Downtown Hartford. This extraordinary property boasts five stunning brick buildings with a diverse unit mix ranging from cozy studios to spacious 4-bedroom townhouses, offering something for everyone. With card-operated laundry facilities in each building, secure gated parking, and a tenant-friendly electric billing setup, managing this investment is a breeze. Several units currently immediately available allow new owners to unleash their vision, whether it's continuing the remodeling journey or handpicking the perfect tenants. Originally gutted to the studs in the 1980s, this property has seen continuous improvement and modernization, making it a solid investment opportunity with endless potential. Don't miss out on this golden opportunity to make your mark in the thriving Hartford real estate market? Seize it now and unlock the potential of this remarkable investment gem!

Listed by Lisa Cozzi and Molly Bradbury of Berkshire Hathaway NE Prop.

MLS Number 170608049

• Commercial
• MLS Status Active
• Year Built 1950
• Square Feet 13,861
• Acreage 6.46

An exciting opportunity awaits all potential investors! We are thrilled to present a prime commercial property that offers unparalleled visibility and convenient access to major highways. With seven rentals that generate a monthly income of $32,600.00 and long-term leases, four car dealer licenses, this property is truly a goldmine. Moreover, the current owner has held onto this gem for over 35 years, and there's an extensive tenant waitlist eagerly awaiting their chance. The property is inclusive of 200 S Main Street, 202 S. Mian Street and a 3 third parcel with extra land to tie it all together. Tons of parking. On the commercial side the building has been restored with metal roofs, siding, windows and doors and garage doors. There is tons of parking and 2 more building are approved as of 2020 which would increase the gross monthly to 40,000K. We have a detailed appraisal available upon request.

Listed by Gregory E. Heineman of Trend 2000 Real Estate

MLS Number 24032744

• Single Family
• Square Feet 3,871
• Bedrooms 4
• Bathroom 4
• Year Built 1912

Welcome to a world of pure imagination. Here you will find exceptional beauty, 360 panoramic views of the sea all around you. Immerse yourself in tranquil moments as well as outdoor adventure that is boundless. Whether you're seeking relaxation or your next thrilling adventure, this property offers a truly magical experience. Multiple French doors, balconies, and well-placed custom windows take advantage of the day's sunlight & the moon-lit stars at night. With 3,871 square feet of interior elegance this Idyllic Thimble Island home is a haven for a spectrum of design elements. The main level features a well-equipped kitchen and an expansive dining area, ideal for sizeable gatherings. The living room 's square footage expands beyond its French doors to the impressive wrap around porch that provides countless hours of picturesque views. The upper level is the home of 4 reimagined bedrooms, all with beautiful views and ample space for family & guests. The primary ensuite is simply a retreat of its own, vaulted ceilings, two balconies, and 180 of water views make it almost indescribable. The pristine magazine worthy grounds provide resort-like living in every direction. From the gunite pool nicely nestled in the eastern quarter, to the spa that takes in the western sunsets. Just a moments, boat ride from the Stony Creek mainland this island home promises an extraordinary living experience.

Listed by Vicky Welch of William Raveis Real Estate

MLS Number 170604053

• Land
• Acreage 400
• MLS Status Active
• Waterfront
• Zoning RD

Secluded 50 acre pristine SPECTACLE LAKE and two 8 acre ponds on 400 acre wilderness tract in quiet Northeast corner of Connecticut on Rhode Island border. One of the few privately owned large lakes without public access in the State of CT, Spectacle Lake boasts 9,000' of wooded shoreline affording numerous homesites some with sunrise-sunset views. Boating, fishing and swimming are all yours in a unique, private, quiet and serene environment. Teeming with abundant wildlife, this property is a nature lover's paradise. Extensive engineering, wetlands identification, soils testing and environmental studies indicate the feasibility of large scale cluster development, large estate sites and multiple other uses under rural zoning. Several miles of gravel roads throughout the property allow vehicular access to the interior lake, ponds and forest. This parcel is the Southerly portion of 644 acres listed at $5.9M (see MLS L10060067). The Northerly 244 acres are listed separately at $2.5M (See MLS 170604362). Distance to: Providence 20 mi, Foxwoods Casino 30 mi, Hartford 45mi, Boston 55 mi, NYC 150 mi. Several major airports are within 1 hour's driving time. A few smaller airstrips are within 1/2 hr. (Owner is a CT licensed real estate broker).

Listed by J. Thomas Mettling of J. Thomas Mettling

MLS Number N10196732

• Land
• Acreage 26
• MLS Status Active
• Zoning Commercial

Proposed Hotel, Restaurant, Multi Family, and Retail Site. On 26+ acres zone TVA-GD Public water & sewer available. Merrow Rd Frontage: 530Ft., I-84 Frontage 1,960. Traffic count: 77,700 (on 84) 14,500 (on Merrow Rd /195)

Listed by Ron Lyman of Lyman Real Estate

MLS Number 24036902

• Multi Family Multi-Family For Sale
• Square Feet 64,609
• Acreage 1.09
• Bedrooms 7
• Bathroom 6

We are pleased to present the exclusive listing for the residential property located at 464 Pratt Street Extension, Meriden, Connecticut 06450. This property spans 64,609 square feet and comprises 22 residential units with town approval for up to 38. Nestled on approximately 1.09 acres, this property offers a unique blend of historic charm and modern living spaces. This listing includes 457 Pratt St Ext, a 0.26-acre lot which provides ample additional parking, enhancing the convenience and appeal of this exceptional residential offering. This property represents a significant investment opportunity with its blend of extensive space, and modern conveniences. The added parking space enhances its attractiveness for both residents and investors.

Listed by David E. Candelora and Michael J. Robinson of RE/MAX Showcase