233 Front Unit 3
New Haven, CT 06513
Map
- 3 beds
- 4 baths
- 3,000 sqft
- $250 per sqft
- 1987 build
- – on site
More homes
Waterfront Luxury Meets Local Charm Wake up to sweeping water views, breathtaking sunrises and experience coastal living at its finest in this architecturally stunning waterfront retreat nestled in the heart of the vibrant Quinnipiac riverfront community. Open the French doors and bring the outdoors inside this striking space with featured reclaimed boathouse wood and custom finished hardwood floors. This home is a rare blend of modern design, natural beauty, and neighborhood walkability. Step inside to soaring cathedral ceilings, walls of windows that flood the living space with natural light and a seamless open layout perfect for entertaining or simply relaxing by the fire. The gourmet kitchen is a chef's dream, featuring dual-fuel Wolf stove and Subzero refrigerator, custom cabinetry, herringbone tile floor, and a statement island ideal for hosting while taking in the spectacular views. Upstairs, the expansive primary suite offers a loft with glass railings and a private outdoor balcony, a spa-like ensuite bath, fireplace and a spacious walk-in closet. Additional bedrooms provide flexibility for guests, a home office, or family living. The Mid-Level family room/library offers warm and unique character with built-ins and custom mantel fireplace. Outdoor living is just as impressive - Smell the salt air from your expansive patio with views of wildlife, local marinas and boats passing by. Enjoy direct water access from your private deeded boat slip with entry to Long Island
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 Jul 1, 2025
•
MLS# 24097440 —
The Building
-
Year Built:1987
-
Year Built Source:Public Records
-
New Construction Type:No/Resale
-
Style:Townhouse
-
Attic:No
-
Exterior Siding:Clapboard
-
Basement Description:Crawl Space, Concrete Floor
-
Exterior Features:Balcony, Sidewalk, Awnings, Deck, French Doors, Patio
-
End Unit:Yes
-
Unit On Floor Number:1
-
Levels In Unit:3
-
SqFt Total:3000
-
SqFt Est Heated Above Grade:3000
Interior
-
Interior Features:Cable - Available, Open Floor Plan
-
Fireplaces Total:4
-
Laundry Room:Upper Level
-
Laundry Room Location:In bathroom on primary suite floor
Room Dimensions
-
Living Area SqFt Per Public Record:3000
Location
-
Directions:Exit 8 off I 91 head west onto foxon blvd and left on front street to # 233 Front Street.
-
Neighborhood:N/A
The Property
-
Parcel Number:1242415
-
Property Type:Condo/Co-Op For Sale
-
Property Subtype:Condominium
-
Zoning:RM1
-
Flood Zone:Yes
-
Lot Description:Water View
-
Elevation Certificate:No
Listing Agent
- Contact info:
- Agent phone:
- (203) 453-2533
Taxes
-
Tax Year:July 2024-June 2025
-
Property Taxes:10325
Beds
-
Beds Total:3
Baths
-
Total Baths:4
-
Full Baths:3
-
Half Baths:1
The Listing
-
Home Warranty Offered:No
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, Microwave, Range Hood, Refrigerator, Dishwasher, Compactor, Washer, Dryer, Wine Chiller
Schools
-
Elementary School:Per Board of Ed
-
Intermediate School:Per Board of Ed
-
Middle Or Junior School:Per Board of Ed
-
High School:Per Board of Ed
The Community
-
Swimming Pool:No
-
Direct Waterfront:Yes
-
Waterfront Description:River, Walk to Water, Dock or Mooring, Water Community, View
-
Association Fee Includes:Grounds Maintenance, Trash Pickup, Snow Removal, Water, Sewer, Property Management, Flood Insurance
-
Pets Allowed:Yes
-
Pets Allowed Info:1 dog no more than 20 inc
-
Home Owner's Assocation:1
-
HOA Fee Amount:1890
-
HOA Fee Frequency:Monthly
-
Special Association Assessment:1
-
Special Assessment Details:seller will pay off assessment
Parking
-
Garage & Parking:Attached Garage, Off Street Parking, Driveway
-
Garages Number:2
-
Parking Total Spaces:4
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.
Sale history
| Date | Event | Source | Price | % Change |
|---|---|---|---|---|
|
7/1/25
Jul 1, 2025
|
Sold | SMART_MLS | $750,000 | 10.5% |
|
5/27/25
May 27, 2025
|
Pending | SMART_MLS | $679,000 | |
|
5/22/25
May 22, 2025
|
Listed / Active | SMART_MLS | $679,000 |
