855.375.4001
Listing Courtesy of: 716-293-2817 - Michelle Petrie - WNY Metro Roberts Realty 716-875-2211
$1,600,000 affordable loan icon Calculate Payment

3248 Lockport Olcott Rd Newfane, NY 14108

Down payment assistance icon
Single Family Residence
6 Beds
5 Baths
... Bed/Bath
5,306 Sq. Ft.

Property Activity

Time on Site
days
Days on Market
Views
Saves
Last updated on 1/30/2026 11:11 PM
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 b...ackyard 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 Continue reading
MLS#
B1613553
Property Type
Single Family
Bedrooms
6
Bathrooms
4 Full/1 Half
Year Built
1997
Square Feet
5,306 sq. ft
Lot Size
14.8
Stories
2.0
Sewer
Sewer Connected

Receive an email as soon as the price changes

Receive an email

as soon as the price changes
Get Price Alerts
price alerts icon

Get Price Alerts

Don't miss your chance. Receive an email as soon as the price changes.

Notify Me

Get email alerts when
a home price changes

Sign up
view of kitchen

Walk Score measures the walkability of any address, Transit Score measures access to public transit on a scale of 1-100.

Source: Walk Score®
scales icon

How much home can I afford?

Kickstart your home search journey with our online Pre-Approval.

Get Started
megaphone icon

See How Much You Could Save

Thinking about buying or selling? Talk to one of our Mortgage Professionals today to see how much you could save on your next home. Call us at 833-981-2030.

Let's Talk
Listing Courtesy of: 716-293-2817 - Michelle Petrie - WNY Metro Roberts Realty 716-875-2211
Andrea D. Conner, License 10311208085, Xome Inc., License 10991227159, [email protected], 844-400-XOME (9663), 750 Highway 121 Bypass, Suite 100, Lewisville, Texas 75067


The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of the New York State Alliance of MLSs (CNYIS, UNYREIS and WNYREIS). Real estate listings held by firms other than Xome are marked with the IDX logo and detailed information about them includes the Listing Broker’s Firm Name. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither the listing broker(s) nor Xome shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless. Per New York legal requirement, click here for the Standard Operating Procedures. Copyright © 2026 CNYIS, UNYREIS, WNYREIS. All rights reserved.
This content last refreshed on 1/30/2026 11:11 PM. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Information is deemed reliable but is not guaranteed.
save icon Save
save icon Save
share icon Share
checkmark icon Get Pre-Approved