3248 Lockport Olcott Road

About this home

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

Interior 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

Exterior features

• Barbecue
• Concrete Driveway
• Hot Tub Spa
• Pool
• Patio

Appliances

• 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

Mechanical

Schools

Tax & finance

Location

Newfane, NY 14108 · Niagara County

Open in Google Maps ↗