x
Showing 1 of 0
X
Save

123 Sterling Avenue unit: 4 4
Greenport NY 11944 US

$1,599,999

Active Listing ID 961095
bed icon
2 bed
bath icon
3.00 Bath (2 Full , 1 Half)
lot icon
Lot: 0.04 Acres
home icon
Condominium

$1,599,999

Active Listing ID 961095
Save

123 Sterling Avenue unit: 4 4 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.04 Acres
  • Property Type: Residential
  • Property Sub-type: Condominium
  • Features
  • Full Bathrooms: 2
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air
  • Floor Covering: Hardwood
  • Heating Fuels: Electric (Heating)
  • Additional Features
  • Waterfront

School Information

  • School
  • Greenport Elementary School(Elementary)
  • Greenport High School(MiddleSchool)
  • Greenport High School(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Condominium
  • listprice: 1599999
  • unparsedaddress: 123 Sterling Avenue unit: 4
  • unitnumber: 4
  • postalcity: Greenport
  • stateorprovince: NY
  • country: US
  • postalcode: 11944
  • bathroomsfull: 2
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.0389
  • lotsizeunits: Acres
  • lotsizearea: 0.0389
  • livingarea: 1590
  • livingareaunits: Square Feet
  • latitude: 41.106699
  • longitude: -72.357381
  • listagentfullname: Fazina Deen
  • listagentemail: aaliyah5698@gmail.com
  • listagentkey: 3yd-MLSLINY-182970
  • listagentmlsid: 182970
  • listagentpreferredphone: 5166332563
  • listagentofficephone: 5166332563
  • listofficekey: 3yd-MLSLINY-KVKL01
  • listofficemlsid: KVKL01
  • disclaimer: 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.
  • sourcesystemid: MLSLINY
  • yearbuilt: 2023
  • listingcontractdate: 2026-02-13
  • listagentfax: 6316566595
  • listagenturl: http://www.listingpros.com
  • countyorparish: Suffolk County
  • parcelnumber: 1001-003-02-02-00-004-000
  • elementaryschool: Greenport Elementary School
  • highschool: Greenport High School
  • elementaryschooldistrict: Greenport
  • middleorjuniorschooldistrict: Greenport
  • highschooldistrict: Greenport
  • appliances: Dishwasher, Dryer, Electric Oven, Electric Range, Freezer, Microwave, Oven, Refrigerator, Stainless Steel Appliance(s), Washer, Wine Refrigerator
  • cooling: Central Air
  • constructionmaterials: Brownstone
  • flooring: Hardwood
  • heating: Electric (Heating)
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 3
  • parkingtotal: 0
  • parkingfeatures: Covered
  • waterfrontyn: True
  • franchiseaffiliation: None
  • interiorfeatures: 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
  • rooms: Bathroom 1, Bathroom 3, Bedroom 2, Bedroom 1, Bonus Room, Bathroom 2
  • utilities: Electricity Available
  • accessibilityfeatures: Accessible Elevator Installed
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -72.35738, 41.1067
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Listing Pro Realty Services", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"admin@listingpros.com", "ListBrokerageCity":"Hauppauge", "ListBrokerageCountry":"US", "ListBrokerageEmail":"admin@listingpros.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MLSLINY/05ee0701753811e298a11231380fc0b5/20130321143624597.png", "ListBrokerageName":"Listing Pro Realty Services", "ListBrokeragePhone":"(631) 656-6600", "ListBrokeragePostalCode":"11788", "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":"Suite 170", "ListBrokerageUnparsedAddress":"380 Townline Road", "ListBrokerageWebsiteUrl":"http://www.listingpros.com", "ListOfficeAddress1":"444 Route 111 ", "ListOfficeAddress2":"Suite 170", "ListOfficeBrokerMlsId":"KVKL01", "ListOfficeCity":"Smithtown", "ListOfficeCountry":"USA", "ListOfficeEmail":"admin@listingpros.com", "ListOfficePostalCode":"11787", "ListOfficeStateOrProvince":"NY", "ListPriceCurrencyType":"USD", "ListingTitle":"CONDOS - Greenport, NY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/123-Sterling-Ave-Apt-4_Greenport_NY_11944_M91257-86101?f=listhub&s=MLSLINY&m=961095&c=rexren", "MLSModificationTimestamp":"2026-02-14 15:31:36", "Neighborhoods":[], "PostalCode":null, "RoomCount":6, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":7040, "TaxDescription":null, "TaxYear":"2025"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 2/14/2026 3:48:52 PM GMT
Source Updated Date: 2/14/2026 6:53:47 PM GMT

Courtesy of: Fazina Deen, Listing Pro Realty Services, aaliyah5698@gmail.com

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.