3248 Lockport Olcott Road Newfane, NY 14108

Active

$2,500,000

Market Estimate

Request Info

6 Beds
5 Baths
5,306 sq. ft.
Single-Family
MLS# B1354534

3248 Lockport Olcott Road, Newfane, NY 14108

Listing provided courtesy of: Keller Williams Realty WNY

Favorite Share

Views: 819 Days On Site: 305

Go Tour This Listing

Friday 27 May

Saturday 28 May

Sunday 29 May

Monday 30 May

Tuesday 31 May

Wednesday 01 Jun

Thursday 02 Jun

Friday 03 Jun

Saturday 04 Jun

Sunday 05 Jun

Monday 06 Jun

Tuesday 07 Jun

Wednesday 08 Jun

Thursday 09 Jun

Friday 10 Jun

Saturday 11 Jun

Sunday 12 Jun

Monday 13 Jun

Tuesday 14 Jun

Wednesday 15 Jun

Thursday 16 Jun

Friday 17 Jun

Saturday 18 Jun

Sunday 19 Jun

Monday 20 Jun

Tuesday 21 Jun

Wednesday 22 Jun

Thursday 23 Jun

Friday 24 Jun

Saturday 25 Jun

Sunday 26 Jun

Monday 27 Jun

Tuesday 28 Jun

Wednesday 29 Jun

Thursday 30 Jun

Friday 01 Jul

Saturday 02 Jul

Sunday 03 Jul

Monday 04 Jul

Tuesday 05 Jul

Wednesday 06 Jul

Thursday 07 Jul

Friday 08 Jul

Saturday 09 Jul

Sunday 10 Jul

Monday 11 Jul

Tuesday 12 Jul

Wednesday 13 Jul

Thursday 14 Jul

Friday 15 Jul

Saturday 16 Jul

Sunday 17 Jul

Monday 18 Jul

Tuesday 19 Jul

Wednesday 20 Jul

Thursday 21 Jul

Friday 22 Jul

Saturday 23 Jul

Sunday 24 Jul

Monday 25 Jul

Tuesday 26 Jul

Wednesday 27 Jul

Thursday 28 Jul

Friday 29 Jul

Saturday 30 Jul

Sunday 31 Jul

Monday 01 Aug

Tuesday 02 Aug

Wednesday 03 Aug

Thursday 04 Aug

Friday 05 Aug

Saturday 06 Aug

Sunday 07 Aug

Monday 08 Aug

Tuesday 09 Aug

Wednesday 10 Aug

Thursday 11 Aug

Friday 12 Aug

Saturday 13 Aug

Sunday 14 Aug

Monday 15 Aug

Tuesday 16 Aug

Wednesday 17 Aug

Thursday 18 Aug

Friday 19 Aug

Saturday 20 Aug

Sunday 21 Aug

Monday 22 Aug

Tuesday 23 Aug

Wednesday 24 Aug

Schedule A Showing

Property Details

Description Tours Videos

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. Furnishings available for sale.

General Features
- Area Newfane-292800
- Pool Features In Ground
- Waterfront Y/N 0
- YearBuilt 1997
- Tax Annual Amount $17,400
Building Features
- Accessibility Features Low Threshold Shower, No Stairs, Accessible Doors
- Garage Y/N 1
- Heating Gas, Zoned, Forced Air
- Heating Y/N 1
- Interior Features Ceiling Fan(s), Cathedral Ceiling(s), Entrance Foyer, Separate/Formal Living Room, Home Office, Hot Tub/Spa, Jetted Tub, Multiple Master Suites, Sliding Glass Door(s), Natural Woodwork, Window Treatments
- Number Of Units Total 0
- Roof Asphalt
- Room sTotal 12
- Patio And Porch Features Balcony, Deck, Patio, Porch
- Appliances Dryer, Dishwasher, Exhaust Fan, Microwave, Refrigerator, Washer
- Basement Full,Finished,Sump Pump
- Full Bathrooms 5
- Building Area Total 5306
- Half Bathrooms 0
- Cooling Zoned, Central Air
- Cooling Y/N 1
- Electric Circuit Breakers
- Foundation Details Poured
- Exterior Features Awning(s), Balcony, Deck, Sprinkler/Irrigation, Pool, Patio
- Garage Spaces 3
Property Features
- Lot Features Agricultural, Wooded
- Lot Size Acres 14.8
- Lot Size Dimensions 221X900
- Parking Features Garage Door Opener
- Utilities Cable Available

Contact

Richard Dentinger

Licensed Associate Real Estate Broker

Wheatfield Branch

Cell: 716-909-1831

Neighborhood

14108 (Newfane) Demographics

46 Median Age

210 Population Density (per sq. mile)

31% College Educated

$56,862 Estimated Median Income

1,943 Estimated Total Home Owners

284 Estimated Total Renters

87% / 13% Estimated Owner / Renter Divide

2 Estimated Average Household Size

5,689 Total Population

Community data courtesy of LiveBy, Inc.

Market Last 30 Days In This Postal Code

$217,800 Median Sales Price

6 Homes Sold

6 New On Market

Average Days on Site

Properties for Sale

Calculations provided by Reliance Network

Property History

Date	Event	Price	Percent Change
--	Current Price Source: Multiple Listing Service	New Value: $2,500,000
7/26/2021 2:30:00 PM	New in Database Source: Multiple Listing Service	New Value: $2,500,000

Payment Calculator

$0 per month

Year Fixed, Interest

Principal and Interest

Property Taxes

Homeowners' Insurance

Home Price

Down Payment

* This payment calculator is intended for educational and planning purposes only.
** Assumes 3.5% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information.

About

Sam Geraci HUNT Mortgage Consultant - NMLS #37765

At HUNT Mortgage, we pride ourselves on providing superior customer service and creating satisfied customers. From mortgage processing and underwriting to loan closing and funding, our expert Mortgage Consultants will efficiently expedite your entire mortgage transaction and keep you informed every step of the way. We’re committed to building rewarding, long-term customer relationships.

HUNT Mortgage Corporation NMLS #37405 - Mortgage Banker License #B500142 - New York State Department of Financial Services

About

Kelly Calmes Insurance Producer

With 30 years of experience in the insurance industry, Kelly became a welcome addition to HUNT Insurance in early 2020, serving the Amherst, Ken-Ton, Lewiston, Lockport, Wheatfield, Williamsville/Clarence, and Williamsville Village branches. After receiving her degree from Bryant & Stratton in Business Management, Kelly started out her career as an account manager for Liberty Mutual. Additional large agencies she has worked for include HSBC Insurance, AAA Insurance, and most recently, SDN Insurance. Kelly is also P&C and Life & Health licensed.

Kelly enjoys working for HUNT Insurance because of the collaborative environment between Insurance Producers, HUNT sales professionals, and Mortgage Consultants that encourages productivity and success.

The scoop on Kelly: Always keeping busy, Kelly also works part-time at West Herr Ford in the title and billing office. When she is not working, Kelly loves spending time with her kids and her boxer, Shelby.

The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS’s. Real estate listings held by firms other than HUNT Real Estate, 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 Wheatfield Branch shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless. © 2022 CNYIS, UNYREIS, WNYREIS. All rights reserved.

Note: All room dimensions, including square footage data, are approximate and must be verified by the buyer. The information contained herein is furnished by the owner to the best of his/her knowledge but is subject to verification by the purchaser, and agent assumes no responsibility for the correctness thereof. The sale offering is made subject to errors, omissions, change of price, prior sale, or withdrawal without notice. In accordance with the Law, this property is offered without respect to race, color, creed, national origin, sex, familial status or disability. This is not intended to solicit property currently listed.