#24044314, Shy Grahame, Listing Office: Berkshire Hathaway NE Prop.

233 Front St Unit 3 New Haven, CT 06513
Property details
About 233 Front St Unit 3
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
Highlights
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 3
- Appliances: Gas Range, Microwave, Range Hood, Refrigerator, Dishwasher, Trash Compactor, Washer, Dryer, Wine Cooler
- Basement: Yes
- Interior: Cable - Available, Open Floor Plan
- Total Bedroom Count: 3
- Garage Space: 2 spaces
- Attached Garage: Yes
- Private Pool: No
- Parking: Attached Garage, Off Street Parking, Driveway
- Waterfront: River, Waterfront, Dock, Water Access
- View: Water
- Exterior: Balcony, Sidewalk, Awnings, Deck, French Doors, Patio
- Architectural Style: Townhouse
- Heating: Forced Air
- Cooling: Central Air
- List Price: $679,000
- Price/SqFt: $226
- HOA Amount: $1890 Monthly
- Lot: Views
- Directions: Exit 8 off I 91 head west onto foxon blvd and left on front street to # 233 Front Street.
- Year Built: 1987
- Living Area: 3,000 SqFt
- MLS Number: 24097440
- Office Name: William Pitt Sotheby's Int'l
- Office Phone: (203) 453-2533
- Office Email: jules@williampitt.com
- Listing Agent: Jules G Etes
Copyright © 2025 Smart MLS. 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.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 5/22/2025, 11:20:31 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹

$679,000
233 Front St Unit 3
$8,063
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
5
Ferrara Elementary School
Public District 3-5
2.4 mi
•22 Maynard Rd
5
Ridge Hill School
Public District KG-6
2.5 mi
•120 Carew Rd
4
Lincoln - Bassett Community School
Public District PK-6
2.6 mi
•130 Bassett St
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $36,750. Typical income of New Haven, CT residents is less than $<35k annually. The most common type of family is single, no kids. Typical level of education for residents in this area is high school diploma.
Similar homes for sale
Frequently asked questions
About 233 Front St Unit 3
The listing price of 233 Front St Unit 3 property is $679,000.
The property 233 Front St Unit 3 is a condo located in New Haven, Connecticut, 06513.
Coming Soon: 233 Front St Unit 3 is Coming Soon. This listing has not previously been on the market, but will be on the market soon (no showings are allowed yet). A listing contract has been executed.
The nearby schools for 233 Front St Unit 3 are: Ferrara Elementary School (GreatSchools Rating 5/10), Ridge Hill School (GreatSchools Rating 5/10), Lincoln - Bassett Community School (GreatSchools Rating 4/10), Fair Haven School (GreatSchools Rating 3/10), Clinton Avenue School (GreatSchools Rating 3/10), Columbus Family Academy (GreatSchools Rating 3/10), Elm City College Preparatory School (GreatSchools Rating 4/10), Wilbur Cross High School (GreatSchools Rating 1/10), New Haven Academy (GreatSchools Rating 2/10).
The property at 233 Front St Unit 3 has 3 bedrooms and 3 full and 1 half bathrooms.
The property 233 Front St Unit 3 is 3,000 SqFt (source: MLS/tax record).
The year of construction for 233 Front St Unit 3 is 1987.
This home is located at 233 Front St Unit 3 in New Haven, CT and zip code 06513 in the Fair Haven neighborhood. This 3,000 square foot home was built in 1987. Features: 3 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since May 21, 2025 and is currently priced at $679,000.
New Haven, CT housing market in April 2025 saw over 28 listings sold above listed price, more than 10 sold at listed price and over 22 sold below. The number of homes for sale in New Haven, CT increased by 2.2% between March and April 2025.