- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
$569,900
Monthly Est:$2,837
5 Beds
- 3 Baths
2 full baths + 1 half bath
2,945sqft
5274 Columbia Ave, Hamburg, NY 14075
$569,900
$2,837/moEst:
Get Pre-Approved
Single Family Residence
Built in 1914
$-- HOA
0.43 acre lot
$194/sq.ft
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.
- Houzeo last checked: 12 hours ago
- Listing updated: August 12, 2026 at 10:12 am
- Listing Provided by: Joshua James (716) 697-3280 DRE #10301210944 | Keller Williams Realty WNY (716) 832-3300
- Source: New York State Alliance of MLSs, Buffalo-NY | MLS#: B1705787

Property Details
Status
Active
Type
Single Family Residence
No. of Stories
2
County
City
Neighborhood
--
Year Built
1914
HOA Fees
-
Finished Area
2,945 sqft
Lot Size
0.43 acre lot
Basement Area
- sqft
MLS Name
New York State Alliance of MLSs, Buffalo
MLS Number
B1705787
MLS Status
Active
Days on Market
61
Cumulative Days on Market
61

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 5
Bathrooms: 3
Interior
Flooring
Hardwood, Tile, Varies
Exterior Features
Blacktop Driveway, Fully Fenced, Hot Tub Spa, Pool
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
Heating
Gas, Forced Air, Radiant Floor
Appliances
Appliances Negotiable, Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Washer
Cooling
Central Air
Sewer
Connected
Construction
Year Built
Year Built: 1914
Home type
Single Family Residence
Roof
Architectural, Shingle
Construction Materials
Vinyl Siding, Copper Plumbing
Property Condition
Resale
Architectural Style
Colonial, Two Story, Traditional
Foundation Details
Block
Utilities & Energy
Laundry Features
Upper Level
Parking Features
Detached, Garage, Circular Driveway, Garage Door Opener, Other
Electric
Circuit Breakers
Pool Features
In Ground
Basement
Full, Sump Pump
Water Source
Connected, Public
Utilities
Cable Available, Electricity Connected, High Speed Internet Available, Sewer Connected, Water Connected
Other Features
Lot Features
Rectangular, Rectangular Lot, Residential Lot
Patio And Porch Features
Open, Porch
Subdivision Name
Holland Land Company's Su
Price History
| Date | Event | Price |
|---|---|---|
08/12/2026 Source: | Off Market | $569,900 $194/sqft |
08/12/2026 Source: | Listed for Sale | $569,900 -1.72% $194/sqft |
07/25/2026 Source: | Listing Removed | $579,900 $197/sqft |
06/04/2026 Source: | Listed for Sale | $579,900 $197/sqft |
06/04/2026 Source: | Off Market | $579,900 $197/sqft |
Show more
Getting Around 5274 Columbia Ave
Bike Score®
Somewhat Bikeable
32/100
Walk Score®
Car-Dependent
11/100
Data provided by Redfin
Nearby Homes
Find Homes by Property Features in Hamburg, NY
Nearby New Homes For Sale
Based on data from the New York State Alliance of MLSs (CNYIS, Inc., UNYREIS and WNYREIS) through Oct 12, 2026, 10:30AM.. All information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable by is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 the New York State Alliance of MLSs. All Rights Reserved.
Advertising Broker: Derek Greene | The Greene Realty Group