- 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
Exterior Features
Blacktop Driveway, Fully Fenced, Hot Tub Spa, Pool
Appliances
Appliances Negotiable, Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Washer
Flooring
Hardwood, Tile, Varies
Sewer
Connected
Cooling
Central Air
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
Construction
Year Built
Year Built: 1914
Home type
Single Family Residence
Property Condition
Resale
Foundation Details
Block
Architectural Style
Colonial, Two Story, Traditional
Construction Materials
Vinyl Siding, Copper Plumbing
Roof
Architectural, Shingle
Utilities & Energy
Pool Features
In Ground
Laundry Features
Upper Level
Electric
Circuit Breakers
Water Source
Connected, Public
Basement
Full, Sump Pump
Utilities
Cable Available, Electricity Connected, High Speed Internet Available, Sewer Connected, Water Connected
Parking Features
Detached, Garage, Circular Driveway, Garage Door Opener, Other
Other Features
Lot Features
Rectangular, Rectangular Lot, Residential Lot
Subdivision Name
Holland Land Company's Su
Patio And Porch Features
Open, Porch
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