
Search Properties
Buy with EXIT
Sell with EXIT
Find an Agent/Office
About
Why EXIT
The Spirit of EXIT
Careers
Offices
Contact Us
3248 Lockport Olcott Road, Newfane, NY 14108
Share Listing
Overview
Features
Commute
Transportation
Market Statistics
Neighborhood
Similar Homes
Similar Home Values
Contact
$1,600,000
Share Listing
Home Details for 3248 Lockport Olcott Road
Price
$1,600,000
Type
Multi Family
Bedrooms
6
Total Bathrooms
5
Full Bathrooms
4
Half Bathrooms
1
Year Build
1997
Sq. Ft.
5306
Lot Size
14.8
County
Niagara
Garage
3
Basement
Full, Finished
Tax
$18,816
MLS®️ Listing#
B1613565
On exitrealty.com
127 days
Property Description
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
Read more
- Heating Information
- Natural Gas
- Zoned
- Forced Air
- Waterfront and Water Access
- River Access
- Stream
- Cooling Information
- Zoned
- Central Air
- Utilities
- Sewer Connected
- Water Connected
- Basement
- Full
- Finished
- Water Features
- Public
- Parking
- Concrete
Listing Courtesy: WNY Metro Roberts Realty - 716-293-2817. Presented by: Michelle Petrie

IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. This data is deemed reliable by is not guaranteed accurate by the MLS.
? 2024 CNYIS, Inc., GENRIS and WNYREIS All rights reserved.

Last Updated: 2025-10-01 00:02:56
See average values in the proximity of this property
Median Listing Price
Median Days on EXIT Realty®
Median Square Feet
Market statistics compiled from data from WNYREIS.
See several nearby properties
EXIT TURNING KEY REALTY
8175 Sheridan Drive. Suite 400, Buffalo , NY 14221
See properties nearby this listing
Compare the values of homes nearby
$1,600,000
Share Listing
EXIT TURNING KEY REALTY
8175 Sheridan Drive. Suite 400, Buffalo , NY 14221