5459 Columbia Avenue, Hamburg, NY 14075

• 3 beds |
• 1 bath |
• 1,208 sqft

Property Description

This well maintained 3-bedroom, 1-bath ranch is located on a highly sought-after dead-end street directly across from Lake Erie and next to Wanakah Country Club. Situated on a spacious .72-acre lot, this home offers the perfect blend of privacy, comfort, and outdoor enjoyment. The fenced-in yard features an in-ground pool with numerous updates completed within the last 5 years including a Loop-Loc cover, liner, heater, filter, child protective fence, and a variable speed pump installed just 2 weeks ago. Inside, the home offers a 300 sq ft kitchen extension providing additional living and entertaining space, cedar-lined closets, a cozy gas insert fireplace, and new 3-pane windows and slider completed just 2 years ago. Major mechanical updates include a boiler and hot water tank approximately 7 years old along with updated 150 amp electric service. Additional exterior highlights include a vinyl railing front porch, pergola, 1-car garage with a 2-car concrete side pad, and deeded private beach access. Enjoy all this in a desirable lakeside location with the convenience of nearby golf, beaches, and scenic views.

Listing Status:

Pending

Date Added:

May 11, 2026

Data Last Updated:

June 26, 2026 at 7:16AM

Listing Office:

Howard Hanna WNY Inc. : 716-825-0600

Listing Agent:

Aaron Spinnegan : 716-903-4354

MLS ID:

B1680158

Interior

• General: Cedar Closet(s)Eat-in KitchenPull Down Attic StairsSkylightsBedroom on Main Level
• Appliances: DryerGas OvenGas RangeGas Water HeaterRefrigeratorWasher
• Laundry: In Basement
• Basement: Full
• Flooring: Ceramic TileHardwoodVaries
• Heating: GasBaseboard
• Fireplace: FireplaceFireplaces: 1

Exterior

• General: Concrete Driveway
• Style: Ranch
• Parking: AttachedGarageHeated GarageOther

Construction

• Roofing: ArchitecturalShingle
• Windows: Skylight(s)
• General: Brick1Poured

Location

• Road/Access: City Street
• Originating MLS: NYS_B
• School District: Frontier
• County: Erie

Lot

• Zoning: 144889-181-100-0001-012-000

Utilities

• Utilities: High Speed Internet AvailableSewer ConnectedWater ConnectedCircuit Breakers
• Water: ConnectedPublic
• Sewer: Connected

Financial

• Source: NYS_B