For Sale
3D Tour3D Tour
Multi family home for sale at 3248 Lockport Olcott Rd, Newfane, NY 14108 | MLS# B1613565 | Listing updated on 2026-07-01
Photo 1 of Multi family home for sale at 3248 Lockport Olcott Rd, Newfane, NY 14108 | MLS# B1613565 | Listing updated on 2026-07-01
Photo 2 of Multi family home for sale at 3248 Lockport Olcott Rd, Newfane, NY 14108 | MLS# B1613565 | Listing updated on 2026-07-01
Photo 3 of Multi family home for sale at 3248 Lockport Olcott Rd, Newfane, NY 14108 | MLS# B1613565 | Listing updated on 2026-07-01
Photo 4 of Multi family home for sale at 3248 Lockport Olcott Rd, Newfane, NY 14108 | MLS# B1613565 | Listing updated on 2026-07-01
39+
Beds Icon

Virtual Tour

Beds Icon

Street View

$1,350,000

Monthly Est:$6,719

  • Beds Icon6 Beds
  • Beds Icon
    5 Baths
  • Beds Icon5,306sqft

3248 Lockport Olcott Rd, Newfane, NY 14108

$6,719/moEst:

Get Pre-Approved

  • Multi Family

  • Built in 1997

  • $-- HOA

  • 14.8 acres lot

  • $254/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. 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 apa
rt 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

  • Houzeo last checked: 2 minutes ago
  • Listing updated: July 1, 2026 at 6:13 pm
  • Listing Provided by: Michelle Petrie (585) 749-8275 DRE #10401343898 | WNY Metro Roberts Realty (716) 875-2211
  • Source: New York State Alliance of MLSs, Buffalo-NY | MLS#: B1613565 New York State Alliance of MLSs, Buffalo-NY

Property Details

  • Status

    Active

  • Type

    Multi Family

  • No. of Stories

    1

  • County

    Niagara County

  • City

    Newfane

  • Neighborhood

    --

  • Year Built

    1997

  • HOA Fees

    -

  • Finished Area

    5,306 sqft

  • Lot Size

    14.8 acres lot

  • Basement Area

    - sqft

  • MLS Name

    New York State Alliance of MLSs, Buffalo

  • MLS Number

    B1613565

  • MLS Status

    Active

  • Days on Market

    511

  • Cumulative Days on Market

    720

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 6

    Bathrooms: 5

Interior

  • Flooring

    Ceramic Tile, Hardwood, Varies

  • Appliances

    Gas Water Heater, Humidifier

  • Interior Features

    Air Filtration, Programmable Thermostat

  • Sewer

    Connected

  • Cooling

    Zoned, Central Air

  • Heating

    Gas, Zoned, Forced Air

  • Exterior Features

    Barbecue, Hot Tub Spa, Pool, Patio

Construction

  • Year Built

    Year Built: 1997

  • Home type

    Multi Family

  • Construction Materials

    Stone, Stucco, Vinyl Siding

  • Foundation Details

    Poured

  • Property Condition

    Resale

  • Roof

    Asphalt

Utilities & Energy

  • Water Source

    Connected, Public

  • Parking Features

    Concrete, Two Or More Spaces

  • Pool Features

    In Ground

  • Basement

    Full, Finished

  • Utilities

    Sewer Connected, Water Connected

Other Features

  • Lot Features

    Irregular Lot, Secluded, Wooded

  • Patio And Porch Features

    Patio

Price History

DateEventPrice

06/11/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1613565

Off Market

$1,350,000

$254/sqft

06/11/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1613565

Listed for Sale

$1,350,000 -15.62%

$254/sqft

06/10/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1613553

Listing Removed

$1,600,000

$302/sqft

06/10/2025

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1613565

Off Market

$1,600,000 -15.79%

$302/sqft

04/25/2024

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1518296

Listing Removed

$1,900,000

$358/sqft

Show more

Based on data from the New York State Alliance of MLSs (CNYIS, Inc., UNYREIS and WNYREIS) through Nov 04, 2026, 09:00AM.. All information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable by is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 the New York State Alliance of MLSs. All Rights Reserved.

Advertising Broker: Derek Greene | The Greene Realty Group

Skip to Main Content