Email ListingPRINT Email ListingSAVE Click to CallCALL

3248 Lockport Olcott Road, Newfane, NY 14108$1,900,000

Beds: 6 Baths: 5 full Sq. Feet: 5,306 Days on Site: 557 MLS#: B1354534 View Map

Comments for 3248 Lockport Olcott Road, Newfane, NY 14108

Picture perfect custom dream home with luxury in-law setup, Roman heated pool, majestic gazebo & outdoor kitchen, 1/2 basketball court, amazing grounds with privacy right on the 18-Mile creek. Enter your winding concrete drive enjoying the meticulously kept grounds, lush artistic gardens throughout the 14 plus acres and trail paradise. The home has a spacious feel as you enter through the double custom doors into the grand foyer encountered by the beautiful winding grand staircase. Master den with custom built-in desk and shelving, Formal living room takes you to the beautiful formal dining room with custom-built china cabinet with french doors to the beautiful kitchen with granite counters. The kitchen offers a spacious breakfast area overlooking the pool and patio area. Family room with 2 separate seating areas with generously sized windows capturing every possible vista.Artistically designed master with a two-way fireplace to the spa-like master bath. Incredible oak flooring throughout the home. 3 car heated garage offering loads of storage. Full finished basement with bedroom, and massive gym. An artist could not have painted a better picture. Seller motivated and negotiable.

Property Type: Residential - Single Family Other Equipment: Generator
Accessibility: Low Threshold Shower, No Stairs, Accessible Doors Parcel#: 292800-053-013-0001-0050-001
Appliances: Built-In Range, Built-In Oven, Double Oven, Dryer, Dishwasher, Exhaust Fan, Gas Cooktop, Gas Oven, Gas Range, Gas Water Heater, Microwave, Refrigerator, Range Hood, Washer, Water Softener Owned Parking: Attached, Circular Driveway, Driveway, Garage Door Opener
Basement: Full, Finished, Sump Pump Parking Notes: Attached, Circular Driveway, Driveway, Garage Door Op
Cooling: Central Air Patio/Porch: Balcony, Deck, Open, Patio, Porch
Days on Site: 557 Pool: In Ground
Door Features: Sliding Doors Roof Type: Asphalt
Exterior: Stone, Stucco, Vinyl Siding, Copper Plumbing Security: Security System Owned
Exterior Features: Awning(s), Balcony, Concrete Driveway, Deck, Gas Grill, Sprinkler/Irrigation, Pool, Patio Sewer: Connected
Fireplaces: 1 Spa: Yes
Flooring: Ceramic Tile, Hardwood, Varies Spa: Hot Tub
Garage: 3 Stories: 2.0
Heating: Gas, Zoned, Forced Air Swimming Pool: Yes
Home Style: Contemporary, Two Story Taxes: $17,400
Interior Features: Breakfast Bar, Ceiling Fan(s), Cathedral Ceiling(s), Central Vacuum, Den, Separate/Formal Dining Room, Entrance Foyer, Eat-in Kitchen, Separate/Formal Living Room, Guest Accommodations, Granite Counters, Home Office, Hot Tub/Spa, Jetted Tub, Country Kitchen, Kitchen Isl Utilities: Cable Available, High Speed Internet Available, Sewer Connected, Water Connected
Laundry: Main Level Water: Connected, Public
Lot Description: Agricultural, Wooded Window: Drapes, Leaded Glass
Lot Dimensions: 221X900 Year Built: 1997
Lot Size: 14.80 Acres  
Bedroom 1: 19.00 x 16.00 Level - Second Kitchen: 16.00 x 15.00 Level - First
Other: 15.00 x 18.00 Level - First Dining Room: 16.00 x 15.00 Level - First
Other: 12.00 x 15.00 Level - First Living Room: 20.00 x 16.00 Level - First
Other: 13.00 x 15.00 Level - First Other: 12.00 x 11.00 Level - Second
Other: 14.00 x 11.00 Level - First Bedroom 3: 15.00 x 11.00 Level - Second
Family Room: 19.00 x 17.00 Level - First Bedroom 2: 23.00 x 19.00 Level - Second
School District: Newfane

Listing By

Agency Name: Keller Williams Realty WNY
Agency Contact: 716-832-3300

Shown By

Agency Title: MJ Peterson Real Estate
Agency Phone:

IDX logo

Newfane School District Residential Market Trend Graphs

  • Newfane School District
  • Zip Code 14108
  • Newfane
  • Niagara County

Niagara County Demographic Information for 3248 Lockport Olcott Road, Newfane, NY 14108

Fips Code36063
2020 to 2021 Changedown 0.5%
2010 Count216,469
2020 Count212,666
2021 Estimate211,653
2010 Estimate216,480
Age Distribution (Years Old)
0 to 45.3%
5 to 1719.9%
18 to 6455.2%
65 and Older19.6%
Place of Birth
High School Graduate, Age 25+91.5%
Bachelor's Degree or Higher, Age 25+25.6%
Computer and Internet use
Households with a computer88.6%
Households with a broadband Internet subscription82.5%
English is Second Language, Age 5+4.8%
English is First Language, Age 5+95.2%
Per Capita Income$31,762
Median Household Income$57,252
People in Poverty11.7%
Average Work Commute Time23 minutes
Total Housing Units100,539
Average Household Size2.29
Owner-Occupied Median Value$131,600
Median selected monthly owner costs -with a mortgage$1,278
Median selected monthly owner costs -without a mortgage$541
Median gross rent$714
Building Permits
New Private Housing Issued 2020205
Years at Residence
1 Year or More91.0%
Less Than 1 Year9.0%
Business and Employment
Private non-farm Establishments4,516
Private non-farm Employment61,980
Private non-farm Employment Growthdown 2.1%
Nonemployer Establishments10,336
Number of Firms12,167
Business Production
Value of Shipments$3,134,915,000
Wholesale Trade$1,506,419,000
Retail Trade$2,521,578,000
Retail Sales Per Capita$11,722
Accommodation and Food Services$1,055,916,000
Land Area522.36 sq. miles
Population Per Square Mile415
Schedule a showing...
or ask questions!

All fields labeled with an asterisk(*) are required.

Contact Form
    Choose your video chat app

Mortgage Payment Calculation for 3248 Lockport Olcott Road, Newfane, NY 14108

  • %
  • years/fixed
  • yearly
  • yearly (estimated)
  • Est. Payment: $9,979.08 / per month

(Payments are an estimate and may vary by lender)

Login to My Homefinder

Login to My Homefinder