USANYHamburgHolland Land Company5274 Columbia Ave

5274 Columbia Ave, Hamburg, NY

Name: 5274 Columbia Ave, For Sale in Hamburg - eXp Realty
Brand: Keller Williams Realty WNY
SKU: B1660978
Price: 579900 USD

House

For Sale

Listed price in listed location currency (USD).

$579,900

530

MLS® B1660978

Key Facts
Description
Map

Key Facts

Type Single Family Residence

Levels Residential

Size 2945 sqft

Garage Yes

Taxes $10,153

Days Active 7

Lot Size 0.4293 acres

Approx. Age 1914

Avg. Price Per Sqft $196

MLS® Number B1660978

Property Address: 5274 Columbia Ave, Hamburg, NY, 14075-5707

Average square foot calculated using Size range provided by listing agent.

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.

MLS® NumberB1660978

Laundry LevelUpper Level

Central VacNo

FireplaceNo

Acreage0.4293

Exterior

GarageYes

Approx. Age1914

BasementFull, Sump Pump

DrivewayDetached, Garage, Garage Door Opener

Garage Spaces2

Heat

A/C

Heating Fuel

Extras

Price History

-End Date

Not Sold YetSold Price

For Sale

Feb 6, 2026List Date

$579,900List Price

Commute

Commute

Starting Address

Destination Address

Like what you see?

Complete the form and we'll be in touch. No login necessary.

Add a Comment

I want to view this property

By checking this box, and clicking "Take a Tour", I am confirming that I have read and agree to Zoocasa's Data Processing & Privacy Policy, and to Zoocasa's Terms of Use.

By checking this box, and clicking "Take a Tour", I am electronically signing and consenting to receive marketing communications (about real estate brokerage services and one or more properties that I may buy, sell, or rent), that may be delivered to me via email, telephone and/or text messaging (using "automated technology" such as an automatic telephone dialing system, and/or an artificial or prerecorded voice), from Zoocasa, eXp Realty® and its independent contractor real estate agents, and/or its or their affiliates, using the contact information I provided. Consent is not a condition of purchase. I may opt-out at any time by emailing [email protected] or calling 1-844-683-4664.

Similar Listings

Comparable Properties

Explore eXp Find an Agent Join eXp Investor Relations Company Careers Home Guides

eXp Life Zoocasa SUCCESS®SUCCESS® Lending eXp Revenos eXp Commercial eXp Luxury eXp Land and Ranch Accessibility

Terms and Conditions Privacy Rights Request Privacy Policy Cookie Policy Brand Guidelines Help Sitemap

2219 Rimland Drive, Suite 301, Bellingham, Washington, 98226

1 833-303-0610

[email protected]

eXp REALTY

DMCA Notice

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply

Fair Housing and Reasonable Accommodations

MLS Compliance Statements

Karen Richards - Designated Managing Broker, Broker Operations - TX

Texas Real Estate Commission information about brokerage services

Texas Real Estate Commission Consumer Protection Notice

eXp Realty® is committed to adhering to the guidelines of The New York State Fair Housing Regulations.The Fair Housing Notice →

*Standardized Operating Procedure for Purchasers of Real Estate Pursuant to Real Property Law 442-H.Learn More →

eXp Realty of California, Inc. | CA DRE# 01878277 | Deborah Penny - Designated Broker

eXp Realty of Southern California, Inc. | CA DRE#01325837 | Jason Crawford – Designated Broker

eXp Realty of Greater Los Angeles, Inc. | CA DRE# 01240990 | Mike Mendibles - Designated Broker

eXp Realty of Northern California, Inc. | CA DRE# 01951343 | Ryan Rosas - Designated Broker