NOT LISTED FOR SALE

5417 Columbia Ave Hamburg, NY 14075

Estimated Value: $423,000 - $489,000

4 Beds
2.5 Baths
2,661 Sq Ft
$171/Sq Ft Est. Value

Last Sold July 23, 2015

Last sale price $245,000 $92 Per Sq Ft

Est. 85% increase in value since last sale

Current estimated payment $2,866/month

1 Day on Market

Highlights

  • 0.81 Acre Lot
  • Deck
  • Cathedral Ceiling
  • Colonial Architecture
  • Wooded Lot
  • Wood Flooring

About This Home

As of July 2015

FABULOUS INTERIOR and great ONE ACRE lot!! Gorgeous hardwood floors in kitchen, LR, DR! Kitchen has glazed maple cabinets, island, granite counters, stainless appliances. Beautiful LR w/ granite raised hearth fireplace and open floor plan. DR has loads of windows to overlook 372' deep yard. Master suite is awesome: Sitting room, 9x6 walk-in & stunning tiled bath w/jacuzzi! Huge BRS on 2nd floor w/ great decor, 2nd flr bath w/ double sink, tiled floor,tub/shower. Lovely tiled front and side entries. All freshly painted. Gorgeous deep yard w/shed, 2 patios and deck. Furnace and A/C 2013.

Last Agent to Sell the Property

Lou Ann Spaulding

Listing by No Office Affiliation License #30SP0554350 Listed on: 05/18/2015

Last Buyer's Agent

David Lindstrom

Listing by HUNT Real Estate Corporation License #40LI1102880

HUNT Real Estate Corporation

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,453

Year Built

  • Built in 1957

Lot Details

  • 0.81 Acre Lot
  • Lot Dimensions are 372 x 95
  • Rectangular Lot
  • Wooded Lot

Home Design

  • Colonial Architecture
  • Block Foundation
  • Partial Copper Plumbing
  • Vinyl Construction Material

Interior Spaces

  • 2,661 Sq Ft Home
  • 2-Story Property
  • Cathedral Ceiling
  • Ceiling Fan
  • 2 Fireplaces
  • Wood Burning Fireplace
  • Gas Fireplace
  • Living Room
  • Formal Dining Room
  • Security System Owned

Kitchen

  • Eat-In Country Kitchen
  • Gas Range
  • Free-Standing Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops

Flooring

  • Wood
  • Wall to Wall Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Whirlpool Bathtub

Partially Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Laundry in Basement

Parking

  • 1 Car Attached Garage
  • Garage Door Opener
  • Circular Driveway

Outdoor Features

  • Deck
  • Patio
  • Shed

Schools

  • Pinehurst Elementary School
  • Frontier Middle School
  • Frontier Senior High School

Utilities

  • Forced Air Cooling System
  • Heating System Uses Gas
  • Gas Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 144889-181-100-0001-015-000

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,453

Year Built

Built in 1957

Lot Details

0

Listing Details

  • Additional Structures: Shed/Storage
  • Age: 58
  • NY Swis Code: Hamburg-144889
  • Total Assessed Value: 106000
  • Foundation Description: Block
  • Listing Type: Exclusive Right To Sell
  • Lot Dimension Depth: 372
  • Lot Dimension Front: 95
  • Lot Information: Neighborhood Street, Wooded Lot
  • Lot Shape: Rectangular
  • L P Per Acre: 296172.8400
  • List Price per Sq Ft: 90.1540
  • Nearest Cross Street: LakeShore
  • Number of Stories: 2.0000
  • Property Type: Single Family Residential
  • Ratio Close Price By Acres: 302469.14
  • Ratio Close Price By Sq Ft: 92.07
  • Ratio List Price By Acres: 296172.84
  • Ratio List Price By Sq Ft: 90.15
  • Regional Board Code: Buffalo
  • Regional Board Number: 6375
  • School Tax: 2758
  • Sale Price List Price: 1.0212
  • S P Per Acre: 302469.1400
  • S P Per Sq Ft: 92.0700
  • Styles of Residence: 2 Story, Colonial
  • Sub Board Code: Buffalo
  • Type of Sale: Normal
  • Value Range Search Low Price: 239900.00
  • Year Built Description: Existing
  • Age of Building: 65
  • Year Built: 1957
  • Directions To Property: Lakeshore Rd (rte 5) in Wanakah to Columbia
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2
  • Year Built: 1957

