For Sale
3D Tour3D Tour
Single family home for sale at 5274 Columbia Ave, Hamburg, NY 14075 | MLS# B1705787 | Listing updated on 2026-08-12
Photo 1 of Single family home for sale at 5274 Columbia Ave, Hamburg, NY 14075 | MLS# B1705787 | Listing updated on 2026-08-12
Photo 2 of Single family home for sale at 5274 Columbia Ave, Hamburg, NY 14075 | MLS# B1705787 | Listing updated on 2026-08-12
Photo 3 of Single family home for sale at 5274 Columbia Ave, Hamburg, NY 14075 | MLS# B1705787 | Listing updated on 2026-08-12
Photo 4 of Single family home for sale at 5274 Columbia Ave, Hamburg, NY 14075 | MLS# B1705787 | Listing updated on 2026-08-12
46+
Beds Icon

Virtual Tour

Beds Icon

Street View

$569,900

Monthly Est:$2,837

  • Beds Icon5 Beds
  • Beds Icon
    3 Baths
  • Beds Icon2,945sqft

5274 Columbia Ave, Hamburg, NY 14075

$2,837/moEst:

Get Pre-Approved

  • Single Family Residence

  • Built in 1914

  • $-- HOA

  • 0.43 acre lot

  • $194/sq.ft

Description

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.

  • Houzeo last checked: 12 hours ago
  • Listing updated: August 12, 2026 at 10:12 am
  • Listing Provided by: Joshua James (716) 697-3280 DRE #10301210944 | Keller Williams Realty WNY (716) 832-3300
  • Source: New York State Alliance of MLSs, Buffalo-NY | MLS#: B1705787 New York State Alliance of MLSs, Buffalo-NY

Property Details

  • Status

    Active

  • Type

    Single Family Residence

  • No. of Stories

    2

  • County

    Erie County

  • City

    Hamburg

  • Neighborhood

    --

  • Year Built

    1914

  • HOA Fees

    -

  • Finished Area

    2,945 sqft

  • Lot Size

    0.43 acre lot

  • Basement Area

    - sqft

  • MLS Name

    New York State Alliance of MLSs, Buffalo

  • MLS Number

    B1705787

  • MLS Status

    Active

  • Days on Market

    61

  • Cumulative Days on Market

    61

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 5

    Bathrooms: 3

Interior

  • Flooring

    Hardwood, Tile, Varies

  • Exterior Features

    Blacktop Driveway, Fully Fenced, Hot Tub Spa, Pool

  • Interior Features

    Breakfast Bar, Ceiling Fans, 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

  • Heating

    Gas, Forced Air, Radiant Floor

  • Appliances

    Appliances Negotiable, Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Washer

  • Cooling

    Central Air

  • Sewer

    Connected

Construction

  • Year Built

    Year Built: 1914

  • Home type

    Single Family Residence

  • Roof

    Architectural, Shingle

  • Construction Materials

    Vinyl Siding, Copper Plumbing

  • Property Condition

    Resale

  • Architectural Style

    Colonial, Two Story, Traditional

  • Foundation Details

    Block

Utilities & Energy

  • Laundry Features

    Upper Level

  • Parking Features

    Detached, Garage, Circular Driveway, Garage Door Opener, Other

  • Electric

    Circuit Breakers

  • Pool Features

    In Ground

  • Basement

    Full, Sump Pump

  • Water Source

    Connected, Public

  • Utilities

    Cable Available, Electricity Connected, High Speed Internet Available, Sewer Connected, Water Connected

Other Features

  • Lot Features

    Rectangular, Rectangular Lot, Residential Lot

  • Patio And Porch Features

    Open, Porch

  • Subdivision Name

    Holland Land Company's Su

Price History

DateEventPrice

08/12/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1705787

Off Market

$569,900

$194/sqft

08/12/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1705787

Listed for Sale

$569,900 -1.72%

$194/sqft

07/25/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1660978

Listing Removed

$579,900

$197/sqft

06/04/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1660978

Listed for Sale

$579,900

$197/sqft

06/04/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1660978

Off Market

$579,900

$197/sqft

Show more

Getting Around 5274 Columbia Ave

Bike Score®

Bike Score

Somewhat Bikeable

32/100

Walk Score®

Walk Score

Car-Dependent

11/100

Data provided by Redfin

Nearby Homes

Based on data from the New York State Alliance of MLSs (CNYIS, Inc., UNYREIS and WNYREIS) through Oct 12, 2026, 10:30AM.. All information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable by is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 the New York State Alliance of MLSs. All Rights Reserved.

Advertising Broker: Derek Greene | The Greene Realty Group