5274 Columbia Avenue, Hamburg, NY 14075
- 5 beds |
- 3 baths |
- 2,945 sqft
Single-Family Home 
Built in 1914 
0.43acre lot
2 car garage 
$194/sqft 
Listed 1 month ago
Property 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.
- Listing Status:
- Active
- Date Added:
- August 12, 2026
- Data Last Updated:
- October 8, 2026 at 7:16AM
- Listing Office:
- Keller Williams Realty WNY : 716-832-3300
- Listing Agent:
- Joshua James : 716-697-3280
- Contact:
- 716-697-3280
- MLS ID:
- B1705787
- General: Blacktop DrivewayFully FencedHot Tub/SpaPoolPool House
- Style: ColonialTwo StoryTraditional
- Other Structures: Pool HousePorchOpen
- Pool: In Ground
- Parking: DetachedGarageCircular DrivewayGarage Door OpenerOther
- Roofing: ArchitecturalShingle
- General: Vinyl SidingCopper Plumbing2Block
- Road/Access: City StreetMain Thoroughfare
- Originating MLS: NYS_B
- School District: Frontier
- County: Erie
- Zoning: 144889-181-060-0002-020-100
- Fencing: Full
- Utilities: Cable AvailableElectricity ConnectedHigh Speed Internet AvailableSewer ConnectedWater ConnectedCircuit Breakers
- Water: ConnectedPublic
- Sewer: Connected
- Source: NYS_B
This listing courtesy of Joshua James , Keller Williams Realty WNY
Monthly Payment
- Principal & Interest $
- Property Taxes $
- Home Insurance $
- VA Funding Fee $
