Skip main navigation
Off market
  • $403,100

    5153 Columbia Ave, Hamburg, NY 14075

    4beds
    2,183sqft
    SingleFamily
    Built in 1927
    9,147 Square Feet Lot
    $403,100 Zestimate®
    $185/sqft
    $3,561 Estimated rent

    Home value

    $403,100

    $375,000 - $431,000

    $3,561/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,561/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,561/mo

    Rent Zestimate®

    Refinance and save

    $2,763/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $2,763/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Stunning and Unique!This totally remodeled 4BR, 2.5 Bath Colonial adjacent to Wanakah Country Club boasts a Totally Open Concept on the entire first level!The natural lighting is amazing!Kitchen w/Eating Area, Formal Dining Room and Living Room flow together for wonderful entertaining spaces;Sliding Doors lead to the full length porch and stamped patio to add to the wide open feel;HUGE MBR suite with Whirlpool tub;All BRs have generous closets;Dual heating and AC systems provide zoned comfort and added efficiency in this large home; XL hot water tank so you'll never have a cold shower;Full, tall, dry basement could be additional living space or LOTS of storage;Laundry Room/Mudroom is so convenient! W/in 10 yrs: roof, HWT, Furnace/AC, Sump pump, windows, doors, siding. Showings start now!

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Gas
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Garbage disposal, Microwave, Range / Oven, Refrigerator
    • Laundry: Laundry-1st Floor
    Features
    • Kitchen Island, Pantry, Great Room, Sump Pump, Granite Counters, Eat-in Kitchen, Whirlpool Tub, Bonus Room, Circuit Breakers - Some, Copper Plumbing - Some, Sliding Glass Door, Foyer/Entry Hall, Laundry-1st Floor, Master Bedroom Bath
    • Flooring: Carpet, Hardwood, Linoleum / Vinyl
    • Doors: Sliding Glass Door
    • Basement: Partially finished
    • Attic: Crawl Space, Scuttle
    Interior area
    • Total interior livable area: 2,183 sqft

    Property

    Parking
    • Parking features: Garage - Detached
    Features
    • Exterior features: Vinyl
    • Spa features: Bath
    Lot
    • Size: 9,147 Square Feet
    • Features: Rectangular Lot, Neighborhood Street, Near Public Transit, Beach/Water Access - See Remarks
    Details
    • Additional structures: Garage(s), Shed/Storage
    • Parcel number: 1448891691821
    • Special conditions: Normal
    • Wooded area: 0

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Two Story
    Materials
    • Metal
    • Roof: Asphalt
    Condition
    • Existing
    • Year built: 1927

    Utilities & green energy

    • Electric: Circuit Breakers - Some
    • Gas: Gas
    • Sewer: Sewer Connected
    • Water: Public

    Community & HOA

    Location
    • Region: Hamburg

    Financial & listing details

    • Price per square foot: $185/sqft
    • Tax assessed value: $373,800

    Price history

    DateEventPrice
    6/7/2019Sold$255,000+2%$117/sqft
    Source: NYSAMLSs #B1182942 Report a problem
    4/29/2019Pending sale$250,000$115/sqft
    Source: Howard Hanna - West Seneca #B1182942 Report a problem
    4/16/2019Price change$250,000-2%$115/sqft
    Source: Howard Hanna - West Seneca #B1182942 Report a problem
    4/4/2019Listed for sale$255,000+27.5%$117/sqft
    Source: Howard Hanna #B1182942 Report a problem
    1/22/2011Listing removed$200,000$92/sqft
    Source: Realty USA #373989 Report a problem
    9/11/2010Price change$200,000-7%$92/sqft
    Source: Realty USA #370994 Report a problem
    9/8/2010Price change$215,000-2.2%$98/sqft
    Source: Realty USA #370994 Report a problem
    6/5/2010Price change$219,900-4.3%$101/sqft
    Source: Realty USA #357192 Report a problem
    5/1/2010Price change$229,900-4.2%$105/sqft
    Source: Realty USA #357192 Report a problem
    3/10/2010Listed for sale$239,900+182.2%$110/sqft
    Source: Realty USA #357192 Report a problem
    9/25/2008Sold$85,000-5.5%$39/sqft
    Source: Public Record Report a problem
    4/29/2008Listing removed$89,900$41/sqft
    Source: Listhub Report a problem
    4/22/2008Listed for sale$89,900-10.1%$41/sqft
    Source: Listhub Report a problem
    12/15/2000Sold$100,000$46/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $108,400
    2024-- $108,400
    2023-- $108,400
    2022-- $108,400
    2021-- $108,400
    2020-- $108,400 +35.5%
    2019-- $80,000
    2018-- $80,000
    2017$3,540 +93.3%$80,000
    2016$1,831 $80,000
    2015-- $80,000
    2014-- $80,000
    2013-- $80,000
    2012-- $80,000
    2011-- $80,000
    2010-- $80,000
    2009-- $80,000 -18.5%
    2008-- $98,100
    2007-- $98,100
    2006-- $98,100
    2005-- $98,100
    2004-- $98,100
    2003-- $98,100
    2002-- $98,100
    2001-- $98,100
    2000-- $98,100
    Find assessor info on the county website

    Neighborhood: 14075

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Frontier

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.