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
Active
$1,600,000
3248 Lockport Olcott Rd, Newfane, NY 14108
6beds
5,306sqft
Multi Family
Built in 1997
-- sqft lot
$1,453,300 Zestimate®
$302/sqft
$-- HOA
What's special
- 375 days |
- 818 |
- 41 |
Zillow last checked:
Listing updated:
Listed by:
WNY Metro Roberts Realty 716-875-2211,
Michelle Petrie 716-293-2817
Source: NYSAMLSs,MLS#: B1613565
Originating MLS: Buffalo
Originating MLS: BuffaloLoading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Heating
- Gas, Zoned, Forced Air
Cooling
- Zoned, Central Air
Appliances
- Included: Gas Water Heater, Humidifier
Features
- Air Filtration, Programmable Thermostat
- Flooring: Ceramic Tile, Hardwood, Varies
- Basement: Full,Finished
- Number of fireplaces: 2
Interior area
- Total structure area: 5,306
- Total interior livable area: 5,306 sqft
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Concrete, Two or More Spaces
- Garage spaces: 3
Features
- Patio & porch: Patio
- Exterior features: Barbecue, Hot Tub/Spa, Pool, Patio
- Pool features: In Ground
- Has spa: Yes
- Waterfront features: River Access, Stream
- Body of water: Twelvemile Creek
- Frontage length: 900
Lot
- Size: 14.8 Acres
- Dimensions: 221 x 900
- Features: Irregular Lot, Secluded, Wooded
Details
- Parcel number: 2928000530130001050001
- Special conditions: Standard
- Horses can be raised: Yes
- Horse amenities: Horses Allowed
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Multi Family
Materials
- Stone, Stucco, Vinyl Siding
- Foundation: Poured
- Roof: Asphalt
Condition
- Resale
- Year built: 1997
Utilities & green energy
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Sewer Connected, Water Connected
Community & HOA
Location
- Region: Newfane
Financial & listing details
- Price per square foot: $302/sqft
- Tax assessed value: $412,000
- Annual tax amount: $18,816
- Date on market: 6/10/2025
- Cumulative days on market: 730 days
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
Estimated market value
$1,453,300
$1.38M - $1.53M
$5,505/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/10/2025 | Listed for sale | $1,600,000$302/sqft |
Source:  NYSAMLSs #B1613565 Report a problem | ||
| 6/9/2025 | Listing removed | $1,600,000$302/sqft |
Source: NYSAMLSs #B1546440 Report a problem | ||
| 6/8/2024 | Listed for sale | $1,600,000-15.8%$302/sqft |
Source: NYSAMLSs #B1542858 Report a problem | ||
| 4/25/2024 | Listing removed | -- |
Source: NYSAMLSs #B1518296 Report a problem | ||
| 1/26/2024 | Listed for sale | $1,900,000$358/sqft |
Source: NYSAMLSs #B1518296 Report a problem | ||
| 12/1/2023 | Listing removed | -- |
Source: NYSAMLSs #B1468206 Report a problem | ||
| 8/26/2023 | Listed for sale | $1,900,000$358/sqft |
Source: NYSAMLSs #B1468206 Report a problem | ||
| 8/24/2023 | Pending sale | $1,900,000$358/sqft |
Source: NYSAMLSs #B1468206 Report a problem | ||
| 5/1/2023 | Listed for sale | $1,900,000$358/sqft |
Source: NYSAMLSs #B1468206 Report a problem | ||
| 5/1/2023 | Listing removed | -- |
Source: NYSAMLSs #B1354534 Report a problem | ||
| 9/9/2022 | Listed for sale | $1,900,000+304.3%$358/sqft |
Source: NYSAMLSs #B1354534 Report a problem | ||
| 6/30/2003 | Sold | $470,000$89/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $412,000 |
| 2024 | -- | $412,000 |
| 2023 | -- | $412,000 |
| 2022 | -- | $412,000 |
| 2021 | -- | $412,000 |
| 2020 | -- | $412,000 |
| 2019 | -- | $412,000 |
| 2018 | -- | $412,000 |
| 2017 | $5,356 | $412,000 |
| 2016 | -- | $412,000 |
| 2015 | -- | $412,000 |
| 2014 | -- | $412,000 |
| 2013 | -- | $412,000 |
| 2012 | -- | $412,000 |
| 2011 | -- | $412,000 |
| 2010 | -- | $412,000 |
| 2009 | -- | $412,000 |
| 2008 | -- | $412,000 |
| 2007 | -- | $412,000 |
| 2006 | -- | $412,000 +3% |
| 2005 | -- | $400,000 -13% |
| 2004 | -- | $459,900 +65.1% |
| 2003 | -- | $278,600 |
| 2002 | -- | $278,600 |
| 2001 | -- | $278,600 |
| 2000 | -- | $278,600 |
Find assessor info on the county website
Monthly payment
Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 14108
Nearby schools
GreatSchools rating
- 3/10Newfane Elementary SchoolGrades: K-4Distance: 1.2 mi
- 4/10Newfane Middle SchoolGrades: 4-8Distance: 1.9 mi
- 6/10Newfane Senior High SchoolGrades: 7-12Distance: 2.1 mi
Schools provided by the listing agent
- District: Newfane
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- New York
- Niagara County
- Newfane
- 14108
- 3248 Lockport Olcott Rd
Nearby cities
Nearby zip codes
Other Newfane Topics
