Condos

MLS Number 170568768

• Commercial
• MLS Status Active
• Year Built 1958
• Square Feet 34,382
• Acreage 1.8

BUSINESS NOT INCLUDED IN SALE. Existing business to be relocated to new facility to be built. Owners looking to do a sale/leaseback until the new facility is completed. Buyer can use or develop the property at that time. Ideal for non-profit rehab center or adult care facility. Would cost 3-4 timea the asking price to replace this facility. Many options for this HC accessible medical facility.

Listed by Kenneth S. Ginsberg of Houlihan Lawrence WD

MLS Number 170331080

• Land
• Acreage 7
• MLS Status Active
• Other Amenities Waterfront
• Zoning PS-B

Located on Busy Berlin Turnpike between CVS and Acura Dealer across from Home Depot. The lots front Berlin Turnpike, Deming Road and Episcopal Rd. It consist of 1.35 acres with 361 frontage along Berlin Turnpike and 3.71 acres with 715' frontage along Deming Rd and Episcopal Rd. There is shared access with CVS. Great Retail Spot Each lot is available for 2,000,000 apiece.

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

MLS Number 170610321

• Commercial
• MLS Status Active
• Year Built 1958
• Square Feet 82,625
• Bathroom 4

Introducing "The Hartford 99 BSD Portfolio," a notable investment opportunity featuring five well-maintained brick multifamily properties in prime locations across Hartford, CT. Comprising 24 Carpenter St, 39 Imlay St, 240 Laurel St, 246 Laurel St, and 495 Maple Ave, this turnkey portfolio boasts gas-heated units, onsite laundry facilities, and tenant-paid electric, providing both efficiency and convenience. With ample parking available for all buildings, these carefully tended properties not only showcase cleanliness but also attract quality tenants. The portfolio presents a unique value-add opportunity through potential rent increases, making it an enticing prospect for savvy investors seeking solid assets. Positioned in a prime location, "The Hartford 99 BSD Portfolio" stands as a testament to quality and promises long-term growth in the flourishing Hartford real estate market. Don't miss your chance to own this strategically positioned and well-managed portfolio.

Listed by Brandon Rush of Berkshire Hathaway NE Prop.

MLS Number 170610912

• Multi Family Multi-Family For Sale
• Acreage 1
• Square Feet 82,625
• Property Style Other
• Year Built 1958

Introducing "The Hartford 99 BSD Portfolio," a notable investment opportunity featuring five well-maintained brick multifamily properties in prime locations across Hartford, CT. Comprising 24 Carpenter St, 39 Imlay St, 240 Laurel St, 246 Laurel St, and 495 Maple Ave, this turnkey portfolio boasts gas-heated units, onsite laundry facilities, and tenant-paid electric, providing both efficiency and convenience. With ample parking available for all buildings, these carefully tended properties not only showcase cleanliness but also attract quality tenants. The portfolio presents a unique value-add opportunity through potential rent increases, making it an enticing prospect for savvy investors seeking solid assets. Positioned in a prime location, "The Hartford 99 BSD Portfolio" stands as a testament to quality and promises long-term growth in the flourishing Hartford real estate market. Don't miss your chance to own this strategically positioned and well-managed portfolio.

Listed by Brandon Rush of Berkshire Hathaway NE Prop.

MLS Number 170555167

• Multi Family Multi-Family For Sale
• Square Feet 74,000
• Acreage 0.22
• Year Built 1968

Rare opportunity to own 68 units on one parcel in the Asylum Hill area of Hartford. This offering consists of 5 adjacent, brick buildings and one building lot. The unit mix is: 1, 4 bedroom townhouse; 22, 3 bedroom townhouses; 19, 2 bedroom ranch style; 11, 1 bedroom ranch style; and, 15 studios. 16 of these units have 2 full bathrooms. Since acquisition, the current owner has remodeled the common areas (new entrance doors on order) and renovated 25+ units with modern finishes. This asset was also gutted to the studs approximately 25 years ago. This property has: secured entry with pass card systems, large fenced in parking lot (recently paved), modern laundry rooms, updated electrical, and an onsite office. Recent mechanical upgrades include: buildings 36 & 46 have new circular pumps, building 40 has new water heaters, and buildings 46 & 48 have 5 year old roofs, and a few of the boilers have been replaced. This asset is located near the Hartford Insurance and St Francis Hospital.

Listed by Lisa Cozzi of Berkshire Hathaway NE Prop.

MLS Number 170554197

• Commercial
• MLS Status Active
• Year Built 1968
• Square Feet 74,000
• Acreage 0.22

Rare opportunity to own 68 units on one parcel in the Asylum Hill area of Hartford. This offering consists of 5 adjacent, brick buildings and one building lot. The unit mix is: 1, 4 bedroom townhouse; 22, 3 bedroom townhouses; 19, 2 bedroom ranch style; 11, 1 bedroom ranch style; and, 15 studios. 16 of these units have 2 full bathrooms. Since acquisition, the current owner has remodeled the common areas (new entrance doors on order) and renovated 25+ units with modern finishes. This asset was also gutted to the studs approximately 25 years ago. This property has: secured entry with pass card systems, large fenced in parking lot (recently paved), modern laundry rooms, updated electrical, and an onsite office. Recent mechanical upgrades include: buildings 36 & 46 have new circular pumps, building 40 has new water heaters, and buildings 46 & 48 have 5 year old roofs, and a few of the boilers have been replaced. This asset is located near the Hartford Insurance and St Francis Hospital.

