David E. Cornwell
Licensed Real Estate Salesperson
REALTOR®
Walton, NY
Office: (607) 865-7000 (607) 437-8941

3248 Lockport Olcott Road, Newfane, NY 14108

50 Total Photos [Click to View All]

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

3248 Lockport Olcott Road | MLS# B1613565

This multi-family property located at 3248 Lockport Olcott Road, Newfane, NY 14108 is currently listed for sale with an asking price of $1,600,000. Lockport Olcott Road is located within the Newfane school district. Search Newfane real estate on david-cornwell.timberlandproperties.com today.

Gallery

Property Features

Property Type: Multi Unit - Multiple
Basement: Full, Finished
Cooling: Zoned, Central Air
Fireplaces: 2
Garage: 3
Heating: Gas, Zoned, Forced Air
Lot Size: 14.80 Acres
Roof Type: Asphalt
Stories: 1.0
Taxes: $18,816
Year Built: 1997

Amenities

Air Filtration
Programmable Thermostat
Barbecue
Hot Tub/Spa
Pool
Patio

Feature Descriptions

Appliances: Gas Water Heater, Humidifier
Body of Water: Twelvemile Creek
Days on Site: 266
Exterior: Stone, Stucco, Vinyl Siding
Flooring: Ceramic Tile, Hardwood, Varies
Horse Amenities: Horses Allowed
Hot Tub: Yes
Lot: Irregular Lot, Secluded, Wooded
Lot Dimensions: 221X900
Parcel#: 292800-053-013-0001-050-001
Parking: Concrete, Two or More Spaces
Parking Notes: Concrete, Two or More Spaces
Patio/Porch: Patio
Pool: In Ground
Sewer: Connected
Spa: Yes
Swimming Pool: Yes
Units: 2
Utilities: Sewer Connected, Water Connected
Water: Connected, Public
Water Features: River Access, Stream

Local Schools

School District: Newfane

Estimate Your Payment

Estimated Payment

$ 5,595.57 per month $3,560.91 Principal & Interest $1,568.00 Property Tax $466.67 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: WNY Metro Roberts Realty
Agency Contact: 716-293-2817

Shown By

Agent Name: David E. Cornwell
Agent Phone: (607) 437-8941
Agency Title: Timberland Properties

IDX logo

All information is deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither broker(s), nor agent(s) shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless. Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 03/03/2026. The listing information on this page last changed on 03/03/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Tue 03/03/2026 1:11:47 AM EST) or Global MLS (last updated Tue 03/03/2026 1:06:55 AM EST) or New York State Alliance MLS (last updated Tue 03/03/2026 1:10:29 AM EST) or Hudson Valley Catskill Region MLS (last updated Tue 03/03/2026 12:11:14 AM EST) or OneKey MLS (last updated Tue 03/03/2026 1:10:05 AM EST). Real estate listings held by brokerage firms other than Timberland Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

All information is deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither broker(s), nor agent(s) shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless.

Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel