- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
$1,350,000
Monthly Est:$6,719
6 Beds
- 5 Baths
4 full baths + 1 half bath
5,306sqft
3248 Lockport Olcott Rd, Newfane, NY 14108
$1,350,000
$6,719/moEst:
Get Pre-Approved
Multi Family
Built in 1997
$-- HOA
14.8 acres lot
$254/sq.ft
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
- Houzeo last checked: 2 minutes ago
- Listing updated: July 1, 2026 at 6:13 pm
- Listing Provided by: Michelle Petrie (585) 749-8275 DRE #10401343898 | WNY Metro Roberts Realty (716) 875-2211
- Source: New York State Alliance of MLSs, Buffalo-NY | MLS#: B1613565

Property Details
Status
Active
Type
Multi Family
No. of Stories
1
County
City
Neighborhood
--
Year Built
1997
HOA Fees
-
Finished Area
5,306 sqft
Lot Size
14.8 acres lot
Basement Area
- sqft
MLS Name
New York State Alliance of MLSs, Buffalo
MLS Number
B1613565
MLS Status
Active
Days on Market
511
Cumulative Days on Market
720

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 6
Bathrooms: 5
Interior
Flooring
Ceramic Tile, Hardwood, Varies
Appliances
Gas Water Heater, Humidifier
Interior Features
Air Filtration, Programmable Thermostat
Sewer
Connected
Cooling
Zoned, Central Air
Heating
Gas, Zoned, Forced Air
Exterior Features
Barbecue, Hot Tub Spa, Pool, Patio
Construction
Year Built
Year Built: 1997
Home type
Multi Family
Construction Materials
Stone, Stucco, Vinyl Siding
Foundation Details
Poured
Property Condition
Resale
Roof
Asphalt
Utilities & Energy
Water Source
Connected, Public
Parking Features
Concrete, Two Or More Spaces
Pool Features
In Ground
Basement
Full, Finished
Utilities
Sewer Connected, Water Connected
Other Features
Lot Features
Irregular Lot, Secluded, Wooded
Patio And Porch Features
Patio
Price History
| Date | Event | Price |
|---|---|---|
06/11/2026 Source: | Off Market | $1,350,000 $254/sqft |
06/11/2026 Source: | Listed for Sale | $1,350,000 -15.62% $254/sqft |
06/10/2026 Source: | Listing Removed | $1,600,000 $302/sqft |
06/10/2025 Source: | Off Market | $1,600,000 -15.79% $302/sqft |
04/25/2024 Source: | Listing Removed | $1,900,000 $358/sqft |
Show more
Find Homes by Property Features in Newfane, NY
Based on data from the New York State Alliance of MLSs (CNYIS, Inc., UNYREIS and WNYREIS) through Nov 04, 2026, 09:00AM.. All information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable by is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 the New York State Alliance of MLSs. All Rights Reserved.
Advertising Broker: Derek Greene | The Greene Realty Group