Listed by Lisa Cozzi of Berkshire Hathaway NE Prop.

MLS Number 170565519

• Land
• Acreage 280
• MLS Status Active
• Waterfront
• Zoning RA

This 280 acre property is located in Windsor and East Granby. The property has been farmed for many generations in tobacco and row crops. The property has approximately 90 acres open in fields with Merrimac fine sandy loam and Windsor loamy sand, two of the finest agricultural soils. There are 3,361 feet of frontage along the Farmington River and 1000 feet of frontage along Stone Road in Windsor and 816 feet of frontage along Spoonville Road in East Granby. There are 8 tobacco barns on the properties in various conditions. Most of the land is classified under current use in CT. Current agricultural lease income is $43,050 from April to December from a local farm family. $500/ac for tobacco, $300/ac for vegetables, and $750 per tobacco barn for three barns and $3000/yr for farm workshop with fence enclosure. Annual property tax is $25,974.

Listed by Keith Ross of Landvest,Inc

MLS Number 170601698

• Commercial
• MLS Status Active
• Year Built 1960
• Square Feet 40,000
• Acreage 71

Welcome to the Historic Spa at Grand Lake, now known as The Hotel at Grand Lake! Nestled on 71 pristine acres overlooking Lake Williams, this seven building resort property offers an amazing opportunity for a new owner with current rental income in place. The hotel currently offers 55 rooms for guests, with an additional 30 rooms awaiting remodel. This property would make a great conversion to a multifamily project with many amenities. A short walk thru the woods brings you to Brewster Pond, allowing visitors easy access to fishing, kayaking, and paddle boarding. The grounds include an indoor and outdoor pool, large banquet hall, full-sized restaurant-capacity kitchen, and beautiful views of the lake. Also there is an additional restaurant and bakery building. Also included is a 2,700 sq ft contemporary single story 3-bedroom home with open concept layout and a full floor-to-ceiling brick fireplace in great room. The single family home includes a 3-car detached garage. Rooms are currently rented on a weekly basis with approx. 35 of the 55 rooms rented. Gross income currently $40,000 per month for the 35 rooms rented.

Listed by Francis H. Shank of Amodio & Co.

MLS Number 170364551

• Commercial
• MLS Status Active
• Square Feet 81,312
• Year Built 1885
• 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 170515163

• Single Family
• Square Feet 6,740
• Bedrooms 5
• Bathroom 5
• Year Built 2006

Luxurious Country Estate between New York and Boston! Nestled to the North of rural Granby, CT, this luxurious country estate offers the perfect blend of privacy and accessibility. Located just minutes from the town center and close to Bradley International Airport, the estate is also within easy reach of the charming towns of Litchfield County and the scenic Berkshires. Set on over 240 acres of natural beauty, the custom-built home designed by architect Emil Dahlquist and built by local master craftsmen is a haven of luxury and tranquility. Enjoy stunning views from every window, wander through colorful gardens, relax in the gazebo, hike or ride through mature woodland, and accommodate your equine friends in open pastures and run-ins. The impressive barn, complete with an office above, provides ample space for all your outdoor needs. Whether for grand entertaining or everyday living, this magnificent estate provides the ultimate experience in comfort, elegance, and natural beauty. This truly is a special place! Please contact the listing agent for video link, additional details and to book your private tour. *** SHOWINGS STRICTLY BY APPOINTMENT ONLY ***

Listed by Anna Sogliuzzo of Berkshire Hathaway NE Prop.

MLS Number L10060067

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

50 ACRE SPECTACLE LAKE ON 645 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. Abundant wildlife provides excellent hunting as well. No traffic noise. Star gazing is unparalleled. 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 ready immediately). Zoning regulations allow and recorded engineering data show 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 (lessee is responsible for annual real estate taxes of $3,378 of the total $9,221). Seller options: 245+/- 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 23 miles, Hartford 50 miles, Boston 60 miles, New York City 150 miles. Several major airports are within one hour's drive. Local airstrips are also available for small planes. (Owner is a licensed CT RE broker).

Listed by J. Thomas Mettling of J. Thomas Mettling

MLS Number 170582498

• Single Family
• Square Feet 10,890
• Bedrooms 4
• Bathroom 5
• Year Built 2021

Built in 2021 and designed by John Toates, Architecture and Design, LLC., this modern masterpiece, blends artistic and functional design with stunning views of Long Island Sound. This is your opportunity to live the dream in a turnkey, state of the art, direct waterfront home in the coveted Pine Orchard area of Branford, CT. With over 5,300 square feet of living space, in the main house, the owner has thought out every detail to provide enduring, quiet luxury. Amazing waterfront vistas, gorgeous sunrises and sunsets await you in this sensational home which blends aesthetics and technology to create an amazing living space. From the generously designed chef's kitchen with a contemporary butler's pantry to the over-sized wine cellar, every room in this house has been thoughtfully designed. From ship lap ceilings to LED lighting throughout the house, no detail has been overlooked. There are ample accommodations for family and guests in this 4 bedroom, 5 bathroom one of a kind property on Long Island Sound. This home also includes a home gym, media room, Centor integrated doors, living room with fireplace and noise reduction doors, screened in porch with water views, a full studio and so much more. Hurricane rated windows and a full house generator add to your peace of mind. You have nothing more to do except move in and enjoy this modern masterpiece on Long Island Sound.

Listed by William H. Mooney and Elizabeth M. Mishler of William Raveis Real Estate