3248 Lockport Olcott Road, Newfane, NY, 14108

Save
Ask
Tour
Hide
Share
$1,350,000
455 Days On Site

3248 Lockport Olcott Road
Newfane, NY 14108

For Sale|Multi Family|Active
6
Beds
5
Total Baths
4
Full Baths
1
Partial Bath
5,306
SqFt
$254
/SqFt
1997
Built
County:
Niagara
Listing courtesy of Michelle Petrie of WNY Metro Roberts Realty (585) 749-8275
Call Now: 716-676-6123
Is this the listing for you? We can help make it yours.
716-676-6123
3248 Lockport Olcott Road3248 Lockport Olcott Road3248 Lockport Olcott Road3248 Lockport Olcott Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$6,159
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

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

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,350,000
Days On Site 
455 Days
Bedrooms 
6
Inside Area (SqFt) 
5,306 sqft
Total Baths 
5
Full Baths 
4
Partial Baths 
1
Lot Size 
14.8 Acres
Year Built 
1997
MLS® Number 
B1613565
Status 
Active
Property Tax 
$18,816
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
Public Records
Friends & Family
Recent Activity
2 months agoPrice changed to $1,350,000
2 months agoListing updated with changes from the MLS®
3 months agoStatus changed to Active
a year agoListing first seen on site
General Features
Acres 
14.8
Cross Street 
Jaques Rd.
Garage 
Yes
Garage Spaces 
3
Number Of Stories 
1
Parking 
Concrete
Property Sub Type 
Multi Family
Special Circumstances 
Standard
SqFt Total 
5306
Utilities 
Sewer ConnectedWater Connected
Water Source 
Public
Interior Features
Appliances 
Gas Water HeaterHumidifierWater Heater
Basement 
FullFinished
Cooling 
ZonedCentral Air
Fireplace 
Yes
Fireplaces 
2
Flooring 
Ceramic TileHardwoodVaries
Heating 
Natural GasZonedForced Air
Interior 
Smart Thermostat
Spa 
Yes
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
StoneStuccoVinyl Siding
Exterior 
Barbecue
Frontage 
900
Lot Features 
Irregular LotSecludedWooded
Patio And Porch 
Patio
Pool Features 
In GroundOutdoor PoolPrivate
Private Pool 
Yes
Roof 
Asphalt
Spa 
Yes
Waterfront Features 
River AccessStream
Community Features
MLS Area 
Newfane-292800
School District 
Newfane
Township 
Not Applicable
Financing Terms Available 
CashConventionalFHAUSDA LoanVA Loan
Horse Allowed 
Yes
Schools
School District
Newfane
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Michelle Petrie of WNY Metro Roberts Realty (585) 749-8275



The data relating to real estate on this website comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS’s. Real estate listings held by firms other than are marked with the IDX logo and detailed information about them includes the Listing Broker’s Firm Name.

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) nor shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless. © Last checked: 2026-09-08 07:41 PM UTC CNYIS, UNYREIS, WNYREIS. All rights reserved.

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share
Scroll to Top