ICONIC LAKECREST ESTATE MANSION, one of the most prominent, luxurious properties overlooking Lake Erie in Hamburg, is back after a winter hiatus. This truly unique property offers a rare opportunity. Only three families in 106 years have owned this stately Georgian Colonial on an 8.5-acre compound, which comes complete with an elegant 5,294-square-foot main house, a carriage home for guests or in-laws, a six-car garage, massive gazebo and a 12,500-square-foot building on the rear of the property that includes 17 horse stalls. Enjoy breathtaking views and fabulous sunsets from the pillared front porch overlooking the lake with the City of Buffalo and Canada serving as a backdrop. This is Lake Erie living with a Chestnut Ridge feel. The main house is currently used as a residence and Bed & Breakfast. It comes with 4 bedrooms, 4.5 bathrooms and 20th century charm you would expect. Beautiful Brazilian cherry hardwood floors grace the first-floor living, family and dining rooms. Massive eat-in kitchen includes two built-in ovens. Two staircases lead to the second floor, which includes all four bedrooms plus office space. This home even has a separate bridal suite! New furnaces, numerous updates and more. Gated driveway and hedges provide plenty of privacy. Fantastic home in every way for living, entertaining and hosting. Three furnaces replaced in 2024. Great storage space and plenty of closets throughout. HWT replaced in 2023. Electrical updated in 2025. Dry basement. The property comes with a variance allowing eight horses. Two-story barn also could be used for storing cars, boats or whatever suits your needs. Offers will be reviewed as they’re submitted. Do not let this opportunity slip away!
Active
$1,500,000
4261 Lake Shore Rd, Hamburg, NY 14075
4beds
5,294sqft
Single Family Residence
Built in 1920
8.5 Acres Lot
$-- Zestimate®
$283/sqft
$-- HOA
What's special
Massive gazeboSix-car garageDry basementSeparate bridal suite
- 61 days |
- 2,066 |
- 69 |
Zillow last checked:
Listing updated:
Listed by:
HUNT Real Estate Corporation 716-662-9701,
Brian Hillery 716-512-3425,
James Gleason 716-536-3101,
HUNT Real Estate Corporation
Source: NYSAMLSs,MLS#: B1676778
Originating MLS: Buffalo
Originating MLS: BuffaloLoading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Heating
- Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Built-In Range, Built-In Oven, Double Oven, Dryer, Dishwasher, Electric Cooktop, Exhaust Fan, Disposal, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Range Hood, Washer
Features
- Breakfast Bar, Ceiling Fan(s), Den, Separate/Formal Dining Room, Eat-in Kitchen, Separate/Formal Living Room, Guest Accommodations, Great Room, Home Office, Country Kitchen, Library, Living/Dining Room, Other, Pantry, See Remarks, Storage, Solid Surface Counters, Natural Woodwork, Window Treatments, In-Law Floorplan, Bath in Primary Bedroom
- Flooring: Carpet, Ceramic Tile, Hardwood, Tile, Varies
- Windows: Drapes
- Basement: Full,Walk-Out Access,Sump Pump
- Number of fireplaces: 6
Interior area
- Total structure area: 5,294
- Total interior livable area: 5,294 sqft
Property
Parking
- Total spaces: 6
- Parking features: Detached, Electricity, Garage, Heated Garage, Storage, Workshop in Garage, Driveway, Other
- Garage spaces: 6
Features
- Levels: Two
- Stories: 2
- Patio & porch: Open, Porch
- Exterior features: Blacktop Driveway, See Remarks
Lot
- Size: 8.5 Acres
- Dimensions: 665 x 557
- Features: Irregular Lot
Details
- Additional structures: Barn(s), Guest House, Gazebo, Outbuilding, Other, Garage Apartment
- Parcel number: 1448891591700001016100
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial,Historic/Antique
- Property subtype: Single Family Residence
Materials
- Brick, Composite Siding, Frame, Wood Siding, Copper Plumbing
- Foundation: Other, See Remarks, Stone
- Roof: Asphalt
Condition
- Resale
- Year built: 1920
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Sewer Connected, Water Connected
Community & HOA
Location
- Region: Hamburg
Financial & listing details
- Price per square foot: $283/sqft
- Tax assessed value: $454,900
- Annual tax amount: $27,663
- Date on market: 4/27/2026
- Listing terms: Cash,Conventional,FHA,VA Loan
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 4/27/2026 | Listed for sale | $1,500,000+0.7%$283/sqft |
Source:  NYSAMLSs #B1676778 Report a problem | ||
| 12/19/2025 | Listing removed | $1,490,000$281/sqft |
Source: HUNT ERA Real Estate #B1629354 Report a problem | ||
| 8/18/2025 | Listed for sale | $1,490,000+49%$281/sqft |
Source: NYSAMLSs #B1629354 Report a problem | ||
| 2/17/2016 | Listing removed | $999,999$189/sqft |
Source: Hunt Real Estate ERA #b444418 Report a problem | ||
| 1/22/2014 | Listed for sale | $999,999+0.9%$189/sqft |
Source: Hunt Real Estate ERA #b444418 Report a problem | ||
| 11/2/2013 | Listing removed | $990,900$187/sqft |
Source: WNY METRO ROBERTS REALTY #B409252 Report a problem | ||
| 9/2/2013 | Price change | $990,900-0.9%$187/sqft |
Source: WNY METRO ROBERTS REALTY #B409252 Report a problem | ||
| 6/1/2013 | Price change | $999,900-16%$189/sqft |
Source: WNY METRO ROBERTS REALTY #B409252 Report a problem | ||
| 1/22/2013 | Listed for sale | $1,190,000-5.6%$225/sqft |
Source: WNY METRO ROBERTS REALTY #B409252 Report a problem | ||
| 5/12/2008 | Listing removed | $1,260,000$238/sqft |
Source: Listhub #304006 Report a problem | ||
| 4/29/2008 | Listed for sale | $1,260,000$238/sqft |
Source: Listhub #304006 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $454,900 |
| 2024 | -- | $454,900 |
| 2023 | -- | $454,900 |
| 2022 | -- | $454,900 |
| 2021 | -- | $454,900 |
| 2020 | -- | $454,900 |
| 2019 | -- | $454,900 |
| 2018 | -- | $454,900 |
| 2017 | $22,689 +107.9% | $454,900 |
| 2016 | $10,912 | $454,900 |
| 2015 | -- | $454,900 |
| 2014 | -- | $454,900 |
| 2013 | -- | $454,900 |
| 2012 | -- | $454,900 |
| 2011 | -- | $454,900 |
| 2010 | -- | $454,900 |
| 2009 | -- | $454,900 |
| 2008 | -- | $454,900 |
| 2007 | -- | $454,900 |
| 2006 | -- | $454,900 |
| 2005 | -- | $454,900 |
| 2004 | -- | $454,900 |
| 2003 | -- | $454,900 |
Find assessor info on the county website
Monthly payment
Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 14075
Nearby schools
GreatSchools rating
- 7/10Cloverbank Elementary SchoolGrades: PK-5Distance: 1.9 mi
- 7/10Frontier Middle SchoolGrades: 6-8Distance: 2.5 mi
- 6/10Frontier Senior High SchoolGrades: 9-12Distance: 1.9 mi
Schools provided by the listing agent
- Middle: Frontier Middle
- High: Frontier Senior High
- District: Frontier
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- New York
- Erie County
- Hamburg
- 14075
- 4261 Lake Shore Rd
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Hamburg Topics
