5274 Columbia Avenue Hamburg, NY $ 579,900
5274 Columbia Avenue
$ 579,900
Recently Listed
Share Save

5274 Columbia Avenue

Hamburg, NY, 14075
$ 579,900
Bedrooms5 Baths2.1 Sq 2,945

Monthly Estimate*

$ 3,571

5274 Columbia Avenue, Hamburg, NY 14075 - Image 1
5274 Columbia Avenue, Hamburg, NY 14075 - Image 2
5274 Columbia Avenue, Hamburg, NY 14075 - Image 3
5274 Columbia Avenue, Hamburg, NY 14075 - Image 4
5274 Columbia Avenue, Hamburg, NY 14075 - Image 5
5274 Columbia Avenue, Hamburg, NY 14075 - Image 6
5274 Columbia Avenue, Hamburg, NY 14075 - Image 7
5274 Columbia Avenue, Hamburg, NY 14075 - Image 8
5274 Columbia Avenue, Hamburg, NY 14075 - Image 9
5274 Columbia Avenue, Hamburg, NY 14075 - Image 10
5274 Columbia Avenue, Hamburg, NY 14075 - Image 11
5274 Columbia Avenue, Hamburg, NY 14075 - Image 12
5274 Columbia Avenue, Hamburg, NY 14075 - Image 13
5274 Columbia Avenue, Hamburg, NY 14075 - Image 14
5274 Columbia Avenue, Hamburg, NY 14075 - Image 15
5274 Columbia Avenue, Hamburg, NY 14075 - Image 16
5274 Columbia Avenue, Hamburg, NY 14075 - Image 17
5274 Columbia Avenue, Hamburg, NY 14075 - Image 18
5274 Columbia Avenue, Hamburg, NY 14075 - Image 19
5274 Columbia Avenue, Hamburg, NY 14075 - Image 20
5274 Columbia Avenue, Hamburg, NY 14075 - Image 21
5274 Columbia Avenue, Hamburg, NY 14075 - Image 22
5274 Columbia Avenue, Hamburg, NY 14075 - Image 23
5274 Columbia Avenue, Hamburg, NY 14075 - Image 24
5274 Columbia Avenue, Hamburg, NY 14075 - Image 25
5274 Columbia Avenue, Hamburg, NY 14075 - Image 26
5274 Columbia Avenue, Hamburg, NY 14075 - Image 27
5274 Columbia Avenue, Hamburg, NY 14075 - Image 28
5274 Columbia Avenue, Hamburg, NY 14075 - Image 29
5274 Columbia Avenue, Hamburg, NY 14075 - Image 30
5274 Columbia Avenue, Hamburg, NY 14075 - Image 31
5274 Columbia Avenue, Hamburg, NY 14075 - Image 32
5274 Columbia Avenue, Hamburg, NY 14075 - Image 33
5274 Columbia Avenue, Hamburg, NY 14075 - Image 34
5274 Columbia Avenue, Hamburg, NY 14075 - Image 35
5274 Columbia Avenue, Hamburg, NY 14075 - Image 36
5274 Columbia Avenue, Hamburg, NY 14075 - Image 37
5274 Columbia Avenue, Hamburg, NY 14075 - Image 38
5274 Columbia Avenue, Hamburg, NY 14075 - Image 39
5274 Columbia Avenue, Hamburg, NY 14075 - Image 40
5274 Columbia Avenue, Hamburg, NY 14075 - Image 41
5274 Columbia Avenue, Hamburg, NY 14075 - Image 42
5274 Columbia Avenue, Hamburg, NY 14075 - Image 43
5274 Columbia Avenue, Hamburg, NY 14075 - Image 44
5274 Columbia Avenue, Hamburg, NY 14075 - Image 45
5274 Columbia Avenue, Hamburg, NY 14075 - Image 46
5274 Columbia Avenue, Hamburg, NY 14075 - Image 47
5274 Columbia Avenue, Hamburg, NY 14075 - Image 48
5274 Columbia Avenue, Hamburg, NY 14075 - Image 49
5274 Columbia Avenue, Hamburg, NY 14075 - Image 50

Single Family Home for sale in Hamburg, NY

for $579,900 with 5 bedrooms and 2 full baths, 1 half bath. This 2,945 square foot home was built in 1914 on a lot size of 0.4293.

Welcome to 5274 Columbia; a luxury colonial situated on one of the most preeminent streets in Hamburg, steps from backing to Wanakah Country Club with private & deeded waterfront beach access to Lake Erie with incredible views off Beach Drive; your private 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 wood built-in bookshelves & gorgeous hardwood throughout the first floor. This exquisite home features a luxuriously designed kitchen with high-end, 36” custom Cherry cabinetry w/frosted glass, Granite counters w/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. First floor bedroom makes for ease of living with 4 more bedrooms upstairs, extra wide hallway, an additional two bathrooms & 2nd floor laundry is ideal. Step out the eat-in kitchen area w/heated floors to the beautifully redone, three-tiered wood deck with hot tub & Gazebo, leading down to a brand new, distinctive inground heated pool w/warranty. 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 the lakeview paradise with no expense spared on updates including pool, FP, 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 starting 2/11/26.

