For Sale
    • For Sale
    • For Lease
    • Recently Sold
    • Property Lookup
    • Brokers
    Back to Search
    Multi-Family Estate with In-Law Suite Title is generated by Realmo AI

    3248 Lockport Olcott Road, Newfane, NY 14108

    View on Map
    Claim this Listing
    For Sale
    $1,350,000

    MULTI_FAMILY - Newfane, NY

    Property size:
    5,306 SF
    Lot size:
    14.80 Acres
    Price / SF:
    $254/SF
    Added:
    Jun 10, 2025
    Days on Market:
    392
    Last Refresh:
    Jul 6 at 9:06 am

    Property Features for 3248 Lockport Olcott Road

    General Information

    Property type
    Residential Multi Family
    Property subtype
    Other
    Bedrooms
    6
    Bathrooms
    5
    Rooms
    Bedroom 3, Bathroom 3, Bedroom 4, Bedroom 5, Bathroom 2, Bathroom 4, Bedroom 6, Bedroom 1, Bathroom 1, Bathroom 5, Basement, Bedroom 2
    Spa
    1
    Patio and Porch features
    Patio
    Interior features
    AirFiltration, ProgrammableThermostat
    Exterior features
    Barbecue, HotTubSpa, Pool, Patio
    Fireplace
    1
    Appliances
    GasWaterHeater, Humidifier
    Standard status
    Active
    APN
    292800-053-013-0001-050-001
    Size
    5,306 SF
    Lot size
    14.80 Acres

    Taxes and HOA fees

    Tax Annual Amount
    18816

    Utilities

    Heating system
    Natural Gas, Forced Air, Zoned
    Cooling system
    Central Air, Zoned
    Water source
    Public
    Water front features
    River Access, Stream

    Building Details

    Year built
    1997
    Floors in Building
    1
    Number of units
    2
    Flooring type
    Hardwood, Tile, Varies
    Building materials
    Stone, Stucco, VinylSiding
    Roof type
    Asphalt

    We can help!

    Contact an agent
    Michelle Petrie

    Listing agent Michelle Petrie License #10401343898

    Listing office WNY Metro Roberts Realty 2211 Sheridan Drive, cheektowaga, NY

    Listing date Jun 10, 2025

    MLS# B1613565 Listing URL

    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.

    HighLights

    • Custom home built in 1997 on over 14 acres with mature trees and a peaceful creek; stream and river access reported
    • Resort‑style backyard with inground pool, hot tub (spa), outdoor kitchen, barbecue, and expansive patios (incl. patio/pergola dining area)
    • Multi‑generational layout with separate in‑law suite featuring 2 bedrooms, a full bath, and its own living area
    • Zoned HVAC with natural gas forced‑air heating and zoned central air; programmable thermostat plus air filtration
    • Finished basement includes a private gym; fireplace on‑site
    • Public water and asphalt shingle roof; stone, stucco, and vinyl siding; recent upgrades include new garage doors and new AC condensers

    Overview

    This custom-built multi-family estate offers flexible living arrangements with a main residence and a separate in-law suite. The main home includes four bedrooms and three baths, highlighted by an oversized chef’s kitchen and an appointed dining room. A separate in-law suite provides two bedrooms, a full bath, and its own living area, creating a private setup for extended guests, family members, or long-term stays.

    Set on 14.8 acres of private grounds, the property is described as surrounded by mature trees and a peaceful creek. Outdoor features include an inground pool, hot tub, outdoor kitchen, pergola dining area, pool house, basketball court, and expansive patios.

    Recent upgrades include brand new garage doors and new AC condensers. With finished basement space that includes a private gym, the home supports a lifestyle geared toward both everyday comfort and hosted gatherings. This configuration may appeal to buyers seeking a residence with distinct living areas while still keeping multiple groups under one property.
    Property Profile Location Intelligence

    Current Use by Public Records

    Single family properties

    Suggested Use

    Real Estate Agency Big Box & Wholesale Store Hair Salon Hotel & Motel Dental Office Gym & Fitness Center Food Market Storage Facility Garden Center Discount Store

    Zoning and permitted uses should be independently verified with local authorities.

    Location Insight

    • Map
    • Local Demand
    City
    Newfane
    County
    Niagara
    State
    New York
    Longitude
    -78.698613
    Latitude
    43.257316

    FAQs

    What type of property is this?
    Single family property - Custom estate includes a separate in-law suite and extensive outdoor amenities for flexible multi-generational living.
    Where is this single family property located?
    The property is located at 3248 Lockport Olcott Road Newfane, NY.
    What is the asking price?
    The asking price for this property is $1,350,000.
    What are key features of this property?
    This property features: Custom home built in 1997 on over 14 acres with mature trees and a peaceful creek; stream and river access reported; Resort‑style backyard with inground pool, hot tub (spa), outdoor kitchen, barbecue, and expansive patios (incl. patio/pergola dining area); Multi‑generational layout with separate in‑law suite featuring 2 bedrooms, a full bath, and its own living area
    More about this property
    Thanks! Your message was sent.
    Error! Your message wasn't sent.
    Please enter your name
    Please enter email
    Please enter the email in the correct format
    Please enter phone
    Please enter the number in the correct format
    Please enter message