Curious about this home?

Ask anything — no agents, no pressure

Try asking

About This Home

This 5-bedroom, 3-bathroom single family at 5274 Columbia Avenue in Hamburg, NY is listed for $579,900 ($197 per sqft). Built in 1914, the home offers 2,945 sqft of living space on a 0.43 acres lot.

Agent Description

Welcome to 5274 Columbia; a luxury colonial situated on one of the most preeminent streets in Hamburg, steps from backing to Wanakah Country Club with private & deeded waterfront beach access to Lake Erie with incredible views off Beach Drive; your private 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 wood built-in bookshelves & gorgeous hardwood throughout the first floor.

This exquisite home features a luxuriously designed kitchen with high-end, 36" custom Cherry cabinetry w/frosted glass, Granite counters w/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.

First floor bedroom makes for ease of living with 4 more bedrooms upstairs, extra wide hallway, an additional two bathrooms & 2nd floor laundry is ideal. Step out the eat-in kitchen area w/heated floors to the beautifully redone, 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 the lakeview paradise with no expense spared on updates including pool, FP, 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.

Key Features

  • Built in 1914
  • 0.43 acre lot
  • 2 stories
  • Fireplace
  • Waterfront

Property Details

2 stories
2 full, 1 half
1914

Amenities

FireplaceWaterfrontSpaHardwoodA/C

Monthly Cost Estimate

$3,101/mo

20% down · 6.5% · 30 years

Principal$419
Interest$2,513
Insurance$169

Estimates only. Actual payments may vary.

Location

5274 Columbia Avenue

Hamburg, NY 14075

Holland Land Company

Features & Amenities

Interior Features

BreakfastBarCeilingFansDryBarSeparateFormalDiningRoomEntranceFoyerEatInKitchenSeparateFormalLivingRoomGraniteCountersNaturalWoodworkBedroomOnMainLevelBathInPrimaryBedroomMainLevelPrimaryPrimarySuite

Exterior Features

BlacktopDrivewayFullyFencedHotTubSpaPool

Property Details

Flooring

TileVariesHardwood

Construction

VinylSiding CopperPlumbing

Pool Features

Porch

Parking

GarageOpen

Heating

Forced AirRadiant FloorRadiantNatural Gas

Cooling

Central Air

Appliances

AppliancesNegotiableDryerDishwasherGasOvenGasRangeGasWaterHeaterRefrigeratorWasher

Questions & Answers

This 5-bedroom, 3-bathroom single family at 5274 Columbia Avenue is listed at $579,900 ($197/sqft). The estimated monthly payment is $2,513 based on 20% down at 6.5% interest.

Key features include: Built in 1914, 0.43 acre lot, 2 stories, Fireplace, Waterfront. Interior Features: BreakfastBar, CeilingFans, DryBar. Exterior Features: BlacktopDriveway, FullyFenced, HotTubSpa.

This property is listed by Joshua James and can be reached at 7166973280 or joshjamesrealtor@gmail.com.

JJ

Joshua James

Agent at Keller Williams Realty WNY

(716) 697-3280

Listed by Keller Williams Realty WNY · View on Broker Site

MLS# B1660978· Source: listhub· Updated 120 days ago

Copyright © 2026 New York State Alliance of MLSs, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

5274 Columbia Avenue, Hamburg, NY 14075

Open this listing in: