Active

3248 Lockport Olcott Road

Newfane, NY 14108

$1,600,000 $6,745/Mo

Get Pre-Approved Check your credit

Overview

Bed

Bath

5,306

Sqft

14.80

Acres(Lot)

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 accommod ating 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 Details

Property Type : Residential

Price : $1,600,000

AD Id : 83828143

MLS Id : B1613565

Beds : 6

Lot Size : 14.80 Acres

Living Area Size : 5,306

Year Built : 1997

Garage : 3

County : Niagara

Map

What's Nearby

Nearby Areas

Features

Bedroom Information

Total beds: 6

Bathroom Information

Total Baths: 5 Full Baths: 4 Half Baths: 1

Room Information

Has Basement: Yes Basement: Full, Finished
Flooring Information

Ceramic Tile, Hardwood, Varies
Roofing Information

Asphalt
Interior Features

Smart Thermostat Roof: Asphalt Appliances: Gas Water Heater, Humidifier, Water Heater
Heating & Cooling

Has Heating: Yes Heating: Natural Gas, Zoned, Forced Air Has Cooling: Yes Cooling: Zoned, Central Air

Building Information

Year Built: 1997 Building Area Total: 5306 Construction Materials: Stone, Stucco, Vinyl Siding Frontage Length: 900 Patio And Porch Features: Patio Pool Features: In Ground, Outdoor Pool, Private Private Pool: Yes Water front Features: River Access, Stream
Exterior Features

Exterior Features: Barbecue

Lot Information

Lot Dimensions: 221X900 Main Square Feet: 14.8 Acres Lot Size Acres: 14.8 Lot Size Square Feet: 644688 Lot Description: Irregular Lot, Secluded, Wooded

Listing Price Information

Listing Price: $1600000 Cash, Conventional, FHA, USDA Loan, VA Loan

Tax Information

Parcel Number: 292800-053-013-0001-050-001 Tax Lot: 50 Annual Tax: $18816

Virtual Tour

Virtual Tour (External Link)

Parking Information

Concrete

Garage Information

Has Garage: Yes Garage Space: 3

Utility Information

Sewer Connected, Water Connected
Location Information

Direction: North on Transit Rd., right on Grand St., Left on Clinton St., Left on Lake Ave., Keep left on Rt. 78, house on left, set back WaterSource: Public

Sell a home like this and save $95,501 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Loading, please wait...

Similar Multifamily To 3248 Lockport Olcott Road

Nearby For Sale

Active

$1,600,000

Multifamily For Sale

3248 Lockport Olcott Road,
Newfane, NY, 14108

Bed

Bath

Sqft

Acres(Lot)

5841-5847 Ontario Street,
Newfane, NY, 14126

Bed

Bath

Sqft

Acre(Lot)

1874 Hess Road,
Newfane, NY, 14008

Bed

Bath

2,812

Sqft

0.36

Acre(Lot)

The data relating to real estate for sale on this website comes in part from the Internet Data exchange (IDX) program of the New York State Alliance MLS. 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. Real estate listings held by brokerage firms other than ByOwner, are indicated by detailed information about them such as the name of the listing firms. 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 ByOwner shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless. Copyright ©2026 New York State Alliance and participating MLS's - CNYIS, UNYREIS and WNYREIS. All Rights Reserved.

ByOwner last updated this listing 06/17/2026 @ 13:58

MLS: B1613565 LISTED BY: Michelle Petrie, WNY Metro Roberts Realty 716-875-2211 SOURCE: Western New York Real Estate Information Services (WNYREIS)