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 ('azhud','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 = 'azhud', 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 ('azhud','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 = 'azhud', 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 ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Sullivan
| Grahamsville, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Grahamsville, Sullivan, New York
Displaying 1 to 7 of 7 Properties (0 foreclosures)
Fresh Air Realty
$895,000
3
bd /
2
ba /
2,760
sqft
106 Porcupine Road
Grahamsville
,
New York
12740
Fresh Air Realty
$410,000
3
bd /
2
ba /
1,702
sqft
11 Forest
Grahamsville
,
New York
12740
Berkshire Hathaway Homeservice
$329,000
2
bd /
2
ba /
1,500
sqft
7824 State Route 42 None
Grahamsville
,
New York
12740
Century 21 Stoeckeler R.E.
$175,000
--
bd /
0
ba /
--
sqft
Tbd South Hill
Grahamsville
,
New York
12765
Century 21 Stoeckeler R.E.
$1,500,000
2
bd /
1
ba /
1,330
sqft
45 Rocky Hill Court
Grahamsville
,
New York
12740
Century 21 Stoeckeler R.E.
$15,000
--
bd /
0
ba /
--
sqft
Tbd Rocky Hill
Grahamsville
,
New York
12765
Win Morrison Realty
$1,499,000
--
bd /
0
ba /
--
sqft
Tbd Smith Lane
Grahamsville
,
New York
12740
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
grahamsville
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 ('azhud','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 = 'azhud', 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!