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

4547 Route 74
Shoreham, VT 05770
Curtis Trousdale with Preferred Properties - Williston, original listing - (802) 862-9106

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $185,000
Beds: --
Baths: --
Status: Active Under Contract
SqFt: --
Agency: Preferred Properties - Williston
Agency Phone: (802) 862-9106

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 45 acre(s)
Property Type: Residential-Other
Year Built: --
Notes: Pinnacle Forest in Shoreham & Bridport, VT is a 45 +/- acre spectacle of beauty amidst the Addison County farming community! The property features over 2000’ +/- along the Lemon Fair River & amazing views of Adirondack Mountains. The road frontage has a gentle slope up to two antique barns. An old farmhouse burned & was removed, but there exists a state wastewater permit for the continued use of the existing artesian well & 4-bedroom septic system. This site overlooks the Lemon Fair Sculpture Park with public walking paths. Above the old homestead, there is an extensive set of walking/ATV/horse trails that bring you up an amazing rock plateau that sits high above the flat farmland of the county. These trails are NOT steep, and you will experience an amazing forest of hickory, oak, apple & maple. The trails access most of the property, were just bush hogged & are ready for you to explore. A house site on the second cleared slope or west side of the pinnacle would offer great Adirondack views. From there, the cliffs drop vertically 100’ to the river. These shear rock walls will be wonderful for the climbing enthusiast & are beautiful to view. To the north, there is a large fallow field along the river. VT 74 is a state paved road & utilities are at the driveway including highspeed internet. Short drive to Middlebury for major shopping, medical & restaurants. If you are looking for a truly unique get-away in VT that your friends & family will swoon over, then come explore today!
MlsNumber: --
ListingId: --


Listing Provided By: Preferred Properties - Williston, original listing
Office Phone: (802) 862-9106
Agent Name: Curtis Trousdale
Disclaimer: Copyright © 2024 LandLeader. 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