Advertise
    For Sale
    • For Sale
    • For Lease
    • Recently Sold
    • Property Lookup
    • Brokers
    Back to Search
    Resort-Style 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,600,000

    MULTI_FAMILY - Newfane, NY

    Property size:
    5,306 SF
    Lot size:
    14.80 Acres
    Price / SF:
    $301/SF
    Added:
    Jun 10, 2025
    Days on Market:
    376
    Last Refresh:
    Jun 20 at 11:06 pm

    Property Features for 3248 Lockport Olcott Road

    General Information

    Property type
    Residential Multi Family
    Property subtype
    Other
    Bedrooms
    6
    Bathrooms
    5
    Rooms
    Bathroom 1, Bedroom 3, Bathroom 2, Basement, Bathroom 4, Bathroom 3, Bedroom 2, Bedroom 1, Bedroom 5, Bedroom 4, Bedroom 6, Bathroom 5
    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
    Zoned, Forced Air, Natural Gas
    Cooling system
    Zoned, Central Air
    Water source
    Public
    Water front features
    Stream, River Access

    Building Details

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

    We can help!

    Listing Contact
    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‑built home (1997) on 14+ acres with private creek and river access features
    • Main residence offers 4 bedrooms and 3 bathrooms, including a primary suite with spa‑inspired bathroom and walk‑in closet
    • Separate in‑law suite with 2 bedrooms, 1 full bath, and its own living area
    • Finished basement includes a private gym
    • Backyard amenities include an inground pool, hot tub, outdoor kitchen, pergola dining area, pool house, patios, and barbecue
    • Recent upgrades include brand new garage doors and new AC condensers; home has zoned forced‑air heating and zoned central air

    Overview

    This custom-built mansion, situated on over 14 acres, offers resort-style living with privacy and versatility. The main residence features 4 bedrooms and 3 baths, including a primary suite with a spa-inspired bathroom and a walk-in closet. An oversized chef's kitchen and a dining room accommodate gatherings and celebrations. A separate in-law suite includes 2 bedrooms, a full bath, and its own living area. The finished basement features a private gym. The backyard is equipped for entertaining with an inground pool, hot tub, outdoor kitchen, pergola dining area, pool house, basketball court, and expansive patios. Recent upgrades include new garage doors and new AC condensers. The property offers 5306 square feet of living space and is located in Newfane, NY.
    Property Profile Location Intelligence

    Current Use by Public Records

    Single family properties

    Suggested Use

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

    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 - Luxury estate on 14+ acres with pool, gym, and more.
    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,600,000.
    What are key features of this property?
    This property features: Custom‑built home (1997) on 14+ acres with private creek and river access features; Main residence offers 4 bedrooms and 3 bathrooms, including a primary suite with spa‑inspired bathroom and walk‑in closet; Separate in‑law suite with 2 bedrooms, 1 full bath, and its own living area
    (585) 749-8275
    We can help!
    Listing Contact
    Michelle Petrie
    Real Estate License ID: 10401343898
    Request Owner's contact information
    Message sent successfully
    Error
    If you are the owner or broker of this property and would like to edit or remove this listing please send a message to web site administrator.
    Message sent successfully
    Error
    Email to Your Friends
    Link copied to clipboard
    Separate multiple addresses with a comma
    Message sent successfully
    Error
    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
    Thank You

    You are Unsubscribed From Notifications

    Thank You for Inquiry
    3248 Lockport Olcott Road, Newfane, NY 14108
    letter with green check mark
    Check your email
    We sent you the
    agent's contact details. yellow underline
    Can't find it?
    Please check your junk/spam folder.
    Google sign-in failed. Please try again or use another login method.
    Sign Up Successful!
    You now have access to more from Realmo!