(845) 398-1717 susan@ImagineProperties1.com Imagine Properties
    Traffic Dashboard
    Home Home
    • HOME
    • ABOUT
      • Learn More
      • Meet the Team
      • Reviews
    • LIST OF SERVICES
      • Union News
      • Services
    • MORTGAGE
      • Mortgage Calculator
    • COMMUNITIES
      • Areas
      • Community News
      • All Listings
      • Palm Beach County
      • New Jersey
    • IMAGINE HELP
    • BUYERS
      • Buying Tips
      • Featured Listings
      • Search New York Homes
      • Search New Jersey Homes
    • SELLERS
      • Home Valuation
    • INVESTORS
    • RESOURCES
      • Slattery Moving & Storage
      • Short Sale
      • Senior Real Estate
      • Probate
      • Articles
    • MORE
      • Florida
      • School Report
      • Real Estate Tips
      • Sold Properties
    • RITZ-CARLTON RESIDENCES
    • CONTACT
    Traffic Dashboard
    Susan Camus
    (845) 398-1717 susan@ImagineProperties1.com
    • 100 Dutch Hill Rd Suite 260
      Orangeburg, NY 10962
    Home
    • HOME
    • ABOUT
    • LIST OF SERVICES
    • MORTGAGE
    • COMMUNITIES
    • IMAGINE HELP
    • BUYERS
    • SELLERS
    • INVESTORS
    • RESOURCES
    • MORE
    • RITZ-CARLTON RESIDENCES
    • CONTACT
    Legal
    • Privacy
    • Terms
    • DMCA
    • Accessibility
    • Fair Housing
    Account
    • Dashboard
    • Logout
    • Login
    Susan Camus | Imagine Properties - Footer Logo
    ©2026 Imagine Properties. All rights reserved.
    Website built by CloseHack.
    Miami Association of REALTORS®

    MIAMI ASSOCIATION OF REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the Multiple Listing Service. Real estate listings held by brokerage firms other than Marjo Realty Co. may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS.

    New Jersey Multiple Listing Service, Inc.

    The data relating to the real estate for sale on this web site comes in part from the Internet Data Exchange Program of the NJMLS. Real estate listings held by brokerage firms other than Susan Camus | Imagine Properties are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Some properties listed with the participating brokers do not appear on this website at the request of the seller. Listings of brokers that do not participate in Internet Data Exchange do not appear on this website. 

    All information deemed reliable but not guaranteed. Last date updated: 01/09/2023

    2023 New Jersey Multiple Listing Service, Inc. All rights reserved.  

    My Florida Regional MLS DBA Stellar MLS

    IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Some IDX listings have been excluded from this website. Listing Information presented by local MLS brokerage: Susan Camus | Imagine Properties

    OneKey MLS

    IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

    Return
    • All Types
    • House+2 more
    • Price
    • Bed/Bath
    • Size
    • Dates
    • Filters
    • Amenities
    • Save
    • Share
    Listings
    No results
    Sort
    Home / Greenport / 123 Sterling Avenue #2
    123 Sterling Avenue #2 Greenport, NY 11944 123 Sterling Avenue #2 Greenport, NY 11944 123 Sterling Avenue #2 Greenport, NY 11944 123 Sterling Avenue #2 Greenport, NY 11944 123 Sterling Avenue #2 Greenport, NY 11944 123 Sterling Avenue #2 Greenport, NY 11944 123 Sterling Avenue #2 Greenport, NY 11944 View All Photos

    $45,000

    | Active

    123 Sterling Avenue #2

    Greenport, NY 11944

    1,528
    Square Feet
    3
    Beds
    3
    Baths
    0.04
    Acres
    195
    Days on Market
    963470
    MLS#
    Rental
    Type
    Apartment
    Structure
    Residential
    Zone
    Contact

    SUMMER RENTAL! BOAT SLIP: Perched above the water with expansive views of Greenport Harbor and Stirling Basin, this unit offers modern luxury on one of Greenport Village's most beautiful streets. This unit includes a private boat slip, dedicated indoor and outdoor parking spaces, in-unit laundry. Four blocks from the center of the village commercial district with shops, restaurants, and galleries. Great proximity to Jitney and LIRR for easy access to NYC. Featuring three bedrooms, two full baths and one half bath. Open concept kitchen / dining / living room. 500 sq ft space with additional half bath on lower level for work space and 224 sq ft of waterside balcony space.

    Property Details
    Interior
    Washer/Dryer Hookup
    Cooling
    Central Air
    Heating
    ENERGY STAR Qualified Equipment
    Cooling Features
    Central Air
    Bedrooms
    3
    Bathrooms
    3.0
    Full Baths
    3
    Acres
    0.0368
    Square Feet
    1528.0
    Parking Features
    Assigned
    Parking
    1
    Parking Spaces
    1
    Parking Type
    Garage
    Parking Garage
    1
    Parking Garage Spaces
    1.0
    Property Type
    Rental
    Year Built
    2024
    Sewer Information
    Public Sewer
    Utility Source
    Public
    Utility Features
    Cable Connected, Electricity Connected, Natural Gas Connected
    Appliances
    Cooktop, Dishwasher, Dryer, ENERGY STAR Qualified Appliances, Microwave, Refrigerator, Stainless Steel Appliance(s)
    School District
    Greenport
    Elementary School
    Greenport Elementary School
    Middle School
    Greenport High School
    High School
    Greenport High School
    County
    Suffolk County
    Region
    Southold
    Date Available
    February 19, 2026
    Original List Price
    $45,000
    Days on Market (Cumulative)
    195
    HOA
    1
    HOA Fees
    1200.0
    Pets
    Call
    Pets Allowed
    Call
    MLS #
    963470
    Location
    Legal

    IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

    Last Updated: Sep 2, 2026 12:35 PM. Source: ONEKEY

    Provided By
    Listed by Lisa B. Gillooly (#KEY143421), 631-251-8644
    Listing Office: Compass Greater NY LLC (#KEYCMPA15)

    Susan Camus | Imagine Properties Have a question about this home?

    Interested in Purchasing 123 Sterling Avenue #2?

    Get an estimate on monthly payments on this property.

    $
    years
    Down Payment
    $
    %
    Interest Rate
    %
    Tax Rate
    %
    $
    $annually
    $monthly
    Estimated Monthly Payment
    $0.00
    Loan Amount
    $0.00