229 Front Unit A
New Haven, CT 06513
Map
- 2 beds
- 2 baths
- 1,185 sqft
- $2 per sqft
- 1987 build
- – on site
Waterfront Luxury Living on the Quinnipiac River Wake up to stunning water views in this beautifully updated townhouse-style condo nestled right on the Quinnipiac River. Soaring vaulted ceilings and dramatic Palladian windows flood the space with natural light, while dimmable recessed lights and six custom dimmable lighting zones in the kitchen and living room highlight the open layout and high-end finishes throughout. The gourmet kitchen is a chef's dream, featuring premium appliances, elegant cabinetry, under-cabinet lighting, and built-in functionality for modern living. Enjoy cozy evenings in the living room by the fireplace, enhanced by high-end in-ceiling speakers, or movie nights in your master bedroom with a home theater and surround sound. Both bathrooms have been tastefully remodeled with a modern touch. Upstairs, a spacious loft with a balcony overlooks the main living area-perfect for a reading nook, office, or guest space. Step outside to your private decks or take in the breeze from your own boat dock just steps away. A full-size washer and dryer are located in the semi-finished garage, offering added convenience. All this is just a short walk to some of New Haven's finest dining and entertainment. A rare blend of style, comfort, and waterfront charm-this one's a must-see!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 3, 2025
•
MLS# 24091547 —
The Building
-
Year Built:1987
-
Year Built Source:Public Records
-
New Construction Type:No/Resale
-
Style:Townhouse
-
Attic:Yes
-
Attic Description:Access Via Hatch
-
Basement Description:Crawl Space
-
Energy Features:Storm Doors, Thermopane Windows
-
End Unit:No
-
In-Law Apartment:No
-
Unit On Floor Number:1
-
Levels In Unit:3
-
SqFt Total:1185
-
SqFt Description:above ground
-
SqFt Est Heated Above Grade:1185
Interior
-
Interior Features:Audio System, Auto Garage Door Opener, Cable - Available, Open Floor Plan, Security System
-
Fireplaces Total:1
-
Laundry Room:Upper Level
-
Laundry Room Location:In the partially finished basement.
Room Dimensions
-
Living Area SqFt Per Public Record:1185
Location
-
Directions:Use GVPS
-
Neighborhood:Fair Haven
The Property
-
Parcel Number:1242410
-
Property Type:Residential Rental
-
Property Subtype:Condominium Rental
-
Zoning:residential
-
Flood Zone:Yes
-
Lot Description:Water View
-
Elevation Certificate:Yes
Listing Agent
- Contact info:
- Agent phone:
- (203) 795-6000
Beds
-
Beds Total:2
Baths
-
Total Baths:2
-
Half Baths:2
Heating & Cooling
-
Heat Type:Hot Air
-
Heat Fuel Type:Natural Gas
-
Cooling System:Central Air
Utilities
-
Water Source:Public Water Connected
-
Sewage System:Public Sewer Connected
Appliances
-
Appliances Included:Gas Range, Range Hood, Refrigerator, Dishwasher, Washer, Dryer
Schools
-
Elementary School:Per Board of Ed
-
High School:Per Board of Ed
The Community
-
Nearby Amenities:Commuter Bus, Public Rec Facilities, Public Transportation, Walk to Bus Lines
-
Swimming Pool:No
-
Direct Waterfront:Yes
-
Waterfront Description:River
-
Pets Allowed:No
Parking
-
Garage & Parking:Under House Garage, Paved, Driveway
-
Garages Number:1
-
Parking Total Spaces:1
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
