Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
6 Beds
5 Baths
5,306 sqft

$1,350,000

3248 Lockport Olcott Road, Newfane NY, 14108

Price per sqft$254.43
Built in1997
Property size5,306 sqft
Property typeMulti-family

Overview

Active

Listed Jun 10, 2025

Updated Jul 2

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

$8,982/mo

Est. mortgage payment based on a $1,350,000 home price.

All estimates are provided by Luxury Presence for informational purposes only. Actual amounts may vary.

Additional information

MLS® ID
B1613565

Interior Features

Bedrooms
6
Bathrooms
5
Fireplace
Yes
Cooling
Yes
Heating
Yes
Basement
Yes

Exterior Features

Lot Size
14.8 Acres

Other Property Details

Taxes
$18,816
Tax Frequency
Annually
Garage
Yes
Pool
Yes
MLS provider logo

 

Courtesy of WNY Metro Roberts Realty, Michelle Petrie

Disclaimer: Any use of search facilities of data on this site, other than by a consumer looking to purchase real estate, is prohibited. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change, or withdrawal. Neither listing broker(s) nor Claire Starusnak shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

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 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), Claire Starusnak, nor Luxury Presence shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless.

©2026 CNYIS, UNYREIS, WNYREIS. All rights reserved.

Data last updated 5:55 AM UTC, 7/2/2026

Powered by Luxury Presence