Your browser does not support the video tag.
Knowledge Center
Email Alerts
Mortgage/Credit Help
FAQ
Reviews
Professionals
Search
Refine Search
Beds:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Baths:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Property Type:
Any
Conventional
Foreclosure
Price Range:
to
Refine
DEBUG FN args: Array ( [0] => 1878 [1] => ULSTER [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1878 LocID: ULSTER Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1878 Igate: njhud LocID: 1878 Region: ULSTER State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
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 = 1878 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1878 [1] => ULSTER [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1878 LocID: ULSTER Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1878 Igate: njhud LocID: 1878 Region: ULSTER State: NY Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
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 = 1878 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1878 [1] => ULSTER [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1878 LocID: ULSTER Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1878 Igate: njhud LocID: 1878 Region: ULSTER State: NY Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
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 = 1878 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Ulster
| Woodstock, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Woodstock, Ulster, New York
Displaying 1 to 10 of 63 Properties (0 foreclosures)
Keller Williams Realty HV Nort
$999,750
5
bd /
3
ba /
2,111
sqft
153-155 Tinker Street
Woodstock
,
New York
12498
Corcoran Country Living
$999,000
4
bd /
3
ba /
2,906
sqft
108 Ratterman Road
Woodstock
,
New York
12498
BHHS HUDSON VALLEY PROP-KING
$995,000
2
bd /
2
ba /
1,440
sqft
25 Pine Grove Street
Woodstock
,
New York
12498
Halter Associates Realty
$969,000
4
bd /
2
ba /
1,498
sqft
2366 Glasco Turnpike
Woodstock
,
New York
12498
Halter Associates Realty
$949,000
3
bd /
2
ba /
1,246
sqft
79 Upper Byrdcliffe Way
Woodstock
,
New York
12498
Coldwell Banker Village Green
$929,000
4
bd /
2
ba /
1,807
sqft
46 Lower Byrdcliffe
Woodstock
,
New York
12498
Coldwell Banker Village Green
$895,000
4
bd /
3
ba /
2,219
sqft
1964 Glasco Tpke
Woodstock
,
New York
12498
BHHS HUDSON VALLEY PROP-NP
$865,000
2
bd /
1
ba /
1,368
sqft
219 Tinker Street
Woodstock
,
New York
12498
Coldwell Banker Village Green
$849,000
4
bd /
3
ba /
3,359
sqft
10 Maverick Terrace
Woodstock
,
New York
12498
Halter Associates Realty
$839,000
4
bd /
3
ba /
2,545
sqft
291 Zena Road
Woodstock
,
New York
12401
«
‹
1
2
3
›
»
Cities In ULSTER, NY
Accord
Bearsville
Big Indian
Bloomington
Boiceville
Chichester
Clintondale
Connelly
Cottekill
Cragsmoor
Ellenville
Esopus
Gardiner
Glasco
Glenford
Greenfield Park
High Falls
Highland
Highmount
Hurley
Kerhonkson
Kingston
Lake Hill
Lake Katrine
Malden On Hudson
Marlboro
Milton
Modena
Mount Marion
Mount Tremper
Napanoch
New Paltz
Olivebridge
Phoenicia
Pine Hill
Plattekill
Port Ewen
Rifton
Rosendale
Ruby
Saugerties
Shandaken
Shokan
Spring Glen
Stone Ridge
Tillson
Ulster Park
Walker Valley
Wallkill
Wawarsing
West Camp
West Hurley
West Park
West Shokan
Willow
Woodstock
woodstock
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => ulster [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: ulster State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: ulster State: NY 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 = 1878 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Win Morrison
ASCII
WIn Morrison Realty
work
Direct
:
(845) 339-1144
I'm interested in properties in ULSTER, NY
93088
93088
0
Contact Me
USHUD.com on the Go!