5274 Columbia Avenue
Hamburg, NY 14075 · Erie County
Price
$579,900
Bed / Bath
5 bd · 2.5 ba
Interior
2,945 sqft
Lot
18,700 sqft lot
Built
1914
Garage
2-car
About this home
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.
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
Exterior features
- Blacktop Driveway
- Fully Fenced
- Hot Tub Spa
- Pool
Appliances
- Appliances Negotiable
- Dryer
- Dishwasher
- Gas Oven
- Gas Range
- Gas Water Heater
- Refrigerator
- Washer
Mechanical
Heating
Gas, Forced Air, Radiant Floor
Cooling
Central Air
Schools
District
Frontier
Middle
Frontier Middle
High School
Frontier Senior High
Tax & finance
Annual taxes
$10,153
Financing
Cash · Conventional · FHA · VaLoan
MLS Attribution
Listing courtesy of Keller Williams Realty WNY. Listing agent: Joshua James. Data last updated 6/4/2026. Information deemed reliable but not guaranteed; should be independently verified. © NYS Alliance of MLSs.
More in Hamburg
Similar homes nearby.
Hamburg, NY 14075
5316 Lake Shore Road
$849,900
5 bd · 3.5 ba · 2,037 sqft
Listing courtesy of Howard Hanna WNY Inc.
Hamburg, NY 14075
4 Brush Drive
$78,000
3 bd · 1 ba · 1,126 sqft
Listing courtesy of HUNT Real Estate Corporation
Listed 2 days ago
Hamburg, NY 14075
37 Anderson Place
$359,900
3 bd · 1.5 ba · 1,476 sqft
Listing courtesy of Howard Hanna WNY Inc.
Listed 2 days ago