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

L9.111 Lutheranville Rd
Summit, NY 12175
Christy Dahms with CHARLOTTEVILLE REALTY, original listing - (607) 397-9027

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $59,900
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: CHARLOTTEVILLE REALTY
Agency Phone: (607) 397-9027

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Welcome to L9.111 Lutheranville Rd, Summit, NY, 12175, Summit, NY on 12.34 acres of picturesque land in Schoharie County. This property exudes a unique blend of charm and potential, awaiting your vision to bring it to life. Boasting several level building tiers with southern exposure, frontage on two roads, woods for hunting and recreation, and a rough driveway already in place, this parcel presents an exceptional canvas for your aspirations. Notably, The Snook Cemetery is part of this vast expanse, adding an element of history and character to its allure. Nestled in Schoharie County, this property offers not only the promise of a serene rural retreat but also ensures seamless access to a myriad of local attractions. Embark on outdoor adventures with ease, as the Catskill Scenic Trail and the captivating slopes of Plattekill Mountain are within reach for nature enthusiasts. For a touch of culture, the Roxbury Arts Group sets the stage for a plethora of artistic performances and exhibitions throughout the year. When it comes to convenience, the strategic location of this property shines. Just approximately 45 minutes to Albany, you can effortlessly delve into the vibrant offerings of the city. If you seek a weekend escape or a quick getaway to bustling city life, the property is also within a close drive to the George Washington Bridge in NY, providing the perfect balance between tranquil countryside living and metropolitan excitement.
MlsNumber: --
ListingId: 11484357


Listing Provided By: CHARLOTTEVILLE REALTY, original listing
Phone: (607) 397-9027
Office Phone: (607) 397-9027
Agent Name: Christy Dahms
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