3248 Lockport Olcott Road
Newfane, NY 14108
Map
- 6 beds
- 5 baths
- 5,306 sqft
- ~15 acre lot
- $301 per sqft
- 1997 build
- – on site
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
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 10, 2025
•
MLS# B1613565 —
This property is listed in more than one place. See it here.
The Building
-
Year Built:1997
-
Year Built Details:Existing
-
Construction Materials:Stone,Stucco,VinylSiding
-
Roof:Asphalt
-
Basement:Full,Finished
-
Basement:true
-
Foundation Details:Poured
-
Exterior Features:Barbecue,HotTubSpa,Pool,Patio
-
Patio And Porch Features:Patio
-
Building Area Total:5306.0
-
Building Area Source:PublicRecords
Interior
-
Interior Features:AirFiltration,ProgrammableThermostat
-
Flooring:CeramicTile,Hardwood,Varies
-
Fireplace:true
-
Fireplaces Total:2
-
Stories Total:1
Room Dimensions
-
Living Area:5,306 Sqft
Financial & Terms
-
Rent Includes:Other,SeeRemarks
Location
-
Directions: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
The Property
-
Property Type:Residential
-
Property Subtype:MultiFamily
-
Property Condition:Resale
-
Parcel Number:292800-053-013-0001-050-001
-
Lot Features:IrregularLot,Secluded,Wooded
-
Lot Size Dimensions:221X900
-
Lot Size Acres:14.8
-
Lot Size SqFt:644688.0
-
Lot Size Area:14.8
-
Lot Size Units:Acres
-
Frontage Length:900
-
Waterfront:false
-
Waterfront Features:RiverAccess,Stream
-
Water Body Name:Twelvemile Creek
-
Horse:true
-
Horse Amenities:HorsesAllowed
Listing Agent
- Contact info:
- Agent phone:
- (585) 749-8275
- Office phone:
- (716) 875-2211
Taxes
-
Tax Lot:50
-
Tax Annual Amount:18816.0
-
Tax Assessed Value:412000
Beds
-
Bedrooms Total:6
Baths
-
Total Baths:5
-
Full Baths:4
-
Half Baths:1
-
Spa:true
The Listing
-
Virtual Tour URL Branded:https://media.wnyds.com/videos/018fea6c-1d7a-7351-bd8c-e436276eb09a
-
Virtual Tour URL Unbranded:https://my.matterport.com/show/?m=oBucsZGRuvW&qs=0&help=2&brand=0&mls=1&
-
Virtual Tour URL Unbranded 2:https://my.matterport.com/show/?m=oBucsZGRuvW&qs=0&help=2&brand=0&mls=1&
Heating & Cooling
-
Heating:Gas,Zoned,ForcedAir
-
Heating:true
-
Cooling:Zoned,CentralAir
-
Cooling:true
Utilities
-
Utilities:SewerConnected,WaterConnected
-
Sewer:Connected
-
Water Source:Connected,Public
Appliances
-
Appliances:GasWaterHeater,Humidifier
Schools
-
Elementary School District:Newfane
-
Middle Or Junior School District:Newfane
-
High School District:Newfane
The Community
-
Senior Community:false
-
Pool Features:InGround
Parking
-
Garage:true
-
Garage Spaces:3.0
-
Parking Features:Concrete,TwoOrMoreSpaces
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Sale history
| Date | Event | Source | Price | % Change |
|---|---|---|---|---|
|
6/10/25
Jun 10, 2025
|
Listed / Active | NYSAMLS | $1,600,000 |
