Start of property details

Share this property:
Gallery
Share
Payments
3248 Lockport Olcott Road
Newfane, 14108
FOR
SALE
$1,900,000
For Sale
6
Beds
5
Baths
3
Garage
5,306
Sq.Ft.
14.80
Acres
MLS# B1518296
Cumulative Days on Market: 42 (since January 26th, 2024) Data provided by the MLS.

Property Details

Private Estate with 14 acres of manicured grounds, trails, artistic gardens alongside 18-mile Creek. Acreage offers mature walnut trees and pine trees. Enjoy summer parties with your heated inground, roman pool along with spa and an outside kitchen with entertainment bar. Guest home with private entrance through 3-car garage. Home offers a two story foyer featuring winding staircase. Gentleman's den with custom cabinetry and built in desk. Elegant living room with gorgeous large windows surrounded with exceptional custom drapery. Spacious formal dining room fabulous custom full wall hutch. Formal dining room extends to the covered entertainment size patio with walkout to the oversized patio. Tea room with full wall of windows overlooking the garden. Custom kitchen with granite counters with large dining area. Family room with fireplace. Laundry first floor with full bath. Exquisite master with 2 way gas fireplace to primary bath, full dressing room. Bedrooms are all spacious. Full finished basement with generous exercise room. This home can be purchased with all the high end furniture, along with guest house furniture. An artist couldn't have painted a more beautiful must see home.

Ask a Local Expert

Property Highlights

Price
$1,900,000
Property Type
Residential
Property Sub Type
Single Family Residence
Architectural Style
Ranch, Two Story
Total Bathrooms
5
Year Built
1997
Acres
14.80

Location

Area
Newfane-292800
County
Niagara
Water Body Name
Twelvemile Creek
Waterfront
Yes
Waterfront Features
River Access, Stream

Property Details

Condition
Resale
Price
$1,900,000
Property Sub Type
Single Family Residence
Property Type
Residential

Building

Levels
Two
Stories
2
Total Area
5,306

Community

Local Schools

School District
Newfane

Interior Features

Bedrooms and Bathrooms

1/2 Bathrooms
1
Bathrooms on Main Level
3
Bedrooms
6
Bedrooms on Main Level
2
Full Bathrooms
4
Total Bathrooms
5

Rooms and Basement

Basement Features
Full, Finished
Has Basement
Yes
Total Rooms
12

Area and Spaces

Living Area
5,306

Appliances

Appliances
Built In Range, Built In Oven, Double Oven, Dryer, Dishwasher, Exhaust Fan, Gas Cooktop, Disposal, Gas Oven, Gas Range, Gas Water Heater, Microwave, Refrigerator, Range Hood, Washer, Humidifier

Interior Features

Flooring
Ceramic Tile, Hardwood, Varies
Interior Features
Breakfast Bar, Den, Separate Formal Dining Room, Entrance Foyer, Eatin Kitchen, Guest Accommodations, Granite Counters, Home Office, Kitchen Island, Pantry, See Remarks, Second Kitchen, Walk In Pantry, Air Filtration, Bedroomon Main Level, In Law Floorplan, Bathin Primary Bedroom, Programmable Thermostat
Laundry Features
Main Level

Heating and Cooling

Fireplaces
2
Has Fireplace
Yes
Heating Features
Gas, Zoned, Forced Air

Building Details

Construction

Architectural Style
Ranch, Two Story
Foundation
Poured
Year Built
1997

Materials

Construction Materials
Stone, Stucco, Vinyl Siding
Roof
Asphalt

Terms

Terms

Special Conditions
Standard
Special Terms
Cash, Conventional

Taxes

Tax

Tax (Annual)
$17,400

Heating, Cooling & Utilities

Cooling Features
Zoned, Central Air

Utilities

Sewer
Connected
Utilities
Sewer Connected, Water Connected
Water Source
Connected, Public

Lot

Acres
14.80
Lot Dimensions
221X900
Lot Features
Secluded, Wooded
Lot Size
15

