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 ('flhud','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 = 'flhud', 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 ('flhud','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 = 'flhud', 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 ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Ulster
| Marlboro, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Marlboro, Ulster, New York
Displaying 1 to 10 of 15 Properties (0 foreclosures)
Berkshire Hathaway Homeservice
$995,000
3
bd /
2
ba /
2,481
sqft
271 Ridge Road
Marlboro
,
New York
12542
Halter Associates Realty
$7,900
4
bd /
3
ba /
2,612
sqft
373 Plattekill Road
Marlboro
,
New York
12542
Upstate Realty Group
$699,000
--
bd /
0
ba /
--
sqft
2021-2025 Route 9w
Marlboro
,
New York
12547
Quinn Realty Group Inc.
$650
--
bd /
0
ba /
10,560
sqft
271 Milton Turnpike
Marlboro
,
New York
12547
Curasi Realty, Inc.
$649,900
5
bd /
2
ba /
2,827
sqft
58 Dragotta Road
Marlboro
,
New York
12542
Keller Williams Realty HV Nort
$475,000
3
bd /
2
ba /
3,304
sqft
3 Anna Place
Marlboro
,
New York
12542
Howard Hanna Rand Realty
$474,900
2
bd /
1
ba /
1,367
sqft
37 Partington Lane
Marlboro
,
New York
12542
Prestige RE Connections, LLC
$399,000
3
bd /
2
ba /
2,100
sqft
153 Reservoir Road
Marlboro
,
New York
12542
eXp Realty
$385,000
3
bd /
2
ba /
1,976
sqft
2 Reservoir Road
Marlboro
,
New York
12542
RE/MAX BENCHMARK REALTY GROUP
$329,900
2
bd /
1
ba /
1,008
sqft
1548 Route 9w
Marlboro
,
New York
12542
«
‹
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
marlboro
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 ('flhud','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 = 'flhud', 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!