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 = 1218 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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 = 1218 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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 = 1218 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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;

3617 Horton Brook Rd.
Roscoe Ny, NY 12776

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $395,000
Beds: 3
Baths: 1
Status: Active
SqFt: 1200
Agency: UPPER DELAWARE REAL ESTATE

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 113 acre(s)
Property Type: Residential
Year Built: --
Notes: WILDERNESS HUNTING PRESERVE THIS IS A REMOTE, OFF THE GRID PROPERTY, ONLY REACHED BY A 4 WHEEL DRIVE ROW ROAD. Imagine owning your own private hunting preserve. 113 acres of prime , secluded hunting land where year after year trophy bucks are continuously harvested. Even more seclusion is guaranteed as the property adjoins over 10,000 acres of Catskill Forest Preserve land on two sides. Also making this property a multi season sportsman's paradise , world class fly fishing is found only a couple of miles away at the Horton Bridge Pool on the Beaverkill River and only a short drive over the mountain to fish for monster trout in the Pepacton Reservoir. Reached by a mile long right of way road the property is the crisscrossed with a multitude of woods roads, where you can ride your ATV's to all corners of the property. The parcel is covered with mature timber that's not been harvested in over 10 years and also contains a blue stone quarry and many more potential quarry sites. At the center of the property sits a 1200 sq. ft. off the grid cabin. Built 25 years ago the interior still needs some finishing to your liking, but is completed enough that you can sleep in it tonight. The bottom floor has 2 large bedrooms, bathroom and a combined living and kitchen space with a cathedral ceiling and large floor to ceiling windows. The room is set up for a wood stove with an already installed concrete pad and metal chimney pipe. The upper level has another large bedroom. The cabin is wired for electric and has an outside hookup for a generator. Water is currently collected through a cistern system, and a modern septic system has been installed along with a concrete tank. A new metal roof was recently put on the cabin. Located in the low taxed town of Colchester the property is only 4 miles from the Rt.17 (I86) exit for quick access from the metropolitan area.
MlsNumber: 11094489


Listing Provided By: UPPER DELAWARE REAL ESTATE, original listing
Name: UPPER DELAWARE REAL ESTATE
Office Name: UPPER DELAWARE REAL ESTATE - Downsville, NY
Office Phone: (607) 363-2008
Agent Name: Barry Jones
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