5274 Columbia AVE, Hamburg, NY 14075
See all 50 photos
5274 Columbia AVE, Hamburg, NY 14075
5274 Columbia AVE, Hamburg, NY 14075
5274 Columbia AVE, Hamburg, NY 14075
5274 Columbia AVE, Hamburg, NY 14075
REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your advisor will contact you to discuss available opportunities.
In-PersonVirtual Tour
$ 579,900
Est. payment /mo
Save
Active

5274 Columbia AVE Hamburg, NY 14075

5 Beds

3 Baths

2,945 SqFt


UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 2,945 sqft

Price per Sqft $196

Subdivision Holland Land Company

MLS Listing ID B1660978

Style Colonial,Two Story,Traditional

Bedrooms 5

Full Baths 2

Half Baths 1

Construction Status Existing

HOA Y/N No

Year Built 1914

Annual Tax Amount $10,153

Lot Size 0.429 Acres

Acres 0.4293

Lot Dimensions 110X170

Property Sub-Type Single Family Residence

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 beginning immediately.

Location

State NY

County Erie

Community Holland Land Company

Area Hamburg-144889

Direction Take Lake Shore Road going south. Turn left onto Columbia Avenue. House will be on the right.

Body of Water Lake Erie

Rooms

Basement Full, Sump Pump

Main Level Bedrooms 1

Interior

Interior Features 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

Heating Gas, Forced Air, Radiant Floor

Cooling Central Air

Flooring Hardwood, Tile, Varies

Fireplaces Number 1

Fireplace Yes

Appliance Appliances Negotiable, Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Washer

Laundry Upper Level

Exterior

Exterior Feature Blacktop Driveway, Fully Fenced, Hot Tub/Spa, Pool

Parking Features Detached

Garage Spaces 2.0

Fence Full

Pool In Ground

Utilities Available Electricity Connected, Sewer Connected, Water Connected

Waterfront Description Beach Access,Deeded Access,Lake

Roof Type Architectural,Shingle

Porch Open, Porch

Garage Yes

Building

Lot Description On Golf Course, Rectangular, Rectangular Lot, Residential Lot

Story 2

Foundation Block

Sewer Connected

Water Connected, Public

Architectural Style Colonial, Two Story, Traditional

Level or Stories Two

Additional Building Shed(s), Storage

Structure Type Vinyl Siding,Copper Plumbing

Construction Status Existing

Schools

Middle Schools Frontier Middle

High Schools Frontier Senior High

School District Frontier

Others

Senior Community No

Tax ID 144889-181-060-0002-020-100

Acceptable Financing Cash, Conventional, FHA, VA Loan

Listing Terms Cash, Conventional, FHA, VA Loan

Special Listing Condition Standard


Listed by Keller Williams Realty WNY 716-697-3280

NEARBY SCHOOLS & PROPERTIES

Michelle Thompson

Michelle Thompson

Lic. RE Salesperson | License ID: 40FA1156159

+1(315) 794-3260

GET MORE INFORMATION

Name
Phone*
Message

Go tour this home

5274 Columbia AVE