Water Views
Address
5791 Elmhurst Road, Hamburg, NY
Price
$ 299,990
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
Price
Taxes
Year Built
Visits
In The Neighborhood
Just Listed
North Collins
$ 250,000
- Type
- Single Family
- Size
- 1,959 SqFt
- Rooms
- 4 Beds + 2 Baths
Listed by: WNY Metro Roberts Realty
Just Listed
Cheektowaga
$ 225,000
- Type
- Single Family
- Size
- 1,456 SqFt
- Rooms
- 3 Beds + 1.5 Baths
Listed by: Howard Hanna WNY Inc.
Just Listed
Buffalo
$ 229,900
- Type
- Single Family
- Size
- 1,279 SqFt
- Rooms
- 2 Beds + 1.5 Baths
Listed by: Berkshire Hathaway Homeservices Zambito Realtors
Just Listed
Clarence
$ 752,000
- Type
- Single Family
- Size
- 2,786 SqFt
- Rooms
- 3 Beds + 2.5 Baths
Listed by: Symphony Real Estate LLC
Just Listed
Evans
$ 209,900
- Type
- Single Family
- Size
- 2,168 SqFt
- Rooms
- 5 Beds + 2 Baths
Listed by: Danahy Real Estate
Just Listed
Amherst
$ 649,900
- Type
- Single Family
- Size
- 3,162 SqFt
- Rooms
- 3 Beds + 2.5 Baths
Listed by: Howard Hanna WNY Inc.
Just Listed
Clarence
$ 875,000
- Type
- Single Family
- Size
- 3,707 SqFt
- Rooms
- 5 Beds + 2.5 Baths
Listed by: Howard Hanna WNY Inc.
Open House
Hamburg
$ 245,000
- Type
- Single Family
- Size
- 1,133 SqFt
- Rooms
- 3 Beds + 2 Baths
Listed by: Howard Hanna WNY Inc.
Open House
Buffalo
$ 500,000
- Type
- Single Family
- Size
- 2,157 SqFt
- Rooms
- 4 Beds + 3.5 Baths
Listed by: Keller Williams Realty WNY
Just Listed
Cheektowaga
$ 229,900
- Type
- Single Family
- Size
- 1,296 SqFt
- Rooms
- 3 Beds + 1 Baths
Listed by: REMAX North
Just Listed
Cheektowaga
$ 164,900
- Type
- Single Family
- Size
- 939 SqFt
- Rooms
- 2 Beds + 1 Baths
Listed by: HUNT Real Estate ERA
Open House
Amherst
$ 329,900
- Type
- Single Family
- Size
- 2,077 SqFt
- Rooms
- 4 Beds + 2.5 Baths
Listed by: Howard Hanna WNY Inc.
Just Listed
Orchard Park
$ 1,299,900
- Type
- Single Family
- Size
- 3,675 SqFt
- Rooms
- 4 Beds + 3.5 Baths
Listed by: eXp Realty
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 Skodzinsky Team, 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 sale, change or
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 Skodzinsky Team, 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) nor Skodzinsky
