Buy
  • Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
    Canada Listings (205)
    Mexico Listings (16)
    Advanced Search
Sell Find an Agent
BarrierFreeHome.com BarrierFreeHome.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BarrierFreeHome.com logo
Save Share

Photo Gallery

Listing Photo 1
Listing Photo 2
Listing Photo 3
Listing Photo 4
Listing Photo 5
Listing Photo 6
Listing Photo 7
Listing Photo 8
Listing Photo 9
Listing Photo 10
Listing Photo 11
Listing Photo 12
Listing Photo 13

$1,599,999

2
Beds
3
Baths
1,590
Sqft

123 Sterling Avenue unit: 4, Greenport, New York, 11944

By contacting this agent you agree to these Terms and Conditions.
Home New York Greenport
Welcome to an exceptional waterfront includes 2 units, 2-bedroom
Welcome to an exceptional waterfront includes 2 units, 2-bedroom
Welcome to an exceptional waterfront includes 2 units, 2-bedroom
Welcome to an exceptional waterfront includes 2 units, 2-bedroom
Welcome to an exceptional waterfront includes 2 units, 2-bedroom
MLS# 961095
Condo Sale Pending

Welcome to an exceptional waterfront includes 2 units, 2-bedroom

$1,599,999

123 Sterling Avenue unit: 4, Greenport, New York, 11944

2
Beds
3
Baths
1,590
Sqft
0.039
Acres
$1,599,999
123 Sterling Avenue unit: 4, Greenport, New York, 11944
2 Beds
3 Baths
1,590 Sqft
0.039 Acres

Accessibility Features

Accessible Elevator Installed
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.
30 days
on BarrierFreeHome.com
8
views
0
saves

Property Details

2 Beds
3 Baths
1,590 Sqft
Built 2023
0.039 Acres
No Patio
Covered
Electric (Heating)
Siding : Brownstone
$7,040 Property Tax
Suffolk County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7271909
Viewed
8 times
Added
Feb 13, 2026
Updated on
Feb 23, 2026

Listing Information

Data Source
OneKey MLS
Source Property ID
961095

Compliance

Listing Agent: Fazina Deen, Listing Pro Realty Services, 516-633-2563, 631-656-6600 Listing Site, Listing Status: Pending
Copyright © 2025 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

By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com .

Start advertising today

Explore options for real estate agents and homeowners advertising on BarrierFreeHome.com
Sell Your Home

Explore Similar Properties

No similar properties found.

SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com BeachHouse.com GolfHomes.com
SUBSCRIBE
Receive notifications for new listings
Subscribe

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.03.16
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Greenport

Read more
Sort By: Best Match
  • Best Match
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low
Click to activate

: Greenport Real Estate Agent Info

About Greenport

Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com .
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com BeachHouse.com GolfHomes.com
SUBSCRIBE
Receive notifications for new listings
Subscribe

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.03.16
Terms & Policy