$1,600,000

3248 Lockport Olcott Road, Newfane, NY 14108

  • 6 beds |
  • 5 baths |
  • 5,306 sqft
  • Property Icon Multi-Family Home
  • Property Year Built Icon Built in 1997
  • Property Lot Size Icon14.8acre lot
  • Property Parking Icon 3 car garage
  • Property Price Per Square Feet Icon $302/sqft
  • Property List Date Icon Listed 4 months ago

Property Description

Experience resort-style living every day in this extraordinary estate, perfectly designed for extended guests and those seeking flexible space for events. Nestled on over 14 acres of private sanctuary—surrounded by mature trees and a peaceful creek—this custom-built mansion offers unmatched luxury, privacy, and versatility. The main residence features 4 spacious bedrooms and 3 elegant baths, including a primary suite with a spa-inspired bathroom and a walk-in closet designed for ultimate comfort. The heart of the home is an oversized chef’s kitchen and a beautifully appointed dining room—ideal for family gatherings and celebrations. What truly sets this property apart is the separate in-law suite, complete with 2 bedrooms, a full bath, and its own living area. Whether you’re accommodating parents, adult children, or long-term guests, this private space offers independence and comfort while keeping loved ones close. The finished basement boasts a private gym, and the backyard is an entertainer’s dream: enjoy an inground pool, hot tub, outdoor kitchen, pergola dining area, pool house, basketball court, and expansive patios—perfect for making memories across generations. Recent upgrades include brand new garage doors and new AC condensers for modern convenience and peace of mind. This estate is truly a rare find for families looking to live, entertain, and thrive together—all within their own private resort. Schedule your private tour today and discover the endless possibilities for multigenerational living! Also listed under ML B1613553

Listing Status:
Active
Date Added:
June 10, 2025 at 05:00AM
Listing Office:
WNY Metro Roberts Realty : 716-875-2211
Listing Agent:
Michelle Petrie : 585-749-8275
MLS ID:
B1613565
  • General: Air FiltrationProgrammable Thermostat
  • Appliances: Gas Water HeaterHumidifier
  • Basement: FullFinished
  • Flooring: Ceramic TileHardwoodVaries
  • A/C: ZonedCentral Air
  • Heating: GasZonedForced Air
  • Fireplace: FireplaceFireplaces: 2
  • General: BarbecueHot Tub/SpaPoolPatio
  • Pool: In Ground
  • Parking: ConcreteTwo or More Spaces
  • Roofing: Asphalt
  • General: StoneStuccoVinyl Siding1Poured
  • Originating MLS: NYS
  • School District: Newfane
  • County: Niagara
  • Zoning: 292800-053-013-0001-050-001
  • Utilities: Sewer ConnectedWater Connected
  • Water: ConnectedPublic
  • Sewer: Connected
  • Source: NYS

This listing courtesy of Michelle Petrie, WNY Metro Roberts Realty

Monthly Payment

$Est. Payment
  • Principal & Interest $
  • Property Taxes $
  • Home Insurance $
  • VA Funding Fee $

Ready to Start a VA Loan?

Get Started Veterans United Home LoansNMLS #1907  †
Get Prequalified »
Interest rates used in the VA mortgage calculator are shown for illustrative purposes only. Your rate may differ based on a variety of factors, including your credit score and the current market conditions. To get your personalized interest rate, start your quote online.

Location

Schools Nearby

N

Newfane Elementary School

2909 Transit Rd, Newfane, NY, 14108

Grades KG-4

1.18 miles away

N

Newfane Middle School

2700 Transit Rd, Newfane, NY, 14108

Grades 4-8

1.89 miles away

N

Newfane Senior High School

1 Panther Dr, Newfane, NY, 14108

Grades 8-12

2.08 miles away

Disclaimer: School and School District information courtesy of the National Center for Education Statistics (NCES). School boundaries may change. Proximity to listed schools does not guarantee enrollment eligibility. Contact the school district for more information and exact boundaries.