Interior Features

  • Full Bathrooms: 2
  • Additional Interior Features: Cathedral Ceiling, Ceiling Fan, Circuit Breakers - Some, Copper Plumbing - Some, Security System - Owned, Sump Pump, Whirlpool Tub
  • Additional Rooms: 1st Floor Master Bedroom, Basement / Rec Room, Foyer/Entry Hall, Laundry-Basement, Living Room, Master Bedroom Bath
  • Attic Description: Crawl Space
  • Basement Description: Full, Partially Finished
  • Floor Description: Hardwood-Some, Tile-Some, Wall To Wall Carpet-Some
  • Kitchen Appliances Included: Dishwasher, Microwave, Oven/Range Freestanding, Oven/Range Gas, Refrigerator
  • Kitchen Dining Description: Country Kitchen, Eat-In, Formal Dining Room, Granite Counter, Island, Pantry
  • Number of Bedrooms 1st Floor: 1
  • Number of Bedrooms 2nd Floor: 3
  • Number of Fireplaces Gas: 1
  • Number of Fireplaces Total Calculated: 2
  • Number of Fireplaces Woodburning: 1
  • Number of 1st Floor Full Bathrooms: 1
  • Number of 2nd Floor Full Bathrooms: 1
  • Number of 1st Floor Half Bathrooms: 1
  • Number of Rooms: 10
  • Half Bathrooms: 1
  • Total Bathrooms: 2.10
  • Total Bedrooms: 4
  • Total Sq Ft: 2661

Exterior Features

  • Construction: Brick, Vinyl
  • Additional Exterior Features: Cable TV Available, Deck, Garage Door Opener, Patio
  • Number of Acres: 0.8100

Garage/Parking

  • Driveway Description: Circular, Concrete
  • Garage Description: Attached
  • Number of Garage Spaces: 1.0000

Utilities

  • Heating Fuel Description: Gas
  • Hvac Type: AC-Central, Forced Air
  • Sewer Description: Sewer Connected
  • Water Heater Fuel: Gas

Schools

  • School District: Frontier
  • Elementary School: Pinehurst Elementary
  • Middle School: Frontier Middle
  • High School: Frontier Senior High

Lot Info

  • Parcel Number: 144889-181-100-0001-015-000

Tax Info

  • Total Taxes: 5453

MLS Schools

  • Elementary School Name: Pinehurst Elementary
  • High School Name: Frontier Senior High
  • Middle School Name: Frontier Middle
  • School District Name: Frontier

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 18, 2015
Closed on
Jul 22, 2015
Sold by
Messina Mark and Messina Michelle
Bought by
Lindstrom Sean L and Lindstrom Sarah
Seller's Agent
Lou Ann Spaulding
No Office Affiliation
Buyer's Agent
David Lindstrom
HUNT Real Estate Corporation
List Price
$239,900
Sold Price
$245,000
Premium/Discount to List
$5,100
2.13%
Current Estimated Value
$453,706

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$208,706
Avg. Annual Appreciation
6.18%
Original Mortgage
$245,000
Outstanding Balance
$192,032
Interest Rate
4.01%
Mortgage Type
VA
Estimated Equity
$261,674

Purchase Details

Closed on
Sep 28, 2011
Sold by
Barry Daniel and Barry Heather
Bought by
Messina Mark and Messina Michaelle E

Purchase Details

Closed on
Apr 22, 2009
Sold by
Gmac Mortgage Llc
Bought by
Barry Daniel and Barry Heather

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$94,400
Interest Rate
4.93%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 16, 2009
Sold by
Monaghan Robert Paul and Monaghan Robert P
Bought by
Gmac Mortgage Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$94,400
Interest Rate
4.93%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 3, 2006
Sold by
Lloyd Dean A
Bought by
Monaghan Robert Paul

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$136,000
Interest Rate
1.25%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
May 14, 2001
Sold by
Perfetto Patricia Ann and Omara Mary Jean
Bought by
Lloyd Dean A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$55,000
Interest Rate
11.3%

Purchase Details

Closed on
Dec 29, 1995
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Lindstrom Sean L $245,000 None Available
Messina Mark $207,550 None Available
Barry Daniel $118,000 None Available
Gmac Mortgage Llc $153,000 None Available
Monaghan Robert Paul $170,000 None Available
Lloyd Dean A $52,500 --
-- -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Lindstrom Sean L $245,000
Previous Owner Barry Daniel $94,400
Previous Owner Monaghan Robert Paul $17,000
Previous Owner Monaghan Robert Paul $136,000
Previous Owner Lloyd Dean A $55,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
07/23/2015 07/23/15 Sold $245,000 +2.1% $92 / Sq Ft
05/19/2015 05/19/15 Pending -- -- --
05/18/2015 05/18/15 For Sale $239,900 -- $90 / Sq Ft
Source: Western New York Real Estate Information Services (WNYREIS)

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $5,826 $106,000 $13,100 $92,900
2023 $5,575 $106,000 $13,100 $92,900
2022 $5,512 $106,000 $13,100 $92,900
2021 $5,439 $106,000 $13,100 $92,900
2020 $4,807 $106,000 $13,100 $92,900
2019 $5,651 $106,000 $13,100 $92,900
2018 $4,538 $106,000 $13,100 $92,900
2017 $2,805 $106,000 $13,100 $92,900
2016 $4,745 $106,000 $13,100 $92,900
2015 -- $106,000 $13,100 $92,900
2014 -- $106,000 $13,100 $92,900
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Western New York Real Estate Information Services (WNYREIS)

MLS Number: B475024

Western New York Real Estate Information Services (WNYREIS)

APN: 144889-181-100-0001-015-000