Active

Listing Tools

Here's an MLS version that's under **1,500 characters**, while naturally incorporating high-value SEO and AEO keywords that buyers are searching for, including **waterfront condo in New Haven**, **boat slip**, **Yale University**, **Yale New Haven Hospital**, **Metro-North**, and **Long Island Sound**. --- **Looking for a waterfront condo for sale in New Haven with a private boat slip? This exceptional townhouse-style end unit offers panoramic Quinnipiac River views, luxury finishes, and an unbeatable waterfront lifestyle just minutes from Yale University, Yale New Haven Hospital, Metro-North, I-91, and I-95. The completely redesigned chef's kitchen features an open-concept layout, upgraded gas line for a premium range, relocated plumbing, and stunning river views. Vaulted ceilings, hardwood floors, fresh paint, two beautifully renovated baths, high-end Revel in-ceiling speakers, a six-zone lighting system, and a wood-burning fireplace create a warm, sophisticated interior. The flexible lower-level bedroom with French doors and private entrance is perfect for guests, a home office, or studio. Enjoy a finished garage, full-size laundry, and second refrigerator. Outside, relax on two private waterfront decks or head to your 25-foot boat slip with dock box and swim ladder. Launch your boat, kayak, canoe, or paddleboard and cruise the Quinnipiac River to Long Island Sound. Two nearby marinas and waterfront restaurants are within walking distance, making this a rare

Property Details of 229 Front Street, Unit 1, Fair Haven

Map Location

Driving Directions

Listed by Heike Hyka Severine of Coldwell Banker Realty ((860) 385-6315)

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 2026 SmartMLS, Inc.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Ferrigno-Storrs, REALTORS LLC.. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.