Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Prime Properties
Property view
Listing view 2
Listing view 3

3248 Lockport Olcott Road, 
Newfane, NY 14108

$1,600,000


6

Beds


5

Baths


5,306

Sq Ft


Multi-Family


Virtual Tour

Active

Listed by

Michelle Petrie

Wny Metro Roberts Realty

716-875-2211

Last updated:

June 10, 2025, 11:56 PM

MLS#

B1613565

Source:

NY GENRIS

About This Home

3248 Lockport Olcott Road

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

Home Facts

Multi-Family

5 Baths

6 Bedrooms

Built in 1997

Price Summary

1,600,000

$301 per Sq. Ft.

MLS #:

B1613565

Last Updated:

June 10, 2025, 11:56 PM

Added:

5 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

6

Bathrooms

Total Bathrooms:

5

Full Bathrooms:

4

Interior

Living Area:

5,306 Sq. Ft.


Structure

Structure

Building Area:

5,306 Sq. Ft.

Year Built:

1997


Lot

Lot Size (Sq. Ft):

644,688


Finances & Disclosures

Finances

Price:

$1,600,000

Price per Sq. Ft:

$301 per Sq. Ft.

Source:NY GENRIS
The information being provided by New York State Alliance is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2025 New York State Alliance All rights reserved.

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

 

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.