Date
Details
Price
Change
Source
2/13/2026
Listed
$1,599,999
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/13
$1,599,999
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/13
Property Description
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.
Full Property Details
Full Property Details for 123 Sterling Ave #4
General
- Price: $1,599,999
- HOA FEE: $1,495/month
- Taxes: $7,040
- Status: Active
- Type: Condo
- Source: Long_Island
- MLS ID: 961095
- Updated: 2/14/2026
- Added to Site: 8 day(s) ago
Interior
- Number of Rooms: 6
- Interior Features: Built-in Features, Cathedral Ceiling(s), Chefs Kitchen, Double Vanity, Eat-in Kitchen, Elevator, Granite Counters, High Ceilings, Walk-In Closet(s), Washer/Dryer Hookup
- Appliances: Dishwasher, Dryer, Electric Oven, Electric Range, Freezer, Microwave, Oven, Refrigerator, Stainless Steel Appliance(s), Washer, Wine Refrigerator
- Laundry Facilities: Yes
- Flooring: Hardwood
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 2
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 2
Other Rooms
- Laundry: In Unit
Parking
- Garage: Yes
- Garage Spaces: 1
- Parking Features: Covered
Location
- County: Suffolk County
- Cross Streets: Sterling Street
- Driving Directions: MAIN ROAD TO STERLING AVENUE
School Information
- High School District: Greenport
- Elementary School: Greenport Elementary School
- Middle School: Greenport High School
- High School: Greenport High School
Community
- Association: Yes
- Assoc. Fees Include: Common Area Maintenance, Trash, Water
- Pets Allowed: Yes
- Pet Restrictions: Dogs OK
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air
- Heating Type: Electric
Utilities
- Sewer: Public Sewer
- Water: Public
- Utility Description: Electricity Available, Electricity Connected
Structural Information
- Architectural Style: Other
- Detached/Attached: Attached
- Construction: Brownstone
- Common Walls: 1 Common Wall
- Entry Floor Number: 4
- Stories/Levels: 3
- Stories in Building: 3
- Sq. Ft. Source: Other
- Year Built: 2023
Lot Features
- Lot Size (Acres): 0.0389
- Lot Size (Sq. Ft.): 1,693
Water Features
- Water Front View: Canal Front
Financial Considerations
- Association Fee: Yes
- Association Fee: $1,495
- Assoc Fee Freq.: Monthly
- Tax Amount: $7,040.48
Disclosures and Reports
- Special Conditions: None
- Property ID: 1001-003-02-02-00-004-000
- Block: 2
- Lot Number: 4
Listed by Listing Pro Realty Services
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 123 Sterling Ave #4 —
Listing Pro Realty Services
631-656-6600
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 123 Sterling Ave #4
School District:Greenport Union Free School District
| Name | Grades | Distance |
|---|---|---|
Greenport Elementary School 720 Front Street, Greenport, NY 11944 | PK-6 | 0.7 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 123 Sterling Ave #4
Tax History
Tax History for 123 Sterling Ave #4
Year
Property Taxes
Change
Tax Assessment
Change
2020
100%
$4,460
—
2022
—
$4,460
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 123 Sterling Ave #4
123 Sterling Avenue #4, Greenport, NY 11944 (MLS# 961095) is a Condo property with 2 bedrooms, 2 full bathrooms and 1 partial bathroom. 123 Sterling Avenue #4 is currently listed for $1,599,999 and was received on February 13, 2026. Want to learn more about 123 Sterling Avenue #4? Do you have questions about finding other Condo real estate for sale in Greenport? You can browse all Greenport real estate or contact a Coldwell Banker agent to request more information.