Skip To Content

5274 Columbia Avenue

Hamburg, NY 14075
  • $569,900
  • STATUS: Active
  • ON SITE: 26 Days
  • MLS #: B1705787
UPDATED: 101 min ago
$569,900
  • 5
    BEDS
  • 0.43
    ACRES
  • 2
    BATHS
  • 1
    1/2 BATHS
  • 2,945
    SQFT
  • $194
    $/SQFT
Neighborhood:
Type:
Single-Family Home
Built:
1914
County:

School Information

Middle School:
High School:
School District:

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.

Monthly Payment Calculator

©2026 CNYIS, GENRIS, WNYREIS. All rights reserved. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither the listing broker(s) nor 716 Realty Group WNY shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless.

The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS’s. Real estate listings held by firms other than 716 Realty Group WNY are marked with the IDX logo and detailed information about them includes the Listing Broker’s Firm Name. Data last updated: 2026-09-08T00:14:10.783.
www.716realtygroup.com/homes/180061532
Print Image

5274 Columbia Avenue Hamburg, NY 14075

  • Price: $569,900
  • Status: Active
  • On Site: 26 Days
  • Updated: 101 min ago
  • MLS #: B1705787
5
Beds
2
Baths
1
½ Baths
0.43
Acres
2,945
SQFT
$194
$/SQFT
1914
Built
Neighborhood:
Hamburg-144889
County:
Erie
Area:
Hamburg-144889
Middle School:
Frontier Middle
High School:
Frontier Senior High
School District:
Frontier
Property 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.
Exterior Features

Architectural Style Colonial Two Story Traditional Attached Garage YN No Construction Materials Vinyl Siding Copper Plumbing Exterior Features Blacktop Driveway Fully Fenced Hot Tub / Spa Pool Fencing Full Frontage Length 250 Garage YN Yes 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 Road Frontage Type City Street Main Thoroughfare Roof Architectural Shingle Water Body Name Lake Erie Waterfront Features Beach Access Deeded Access Lake Waterfront YN Yes

Interior Features

Appliances Appliances Negotiable Dryer Dishwasher Gas Oven Gas Range Gas Water Heater Refrigerator Washer Basement Full Sump Pump Basement YN Yes Cooling Central Air Cooling YN Yes Fireplace YN Yes Fireplaces Total 1 Flooring Hardwood Tile Varies Foundation Details Block Heating Gas Forced Air Radiant Floor Heating YN Yes Interior Features Breakfast Bar Ceiling Fan(s) 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 Living Area 2945 Main Level Bedrooms 1

Property Features

Electric Circuit Breakers Listing Terms Cash Conventional FHA VA Loan Pool Features In Ground Possession Close Of Escrow Property Condition Resale Property Sub Type Single Family Residence Sewer Connected Spa YN Yes Special Listing Conditions Standard Tax Annual Amount 10153 Utilities Cable Available Electricity Connected High Speed Internet Available Sewer Connected Water Connected Water Source Connected Public Year Built Details Existing

Greater Rochester Association of Realtors logo Listing information © 2026 CNYIS, GENRIS, WNYREIS. Listing provided by Joshua James of Keller Williams Realty WNY : 716-697-3280.
©2026 CNYIS, GENRIS, WNYREIS. All rights reserved. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither the listing broker(s) nor 716 Realty Group WNY shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless.

The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS’s. Real estate listings held by firms other than 716 Realty Group WNY are marked with the IDX logo and detailed information about them includes the Listing Broker’s Firm Name. Data last updated: 2026-09-08T00:14:10.783.
 
https://bt-photos.global.ssl.fastly.net/rochester/orig_boomver_1_B1705787-2.jpg https://bt-photos.global.ssl.fastly.net/rochester/orig_boomver_1_B1705787-2.jpg https://bt-photos.global.ssl.fastly.net/rochester/orig_boomver_1_B1705787-2.jpg
Logo
716 Realty Group WNY
1382 Hertel Avenue
Buffalo NY, 14216