Clayton Sitterly
Licensed Associate Real Estate Broker
REALTOR®
Johnstown, NY

5274 Columbia Avenue, Hamburg, NY 14075

New - 4 Hours Ago
View Full Photo Gallery

Property Description

Welcome to 5274 Columbia; a luxury colonial situated on one of the most preeminent streets in Hamburg, steps from Wanakah Country Club with private & deeded waterfront beach access to Lake Erie and incredible views off Beach Drive; your personal and serene 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 built-in bookshelves & gorgeous hardwood throughout the first floor. This exquisite home features a luxuriously designed kitchen with high-end, 36 custom Cherry cabinetry with frosted glass accents, Granite counters with an 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. The first floor bedroom makes for ease of living with 4 more bedrooms upstairs, an extra wide hallway, while the additional two bathrooms & 2nd floor laundry is ideal. Step out of the dining nook area that has heated floors to the beautifully refinished, 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 a lakeview paradise with no expense spared on updates including in-ground pool, firepalce, 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 beginning immediately.

5274 Columbia Avenue | MLS# B1705787

This single family home located at 5274 Columbia Avenue, Hamburg, NY 14075 is currently listed for sale with an asking price of $569,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's Su subdivision within the Frontier school district. Search Holland Land Company's Su real estate on clayton-sitterly.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Full, SumpPump
Cooling: CentralAir
Fenced: Yes
Fireplaces: 1
Garage: 2
Heating: Gas, ForcedAir, RadiantFloor
Home Style: Colonial, TwoStory, Traditional
Lot Size: 0.43 Acres
Roof Type: Architectural, Shingle
Stories: 2.0
Taxes: $10,153
Year Built: 1914

Amenities

BreakfastBar
CeilingFans
DryBar
SeparateFormalDiningRoom
EntranceFoyer
EatInKitchen
SeparateFormalLivingRoom
GraniteCounters
NaturalWoodwork
BedroomOnMainLevel
BathInPrimaryBedroom
MainLevelPrimary
PrimarySuite
ProgrammableThermostat
BlacktopDriveway
FullyFenced
HotTubSpa
Pool

Feature Descriptions

Appliances: AppliancesNegotiable, Dryer, Dishwasher, GasOven, GasRange, GasWaterHeater, Refrigerator, Washer
Body of Water: Lake Erie
Exterior: VinylSiding, CopperPlumbing
Fencing: Full
Flooring: Hardwood, Tile, Varies
Laundry: UpperLevel
Lot: Rectangular, RectangularLot, ResidentialLot
Lot Dimensions: 110X170
Parcel#: 144889-181-060-0002-020-100
Parking: Detached, Garage, CircularDriveway, GarageDoorOpener, Other
Parking Notes: Detached, Garage, CircularDriveway, GarageDoorOpener,
Patio/Porch: Open, Porch
Pool: InGround
Sewer: Connected
Spa: Yes
Swimming Pool: Yes
Utilities: CableAvailable, ElectricityConnected, HighSpeedInternetAvailable, SewerConnected, WaterConnected
Water: Connected, Public
Water Features: BeachAccess, DeededAccess, Lake

Local Schools

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

Estimate Your Payment

Estimated Payment

$ 2,280.65 per month $1,268.35 Principal & Interest $846.08 Property Tax $166.22 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: Clayton Sitterly
Agent Phone: (518) 774-6635 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

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 08/12/2026. The listing information on this page last changed on 08/12/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 Wed 08/12/2026 12:36:32 AM EST) or Global MLS (last updated Wed 08/12/2026 12:22:28 AM EST) or New York State Alliance MLS (last updated Wed 08/12/2026 12:34:59 AM EST) or Hudson Valley Catskill Region MLS (last updated Wed 08/12/2026 12:11:13 AM EST) or Berkshire MLS (last updated Tue 08/11/2026 8:13:14 PM EST) or OneKey MLS (last updated Wed 08/12/2026 12:28:22 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime 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.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder