Title Page Background
DEBUG FN args: Array ( [0] => 1833 [1] => [2] => [3] => agent ) BEFORE: Site: 1833 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1833 Igate: njhud LocID: 1833 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1833 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1833 [1] => [2] => [3] => lender ) BEFORE: Site: 1833 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1833 Igate: njhud LocID: 1833 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1833 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1833 [1] => [2] => [3] => other ) BEFORE: Site: 1833 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1833 Igate: njhud LocID: 1833 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1833 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

17 White Hill Road
Hillsdale, NY 12529
Patricia Hinkein with Patricia A. Hinkein Realty, original listing - (518) 537-4888

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,295,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Pending
SqFt: 2194 Square Feet
Agency: Patricia A. Hinkein Realty
Agency Phone: (518) 537-4888

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 27 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1970
Notes: Secluded Hillsdale Contemporary on 27.7 acres with incredible far reaching views. Located off a scenic country road, the long private driveway leads to this 2200 square foot home. Originally built in 1970, the house has been upgraded with new windows and sliding doors which create walls of glass for enjoying the natural beauty of the surrounding landscape. The house features 3 bedrooms, 2.5 baths, a light filled great room with wood burning fireplace, maple floors throughout, cedar lined closets and cedar shake siding, metal roof, covered patio entry and an expansive wraparound deck. The detached 2 car garage has potential for a number of other uses. The property is a combination of open and wooded land with a meadow area and a spring fed pond. Wonderful area for outdoor enthusiasts with skiing, hiking and the rail trail close by. Only 8 minutes to Catamount Mountain Resort, 16 minutes to Great Barrington Airport, 30 minutes to Tanglewood and 35 minutes to Hudson Amtrak Station.
MlsNumber: --
ListingId: 156563


Listing Provided By: Patricia A. Hinkein Realty, original listing
Phone: (518) 755-1696
Office Phone: (518) 537-4888
Agent Name: Patricia Hinkein
Disclaimer: Copyright © 2025 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