Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Integrity Real Estate
Property view
Listing view 2
Listing view 3

5274 Columbia Avenue, 
Hamburg, NY 14075

$579,900


5

Beds


3

Baths


2,945

Sq Ft


Single Family

Pending

Listed by

Joshua James

Keller Williams Realty Wny

716-832-3300

Last updated:

March 15, 2026, 07:37 AM

MLS#

B1660978

Source:

NY GENRIS

About This Home

5274 Columbia Avenue

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.

Home Facts

Single Family

3 Baths

5 Bedrooms

Built in 1914

Price Summary

579,900

$196 per Sq. Ft.

MLS #:

B1660978

Last Updated:

March 15, 2026, 07:37 AM

Added:

a month ago


Rooms & Interior

Bedrooms

Total Bedrooms:

5

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

2

Interior

Living Area:

2,945 Sq. Ft.


Structure

Structure

Architectural Style:

Colonial, Traditional, Two Story

Building Area:

2,945 Sq. Ft.

Year Built:

1914


Lot

Lot Size (Sq. Ft):

18,700


Finances & Disclosures

Finances

Price:

$579,900

Price per Sq. Ft:

$196 per Sq. Ft.

Source:NY GENRIS
The information being provided by New York State Alliance Of Mlss is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2026 New York State Alliance Of Mlss All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.