Beach Homes Realty

New Listing

223 farren avenue

New Haven, CT 06513

$899,000

6 BATHS

3,432 SQFT0.07 AC LOT

Commercial

New Listing

Total Baths 6

Full Baths 4

Square Feet 3432

Acreage 0.07

Status Active

MLS # 24134133

County New Haven

More Info

Category Commercial

Status Active

Square Feet 3432

Acreage 0.07

MLS # 24134133

County New Haven

Mixed-use property featuring 4 residential units and 1 commercial space in a prime New Haven County location. Offering 3,432 sq ft of total space on a 0.073-acre lot, this versatile investment opportunity is situated just seconds from the Quinnipiac River. Ideal for investors seeking steady rental income or an owner-occupant looking to run a business on-site.

Location not available

Exterior Features

Roof Asphalt Shingle
Garage No
Water Public Water Connected
Sewer Public Sewer Connected
Lot Description Corner Lot, Level Lot

Interior Features

Heating Hot Water
Cooling None
Living Area 3,432 SQFT
Year Built 1900

Financial Information

Parcel ID 1238509
Zoning BA

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Dorrance Realty - (860) 637-7431

Listing Agent Patrick T. Precourt

The data relating to real estate for sale on this website appears in part through the SMARTMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SMARTMLS through a licensing agreement. Listing information is from various brokers who participate in the SMARTMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed. Copyright 2025 SmartMLS, Inc.

Listing data is current as of 10/18/2025.

Contact our Agent !

Search States

Alabama California Connecticut Delaware Florida Georgia Louisiana Maryland Massachusetts Mississippi New Hampshire New Jersey North Carolina Rhode Island South Carolina Texas Virginia

Resources

Sell A Beach Home Find an Agent Beach Market Report Beach Homes Lifestyles Frequently Asked Questions

Additional Markets

Find a Lake Home Sell a Lake Home Find a Mountain Home Sell a Mountain Home

Company

Be An Agent About Us Leadership Contact Us

1-833-582-3224

Beach Homes Realty All information is deemed reliable but not guaranteed accurate. Such Information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Some listings have been excluded from this website.

This page utilizes third-party mapping services and does not make any warranties or representations about the accuracy or completeness of these services' representations.

Cookie Policy

Disclaimer