Ad #7271909
MLS #961095
Welcome to an exceptional waterfront includes 2 units, 2-bedroom
123 Sterling Ave 4, Greenport, NY 11944
$1,599,999
2Beds
3Baths
1,590Sqft
0.04Acres
About this property
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.
Property Features
2 Beds
3 Baths
1,590 Sqft
Built in 2023
0.04 Acres
3 Stories
On Beachfront
Covered
Siding: Brownstone
Electric (Heating)
$7,040 / yr property tax
Suffolk County
Additional Photos
Contact Information
Fazina Deen
Listing Pro Realty Services
516-633-2563
Location
Listing Agent: Fazina Deen 516-633-2563
Broker: Listing Pro Realty Services 631-656-6600 Listing Site
Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Broker: Listing Pro Realty Services 631-656-6600 Listing Site
Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BeachHouse.com
Printed Aug 12, 2026
Photo Gallery
$1,599,999
2
Beds
3
Baths
1,590
Sqft
123 Sterling Ave 4, Greenport, NY 11944
By contacting this agent you agree to these Terms and Conditions.
MLS# 961095
Welcome to an exceptional waterfront includes 2 units, 2-bedroom
$1,599,999
123 Sterling Ave 4, Greenport, NY 11944
2
Beds
3
Baths
1,590
Sqft
0.04
Acres
$1,599,999
123 Sterling Ave 4, Greenport, NY 11944
2 Beds
3 Baths
1,590 Sqft
0.04 Acres
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.
179 days
on BeachHouse.com
146
views
0
saves
Property Details
HOME DETAILS
2 Beds
3 Baths
1,590 Sqft
Built in 2023
0.04 Acres
3 Stories
BEACH & VIEW
On Beachfront
EXTERIOR
Covered
Siding: Brownstone
INTERIOR
Electric (Heating)
FINANCIAL & COMMUNITY
$7,040 / yr property tax
Suffolk County
See More Details
Location
Mortgage Calculator
Ad Statistics
Ad Number
7271909
Viewed
146 times
Listing Status
Pending
Added
Feb 13, 2026
Last Refreshed
Jul 03, 2026 06:17:28 PM
Listing Information
Data Source
OneKey MLS
Source Property ID
961095
Listing Agent: Fazina Deen 516-633-2563
Broker: Listing Pro Realty Services 631-656-6600 Listing Site
Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Broker: Listing Pro Realty Services 631-656-6600 Listing Site
Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Request Information
Start advertising today
Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home
Explore Similar Properties
