Ad #7237722
MLS #B1660978
Welcome to 5274 Columbia; a luxury colonial situated on one of
5274 Columbia Ave, Hamburg, NY 14075
$579,900
5Beds
3Baths
2,945Sqft
0.43Acres
About this property
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.
Property Features
5 Beds
3 Baths
2,945 Sqft
Built in 1914
0.43 Acres
2 Stories
On Beachfront
Open, Garage
Siding: VinylSiding, CopperPlumbing
Shingle Roof
Has Swimming Pool
Has Fireplace
Radiant Floor, Forced Air, Radiant, Natural Gas
$10,153 / yr property tax
Erie County
Holland Land Company Community
Additional Photos
Contact Information
Joshua James
Keller Williams Realty Buffalo Northtowns
716-697-3280
Location
Listing Agent: Joshua James (License #: 10301210944) 716-697-3280
Broker: Keller Williams Realty Buffalo Northtowns 716-832-3300 Listing Site
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.
Broker: Keller Williams Realty Buffalo Northtowns 716-832-3300 Listing Site
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.
BeachHouse.com
Printed Aug 11, 2026
Photo Gallery
$579,900
5
Beds
3
Baths
2,945
Sqft
5274 Columbia Ave, Hamburg, NY 14075
By contacting this agent you agree to these Terms and Conditions.
MLS# B1660978
Welcome to 5274 Columbia; a luxury colonial situated on one of
$579,900
5274 Columbia Ave, Hamburg, NY 14075
5
Beds
3
Baths
2,945
Sqft
0.43
Acres
$579,900
5274 Columbia Ave, Hamburg, NY 14075
5 Beds
3 Baths
2,945 Sqft
0.43 Acres
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.
186 days
on BeachHouse.com
0
view
0
saves
Property Details
HOME DETAILS
5 Beds
3 Baths
2,945 Sqft
Built in 1914
0.43 Acres
2 Stories
BEACH & VIEW
On Beachfront
EXTERIOR
Open, Garage
Siding: VinylSiding, CopperPlumbing
Shingle Roof
Has Swimming Pool
INTERIOR
Has Fireplace
Radiant Floor, Forced Air, Radiant, Natural Gas
FINANCIAL & COMMUNITY
$10,153 / yr property tax
Erie County
Holland Land Company Community
See More Details
Location
Mortgage Calculator
Ad Statistics
Ad Number
7237722
Viewed
0 time
Listing Status
Active
Added
Feb 06, 2026
Last Refreshed
Jul 03, 2026 06:17:28 PM
Listing Information
Data Source
New York State Alliance of MLSs, LLC
Source Property ID
B1660978
Listing Agent: Joshua James (License #: 10301210944) 716-697-3280
Broker: Keller Williams Realty Buffalo Northtowns 716-832-3300 Listing Site
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.
Broker: Keller Williams Realty Buffalo Northtowns 716-832-3300 Listing Site
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.
Request Information
Start advertising today
Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home
Explore Similar Properties
