Skip main navigation
For sale
  • $1,600,000

    3248 Lockport Olcott Rd, Newfane, NY 14108

    6beds
    5,306sqft
    Single Family Residence
    Built in 1997
    14.8 Acres Lot
    $1,637,800 Zestimate®
    $302/sqft
    $-- HOA

    What's special

    Inground poolFloor-to-ceiling windowsBasketball courtOutdoor kitchenFinished basementPergola-covered dining areaPool house
    Why vacation when you can come home to your own private resort? Tucked away on over 14 pristine acres, this stunning custom-built mansion offers a sanctuary of luxury, privacy, and recreation—surrounded by mature trees and a tranquil creek. Step outside to an entertainer’s paradise: an incredible backyard oasis featuring an inground pool, bubbling hot tub, outdoor kitchen, pergola-covered dining area, pool house, basketball court, and expansive concrete patios—perfect for gatherings, celebrations, or simply relaxing in your own slice of paradise. Arrive via the winding driveway and be captivated by a home straight out of a dream. Inside, discover exquisite craftsmanship with custom woodwork and cabinetry, gleaming hardwood floors, floor-to-ceiling windows, and designer light fixtures throughout. The spacious main house offers 4 bedrooms and 3 baths, including a luxurious primary suite with a spa-inspired bathroom and a walk-in closet fit for royalty. Hosting family or guests? The separate in-law apartment features 2 bedrooms and 1 bath, while the finished basement includes a private gym—ideal for fitness enthusiasts. Enjoy holiday feasts and everyday meals in the oversized chef’s kitchen with eat-in area, or entertain in the beautifully appointed formal dining room. Recent upgrades include brand new garage doors and new AC condensers, providing peace of mind and modern convenience. The possibilities here are endless. Imagine the memories you’ll make in this extraordinary estate—where every day feels like a getaway. Where else would you rather be than right here, right now? Schedule your private tour today and experience the lifestyle you’ve always dreamed of! Also listed under ML B161565
    6 days
    on Zillow
    |
    532
    |
    10
    |

    Zillow last checked: 7 hours ago

    Listing updated: June 10, 2025 at 12:22pm

    Listing by:

    WNY Metro Roberts Realty 716-875-2211,

    Michelle Petrie 716-293-2817

    Source: NYSAMLSs,MLS#: B1613553MLS LogoOriginating MLS: Buffalo
    Travel times

    Tour with a buyer’s agent

    We’ll find a local expert to take you on a private tour of 3248 Lockport Olcott Rd.

    Next available tour time:Today at 11am

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 6
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    • Main level bathrooms: 3
    • Main level bedrooms: 2
    Heating
    • Gas, Zoned, Forced Air
    Cooling
    • Zoned, Central Air
    Appliances
    • Included: Built-In Range, Built-In Oven, Double Oven, Dryer, Dishwasher, Exhaust Fan, Gas Cooktop, Disposal, Gas Oven, Gas Range, Gas Water Heater, Microwave, Range Hood, Washer, Humidifier
    • Laundry: Main Level
    Features
    • Breakfast Bar, Den, Separate/Formal Dining Room, Entrance Foyer, Eat-in Kitchen, Guest Accommodations, Granite Counters, Home Office, Kitchen Island, Pantry, See Remarks, Second Kitchen, Walk-In Pantry, Air Filtration, Bedroom on Main Level, In-Law Floorplan, Bath in Primary Bedroom, Programmable Thermostat
    • Flooring: Ceramic Tile, Hardwood, Varies
    • Basement: Full,Finished
    • Number of fireplaces: 2
    Interior area
    • Total structure area: 5,306
    • Total interior livable area: 5,306 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Attached, Garage, Circular Driveway, Driveway
    • Attached garage spaces: 3
    Features
    • Patio & porch: Patio
    • Exterior features: Barbecue, Concrete Driveway, Hot Tub/Spa, Pool, Patio
    • Pool features: In Ground
    • Has spa: Yes
    • Waterfront features: River Access, Stream
    • Body of water: Twelvemile Creek
    • Frontage length: 900
    Lot
    • Size: 14.8 Acres
    • Dimensions: 221 x 900
    • Features: Irregular Lot, Secluded, Wooded
    Details
    • Additional structures: Gazebo, Pool House
    • Parcel number: 2928000530130001050001
    • Special conditions: Standard
    • Horses can be raised: Yes
    • Horse amenities: Horses Allowed

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary,Two Story
    • Property subtype: Single Family Residence
    Materials
    • Stone, Stucco, Vinyl Siding
    • Foundation: Poured
    • Roof: Asphalt
    Condition
    • Resale
    • Year built: 1997

    Utilities & green energy

    • Sewer: Connected
    • Water: Connected, Public
    • Utilities for property: Sewer Connected, Water Connected

    Community & HOA

    Location
    • Region: Newfane

    Financial & listing details

    • Price per square foot: $302/sqft
    • Tax assessed value: $412,000
    • Annual tax amount: $18,816
    • Date on market: 6/10/2025
    • Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
    • Loading
    • Loading