HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

Layout spacer

    Layout spacer

      About Us

      • Who We are
      • Meet the Team

      Resources

      • Latest Blogs
      • Free Vendor List
      • PracticalGuides
      • Need Funding?
      • Property Inspector
      • Down Payment Eligibility

      Communities

      • Otsego County
      • Schoharie County
      • Chenango County
      • Delaware County
      • Greene County
      • Broome County
      • Oneida County
      • Montgomery County
      • Ulster County

      Disclosures

      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution

      © 2026 Homes, Farms & Land. All rights reserved.

      Property at 40 Waterfront Circle, Buffalo, NY 14202
      IN ESCROW
      0
      $999,900

      40 Waterfront CircleBuffalo, NY, 14202

      2 Beds2 Baths1,945 SqFt
      Spectacular and breathtaking 3rd floor unit with unbelievable panoramic waterfront views!! Recently underwent complete renovation! (2024) This unit is essentially a new build!!! Has not been lived in since entirely remodeled! Everything is brand new including kitchen and bathrooms! Exquisite custom millwork and finishes throughout. Kitchen includes giant island, artisan cabinetry, quartz counters, SS appliances and more!! Spacious open family room with hard maple flooring and linear fireplace adjoins eat in kitchen. Family room and kitchen enjoy captivating waterfront views. Patio overlooks prime Buffalo waterfront! Primary suite includes custom built in closets and oversized dual head shower with quartz slab walls. Underground parking and personal boat slip included. Whether it's watching a summer sunset, or a storm roll in, the views from this unit are unmatched!!
      1 / 29

      Est. Monthly

      $4,740/mo

      $999,900

      40 Waterfront Circle, Buffalo, NY

      2 Beds2 Baths1,945 SqFt

      Spectacular and breathtaking 3rd floor unit with unbelievable panoramic waterfront views!! Recently underwent complete renovation! (2024) This unit is essentially a new build!!! Has not been lived in since entirely remodeled! Everything is brand new including kitchen and bathrooms! Exquisite custom millwork and finishes throughout. Kitchen includes giant island, artisan cabinetry, quartz counters, SS appliances and more!! Spacious open family room with hard maple flooring and linear fireplace adjoins eat in kitchen. Family room and kitchen enjoy captivating waterfront views. Patio overlooks prime Buffalo waterfront! Primary suite includes custom built in closets and oversized dual head shower with quartz slab walls. Underground parking and personal boat slip included. Whether it's watching a summer sunset, or a storm roll in, the views from this unit are unmatched!!

      StatusIn Escrow
      Property TypeResidential
      Property SubtypeOther
      Year Built1990
      Total Rooms6 rooms
      Days on Market186 days

      Est. Monthly Payment

      $4,739.50

      %
      %
      yr

      Private Mortgage Insurance

      Not required

      Affordability Checkoptional
      $

      Enter your annual income to check affordability

      Property Details

      Property Information

      40 Waterfront Circle

      Buffalo, NY 14202 • Erie
      2
      Beds
      2
      Baths
      1,945
      SqFt
      —
      Acres
      Status
      In Escrow
      Property Type
      Residential
      Property Subtype
      Other
      Year Built
      199036 years ago
      Total Rooms
      6 rooms
      Days on Market
      186 days
      Tax History
      Estimated values, may not reflect current amounts.
      • Annual Tax Amount
        $7,616
      Property History
      • Listed for sale
        Nov 14, 2025 • NYSAMLS • B1651044
        $999,900
      • Closed
        Aug 5, 2025 • NYSAMLS • B1614344
        $975,000
      • Listed for sale
        Jun 13, 2025 • NYSAMLS • B1614344
        $975,000
      Mortgage Calculator
      Estimated monthly payment for this property
      $4,739.50
      Down Payment
      Interest Rate
      Loan Term
      %
      %
      yearsyrs.
      Affordability Checkoptional
      $

      Enter your annual income to see if this home fits your budget

      Private Mortgage Insurance

      Not required — down payment above 20%
      MLS Information
      • Source
        NYSAMLS
      • MLS#
        B1651044
      • Listing Office
        Superlative Real Estate, Inc.
      • Last Updated
        20 days ago

      Appliances

      • Appliances
        • Appliances Negotiable
        • Gas Water Heater

      Climate & Systems

      • Heating
        • Gas
        • Forced Air

      Interior Features

      • Flooring
        • Ceramic Tile
        • Hardwood
        • Varies
      • Basement
        None
      • Interior Features
        • Separate Formal Dining Room
        • Eat In Kitchen

      Parking

      • Parking Features
        • Assigned
        • Attached
        • Garage
        • One Space
      • Garage Spaces
        1

      Lot & Grounds

      • Lot Features
        • Rectangular
        • Rectangular Lot
        • Residential Lot

      Type

      • Property Type
        Residential
      • Property Subtype
        Other

      Structure

      • Construction
        • Brick
        • Stucco

      Condition

      • Year Built
        1990
      • Condition
        Resale
      • Days on Market
        186 days
      • Water
        Connected
      • Sewer
        Connected
      • Utilities
        • Sewer Connected
        • Water Connected
      Also Listed On
      • NYSAMLS
        1 related listing
        Closed$975,000

      607-282-6242, (607) 282-6242, or +1 607 282 6242

      Kevin Lucero

      Kevin Lucero

      Lic. Real Estate Salesperson

      CallEmail
      Picked for you

      Similar Properties

      Handpicked listings that match what you're looking at

      View all →
      • 4344 W Summit Street, Busti, NY 14750ACTIVE$900,000

        4344 W Summit Street, Busti, NY 14750

        8 Beds8,843 SqFt1.0512 Acres

        LISTING BY PROPERTY SISTERS OF CHAUTAUQUA, INC.

      • 12 Elmwood Hill Lane, Brighton, NY 14610ACTIVE$901,000

        12 Elmwood Hill Lane, Brighton, NY 14610

        LandOther0.8 Acres

        LISTING BY MITCHELL PIERSON, JR., INC.

      • 67 Harvard Place, Buffalo, NY 14209ACTIVE$925,000

        67 Harvard Place, Buffalo, NY 14209

        6 Beds5,471 SqFt0.2868 Acres

        LISTING BY WNY METRO ROBERTS REALTY

      • 97 Linwood Avenue, Buffalo, NY 14209ACTIVE$975,000

        97 Linwood Avenue, Buffalo, NY 14209

        9 Beds10,969 SqFt0.2661 Acres

        LISTING BY NETWORK ONE REALTY

      • 306 Stewart Avenue, Ithaca City, NY 14850ACTIVE$999,999

        306 Stewart Avenue, Ithaca City, NY 14850

        5 Beds4,507 SqFt0.02 Acres

        LISTING BY WARREN REAL ESTATE OF ITHACA INC. (DOWNTOWN)

      • L1 State Highway 7, Afton, NY 13730ACTIVE$1,000,000

        L1 State Highway 7, Afton, NY 13730

        LandOther274 Acres

        LISTING BY CANAAN REALTY

      • 308 Fairmount Avenue, Ithaca City, NY 14850ACTIVE$1,000,000

        308 Fairmount Avenue, Ithaca City, NY 14850

        7 Beds2,358 SqFt

        LISTING BY WARREN REAL ESTATE OF ITHACA INC.