Skip main navigation
Active
    • $569,900

    5274 Columbia Ave, Hamburg, NY 14075

    5beds
    2,945sqft
    Single Family Residence
    Built in 1914
    0.43 Acres Lot
    $-- Zestimate®
    $194/sqft
    $-- HOA

    What's special

    Fully-fenced backyard for entertainingFirst floor bedroomCustom built-in bookshelvesExtra wide hallwayNew brick-surround wood-burning fireplaceLuxuriously designed kitchenDistinct tile flooring
    Welcome to 5274 Columbia; a luxury colonial situated on one of the most preeminent streets in Hamburg, steps from Wanakah Country Club with private & deeded waterfront beach access to Lake Erie and incredible views off Beach Drive; your personal and serene oasis. Step out of the cold into the warm vestibule with honeycomb tile & chair rail through French doors into the grand living room with a new brick-surround wood-burning fireplace, custom built-in bookshelves & gorgeous hardwood throughout the first floor. This exquisite home features a luxuriously designed kitchen with high-end, 36” custom Cherry cabinetry with frosted glass accents, Granite counters with an ornate backsplash, Fisher & Paykel chef’s kitchen oven and distinct tile flooring opening to the dining area adorned with windows for an abundance of natural light and three season rm with vaulted ceilings, perfect for sipping your morning coffee. The first floor bedroom makes for ease of living with 4 more bedrooms upstairs, an extra wide hallway, while the additional two bathrooms & 2nd floor laundry is ideal. Step out of the dining nook area that has heated floors to the beautifully refinished, three-tiered wood deck with hot tub & Gazebo, leading down to a brand new, distinctive inground heated pool. Incredible period woodwork & trim accentuate the beauty and craftsmanship of this stunning home & enjoy the newer built, attractive two-car garage and fully-fenced backyard for entertaining. Mere minutes walk to enjoy stunning views of a lakeview paradise with no expense spared on updates including in-ground pool, firepalce, seamless gutters & interior paint 2025, all new gas lines, HWT, Lennox furnace & A/C in 2024, Lorex security system & some electric 2023, tear-off roof 2013 and more. Beautifully appointed & meticulously manicured with showings beginning immediately.
    3 days
    |
    770
    |
    47
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Keller Williams Realty WNY 716-832-3300,

    Joshua James 716-697-3280

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

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      • Main level bathrooms: 1
      • Main level bedrooms: 1
      Heating
      • Gas, Forced Air, Radiant Floor
      Cooling
      • Central Air
      Appliances
      • Included: Appliances Negotiable, Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Washer
      • Laundry: Upper Level
      Features
      • Breakfast Bar, Ceiling Fan(s), Dry Bar, Separate/Formal Dining Room, Entrance Foyer, Eat-in Kitchen, Separate/Formal Living Room, Granite Counters, Natural Woodwork, Bedroom on Main Level, Bath in Primary Bedroom, Main Level Primary, Primary Suite, Programmable Thermostat
      • Flooring: Hardwood, Tile, Varies
      • Basement: Full,Sump Pump
      • Number of fireplaces: 1
      Interior area
      • Total structure area: 2,945
      • Total interior livable area: 2,945 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Detached, Garage, Circular Driveway, Garage Door Opener, Other
      • Garage spaces: 2
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Open, Porch
      • Exterior features: Blacktop Driveway, Fully Fenced, Hot Tub/Spa, Pool
      • Pool features: In Ground
      • Has spa: Yes
      • Fencing: Full
      • On waterfront: Yes
      • Waterfront features: Beach Access, Deeded Access, Lake
      • Body of water: Lake Erie
      • Frontage length: 250
      Lot
      • Size: 0.43 Acres
      • Dimensions: 110 x 170
      • Features: Rectangular, Rectangular Lot, Residential Lot
      Details
      • Additional structures: Pool House
      • Parcel number: 1448891810600002020100
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial,Two Story,Traditional
      • Property subtype: Single Family Residence
      Materials
      • Vinyl Siding, Copper Plumbing
      • Foundation: Block
      • Roof: Architectural,Shingle
      Condition
      • Resale
      • Year built: 1914

      Utilities & green energy

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

      Community & HOA

      Community
      • Subdivision: Holland Land Company's Su
      Location
      • Region: Hamburg

      Financial & listing details

      • Price per square foot: $194/sqft
      • Tax assessed value: $157,500
      • Annual tax amount: $10,153
      • Date on market: 8/12/2026
      • Cumulative days on market: 65 days
      • Listing terms: Cash,Conventional,FHA,VA Loan

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        8/12/2026Listed for sale$569,900-1.7%$194/sqft
        Source: NYSAMLSs #B1705787 Report a problem
        7/25/2026Listing removed$579,900$197/sqft
        Source: NYSAMLSs #B1660978 Report a problem
        6/4/2026Listed for sale$579,900$197/sqft
        Source: NYSAMLSs #B1660978 Report a problem
        2/27/2026Pending sale$579,900$197/sqft
        Source: NYSAMLSs #B1660978 Report a problem
        2/6/2026Listed for sale$579,900+17%$197/sqft
        Source: NYSAMLSs #B1660978 Report a problem
        11/3/2023Sold$495,780$168/sqft
        Source: Public Record Report a problem
        9/5/2023Pending sale$495,780$168/sqft
        Source: NYSAMLSs #B1488154 Report a problem
        8/1/2023Listed for sale$495,780$168/sqft
        Source: NYSAMLSs #B1488154 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $157,500
        2024-- $157,500
        2023-- $157,500
        2022-- $157,500
        2021-- $157,500
        2020-- $157,500
        2019-- $157,500
        2018-- $157,500
        2017$7,826 +93.9%$157,500
        2016$4,036 $157,500
        2015-- $157,500
        2014-- $157,500
        2013-- $157,500
        2012-- $157,500
        2011-- $157,500
        2010-- $157,500
        2009-- $157,500
        2008-- $157,500
        2007-- $157,500
        2006-- $157,500
        2005-- $157,500
        2004-- $157,500
        2003-- $157,500
        2002-- $157,500
        2001-- $157,500
        2000-- $157,500
        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.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 14075

        Getting around

        13 / 100
        Car-Dependent
        28 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Middle: Frontier Middle
        • High: Frontier Senior High
        • 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