Hamburg! Nestled along the shores of Lake Erie, this extraordinary waterfront home offers over an acre of spectacular beachfront property w/private beach access, breathtaking sunsets, & sweeping views of downtown Buffalo. A grand circular concrete driveway creates an unforgettable first impression as you arrive at this one-of-a-kind lakefront retreat. Designed for both luxury living & multi-generational flexibility, this impressive 5-bedroom, 3.5-bath residence features a private main home along with a separate in-law/guest house, each with its own entrance. The main residence showcases stunning panoramic lake views throughout & is filled w/architectural character & natural light. A beautiful entryway w/leaded glass windows, arched insulated doorway, sidelights, & ceramic tile flooring opens into a dramatic great room w/soaring cathedral ceilings & oversized windows that seamlessly bring the outdoors in. The 2-story fireplace w/gas insert serves as the centerpiece of the home, creating warmth & elegance. The formal dining area flows effortlessly into the spacious kitchen, complete with granite top island & additional seating—perfect for entertaining. Convenient 1st-floor laundry room & half bath add everyday practicality. Two primary suites - 1st floor primary suite is a private sanctuary featuring a sep shower, jacuzzi tub & walk-in closet. Upstirs, 2nd suite with full bath, cathedral ceilings & wall of closets & 2nd bdrm facing the lake. The separate in-law/guest house offers 2 bedrooms, a full bath & an open-concept kitchen, dining & living area—ideal for extended family or guests (Airbnb). Outside, the property is equally impressive with beautifully landscaped grounds, stamped concrete walkways, multiple level patios for entertaining & relaxation & stairs leading directly to your private beach. Car enthusiasts & hobbyists will appreciate the attached heated 2-car garage as well as the detached heated 3-car garage. This is far more than a drive-by property—it’s a rare opportunity to own an exceptional waterfront lifestyle on the shores of Lake Erie. Includes 1 year home warranty! Old boar house still has one wall.