$699,900

5222 Columbia Avenue, Hamburg, NY 14075

  • 3 beds |
  • 3 baths |
  • 2,938 sqft
  • Property Icon Single-Family Home
  • Property Year Built Icon Built in 1911
  • Property Lot Size Icon0.77acre lot
  • Property Parking Icon 2 car garage
  • Property Price Per Square Feet Icon $238/sqft
  • Property List Date Icon Listed 2 days ago

Property Description

Welcome to this exceptional residence where timeless elegance meets modern comfort! From the moment you enter you'll be captivated by the nearly 3000 Sq Ft of architectural details. Gleaming hardwood floors throughout 1st Floor-custom windows-crafted trim work-built in cabinetry. The remodeled kitchen showcases exotic granite counters, generous size breakfast bar plus island and all appliances stay! Stylish glass door accents-wine chiller-cool trendy lights and fans! Open concept family room has a contemporary feel - w/ gas fireplace w/granite hearth-entertaining continues in formal dining room w/custom paint & texture treatment applied to walls-adjacent is a luxurious covered "pillared" veranda bordered by lush ferns and a privacy fence. The 30x15 front living room has a newer stunning "picture" window, gas fireplace and features a grand entrance coming from front concrete porch. Three lovely bdrms on second floor with a convenient 2nd floor laundry. The primary suite has its own bath and incredible home office. The office has a panoramic view of picturesque backyard! This yard is an outdoor retreat with a large patio - outdoor fireplace and a fun filled hot tub! Party size concrete drive parks 20+ cars! Garage has newer overhead doors. Deeded beach rights! Seller desires highest and best, no escalation clauses - Offers due Monday 7/6/26 @ 5pm. Seller cannot close before 9/1/26.

Listing Status:
Active
Date Added:
June 24, 2026
Data Last Updated:
June 26, 2026 at 7:16AM
Listing Office:
HUNT Real Estate Corporation : 716-648-2300
Listing Agent:
Patricia Manns : 716-870-2426
MLS ID:
B1693450
  • General: Breakfast BarSeparate/Formal Dining RoomEntrance FoyerEat-in KitchenSeparate/Formal Living RoomHome OfficeCountry KitchenPull Down Attic StairsSliding Glass Door(s)
  • Appliances: DishwasherFree-Standing RangeGas Water HeaterMicrowaveOvenRefrigerator
  • Laundry: Upper Level
  • Basement: Partial
  • Flooring: CarpetHardwoodVaries
  • A/C: Central Air
  • Heating: GasForced Air
  • Fireplace: FireplaceFireplaces: 2
  • General: Concrete DrivewayHot Tub/SpaPatio
  • Style: ColonialTwo StoryTraditionalTransitional
  • Other Structures: PorchPatioCoveredOpen
  • Parking: DetachedGarageDriveway
  • Roofing: Asphalt
  • General: OtherVinyl Siding2OtherSee Remarks
  • Road/Access: City Street
  • Originating MLS: NYS_B
  • School District: Frontier
  • County: Erie
  • Zoning: 144889-181-060-0002-017-000
  • Utilities: Cable AvailableElectricity ConnectedSewer ConnectedWater ConnectedCircuit Breakers
  • Water: ConnectedPublic
  • Sewer: Connected
  • Source: NYS_B

This listing courtesy of Patricia Manns , HUNT Real Estate Corporation

Monthly Payment

$Est. Payment
  • Principal & Interest $
  • Property Taxes $
  • Home Insurance $
  • VA Funding Fee $

Ready to Start a VA Loan?

Get Started Veterans United Home LoansNMLS #1907  †
Interest rates used in the VA mortgage calculator are shown for illustrative purposes only. Your rate may differ based on a variety of factors, including your credit score and the current market conditions. To get your personalized interest rate, start your quote online.

Location

Similar Listing