Gianna Rosania
Licensed Real Estate Salesperson
REALTOR®
Walton, NY
Office: (607) 865-7000 (347) 870-0941
social icon 

5274 Columbia Avenue, Hamburg, NY 14075

Pending

50 Total Photos [Click to View All]

Property Description

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.

5274 Columbia Avenue | MLS# B1660978

This single family home located at 5274 Columbia Avenue, Hamburg, NY 14075 is currently listed for sale with an asking price of $579,900. This property was built in 1914 and has 5 bedrooms and 2 full and 1 partial baths with 2945 sq. ft. Columbia Avenue is located in the Holland Land Company subdivision within the Frontier school district. Search Holland Land Company real estate on gianna-rosania.timberlandproperties.com today.

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Full, Sump Pump
Cooling: Central Air
Fenced: Yes
Fireplaces: 1
Garage: 2
Heating: Gas, Forced Air, Radiant Floor
Home Style: Colonial, Two Story, Traditional
Lot Size: 0.43 Acres
Roof Type: Architectural, Shingle
Stories: 2.0
Taxes: $10,153
Year Built: 1914

Amenities

Breakfast Bar
Ceiling Fan(s)
Dry Bar
Separate/Formal Dining Room
Entrance Foyer
Eat-in Kitchen
Separate/Formal Living Room
Granite Counters
Natural Woodwork
Bedroom on Main Level
Bath in Primary Bedroom
Main Level Primary
Primary Suite
Blacktop Driveway
Fully Fenced
Hot Tub/Spa
Pool

Feature Descriptions

Appliances: Appliances Negotiable, Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Washer
Body of Water: Lake Erie
Days on Site: 25
Exterior: Vinyl Siding, Copper Plumbing
Fencing: Full
Flooring: Hardwood, Tile, Varies
Hot Tub: Yes
Laundry: Upper Level
Lot: On Golf Course, Rectangular, Rectangular Lot, Residential Lot
Lot Dimensions: 110X170
Parcel#: 144889-181-060-0002-020-100
Parking: Detached, Garage, Garage Door Opener
Parking Notes: Detached, Garage, Garage Door Opener
Patio/Porch: Open, Porch
Pool: In Ground
Sewer: Connected
Spa: Yes
Swimming Pool: Yes
Utilities: Electricity Connected, Sewer Connected, Water Connected
Water: Connected, Public
Water Features: Beach Access, Deeded Access, Lake

Local Schools

High School: Frontier Senior High
Middle School: Frontier Middle
School District: Frontier

Estimate Your Payment

Estimated Payment

$ 2,305.83 per month $1,290.61 Principal & Interest $846.08 Property Tax $169.14 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Keller Williams Realty WNY
Agency Contact: 716-697-3280

Shown By

Agent Name: Gianna Rosania
Agent Phone: (347) 870-0941
Agency Title: Timberland Properties

IDX logo

All information is deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither broker(s), nor agent(s) shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless. Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 03/03/2026. The listing information on this page last changed on 03/03/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Tue 03/03/2026 1:12:46 AM EST) or Global MLS (last updated Tue 03/03/2026 1:06:55 AM EST) or New York State Alliance MLS (last updated Tue 03/03/2026 1:10:29 AM EST) or Hudson Valley Catskill Region MLS (last updated Tue 03/03/2026 12:11:14 AM EST) or OneKey MLS (last updated Tue 03/03/2026 1:10:05 AM EST). Real estate listings held by brokerage firms other than Timberland Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

All information is deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither broker(s), nor agent(s) shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless.

Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel