Property Attributes
- MLS#B1687861
- TypeSingle Family
- Listing Status Active
- CountyERIE
- CityHamburg
- AreaHamburg
- NeighborhoodHolland Land Companys Su
- Zip14085
- StyleColonial,TwoStory
- Year Built1920
- Taxes$ 4764
- Price$ 299,990
- Bedrooms3
- Full Bathrooms2
- Half Bathrooms0
- Sqr Footage1780
- Lot Size0.2468 Acres
Data Source:
Central New York Information Services (CNYIS)
Property Description
Welcome to 5791 Elmhurst Road, Lake View. This meticulously maintained residence, held by the same owners for over 38 years, offers three bedrooms and two full bathrooms. The home features a welcoming front porch, a spacious living and dining area ideal for hosting guests, and a bright, eat-in kitchen complete with a gas fireplace, abundant storage, and a recently updated full bathroom. The second floor hosts three generously sized bedrooms and another updated full bathroom. The fully finished basement includes a bar, an entertainment area, and additional storage space. Significant recent improvements include a 2025 sump pump, a 2021 hot water tank, and a 2021 furnace and 2025 central air conditioning system. The exterior serves as a private retreat, featuring a screened-in gazebo, a one-year-old 21-foot above-ground pool, a garden area, and a fire pit, all situated within a fully fenced yard. For car enthusiasts or hobbyists, the property includes an expansive garage with 12-foot ceilings. Furthermore, the property features a notable custom roof design for Buffalo Bills enthusiasts, with the inspiring history behind it available at "Lakeview Bills Mafia roof."
| Price History | |
|---|---|
| 6/5/2026 | Listed $329,982 |
| 7/31/2026 | 5$315,000 |
| 8/27/2026 | 5$299,990 |
General Features
| Sewer | Connected |
|---|---|
| Heating | Gas,ForcedAir |
| Cooling | CentralAir |
| Utilities | SewerConnected,WaterConnected |
| Possession | Closing |
| Roof | Asphalt,Flat,Membrane,Rubber,Shingle |
| Appliances | Dryer,FreeStandingRange,GasOven,GasRange,GasWaterHeater,Oven,Refrigerator,Washer |
| Garage Spaces | 1.0 |
| Patio/Porch Features | Patio |
| Architectural Style | Colonial,TwoStory |
| Pool Features | AboveGround |
| Construction Materials | VinylSiding |
| School District | Frontier |
| Year Built | 1920 |
| Stories Count | 2 |
| Township | Not Applicable |
| Levels | Two |
| Property Subtype | SingleFamilyResidence |
| County | Erie |
| Property Type | Residential |
| Subdivision Name | Holland Land Company's Su |
| Garage Y/N | Yes |
| Other Structures | Gazebo,SecondGarage |
| Total Rooms | 6 |
| Full Baths | 2 |
| Status | Active |
| Directions | Great Lakes Seaway Trail to Lakeview Terrace to Penhurst Pl to Elmhurst Rd |
| City | Hamburg |
| Senior Community Y/N | No |
| High School District | Frontier |
| MLS Area | Hamburg-144889 |
| Lot Size Units | Acres |
| Lot Size Square Feet | 10752.0 |
| Year Built Details | Existing |
| Tax Annual Amount | 4764.0 |
| Property Condition | Resale |
| Standard Status | Active |
| Middle/Junior School District | Frontier |
| Elementary School District | Frontier |
| Tax Assessed Value | 66000 |
| TaxOtherAnnualAssessmentAmount | 0.0 |
| Tax Lot | 34 |
Interior Features
| Interior Amenities | SeparateFormalDiningRoom,EatInKitchen,SeparateFormalLivingRoom,CountryKitchen |
|---|---|
| Basement | Full,PartiallyFinished |
| Flooring | Carpet,Varies,Vinyl |
| Total Fireplaces | 1 |
| Total Stories | 2 |
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Laundry Features | InBasement |
| Total Bedrooms | 3 |
| Main Level Bathrooms | 1 |
| Total Baths | 2 |
Exterior Features
| Exterior Amenities | BlacktopDriveway,ConcreteDriveway,EnclosedPorch,FullyFenced,Pool,Porch,Patio,PrivateYard,SeeRemarks |
|---|---|
| Fencing | Full |
| Parking Features | Electricity,Garage,HeatedGarage,Storage,WorkshopInGarage,CircularDriveway,GarageDoorOpener,SharedDriveway |
| Lot Features | IrregularLot,ResidentialLot |
| Water Source | Connected,Public |
| Lot Size Area | 0.2468 |
| Foundation Details | Poured |
| Building Area Total | 1780.0 |
| Lot Dimensions | 74X145 |
| Lot Size Acres | 0.2468 |
| Waterfront Y/N | No |
| Road Frontage Type | CityStreet |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 14085
In The Neighborhood
Tonawanda
$ 289,900
- Type
- Single Family
- Size
- 2,113 SqFt
- Rooms
- 3 Beds + 2 Baths
Clarence
$ 479,900
- Type
- Single Family
- Size
- 2,250 SqFt
- Rooms
- 3 Beds + 1.5 Baths
Amherst
$ 175,000
- Type
- Single Family
- Size
- 1,019 SqFt
- Rooms
- 3 Beds + 1 Baths
Cheektowaga
$ 349,900
- Type
- Single Family
- Size
- 2,136 SqFt
- Rooms
- 4 Beds + 1.5 Baths
Buffalo
$ 325,000
- Type
- Single Family
- Size
- 1,661 SqFt
- Rooms
- 3 Beds + 2 Baths
Lancaster
$ 299,900
- Type
- Single Family
- Size
- 2,224 SqFt
- Rooms
- 4 Beds + 2 Baths
Tonawanda
$ 234,900
- Type
- Single Family
- Size
- 1,227 SqFt
- Rooms
- 4 Beds + 1 Baths
Buffalo
$ 149,900
- Type
- Single Family
- Size
- 1,220 SqFt
- Rooms
- 4 Beds + 1.5 Baths
Alden
$ 370,000
- Type
- Single Family
- Size
- 1,556 SqFt
- Rooms
- 3 Beds + 2 Baths
Amherst
$ 289,900
- Type
- Single Family
- Size
- 1,261 SqFt
- Rooms
- 3 Beds + 1 Baths
Buffalo
$ 84,900
- Type
- Single Family
- Size
- 1,097 SqFt
- Rooms
- 3 Beds + 1 Baths
Tonawanda
$ 189,900
- Type
- Single Family
- Size
- 900 SqFt
- Rooms
- 2 Beds + 0 Baths
Tonawanda
$ 299,900
- Type
- Single Family
- Size
- 1,834 SqFt
- Rooms
- 4 Beds + 2 Baths
The Greater Syracuse Association of REALTORS ®: The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of the CNYIS, powered by CNYIS. Real estate listings held by firms other than eXp Realty in Western New York, are marked with the IDX logo and detailed information about them includes the Listing Broker's Firm Name. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior
The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS. Real estate listings held by firms other than eXp Realty in Western New York, are marked with the IDX logo and detailed information about them includes the Listing Brokers Firm Name.
Disclaimer: All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither the listing broker(s)