Estimated payment $10,371/month
LAKECREST ESTATE MANSION has finally become available! This is a rare opportunity to purchase one of the most prominent, luxurious properties overlooking Lake Erie in Hamburg. Only three families in 105 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 and a 12,500-square-foot horse barn with 17 stalls. Million-dollar views from a parklike setting on a gorgeous lot with a massive gazebo. Lake Erie living with a Chestnut Ridge feel. The main house, currently used as a residence and Bed & Breakfast, comes with 4 bedrooms, 4.5 bathrooms and the space 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 and office space. This home even has a separate bridal suite! 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. Gated driveway and hedges provide plenty of privacy. Fantastic home in every way for living, entertaining and hosting. Three furnaces replaced in 2024. 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. Seller needs at least 48 hours’ notice before showings. Preapproval letter or proof of funds are required to see the home. Offers will be reviewed as they’re submitted. Do not let this opportunity slip away!
Listing Agent
Listing by HUNT Real Estate Corporation Brokerage Phone: 716-512-3425 License #10301221944 Listed on: 08/18/2025
Co-Listing Agent
Listing by HUNT Real Estate Corporation Brokerage Phone: 716-512-3425 License #10401348386
| 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 | -- | $454,900 | $79,900 | $375,000 |
| 2023 | $26,882 | $454,900 | $79,900 | $375,000 |
| 2022 | $26,271 | $454,900 | $79,900 | $375,000 |
| 2021 | $25,955 | $454,900 | $79,900 | $375,000 |
| 2020 | $24,876 | $454,900 | $79,900 | $375,000 |
| 2019 | $22,689 | $454,900 | $79,900 | $375,000 |
| 2018 | $23,850 | $454,900 | $79,900 | $375,000 |
| 2017 | $10,912 | $454,900 | $79,900 | $375,000 |
| 2016 | $23,067 | $454,900 | $79,900 | $375,000 |
| 2015 | -- | $454,900 | $79,900 | $375,000 |
| 2014 | -- | $454,900 | $79,900 | $375,000 |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 08/18/2025 08/18/25 | For Sale | $1,490,000 | -- | $281 / Sq Ft |
$1,500,000
Rare opportunity to be a part of the most exciting development opportunity in WNY! Located directly across the street from the new $1.5 billion Bills stadium, this property is your golden ticket to immense revenue generation. What sets this offering apart is not just its proximity to this football mecca, but also its business zoning (B-2), allowing for commercial development
Alina Pierowicz Verax Real Estate LLC
$1,650,000
Stately Old Lake Shore home is filled with charm and character throughout. Set on a mature treed lot with gardens and gorgeous sun set views, this home features expansive living and dining spaces designed to capture tranquil lake views. This five bedroom, four full bath, 2 two half bath has the old world charm. Enjoy the pool, pool house, and classic appeal perfect for entertaining family,
Bret Llewellyn MJ Peterson Real Estate Inc.
Source: Western New York Real Estate Information Services (WNYREIS)
MLS Number: B1629354
APN: 144889-159-170-0001-016-100
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of the CNYIS, UNYREIS and WNYREIS. Real estate listings held by firms other than Homes.com, LLC are marked with the IDX logo and include the Listing Broker’s 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 Homes.com, LLC shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless.
© 2025 CNYIS, UNYREIS, WNYREIS. All rights reserved.