Back 4/123 Sterling Avenue
Off Market

4/123 Sterling Avenue

Greenport NY 11944

2
3
1
1590 sq. ft.
1693 sq. ft.
Condo
Last sold for $1,600,000
Fazina DeenFazina Deen, last sold this property on 14 April 2026 after 59 days on market.

Overview

Welcome to an exceptional waterfront includes 2 units, 2-bedroom, 2.5-bath luxury condo offering sweeping panoramic views of Greenport Harbor and Stirling Basin. Located in one of Greenport’s most sought-after luxury buildings, this rare residence includes your own private boat slip and delivers an unmatched North Fork lifestyle. The home features a chef’s kitchen outfitted with state-of-the-art stainless steel appliances, an integrated refrigerator and dishwasher, and a built-in wine cooler. The open-concept kitchen, dining, and living area is designed for effortless entertaining, enhanced by soaring high ceilings and dramatic double doors that open onto a wrap-around balcony with breathtaking water views. Sunlight pours in throughout the day, brightening the entire space and framing breathtaking panoramic water views. The spacious primary suite is a private retreat, complete with balcony access, a custom walk-in closet with built-ins, and a spa-like en suite bath. A well-appointed second bedroom and additional full bath provide comfort and privacy for guests, while a convenient half bath serves the main living area. A unique bonus space adds incredible flexibility and can be used as an entertainment lounge, office, storage area, or private retreat — a rare feature that sets this unit apart. Additional highlights include in-unit laundry, dedicated indoor parking, and an additional outdoor parking space. Whether enjoying sunrise coffee on the balcony, docking your boat steps from home, or entertaining with harbor views as your backdrop, this residence captures the very best of waterfront living in the heart of Greenport.

Features

2 bedrooms
3 bathrooms
1 carspace
1 garage space
1590 sq. ft. floor area
1693 sq. ft. lot size
Condo

Estimated Value

Based on this property and similar 2 bedroom condos sold in Greenport over the last 12 months, the estimated median property value of 4/123 Sterling Avenue is $585k.

Median value
$585k
Estimated value range
$488k - $1.6m
Median days on market
41
Estimated value trend
-36%
decrease over the last 12 months
Average days on market is based on recent, comparable sales in Greenport. It is only an indication of the time a property is actively listed and should not be relied upon as an accurate representation of how soon a property will be sold.

Property history for 4/123 Sterling Avenue

2026
Sold
$1,600,000
14 Apr 2026 by Fazina Deen, of Listing Pro Realty Services
2024
Sold
$1,200,000
31 Jan 2024 by Bridget Elkin, of Compass Greater NY LLC

Happy sellers in Greenport

~%

We have insufficient information to provide an overview of customer satisfaction for Greenport. Viewing the agent profiles, reviews and sales for Greenport can provide insights for this location.

Local market activity for 2 bedroom condos in Greenport

In the last 12 months, 3 two-bedroom condos similar to 4/123 Sterling Avenue, have been sold.

This represents a 56% increase in two-bedroom condos sales when compared to the previous 12 months.

Nearby agents

Compare and contact these top performing agents who’ve delivered exception customer service for their clients in Greenport

or
Skip the list and find your ideal agent to sell your propertyFind My Agent
© 2026 RateMyAgent