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
| 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 11 Properties (0 foreclosures)
RIVER REALTY SERVICES INC.
$1,650,000
--
bd /
0
ba /
8,400
sqft
5512 Route 9w
Marlboro
,
New York
12542
CENTURY 21 ALLIANCE REALTY GROUP
$1,200,000
6
bd /
6
ba /
2,910
sqft
14-16 Plattekill
Marlboro
,
New York
12542
Compass Greater NY, LLC
$735,000
4
bd /
3
ba /
3,238
sqft
25 Meadow View Drive
Marlboro
,
New York
12542
Summerset Realty
$689,000
7
bd /
0
ba /
3,380
sqft
245-249 Lattintown Road
Marlboro
,
New York
12542
Amodio Real Estate & Prop
$599,000
3
bd /
2
ba /
2,514
sqft
7 Penny Lane
Marlboro
,
New York
12542
Compass Greater NY, LLC
$495,000
3
bd /
3
ba /
1,990
sqft
23 Ridge Road
Marlboro
,
New York
12542
VORO, LLC
$299,000
3
bd /
1
ba /
950
sqft
6 Orchard Street
Marlboro
,
New York
12542
Start Home Smart, Inc.
$285,000
3
bd /
1
ba /
1,380
sqft
411 Plattekill Road
Marlboro
,
New York
12542
CENTURY 21 ALLIANCE REALTY GROUP
$249,925
--
bd /
0
ba /
--
sqft
18 Plattekill Road
Marlboro
,
New York
12542
RIVER REALTY SERVICES INC.
$132,500
3
bd /
1
ba /
1,560
sqft
12 Hampton Road
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 ('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!