Exterior Features

Exterior Features
Concrete Driveway
For Horses
Yes
Horse Amenities
Horses Allowed
Patio And Porch Features
Open, Porch

Parking

Garage Capacity
3
Parking Features
Attached, Circular Driveway, Driveway
Listed by Keller Williams Realty Wny, 716-832-3300.
Listing Data last updated 28th February, 2024 18:00
Get a Link to this Property: Copy To Clipboard

Phone:
Connect with:

Payment Calculator

per month. Fixed. % interest.
per month
Total interest paid over s will be:
Principal & Interest
Home Insurance
Property Tax
HOA Fees
All estimates and provided for informational purposes only. Actual amounts may vary. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. Information, rates, programs and loan scenarios shown are for example only as of 29-Feb-2024 and are subject to change without notice. All products are subject to credit and property approval. Not all products are available in all states or for all loan amounts. Other restrictions and limitations apply. Contact your preferred lender for the pricing associated with your specific transaction. Calculations are generated by open source mortgage calculation software tools using common mathematical formulas. Copyright © 2024 Buying Buddy. All calculations should be independantly verified.
Get Walk Score Content

Property History

26 days ago
Property information last updated
33 days ago
Status Active. This is the date the listing was placed on market.
NOTE: Cumulative Days on Market: 42. Data provided by the MLS.

