Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
5 Beds
3 Baths
2,945 sqft

$569,900

5274 Columbia Avenue, Hamburg NY, 14075

Price per sqft$193.51
Built in1914
Property size2,945 sqft
Property typeResidential

Overview

Active

Listed Aug 12, 2026

Updated Aug 13

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.

$3,792/mo

Est. mortgage payment based on a $569,900 home price.

All estimates are provided by Luxury Presence for informational purposes only. Actual amounts may vary.

Additional information

MLS® ID
B1705787

Interior Features

Bedrooms
5
Bathrooms
3
Fireplace
Yes
Cooling
Yes
Heating
Yes
Basement
Yes

Exterior Features

Lot Size
0.43 Acres

Other Property Details

Taxes
$10,153
Tax Frequency
Annually
Garage
Yes
Pool
Yes
Waterfront
Yes
MLS provider logo

 

Courtesy of Keller Williams Realty WNY, Joshua James

Disclaimer: Any use of search facilities of data on this site, other than by a consumer looking to purchase real estate, is prohibited. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change, or withdrawal. Neither listing broker(s) nor Perfect Place shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of the CNYIS, UNYREIS and WNYREIS. Real estate listings are marked with the IDX logo and include the Listing Broker’s Firm Name. 

Disclaimer: All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither the listing broker(s), Perfect Place, nor Luxury Presence shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless.

©2026 CNYIS, UNYREIS, WNYREIS. All rights reserved.

Data last updated 5:34 AM UTC, 8/13/2026

Powered by Luxury Presence