0 of 61

Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

$569,900

Listing Price

5beds

2baths

2,945sqft

18,700sqft lot

5274 Columbia Ave, Hamburg, NY 14075

Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

For Sale

Off Market

Single Family

Home type

196.91

Price / sqft

1914

Year built

Home Details

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 chefs 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

Interior Details

Square Feet
  • 2945

Bedrooms
  • 5

Bathrooms
  • 2

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Forced Air With Air Conditioning

Cooling
  • Has Cooling:

    No

  • Cooling Type:

    N/A

Fuel
  • Has Fuel:

    Yes

  • Fuel Type:

    Oil

Basement
  • Has Basement:

    No

  • Basement Type:

    Partial

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    N/A

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 18700

Water
  • Yes

Sewer
  • Yes

Parking
  • Type:

    Garage, Detached

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    2

Deck
  • N/A

Patio
  • N/A

Fence
  • N/A

Pool
  • N/A

Porch
  • N/A

Stoop
  • N/A

Breezeway
  • N/A

Construction Details

Number of Stories
  • 2

Style
  • Traditional/old

Exterior
  • Aluminum/vinyl

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • N/A

Tax History

Year

Amount

Land

Improvement

Percent Change

Assessment

2020

$8,645

$11,400

$146,100

--%

$157,500

2018

$8,267

$11,400

$146,100

--%

$157,500

2017

$8,142

$11,400

$146,100

--%

$157,500

2016

$7,959

$11,400

$146,100

--%

$157,500

2015

$7,749

$11,400

$146,100

--%

$157,500

2013

$7,244

$11,400

$146,100

--%

$157,500

2011

$7,041

$11,400

$146,100

--%

$157,500

percent-home-icon

Average Home Price in 14075

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

$517,497

6 Beds

3.5 Baths

3,010 Sqft

25,125 Lot (sqft)

Sold 09/01/2026

$399,900

4 Beds

2 Baths

2,994 Sqft

15,960 Lot (sqft)

Sold 07/10/2025

$569,900

5 Beds

2 Baths

2,945 Sqft

18,700 Lot (sqft)

Sold 09/29/2026

$495,000

4 Beds

2 Baths

2,547 Sqft

37,200 Lot (sqft)

Sold 09/29/2026

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
569,900
$
Down payment
113,980
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
3,419.4
$
HOA (Monthly)
0
$
PMI
0
$
$3,689
Your Payment
Total Monthly Payment:$3,689
Percent of Income:63%
Affordable:No

Details for 5274 COLUMBIA AVE

Property Debt

Foreclosure Contact Details