5274 Columbia Avenue, Hamburg, NY 14075

• 5 beds |
• 3 baths |
• 2,945 sqft

Property 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 starting 2/11/26.

Listing Status:

Active

Date Added:

February 5, 2026

Data Last Updated:

February 10, 2026 at 7:16AM

Listing Office:

Keller Williams Realty WNY : 716-832-3300

Listing Agent:

Joshua James : 716-697-3280

MLS ID:

B1660978

Interior

• General: Breakfast BarCeiling Fan(s)Dry BarSeparate/Formal Dining RoomEntrance FoyerEat-in KitchenSeparate/Formal Living RoomGranite CountersNatural WoodworkBedroom on Main LevelBath in Primary BedroomMain Level PrimaryPrimary Suite
• Appliances: Appliances NegotiableDryerDishwasherGas OvenGas RangeGas Water HeaterRefrigeratorWasher
• Laundry: Upper Level
• Basement: FullSump Pump
• Flooring: HardwoodTileVaries
• A/C: Central Air
• Heating: GasForced AirRadiant Floor
• Fireplace: FireplaceFireplaces: 1

Exterior

• General: Blacktop DrivewayFully FencedHot Tub/SpaPoolShed(s)Storage
• Style: ColonialTwo StoryTraditional
• Other Structures: Shed(s)StoragePorchOpen
• Pool: In Ground
• Parking: DetachedGarageGarage Door Opener

Construction

• Roofing: ArchitecturalShingle
• General: Vinyl SidingCopper Plumbing2Block

Location

• Road/Access: City StreetMain Thoroughfare
• Originating MLS: NYS_B
• School District: Frontier
• County: Erie

Lot

• Zoning: 144889-181-060-0002-020-100
• Fencing: Full

Utilities

• Utilities: Electricity ConnectedSewer ConnectedWater ConnectedCircuit Breakers
• Water: ConnectedPublic
• Sewer: Connected

Financial

• Source: NYS_B