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. Showings begin Wednesday March 13th at 9am. Offers should be received by Wednesday May 20th at 1pm

Listing Status:

Active

Date Added:

May 11, 2026

Data Last Updated:

May 12, 2026 at 4: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