Skip main navigation
Pending
    • Price cut: $25K (6/11)
    $300,000

    5459 Columbia Ave, Hamburg, NY 14075

    3beds
    1,208sqft
    Loading
    Single Family Residence
    Built in 1960
    0.72 Acres Lot
    $293,700 Zestimate®
    $248/sqft
    $-- HOA

    What's special

    In-ground poolCozy gas insert fireplaceCedar-lined closetsVinyl railing front porchFenced-in yard
    This well maintained 3-bedroom, 1-bath ranch is located on a highly sought-after dead-end street directly across from Lake Erie and next to Wanakah Country Club. Situated on a spacious .72-acre lot, this home offers the perfect blend of privacy, comfort, and outdoor enjoyment. The fenced-in yard features an in-ground pool with numerous updates completed within the last 5 years including a Loop-Loc cover, liner, heater, filter, child protective fence, and a variable speed pump installed just 2 weeks ago. Inside, the home offers a 300 sq ft kitchen extension providing additional living and entertaining space, cedar-lined closets, a cozy gas insert fireplace, and new 3-pane windows and slider completed just 2 years ago. Major mechanical updates include a boiler and hot water tank approximately 7 years old along with updated 150 amp electric service. Additional exterior highlights include a vinyl railing front porch, pergola, 1-car garage with a 2-car concrete side pad, and deeded private beach access. Enjoy all this in a desirable lakeside location with the convenience of nearby golf, beaches, and scenic views.
    81 days
    |
    96
    |
    6
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Howard Hanna WNY Inc. 716-825-0600,

    Aaron Spinnegan 716-903-4354

    Source: NYSAMLSs,MLS#: B1680158MLS LogoOriginating MLS: Buffalo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 1
      • Full bathrooms: 1
      • Main level bathrooms: 1
      • Main level bedrooms: 3
      Heating
      • Gas, Baseboard
      Appliances
      • Included: Dryer, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Washer
      • Laundry: In Basement
      Features
      • Cedar Closet(s), Eat-in Kitchen, Pull Down Attic Stairs, Skylights, Bedroom on Main Level
      • Flooring: Ceramic Tile, Hardwood, Varies
      • Windows: Skylight(s)
      • Basement: Full
      • Attic: Pull Down Stairs
      • Number of fireplaces: 1
      Interior area
      • Total structure area: 1,208
      • Total interior livable area: 1,208 sqft

      Property

      Parking
      • Total spaces: 1
      • Parking features: Attached, Garage, Heated Garage, Other
      • Attached garage spaces: 1
      Features
      • Levels: One
      • Stories: 1
      • Exterior features: Concrete Driveway
      • Waterfront features: Deeded Access, Lake
      • Body of water: Lake Erie
      Lot
      • Size: 0.72 Acres
      • Dimensions: 100 x 315
      • Features: Near Public Transit, Rectangular, Rectangular Lot, Residential Lot
      Details
      • Parcel number: 1448891811000001012000
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Ranch
      • Property subtype: Single Family Residence
      Materials
      • Brick
      • Foundation: Poured
      • Roof: Architectural,Shingle
      Condition
      • Resale
      • Year built: 1960

      Utilities & green energy

      • Electric: Circuit Breakers
      • Sewer: Connected
      • Water: Connected, Public
      • Utilities for property: High Speed Internet Available, Sewer Connected, Water Connected

      Community & HOA

      Location
      • Region: Hamburg

      Financial & listing details

      • Price per square foot: $248/sqft
      • Tax assessed value: $90,000
      • Annual tax amount: $6,056
      • Date on market: 5/11/2026
      • Cumulative days on market: 83 days
      • Listing terms: Cash,Conventional,FHA,VA Loan

        Estimated market value

        $293,700

        $279,000 - $308,000

        $2,934/mo

        Price history

        DateEventPrice
        6/16/2026Pending sale$300,000$248/sqft
        Source: NYSAMLSs #B1680158 Report a problem
        6/11/2026Price change$300,000-7.7%$248/sqft
        Source: NYSAMLSs #B1680158 Report a problem
        5/12/2026Listed for sale$325,000+301.2%$269/sqft
        Source: NYSAMLSs #B1680158 Report a problem
        6/27/1996Sold$81,000$67/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $90,000
        2024-- $90,000
        2023-- $90,000
        2022-- $90,000
        2021-- $90,000
        2020-- $90,000
        2019-- $90,000
        2018-- $90,000
        2017$4,406 +81.4%$90,000
        2016$2,429 $90,000
        2015-- $90,000
        2014-- $90,000
        2013-- $90,000
        2012-- $90,000
        2011-- $90,000
        2010-- $90,000
        2009-- $90,000
        2008-- $90,000
        2007-- $90,000
        2006-- $90,000
        2005-- $90,000
        2004-- $90,000
        2003-- $90,000
        2002-- $90,000
        2001-- $90,000 +3.4%
        2000-- $87,000
        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 14075

        Getting around

        11 / 100
        Car-Dependent
        29 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • District: Frontier

        Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

            Nearby cities

            Nearby neighborhoods

            Nearby zip codes

            Other Hamburg Topics

              Search
              Updates
              Favorites
              Plan
              Inbox