See more

Single Family Active

Price

$ 579,900

Bedrooms

5

Full Bath

2

Half Bath

1

Property Type

Single Family

Taxes

$ 10,153

Style

Colonial,TwoStory,Traditional

Lot Size

0.4293

Year Built

1914

Town/City

Hamburg

County/Region

Erie

MLS | Web ID

B1660978

Features
Interior
Interior Amenities BreakfastBar CeilingFans DryBar SeparateFormalDiningRoom EntranceFoyer EatInKitchen SeparateFormalLivingRoom GraniteCounters NaturalWoodwork BedroomOnMainLevel BathInPrimaryBedroom MainLevelPrimary P
Basement Full SumpPump
Flooring Hardwood Tile Varies
Total Fireplaces 1
Total Stories 2
Basement (Y/N) Yes
Air Conditioning Y/N Yes
Heating Y/N Yes
Fireplace Y/N Yes
Half Baths 1
Laundry Features UpperLevel
Total Bedrooms 5
Main Level Bedrooms 1
Main Level Bathrooms 1
Total Baths 3
See more
General
Sewer Connected
Heating Gas ForcedAir RadiantFloor
Cooling CentralAir
Utilities ElectricityConnected SewerConnected WaterConnected
Possession Closing
Roof Architectural Shingle
Appliances AppliancesNegotiable Dryer Dishwasher GasOven GasRange GasWaterHeater Refrigerator Washer
Garage Spaces 2.0
Patio/Porch Features Open Porch
Architectural Style Colonial TwoStory Traditional
Pool Features InGround
Construction Materials VinylSiding CopperPlumbing
School District Frontier
Year Built 1914
Electric CircuitBreakers
Stories Count 2
Township Not Applicable
Levels Two
Property Subtype SingleFamilyResidence
Waterfront Features BeachAccess DeededAccess Lake
County Erie
Property Type Residential
Attached Garage No
Subdivision Name Holland Land Company
Garage Y/N Yes
Other Structures Sheds Storage
Total Rooms 14
Full Baths 2
Status Active
Directions Take Lake Shore Road going south. Turn left onto Columbia Avenue. House will be on the right.
High School Frontier Senior High
City Hamburg
Body of Water Lake Erie
Senior Community Y/N No
High School District Frontier
Number Of Units Total 0
MLS Area Hamburg-144889
Lot Size Units Acres
Lot Size Square Feet 18700.0
Year Built Details Existing
Tax Annual Amount 10153.0
Middle/Junior High School Frontier Middle
Property Condition Resale
Standard Status Active
Middle/Junior School District Frontier
Elementary School District Frontier
Tax Assessed Value 157500
TaxOtherAnnualAssessmentAmount 0.0
Tax Lot 20
See more
Exterior
Exterior Amenities BlacktopDriveway FullyFenced HotTubSpa Pool
Fencing Full
Parking Features Detached Garage GarageDoorOpener
Lot Features OnGolfCourse Rectangular RectangularLot ResidentialLot
Water Source Connected Public
Lot Size Area 0.4293
Foundation Details Block
Spa Yes
Building Area Total 2945.0
Lot Dimensions 110X170
Lot Size Acres 0.4293
Waterfront Y/N No
Road Frontage Type CityStreet MainThoroughfare
See more
Internal Only
Street Number 1 5274
See more
* Excluded Features
List By
Keller Williams Realty Wny

Broker

(716) 697-3280

Phone

Affordability Calculator

$4,417
Per Month
81%
19%
0%
Monthly Principal & Interest
$3,571
Monthly Property Taxes
$846
Monthly Home Insurance
--
Default based on a 30-year fixed rate of 6.25% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save

Discover how much house you can afford

Your dream home may be within reach.

Learn More about how to save

The time to sell is now
THE TIME TO SELL IS NOW! What's my home worth?
Nearby
246837 Elementary School
3040027 Middle School
Frontier Senior High High School
Pricing History
DatePricePrice ChangeDescription
2/6/2026$579,900 Listed Price

Map


See all

5274 Columbia Avenue, Hamburg, NY, 14075 is a Single Family Home for sale at $579,900 with 2,945 sqft and a lot size of 0.4293. 5274 Columbia Avenue has 5 bedrooms, 2.1 baths, and was built in 1914. The property's zip code is 14075 which is in Hamburg, NY