Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1829 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1829 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1829 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

4200 Beck Rd
Jamestown, NY 14701

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,775,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2828
Agency: WHITETAIL PROPERTIES REAL ESTATE LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 98 acre(s)
Property Type: Residential
Year Built: 1986
Notes: We are pleased to present a beautiful and tranquil home with a park like setting just minutes from Bemus point, NY. This remarkable hidden retreat has a peaceful and graceful landscape overlooking a large pond with hardwoods all around you. Flower beds, ornamental and fruit trees, walking paths, peace and quiet all come together here for a very special place to call home. Nested on 98.1 acres with a six hundred foot paved driveway, the approach to the 2900 square foot 3 bedroom ranch is private and warming as you drive through the trees to your new home. Mornings are spectacular here with an eastern facing orientation to the property, while the first sunlight of the day is magical, the afternoon glow is just as special. A covered porch on one side, and open decks on two others provides an expanded space to enjoy nature, open air and views over the pond. Once a hobby farm to a pair of wonderful horses, there is a 36 x 36 barn with a hay mow, and several stalls. Well constructed and complementary to the home, the barn has water and electricity and a rear slide to a path that leads to a 10 acre pasture on a nature trail. The home was built in 1986 and has several newer updates to include a new roof, Pella Windows, and two furnaces for zone heating. Two bedrooms are on the lower level, one is upstairs and there is a huge open loft easily made for a fourth bedroom or office space. There is a gas and electric port on site for adding a pool of you chose, and the owners enjoy free gas from the gas well on the south end of the property. The south parcel has had a recent timber harvest (TSI) and a newly established road courses through that parcel for more walking trails, ATV riding or subdividing into a building lot(s). Call us today for your tour and see this peaceful home for yourself. ADDITIONAL INFORMATION: FREE gas, GMO's convey, well & septic, 3 bedroom ranch style home, three decks, two ponds, bass, barn, privacy, trails, horse pasture, hardwoods, newer roof, windows & furnace, paved drive, gentle topography, Deer hunting, 3.3 miles to Bemus Point, NY, 4.7 miles to Jamestown, NY, 3.2 miles to Chautauqua Lake shoreline. Sold AS IS.
MlsNumber: 11279600


Listing Provided By: WHITETAIL PROPERTIES REAL ESTATE LLC, original listing
Name: WHITETAIL PROPERTIES REAL ESTATE LLC
Office Name: WHITETAIL PROPERTIES REAL ESTATE LLC (NY)
Office Phone: (217) 285-9000
Agent Name: Paul Vaicunas
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App