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','usahud','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 = 'usahud', 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','usahud','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 = 'usahud', 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','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Ulster
| Shandaken, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Shandaken, Ulster, New York
Displaying 1 to 10 of 13 Properties (0 foreclosures)
Houlihan Lawrence, Inc. - Millbrook
$1,450,000
4
bd /
4
ba /
4,961
sqft
110 Lost Clove Road
Shandaken
,
New York
12410
Halter Associates Realty
$1,450,000
3
bd /
3
ba /
3,392
sqft
544 Herdman Road
Shandaken
,
New York
12480
Halter Associates Realty
$795,000
1
bd /
1
ba /
609
sqft
8 Emerson Terrace
Shandaken
,
New York
12464
eXp Realty, LLC
$499,000
3
bd /
1
ba /
1,820
sqft
355 Route 42
Shandaken
,
New York
12480
Coldwell Banker Timberland Pro
$469,000
3
bd /
2
ba /
1,779
sqft
49 Ulster Delaware Turnpike
Shandaken
,
New York
12480
Keller Williams Realty HV Nort
$429,900
4
bd /
0
ba /
6,000
sqft
7284 Ny-28
Shandaken
,
New York
12480
BHHS HUDSON VALLEY PROP-WDST
$429,000
--
bd /
0
ba /
--
sqft
121 Fox Hollow Road
Shandaken
,
New York
12480
Compass Greater NY, LLC
$425,000
3
bd /
2
ba /
1,500
sqft
24 Evergreen Drive
Shandaken
,
New York
12480
BHHS HUDSON VALLEY PROP-WDST
$425,000
4
bd /
1
ba /
1,276
sqft
595 Route 42
Shandaken
,
New York
12480
Howard Hanna Rand Realty
$199,000
--
bd /
0
ba /
--
sqft
Tbd Route 28
Shandaken
,
New York
12480
«
‹
1
2
›
»
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
shandaken
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','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Eliana Amodio
ASCII
Amodio Real Estate & Prop
work
Call Today!
:
(561) 322-8428
I'm interested in properties in ULSTER, NY
1843427
1843427
0
Contact Me
USHUD.com on the Go!