229 Front Street 1

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 No more than one dog or cat no more than 20 inches at shoulder height.