About This Home

This 6-bedroom, 5-bathroom residential multi family at 3248 Lockport Olcott Road in Newfane, NY is listed for $1,350,000 ($254 per sqft). Built in 1997, the home offers 5,306 sqft of living space on a 14.80 acres lot.

Key Features

  • Built in 1997
  • 14.80 acre lot
  • Fireplace

Property Details

1 story
4 full, 1 half
3-car garage
1997

Amenities

FireplaceSpaHardwoodA/C
Listing 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

Monthly Cost Estimate

$7,220/mo

20% down · 6.5% · 30 years

Principal$976
Interest$5,850
Insurance$394

Estimates only. Actual payments may vary.

Location

3248 Lockport Olcott Road

Newfane, NY 14108

Features & Amenities

Interior Features

AirFiltrationProgrammableThermostat

Exterior Features

BarbecueHotTubSpaPoolPatio

Property Details

Flooring

TileHardwoodVaries

Construction

Stone Stucco VinylSiding

Outdoor Features

Patio

Heating

Natural GasForced AirZoned

Cooling

Central AirZoned

Appliances

GasWaterHeaterHumidifier

Questions & Answers

This 6-bedroom, 5-bathroom residential multi family at 3248 Lockport Olcott Road is listed at $1,350,000 ($254/sqft). The estimated monthly payment is $7,220 based on 20% down, a 30-year loan at 6.5% interest, estimated insurance.

Key features include: Built in 1997, 14.80 acre lot, Fireplace. Interior Features: AirFiltration, ProgrammableThermostat. Exterior Features: Barbecue, HotTubSpa, Pool.

This property is listed by Michelle Petrie.

MP

Michelle Petrie

License 10401343898

Agent at WNY METRO ROBERTS REALTY

Listed by WNY METRO ROBERTS REALTY · Broker phone: (716) 891-1710 · View on Broker Site · Broker website

MLS# B1613565· Source: New York State Alliance of MLSs, LLC· 506 days on PropertySimple

Copyright © 2026 New York State Alliance of MLSs, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

3248 Lockport Olcott Road, Newfane, NY 14108

Open this listing in: