Why vacation when you can come home to your own private resort? Tucked away on over 14 pristine acres, this stunning custom-built mansion offers a sanctuary of luxury, privacy, and recreation—surrounded by mature trees and a tranquil creek.
Step outside to an entertainer’s paradise: an incredible backyard oasis featuring an inground pool, bubbling hot tub, outdoor kitchen, pergola-covered dining area, pool house, basketball court, and expansive concrete patios—perfect for gatherings, celebrations, or simply relaxing in your own slice of paradise.
Arrive via the winding driveway and be captivated by a home straight out of a dream. Inside, discover exquisite craftsmanship with custom woodwork and cabinetry, gleaming hardwood floors, floor-to-ceiling windows, and designer light fixtures throughout. The spacious main house offers 4 bedrooms and 3 baths, including a luxurious primary suite with a spa-inspired bathroom and a walk-in closet fit for royalty.
Hosting family or guests? The separate in-law apartment features 2 bedrooms and 1 bath, while the finished basement includes a private gym—ideal for fitness enthusiasts.
Enjoy holiday feasts and everyday meals in the oversized chef’s kitchen with eat-in area, or entertain in the beautifully appointed formal dining room.
Recent upgrades include brand new garage doors and new AC condensers, providing peace of mind and modern convenience.
The possibilities here are endless. Imagine the memories you’ll make in this extraordinary estate—where every day feels like a getaway. Where else would you rather be than right here, right now?
Schedule your private tour today and experience the lifestyle you’ve always dreamed of!
Also listed under ML B161565
Active
$1,600,000
3248 Lockport Olcott Rd, Newfane, NY 14108
6beds
5,306sqft
Single Family Residence
Built in 1997
14.8 Acres Lot
$-- Zestimate®
$302/sqft
$-- HOA
What's special
Inground poolFloor-to-ceiling windowsBasketball courtOutdoor kitchenFinished basementPergola-covered dining areaPool house
- 329 days |
- 910 |
- 22 |
Zillow last checked:
Listing updated:
Listing by:
WNY Metro Roberts Realty 716-875-2211,
Michelle Petrie 716-293-2817
Source: NYSAMLSs,MLS#: B1613553
Originating MLS: Buffalo
Originating MLS: BuffaloTour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
- Main level bathrooms: 3
- Main level bedrooms: 2
Heating
- Gas, Zoned, Forced Air
Cooling
- Zoned, Central Air
Appliances
- Included: Built-In Range, Built-In Oven, Double Oven, Dryer, Dishwasher, Exhaust Fan, Gas Cooktop, Disposal, Gas Oven, Gas Range, Gas Water Heater, Microwave, Range Hood, Washer, Humidifier
- Laundry: Main Level
Features
- Breakfast Bar, Den, Separate/Formal Dining Room, Entrance Foyer, Eat-in Kitchen, Guest Accommodations, Granite Counters, Home Office, Kitchen Island, Pantry, See Remarks, Second Kitchen, Walk-In Pantry, Air Filtration, Bedroom on Main Level, In-Law Floorplan, Bath in Primary Bedroom, 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: Attached, Garage, Circular Driveway, Driveway, Other
- Attached garage spaces: 3
Features
- Patio & porch: Patio
- Exterior features: Barbecue, Concrete Driveway, 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
- Additional structures: Gazebo, Pool House
- Parcel number: 2928000530130001050001
- Special conditions: Standard
- Horses can be raised: Yes
- Horse amenities: Horses Allowed
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary,Two Story
- Property subtype: Single Family Residence
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: 532 days
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
Estimated market value
Not available
Estimated sales range
Not available
$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
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: 5-9Distance: 1.9 mi
- 6/10Newfane Senior High SchoolGrades: 6-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
