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.
Property Details
Price:
$569,900
MLS #:
B1705787
Status:
Active
Beds:
5
Baths:
3
Type:
Single Family
Subtype:
SingleFamilyResidence
Subdivision:
Holland Land Company’s Su
Neighborhood:
hamburg144889
Listed Date:
Aug 12, 2026
Finished Sq Ft:
2,945
Total Sq Ft:
2,945
Lot Size:
18,700 sqft / 0.43 acres (approx)
Year Built:
1914
See this Listing
Schools
School District:
Frontier
Middle School:
Frontier Middle
High School:
Frontier Senior High
Interior
Appliances
Appliances Negotiable, Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Washer
Bathrooms
2 Full Bathrooms, 1 Half Bathroom
Cooling
Central Air
Fireplaces Total
1
Flooring
Hardwood, Tile, Varies
Heating
Gas, Forced Air, Radiant Floor
Interior Features
Breakfast Bar, Ceiling Fans, Dry Bar, Separate Formal Dining Room, Entrance Foyer, Eat In Kitchen, Separate Formal Living Room, Granite Counters, Natural Woodwork, Bedroom On Main Level, Bath In Primary Bedroom, Main Level Primary, Primary Suite, Programmable Thermostat
Laundry Features
Upper Level
Levels
Two
Main Level Bathrooms
1
Main Level Bedrooms
1
Exterior
Architectural Style
Colonial, Two Story, Traditional
Construction Materials
Vinyl Siding, Copper Plumbing
Exterior Features
Blacktop Driveway, Fully Fenced, Hot Tub Spa, Pool
Fencing
Full
Garage Spaces
2
Lot Features
Rectangular, Rectangular Lot, Residential Lot
Other Structures
Pool House
Parking Features
Detached, Garage, Circular Driveway, Garage Door Opener, Other
Patio And Porch Features
Open, Porch
Roof
Architectural, Shingle
Stories
2
Waterfront Features
Beach Access, Deeded Access, Lake
Financial
Taxes
$10,153
Map
Community
- Address5274 Columbia Avenue Hamburg NY
- SubdivisionHolland Land Company’s Su
- CityHamburg
- CountyErie
- Zip Code14075
Subdivisions in Hamburg
- Big Tree Town Homes
- Blasdell Park
- Brook Garden
- Brook Gardens
- Buffalo Crk Reservation
- Carnegie
- Commerce Park
- Fairgrounds Village Pt 2
- Highland Acres #2
- Holland Company’s Surv
- Holland Land
- Holland Land Company
- Holland Land Company’s Su
- Holland Land Companys
- Holland Land Companys Sur
- Liberty Park Pt 4
- Meadow Run Sec A
- Mission Hills
- Mount Vernon
- Norway Place Sub
- Old Ogden
- Sagamore Heights
- Town/Hamburg
- Triton Valley Sunset
Market Summary
Current real estate data for Single Family in Hamburg as of Aug 27, 2026
252
Single Family Listed
60
Avg DOM
205
Avg $ / SqFt
$350,588
Avg List Price
Property Summary
- Located in the Holland Land Company’s Su subdivision, 5274 Columbia Avenue Hamburg NY is a Single Family for sale in Hamburg, NY, 14075. It is listed for $569,900 and features 5 beds, 3 baths, and has approximately 2,945 square feet of living space, and was originally constructed in 1914. The current price per square foot is $194. The average price per square foot for Single Family listings in Hamburg is $205. The average listing price for Single Family in Hamburg is $350,588.
Similar Listings Nearby
Courtesy of Keller Williams Realty WNY. Disclaimer: All data relating to real estate for sale on this page comes from the Broker Reciprocity (BR) of the New York State Alliance of MLSs. Detailed information about real estate listings held by brokerage firms other than Michael Paduano include the name of the listing broker. Neither the listing company nor Michael Paduano shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. The Broker providing this data believes it to be correct, but advises interested parties to confirm any item before relying on it in a purchase decision. Copyright 2026. New York State Alliance of MLSs. All rights reserved. 5274 Columbia Avenue
Hamburg, NY