5274 Columbia Avenue, Hamburg, NY 14075

Hamburg
Local realty services provided by:HUNT Real Estate ERA
5274 Columbia Avenue,Hamburg, NY 14075
$569,900
Virtual Tour
  • 5 Beds
  • 3 Baths
  • 2,945 sq. ft.
  • Single family
  • Active
Listed by: joshua james
Office: keller williams realty wny
MLS#:B1705787
Source:NY_GENRIS

Price summary

  • Price:$569,900
  • Price per sq. ft.:$193.51

About this home

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

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, 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 an ERA®  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® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ). I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:1914
  • Subdivision & Development:Holland Land Company's Su
  • Listing ID #:B1705787
  • Added:37 day(s) ago
  • Updated:September 18, 2026 at 02:46 PM

Rooms and interior

  • Bedrooms:5
  • Total bathrooms:3
  • Full bathrooms:2
  • Half bathrooms:1
  • Rooms Total:14
  • Flooring:Hardwood, Tile, Varies
  • Dining Description:Separate Formal Dining Room
  • Kitchen Description:Dishwasher, Refrigerator
  • Basement:Yes
  • Basement Description:Full, Sump Pump
  • Living area:2,945 sq. ft.

Heating and cooling

  • Cooling:Central Air
  • Heating:Forced Air, Gas, Radiant Floor
  • Central air:Yes

Structure and exterior

  • Roof:Shingle
  • Year built:1914
  • Building area:2,945 sq. ft.
  • Lot area:0.43 Acres
  • Lot Features:Rectangular, Residential Lot
  • Architectural Style:Colonial, Traditional, Two Story
  • Construction Materials:Copper Plumbing, Vinyl Siding
  • Exterior Features:Fully Fenced, Hot Tub Spa, Open, Pool, Porch
  • Foundation Description:Block
  • Levels:2 Stories

Schools

  • High school:Frontier Senior High
  • Middle school:Frontier Middle

Utilities

  • Water:Connected, Public, Water Connected
  • Sewer:Connected, Sewer Connected

Finances and disclosures

  • Price:$569,900
  • Price per sq. ft.:$193.51
  • Tax amount:$10,153

Features and amenities

  • Appliances:Dishwasher, Dryer, Gas Range, Refrigerator, Washer
  • Laundry features:Dryer, Upper Level, Washer
  • Pool features:In Ground

Parking

  • Parking description:Circular Driveway, Detached, Garage, Garage Door Opener
  • Garage:Yes
  • Garage spaces:2

New listings near 5274 Columbia Avenue