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] => 1875 [1] => SULLIVAN [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1875 LocID: SULLIVAN Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1875 Igate: njhud LocID: 1875 Region: SULLIVAN 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 = 1875 AND i.igate IN ('mnhud','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 = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1875 [1] => SULLIVAN [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1875 LocID: SULLIVAN Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1875 Igate: njhud LocID: 1875 Region: SULLIVAN 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 = 1875 AND i.igate IN ('mnhud','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 = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1875 [1] => SULLIVAN [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1875 LocID: SULLIVAN Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1875 Igate: njhud LocID: 1875 Region: SULLIVAN 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 = 1875 AND i.igate IN ('mnhud','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 = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Sullivan
| Bethel, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Bethel, Sullivan, New York
Displaying 1 to 7 of 7 Properties (0 foreclosures)
GREAT SUCCESS REALTY INC
$999,000
4
bd /
3
ba /
--
sqft
31 Lake Ridge Rd
Bethel
,
New York
12786
WHITETAIL PROPERTIES REAL ESTATE LLC (NY)
$74,999
--
bd /
0
ba /
--
sqft
00 Hurd Rd Tr 48
Bethel
,
New York
12783
PYRAMID BROKERAGE COMPANY OF THE HUDSON VALLEY LLC
$597,000
--
bd /
0
ba /
--
sqft
0 Smith Rd
Bethel
,
New York
12720
Malek Properties, Inc.
$579,000
--
bd /
0
ba /
--
sqft
Lot 8 Woodstone Trail
Bethel
,
New York
12720
Curasi Realty, Inc.
$299,000
2
bd /
1
ba /
1,036
sqft
36 W Kenoza Place
Bethel
,
New York
12778
PYRAMID BROKERAGE COMPANY OF THE HUDSON VALLEY LLC
$1,499,000
--
bd /
0
ba /
--
sqft
0 West Shore Rd
Bethel
,
New York
12720
Malek Properties, Inc.
$1,495,000
8
bd /
4
ba /
2,731
sqft
3443 Nys Highway
Bethel
,
New York
12786
Cities In SULLIVAN, NY
Barryville
Bethel
Bloomingburg
Burlingham
Callicoon
Callicoon Center
Claryville
Cochecton
Cochecton Center
Eldred
Fallsburg
Ferndale
Forestburgh
Fremont Center
Glen Spey
Glen Wild
Grahamsville
Hankins
Harris
Highland Lake
Hortonville
Hurleyville
Jeffersonville
Kauneonga Lake
Kenoza Lake
Kiamesha Lake
Lake Huntington
Liberty
Livingston Manor
Loch Sheldrake
Long Eddy
Mongaup Valley
Monticello
Mountain Dale
Narrowsburg
Neversink
North Branch
Obernburg
Parksville
Phillipsport
Pond Eddy
Rock Hill
Roscoe
Smallwood
South Fallsburg
Summitville
Swan Lake
Thompsonville
Westbrookville
White Lake
White Sulphur Springs
Woodbourne
Woodridge
Wurtsboro
Youngsville
Yulan
bethel
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => sullivan [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: sullivan State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: sullivan 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 = 1875 AND i.igate IN ('mnhud','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 = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jason Grossman
ASCII
Keller Williams
work
Call Today!
:
(845) 796-6065
I'm interested in properties in SULLIVAN, NY
1841505
1841505
0
Contact Me
USHUD.com on the Go!