Property
$1,600,00014.8 Acres6 beds • 4 baths • 1 half bath • 5,306 sq ft
For Sale
For Sale
$1,600,00014.8 Acres
For Sale
6 beds • 4 baths • 1 half bath • 5,306 sq ft

3248 Lockport Olcott Road, Newfane, NY 14108 - Niagara County

Static Google Map
Property ID 25043492

Is this your property? Sell it faster with premium placement and targeted ads.

MULTI_FAMILY - Newfane, NY

Experience resort-style living every day in this extraordinary estate, perfectly designed for extended guests and those seeking flexible space for events. Nestled on over 14 acres of private sanctuary-surrounded by mature trees and a peaceful creek-this custom-built mansion offers unmatched luxury, privacy, and versatility. The main residence features 4 spacious bedrooms and 3 elegant baths, including a primary suite with a spa-inspired bathroom and a walk-in closet designed for ultimate comfort. The heart of the home is an oversized chef's kitchen and a beautifully appointed dining room-ideal for family gatherings and celebrations. What truly sets this property apart is the separate in-law suite, complete with 2 bedrooms, a full bath, and its own living area. Whether you're accommodating parents, adult children, or long-term guests, this private space offers independence and comfort while keeping loved ones close. The finished basement boasts a private gym, and the backyard is an entertainer's dream: enjoy an inground pool, hot tub, outdoor kitchen, pergola dining area, pool house, basketball court, and expansive patios-perfect for making memories across generations. Recent upgrades include brand new garage doors and new AC condensers for modern convenience and peace of mind. This estate is truly a rare find for families looking to live, entertain, and thrive together-all within their own private resort. Schedule your private tour today and discover the endless possibilities for multigenerational living! Also listed under ML B1613553

Copyright © 2025 New York State Alliance of MLSs, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

From elevation to risk assessment

Search for detailed parcel information including; Elevation & Vegetation Maps, Ownership Information, Detailed Parcel Information, Crop History Map, Soil Survey Productivity Data, and more.

Research Parcel Information
Contact Seller

WNY Metro Roberts Realty

License #10401343898

Williamsville, NY

(585) 749-8275
Listing provided by
Michelle Petrie
WNY Metro Roberts Realty(716) 891-1710
Source: ListHub, MLS# B1613565
Listing status: Active
Listing last updated: October 28, 2025 at 10:32 PM
Listing last checked: December 11, 2025 at 3:30 PM
Report this listing
M

Michelle Petrie

WNY Metro Roberts Realty
View Phone Number

Message

Is this your property? Sell it faster with premium placement and targeted ads.

Michelle Petrie

WNY Metro Roberts Realty