3248 Lockport Olcott Rd

5,306 Sq. Ft.
$302 / Sq. Ft.
5,306
Sq. Ft.
$302
per 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....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
  1. Listed by Michelle Petrie • WNY Metro Roberts Realty
    P: (716)-875-2211 C: (585)-749-8275 Michelle@thepetrieteam.com

Property Details for 3248 Lockport Olcott Road

Waterfront Description
River Access, Stream
On Waterfront
No
Parking Description
Concrete, Two Or More Spaces
Nearest Cross Street
Jaques Rd.
LISTING UPDATED: 06/11/2026 04:15 PM

Property Details for 3248 Lockport Olcott Road

StatusActive
MLS #B1613565
Days on Market378
Taxes$18,816 / year
HOA Fees-
Condo/Co-op Fees-
Property TypeMulti Family
MLS TypeResidential / Residential
Year Built1997
Lot Size14.80 AC / 644,688 SF
CountyNiagara County

Location

Listing Courtesy of WNY Metro Roberts Realty
Add your commute

Building Information for 3248 Lockport Olcott Road

Stories1Residences2Year Built1997Building Size-Lot Size14.80 AC / 644,688 SF

Payment Calculator

$9,541 per month

30 year fixed, 6.36% Interest

Principal and Interest

$7,973

Property Taxes

$1,568

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 3248 Lockport Olcott Road

Summary
Location and General Information
  • Elementary School District: Newfane
  • High School District: Newfane
  • Middle Or Junior School District: Newfane
  • Village: Not Applicable
  • Human YN: Yes
Parking
  • Garage Spaces per Apt: 3.00
  • Garage YN: Yes
Taxes and HOA Information
  • Area NYSWIS Code: Newfane-292800
  • Tax Annual Amount: $18,816.00
Property
Lot Information
  • Building Area Source: Public Records
  • Building Area Total: 5306.0
  • Horse Amenities: Horses Allowed
  • Horse YN: Yes
  • Land Features: Irregular Lot, Secluded, Wooded
  • Num Of Acres: 14.8
  • Lot Size Area: 14.8
  • Lot Size Square Feet: 644688.0
  • Lot Size Units: Acres
  • Parcel Number: 292800-053-013-0001-050-001
  • Lot Number: 50
Property and Assessments
  • Property Condition: Resale
  • Senior Community YN: No
  • Assessed Value: $412,000
  • Year Built: 1997
  • Year Built Description: Existing
Utilities
  • Num Of Electric Meters: 1
  • Num Of Gas Meters: 1
  • Sewer Description: Connected
  • Utilities Available: Sewer Connected, Water Connected
  • Water Supply: Connected, Public
Interior and Exterior Features
Exterior Features
  • Construction Materials: Stone, Stucco, Vinyl Siding
  • Exterior Features: Barbecue, Hot Tub Spa, Pool, Patio
  • Foundation Description: Poured
  • Waterfront Footage: 900
  • Patio And Porch Features: Patio
  • Pool Features: In Ground
  • Roof Description: Asphalt
  • Waterfront Name: Twelvemile Creek
Interior Features
  • Appliances: Gas Water Heater, Humidifier
  • Basement Description: Full, Finished
  • Basement YN: Yes
  • Num Of Possible Bedrooms: 6
  • HVAC Type: Zoned, Central Air
  • Cooling YN: Yes
  • Num Fireplaces Total Calculated: 2
  • Fireplace YN: Yes
  • Floor Description: Ceramic Tile, Hardwood, Varies
  • Heating: Gas, Zoned, Forced Air
  • Heating YN: Yes
  • Interior Features: Air Filtration, Programmable Thermostat
  • Sq Ft Total: 5306.0
  • Main Level Bathrooms: 0
  • Spa YN: Yes
Multi Family
Multi-Family Information
  • Number Of Units In Community: 2
  • Number Of Units Total: 2
  • Operating Expense Includes: Other, See Remarks
  • Stories Total: 1
Unit 1
  • Unit Type Actual Rent: $.00
  • Unit Type Baths Total: 4
  • Unit Type Beds Total: 4
  • Features: Dishwasher,Dryer,Oven/ Range,Refrigerator,Washer,Microwave,Eat-In Kitchen,Formal Dining Room,Living Room,Porch
  • Unit Type Total Rent: $.00
  • Unit Type Num Full Baths: 3
  • Unit Type Num Half Baths: 1
  • Unit Type Actual Rent Range: 0
Unit 2
  • Unit Type Actual Rent: $.00
  • Unit Type Baths Total: 1
  • Unit Type Beds Total: 2
  • Features: ,Den/Family Room,Eat-In Kitchen,Living Room,Porch
  • Unit Type Total Rent: $.00
  • Unit Type Num Full Baths: 1
  • Unit Type Num Half Baths: 0
  • Unit Type Actual Rent Range: 0
Rental
Rental Information
  • Rent Includes: Other, See Remarks

Property History for 3248 Lockport Olcott Road

DateEvent & SourcePriceAppreciation
Jun 9, 2026

Expired

WNYREIS #B1613553

Jun 9, 2026

Expired

New York State Alliance of MLSs (Buffalo) #B1613553

$1,600,000
Jun 10, 2025

Listed (Active)

New York State Alliance of MLSs (Buffalo) #B1613565

$1,600,000
DateEvent & SourcePrice
06/09/2026

Expired

WNYREIS #B1613553

06/09/2026

Expired

New York State Alliance of MLSs (Buffalo) #B1613553

$1,600,000
06/10/2025

Listed (Active)

New York State Alliance of MLSs (Buffalo) #B1613565

$1,600,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 3248 Lockport Olcott Road

Taxable ValueLand$37,400Additions$374,600Total$412,000
Home Facts
Beds6Baths3.5Total Finished SqFt5,306 SqFtAbove Grade Finished SqFt5,306 SqFtStories2Lot Size644,688 SqFtStyleMiscellaneous ResidentialYear Built1997CountyNIAGARAAPN292800 53.13-1-50.1Fireplace TypeHas Fireplace

Schools near 3248 Lockport Olcott Road

This home is within Newfane Central School District.
Rating
School
Type
Grades
Distance
Public - K to 4
Public - 4 to 8
Public - 7 to 12
Rating
School
Distance
Newfane Elementary School
PublicK to 4

Newfane Middle School
Public4 to 8

Newfane Senior High School
Public7 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

3248 Lockport Olcott Road is a multi-family home for sale in Newfane, NY 14108. This property was listed for sale on June 10, 2025 by WNY Metro Roberts Realty, it's currently listed at $1,600,000. It has been on the market for a total of 378 days and was last sold on May 31, 2003. This listing's school district is Newfane Central School District. Nearby schools include Newfane Elementary School, Newfane Middle School and Newfane Senior High School. 3248 Lockport Olcott Road is a 6-bed, 5-bath, 5,306 sqft multi-family home built in 1997.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of WNY Metro Roberts Realty

Based on information from one of the following Multiple Listing Services: WNYREIS and Greater Binghamton Association of REALTORS. Information being provided is for the visitor's personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by WNYREIS and Greater Binghamton Association of REALTORS is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.