Ad #6283692
MLS #B1613565
Experience resort-style living every day in this extraordinary
3248 Lockport Olcott Rd, Newfane, NY 14108
$1,350,000
6Beds
5Baths
5,306Sqft
14.8Acres
About this property
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
Property Features
6 Beds
5 Baths
5,306 Sqft
Built in 1997
14.8 Acres
1 Story
Siding: Stone, Stucco, VinylSiding
Asphalt Roof
Has Swimming Pool
Has Fireplace
Forced Air, Zoned, Natural Gas
$18,816 / yr property tax
Niagara County
Additional Photos
Contact Information
Michelle Petrie
WNY METRO ROBERTS REALTY
585-749-8275
Location
Listing Agent: Michelle Petrie (License #: 10401343898) 585-749-8275
Broker: WNY METRO ROBERTS REALTY 716-891-1710 Listing Site
Copyright © 2026 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.
Broker: WNY METRO ROBERTS REALTY 716-891-1710 Listing Site
Copyright © 2026 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.
BeachHouse.com
Printed Aug 11, 2026
Photo Gallery
$1,350,000
6
Beds
5
Baths
5,306
Sqft
3248 Lockport Olcott Rd, Newfane, NY 14108
By contacting this agent you agree to these Terms and Conditions.
MLS# B1613565
Experience resort-style living every day in this extraordinary
$1,350,000
3248 Lockport Olcott Rd, Newfane, NY 14108
6
Beds
5
Baths
5,306
Sqft
14.8
Acres
$1,350,000
3248 Lockport Olcott Rd, Newfane, NY 14108
6 Beds
5 Baths
5,306 Sqft
14.8 Acres
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
427 days
on BeachHouse.com
107
views
0
saves
Property Details
HOME DETAILS
6 Beds
5 Baths
5,306 Sqft
Built in 1997
14.8 Acres
1 Story
EXTERIOR
Siding: Stone, Stucco, VinylSiding
Asphalt Roof
Has Swimming Pool
INTERIOR
Has Fireplace
Forced Air, Zoned, Natural Gas
FINANCIAL & COMMUNITY
$18,816 / yr property tax
Niagara County
See More Details
Location
Mortgage Calculator
Ad Statistics
Ad Number
6283692
Viewed
107 times
Listing Status
Active
Added
Jun 10, 2025
Last Refreshed
Jul 03, 2026 06:17:28 PM
Listing Information
Data Source
New York State Alliance of MLSs, LLC
Source Property ID
B1613565
Listing Agent: Michelle Petrie (License #: 10401343898) 585-749-8275
Broker: WNY METRO ROBERTS REALTY 716-891-1710 Listing Site
Copyright © 2026 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.
Broker: WNY METRO ROBERTS REALTY 716-891-1710 Listing Site
Copyright © 2026 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.
Request Information
Start advertising today
Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home
Explore Similar Properties
No similar properties found.