Similar Properties

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 Great Lakes Real Estate, Inc., are marked with the IDX logo and detailed information about them includes the Listing Broker's Firm Name. Disclaimer: 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 Great Lakes Real Estate, Inc. shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless. © 2024 CNYIS, UNYREIS, WNYREIS. All rights reserved.
Listing Data last updated: 28th February, 2024 18:00
Equal Housing Opportunity
Service by Buying Buddy® IDX CRM
Copyright © 2003 - 2024 Buying Buddy. All rights reserved.
{"property_id":"ny600_B1518296","AboveGradeFinishedArea":null,"AccessibilityFeatures":null,"Appliances":"BuiltInRange, BuiltInOven, DoubleOven, Dryer, Dishwasher, ExhaustFan, GasCooktop, Disposal, GasOven, GasRange, GasWaterHeater, Microwave, Refrigerator, RangeHood, Washer, Humidifier","ArchitecturalStyle":"Ranch, TwoStory","AssociationAmenities":null,"AssociationFee":null,"AssociationFeeFrequency":null,"AssociationFeeIncludes":null,"AssociationYN":"0","AttributionContact":"716-832-3300","attribution_contact":null,"Basement":"Full, Finished","BasementYN":"1","BathroomsFull":"4","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":null,"BelowGradeFinishedArea":null,"BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"BuyerFinancing":null,"CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Stone, Stucco, VinylSiding","Contingency":null,"Cooling":"Zoned, CentralAir","CountyOrParish":"Niagara","CoveredSpaces":null,"CurrentFinancing":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":null,"ElementarySchool":null,"Exclusions":null,"ExteriorFeatures":"ConcreteDriveway","Fencing":null,"FireplaceFeatures":null,"FireplaceYN":"1","FireplacesTotal":"2","Flooring":"CeramicTile, Hardwood, Varies","FoundationDetails":"Poured","GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Gas, Zoned, ForcedAir","HighSchool":null,"HorseAmenities":"HorsesAllowed","HorseYN":"1","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"BreakfastBar, Den, SeparateFormalDiningRoom, EntranceFoyer, EatinKitchen, GuestAccommodations, GraniteCounters, HomeOffice, KitchenIsland, Pantry, SeeRemarks, SecondKitchen, WalkInPantry, AirFiltration, BedroomonMainLevel, InLawFloorplan, BathinPrimaryBedroom, ProgrammableThermostat","InternetAddressDisplayYN":null,"LaundryFeatures":"MainLevel","Levels":"Two","ListingTerms":"Cash, Conventional","LivingArea":null,"LotFeatures":"Secluded, Wooded","LotSizeArea":"14.80","LotSizeDimensions":"221X900","LotSizeSquareFeet":null,"MainLevelBathrooms":"3","MainLevelBedrooms":"2","MiddleOrJuniorSchool":null,"Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":"0","OtherParking":null,"Ownership":null,"ParkingFeatures":"Attached, CircularDriveway, Driveway","ParkingTotal":null,"PatioAndPorchFeatures":"Open, Porch","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":"0","PostalCity":"Newfane","PropertyCondition":"Resale","PropertySubType":"SingleFamilyResidence","public_remarks":"Private Estate with 14 acres of manicured grounds,  trails,  artistic gardens alongside 18-mile Creek. Acreage offers mature walnut trees & pine trees. Enjoy summer parties with your heated inground,  roman pool along with spa & an outside kitchen with entertainment bar. Guest home with private entrance through 3-car garage. Home offers a two story foyer featuring winding staircase. Gentleman's den with custom cabinetry and built in desk. Elegant living room with gorgeous large windows surrounded with exceptional custom drapery. Spacious formal dining room fabulous custom full wall hutch. Formal dining room extends to the covered entertainment size patio with walkout to the oversized patio. Tea room with full wall of windows overlooking the garden. Custom kitchen with granite counters with large dining area. Family room with fireplace. Laundry first floor with full bath. Exquisite master with 2  way gas fireplace to primary bath,  full dressing room. Bedrooms are all spacious. Full finished basement with generous exercise room. This home can be purchased with all the high end furniture,  along with guest house furniture. An artist couldn't have painted a more beautiful must see home.","Roof":"Asphalt","RoomsTotal":"12","SchoolDistrict":"Newfane","SecurityFeatures":null,"seller_office_id":null,"SeniorCommunityYN":"0","Sewer":"Connected","SkiFeatures":null,"SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Standard","StandardStatus":null,"StateRegion":null,"StoriesTotal":"2","StructureType":null,"TaxAnnualAmount":"17400.00","Utilities":"SewerConnected, WaterConnected","View":null,"ViewYN":"0","VirtualTourURLUnbranded":"https:\/\/my.matterport.com\/show\/?m=Q4gmaEV3Taz&mls=1","VirtualTourURLUnbranded2":"https:\/\/my.matterport.com\/show\/?m=Q4gmaEV3Taz&mls=1","VirtualTourURLUnbranded3":null,"WalkScore":null,"WaterBodyName":"Twelvemile Creek","WaterSource":"Connected, Public","WaterfrontFeatures":"RiverAccess, Stream","WaterfrontYN":"1","WindowFeatures":null,"YearBuilt":"1997","Zoning":null,"ZoningDescription":null,"headline_txt":null,"description_txt":null,"property_uid":"1059375103","listing_status":"active","mls_status":"Active","mls_id":"ny600","listing_num":"B1518296","acreage":null,"acres":"14.80","address":null,"address_direction":null,"address_flg":"1","address_num":"3248","agent_id":"KIVIBARB","area":"Newfane-292800","baths_total":"5.00","bedrooms_total":"6","car_spaces":"3","city":"Newfane","coseller_id":null,"coagent_id":null,"days_on_market":"9","finished_sqft_total":"5306","geocode_address":"3248 Lockport Olcott Road","geocode_status":null,"lat":"43.256882","lon":"-78.696479","office_id":"KWNY","office_name":"Keller Williams Realty WNY","orig_price":"1900000","photo_count":"50","previous_price":null,"price":"1900000","prop_img":"\/listing\/photos\/ny600\/B1518296-1.jpeg","property_type":"Residential","sqft_total":"5306","state":"NY","street_type":"Road","street_name":"Lockport Olcott","sub_area":null,"unit":null,"zip_code":"14108","listing_dt":"2024-01-24","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-02-02 18:49:06","create_dt":"2024-01-26 23:44:23","marketing_headline_txt":null,"use_marketing_description_txt":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}