5274 Columbia Avenue, Hamburg, NY 14075
Local realty services provided by:CENTURY 21 North East
Listed by: joshua james
Office: keller williams realty wny
MLS#:B1705787
Source:NY_GENRIS
Price summary
- Price:$569,900
- Price per sq. ft.:$193.51
About this home
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....
Contact an agent
Home facts
- Year built:1914
- Subdivision & Development:Holland Land Company's Su
- Listing ID #:B1705787
- Added:77 day(s) ago
- Updated:October 28, 2026 at 03:34 PM
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: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:$569,900
- Price per sq. ft.:$193.51
- 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:Circular Driveway, Detached, Garage, Garage Door Opener
- Garage:Yes
- Garage spaces:2
New listings near 5274 Columbia Avenue
- Open Sat, 11am to 1pmNew
$264,900Active3 beds 2 baths1,448 sq. ft.4209 Polly Lane, Hamburg, NY 14075
MLS# B1725248Listed by: MLS NATION REALTY LLC - Open Wed, 5 to 7pmNew
$335,000Active4 beds 2 baths1,638 sq. ft.170 Maple Avenue, Hamburg, NY 14075
MLS# B1724556Listed by: HUNT REAL ESTATE ERA - New
$399,000Active3 beds 3 baths2,115 sq. ft.3540 Heatherwood Drive, Hamburg, NY 14075
MLS# B1724960Listed by: HUNT REAL ESTATE ERA - Open Sat, 11am to 1pmNew
$359,000Active3 beds 3 baths1,816 sq. ft.3011 -L#23 Cloverbank Road, Hamburg, NY 14075
MLS# B1725073Listed by: HOWARD HANNA WNY INC. - New
$349,900Active3 beds 2 baths1,444 sq. ft.148 E Union Street, Hamburg, NY 14075
MLS# B1724390Listed by: CENTURY 21 NORTH EAST - Open Sat, 11am to 1pmNew
$299,000Active3 beds 1 baths1,528 sq. ft.6261 Southwestern Blvd, Hamburg, NY 14075
MLS# B1724997Listed by: HOWARD HANNA WNY INC. - New
$279,000Active3 beds 2 baths1,536 sq. ft.2623 Hakanaw Avenue, Hamburg, NY 14075
MLS# B1724560Listed by: MJ PETERSON REAL ESTATE INC. - New
$429,900Active2 beds 2 baths1,422 sq. ft.4740 Parker Road #26, Hamburg, NY 14075
MLS# B1724387Listed by: HUNT REAL ESTATE ERA - Open Sat, 1 to 3pmNew
$500,000Active4 beds 3 baths2,435 sq. ft.4566 Copperfield Drive, Hamburg, NY 14075
MLS# B1724455Listed by: HOWARD HANNA WNY INC. - Open Sat, 2 to 4pmNew
$249,900Active3 beds 1 baths975 sq. ft.6196 Wright Place, Hamburg, NY 14075
MLS# B1724704Listed by: KELLER WILLIAMS REALTY WNY