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','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 = 1870 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 = 1870 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;

L2.35b Bleinheim Hill Rd
Jefferson, NY 12093
Christy Dahms with CHARLOTTEVILLE REALTY, original listing - (607) 397-9027

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 112 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Welcome to L2.35B Blenheim Hill Rd, Blenheim, NY, in Schoharie County, where an extraordinary opportunity awaits on this vast 112+ acre property. Traverse the idyllic landscape of this expansive lot and embrace the natural beauty surrounding you. The property features two serene streams, a potential pond site, level land perfect for various activities, and excellent hiking and hunting opportunities, allowing you to be truly at home with nature. This parcel is not just a piece of land; it's a canvas waiting for your vision. Embrace the possibility of building your dream home or creating cabins for additional income through Airbnb rentals. The proximity to the Blenheim Farm Wedding Venue presents a charming and convenient perk for Airbnb income. Discover a wealth of local attractions near this property. Less than a 3-hour drive from the George Washington Bridge provides seamless access to New York City's bustling energy. Windham and Albany are a short drive away, offering skiing, a hub of cultural experiences, and urban amenities. In the heart of Schoharie County, this property offers a unique opportunity to craft your ideal retreat or investment venture surrounded by natural splendor. Whether you seek a tranquil escape, a home for outdoor adventures, or a lucrative opportunity, L2.35B Blenheim Hill Rd beckons with boundless potential. Don't miss the chance to own a slice of nature's paradise and create the life you've always envisioned. Gorgeous 112+- Acres of Land with 2 Streams on Quiet Town Road!
MlsNumber: --
ListingId: 11362626


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