USANYHamburgHolland Land Company5274 Columbia Ave

5274 Columbia Ave, Hamburg, NY

House

For Sale

Listed price in listed location currency (USD).

$569,900

532

MLS® B1705787

Overview

Key Facts

Type Single Family Residence

Levels Residential

Size 2945 sqft

Garage Yes

Taxes $10,153

Days Active 0

Lot Size 0.4293 Acres

Approx. Age 1914

Avg. Price Per Sqft $193

MLS® Number B1705787

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 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.

MLS® NumberB1705787

Laundry LevelUpper

Central VacNo

FireplaceNo

Acreage

Exterior

GarageYes

Approx. Age1914

BasementFull, Sump Pump

DrivewayDetached, Garage, Circular Driveway, Garage Door Opener, Other

Garage Spaces

HeatGas, Forced Air, Radiant Floor

A/CCentral Air

Extras

Map

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

Yes, I'd like to receive free weekly market insights and buying and selling tips. Unsubscribe at any time.

By pressing "Take a Tour", I confirm that I have read and agree to the eXp Privacy Policy, and Terms of Use.

By pressing "Take a Tour", I am electronically signing and consenting to receive marketing comms about real estate brokerage and mortgage lending services, delivered via email, phone and/or text (using "automated technology" such as an automatic telephone dialing system, and/or an artificial or prerecorded voice), from eXp Realty® and its independent contractor real estate professionals and their affiliate SUCCESS® Lending using the contact information I provided. Your consent is not a condition of purchase and you may revoke it at any time by replying "STOP" to any texts. Text HELP for more info. Message and data rates may apply. You may also contact us directly at 1-844-683-4664.

Similar Listings

Comparable Properties

The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA.

eXp Realty holds real estate brokerage licenses in multiple states. Zoocasa (Canada), Inc. holds real estate brokerage licenses in multiple provinces. For information on licenses please contact us at [email protected]

For listings in Canada, the trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.

MLS® Compliance Statements
Tony King – 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# 02187306 | Gina Saad – Designated Broker
eXp Realty of Greater Los Angeles, Inc. | CA DRE# 02188471 | Anita Cruz – Designated Broker
eXp Realty of Northern California, Inc. | CA DRE# 01951343 | Ryan Rosas Penny – Designated Broker
Fair Housing and Reasonable Accommodations
DMCA Notice

2026 AODA Compliance Report
Feedback can be submitted through our standard communication channels such as our internal chat platform, email, phone etc., and accommodations are available upon request. Zoocasa reviews all feedback received, acknowledges concerns, and works to respond in a timely manner. Feedback is assessed and addressed appropriately to support continuous improvement of our services and accessibility practices.