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

37895 State Route 28 Highway
Margaretville, NY 12455

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $90,000
Beds: 4
Baths: 1
Status: Active
SqFt: 1364
Agency: Coldwell Banker Timberland Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1887
Notes: Standing for more than a century, this 1889 majestical house is in need of substantial modification. If you have a passion for historical preservation and are willing to put in the effort, this property could become a unique and charming home once again. Historically, the front of the home was a family-run convenient store for local residents. The land in which the home inhabits is flat and beautifully surrounded by rolling hill views. In addition, there is small spring fed pond which could easily be enlarged. The plumbing system was working in 2022, when the home was still occupied. It has been winterized ever since. The inside of the home was cleared out by the present owner. The home is in need of major cleaning and repair. The electric is 200 amp service. The septic was installed in 2012, DEP engineered, and pumped in 2019 (info obtained from the DEP). The age of the oil tank and water heater are unknown. There are 2 heater unit grates in the home, one on the first floor and one on the second. The wooden floors which are visible are in good shape and could be refurbished. There are areas covered by many layers of linoleum and carpet, but believed to be wood also. The yard consists of a chicken coupe and a small shed, which need cleanout and could possibly be replenished. The land requires removing equipment, RVs, and other random clutter. The property is located between Margaretville and Andes and is 2.5 hours from NYC. Surrounding areas have some of the best hiking, kayaking, skiing and arts this region has to offer. The property is being sold as-is, and is priced accordingly. Cash preferred.
MlsNumber: 20233388


Listing Provided By: Coldwell Banker Timberland Properties, original listing
Name: Coldwell Banker Timberland Properties
Phone: (845) 657-4177
Office Name: Coldwell Banker Timberland
Office Phone: (845) 657-4177
Agent Name: Susan Lennon
Disclaimer: Copyright © 2024 Multiple Listing Service of Ulster County. 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