5274 Columbia Avenue, Hamburg, NY 14075
Local realty services provided by:CENTURY 21 North East
5274 Columbia Avenue,Hamburg, NY 14075
$579,900
- 5 Beds
- 3 Baths
- 2,945 sq. ft.
- Single family
- Pending
Listed by: joshua james
Office: keller williams realty wny
MLS#:B1660978
Source:NY_GENRIS
Price summary
- Price:$579,900
- Price per sq. ft.:$196.91
About this home
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. 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....
Contact an agent
Home facts
- Year built:1914
- Listing ID #:B1660978
- Added:55 day(s) ago
- Updated:April 03, 2026 at 07:55 AM
Rooms and interior
- Bedrooms:5
- Total bathrooms:3
- Full bathrooms:2
- Half bathrooms:1
- Rooms Total:14
- Flooring:Hardwood, Tile, Varies
- Dining Description:Separate Formal Dining Room
- Kitchen Description:Dishwasher, Refrigerator
- Basement:Yes
- Basement Description:Full, Sump Pump
- Living area:2,945 sq. ft.
Heating and cooling
- Cooling:Central Air
- Heating:Forced Air, Gas, Radiant Floor
- Central air:Yes
Structure and exterior
- Roof:Shingle
- Year built:1914
- Building area:2,945 sq. ft.
- Lot area:0.43 Acres
- Lot Features:On Golf Course, Rectangular, Residential Lot
- Architectural Style:Colonial, Traditional, Two Story
- Construction Materials:Copper Plumbing, Vinyl Siding
- Exterior Features:Fully Fenced, Hot Tub Spa, Open, Pool, Porch
- Foundation Description:Block
- Levels:2 Stories
Schools
- High school:Frontier Senior High
- Middle school:Frontier Middle
Utilities
- Water:Connected, Public, Water Connected
- Sewer:Connected, Sewer Connected
Finances and disclosures
- Price:$579,900
- Price per sq. ft.:$196.91
- Tax amount:$10,153
Features and amenities
- Appliances:Dishwasher, Dryer, Gas Range, Refrigerator, Washer
- Laundry features:Dryer, Upper Level, Washer
- Pool features:In Ground
Parking
- Parking description:Detached, Garage, Garage Door Opener
- Garage:Yes
- Garage spaces:2
New listings near 5274 Columbia Avenue
- Open Sat, 11am to 1pmNew
$399,900Active3 beds 2 baths1,718 sq. ft.3273 Brookfield Lane, Hamburg, NY 14075
MLS# B1669908Listed by: HUNT REAL ESTATE CORPORATION - New
$189,900Active5.2 Acres0 Erie, Derby, NY 14075
MLS# B1670246Listed by: WNY METRO ROBERTS REALTY - Open Sat, 1 to 3pmNew
$270,000Active3 beds 3 baths1,408 sq. ft.66 Kenton Place, Hamburg, NY 14075
MLS# B1669952Listed by: KELLER WILLIAMS REALTY WNY - New
$369,900Active3 beds 3 baths1,836 sq. ft.5009 Lake Shore Road, Hamburg, NY 14075
MLS# B1667852Listed by: HUNT REAL ESTATE CORPORATION - Open Sat, 11am to 1pm
$425,000Pending3 beds 3 baths2,046 sq. ft.4620 Thornwood Court, Hamburg, NY 14075
MLS# B1669009Listed by: KELLER WILLIAMS REALTY WNY - New
$379,900Active4 beds 4 baths2,174 sq. ft.204 Holiday Lane, Hamburg, NY 14075
MLS# B1669447Listed by: HUNT REAL ESTATE CORPORATION - New
$425,000Active5 beds 3 baths2,773 sq. ft.158 Lake Street, Hamburg, NY 14075
MLS# B1669658Listed by: HOWARD HANNA WNY INC. - Open Sat, 1 to 3pm
$200,000Pending3 beds 1 baths960 sq. ft.4815 Morgan Pkwy Parkway, Hamburg, NY 14075
MLS# B1669650Listed by: HOWARD HANNA WNY INC.
$249,900Pending2 beds 1 baths999 sq. ft.3373 Old Lakeview Road, Hamburg, NY 14075
MLS# B1669417Listed by: WNY METRO ROBERTS REALTY- New
$115,000Active11.47 AcresLakeview Road, Hamburg, NY 14075
MLS# B1669480Listed by: KELLER WILLIAMS REALTY WNY