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 = 1843 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 = 1843 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 = 1843 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;

774 State Route 8 Rd
Hoffmeister, NY 13353
Nicholas DiVisconte with Signature Premier Properties, original listing - (631) 751-2111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $60,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Signature Premier Properties
Agency Phone: (631) 751-2111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: A one of a kind parcel tucked away boarding the Adirondacks is one not to be missed. This lot boasts a well-maintained trail network, streams, diverse cover, varied terrain, food plots, and breathtaking views. There is a spacious clearing tucked behind a small grove of trees for added privacy that is already equipped with power (ran underground), septic & well water is an ideal spot for a home, cabin, or RV setup (RV in photos can be sold separately). From the clearing, the main trail crosses a stream and ascends a hill, leading to a large bench that features the first of several strategically placed food plots. This food plot runs parallel to the bench, making it an excellent location for intercepting deer movement. At the mountain's summit lies another expansive food plot, opening to stunning mountain vistas. Trail cameras have repeatedly captured images of trophy bucks, bears, fishers, coyotes, and turkeys over the years, with occasional sightings of moose. The southern side of the mountain also funnels into a large open food plot; a stream flows, complete with picturesque waterfalls. Except for the road clearing and food plots, the property is heavily wooded, offering pockets of dense cover perfect for bedding. The back of the property borders the expansive 147,454-acre Ferris Lake Wild Forest, significantly enhancing the space available for hunting and outdoor activities. Snowmobiling, ATV & hiking enthusiasts will appreciate the nearby trail system, and Piseco Lake, just 11 miles away, provides excellent fishing and motor-boating opportunities. With a remarkable track record of wildlife activity and an array of features that cater to hunters and outdoor enthusiasts, this property is truly a gem. Whether you're looking to hunt, or simply enjoy the natural beauty of the Adirondacks; this property has it all! ***Can also be sold with adjacent lot (125.000-1-26.200) which is 59.1 acres and includes 3 hunting boxes.***
MlsNumber: --
ListingId: 11476939


Listing Provided By: Signature Premier Properties, original listing
Phone: (631) 751-2111
Office Phone: (631) 751-2111
Agent Name: Nicholas DiVisconte
Disclaimer: Copyright © 2025 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