Brianna Huynh

5274 Columbia Avenue, Hamburg, NY 14075

New - 3 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 brianna-huynh.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: Brianna Huynh
Agent Phone: (518) 925-3431 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Login to My Homefinder