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] => 1871 [1] => SCHUYLER [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1871 LocID: SCHUYLER Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1871 Igate: njhud LocID: 1871 Region: SCHUYLER 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 = 1871 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1871 [1] => SCHUYLER [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1871 LocID: SCHUYLER Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1871 Igate: njhud LocID: 1871 Region: SCHUYLER 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 = 1871 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1871 [1] => SCHUYLER [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1871 LocID: SCHUYLER Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1871 Igate: njhud LocID: 1871 Region: SCHUYLER 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 = 1871 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Schuyler
| Montour Falls, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Montour Falls, Schuyler, New York
Displaying 1 to 9 of 9 Properties (0 foreclosures)
Franzese Real Estate
$749,000
3
bd /
2
ba /
1,770
sqft
Belle Cornell Dr
Montour Falls
,
New York
14865
Franzese Real Estate
$579,000
--
bd /
0
ba /
4,330
sqft
380 State Route 14
Montour Falls
,
New York
14865
First Tioga Realty
$435,000
--
bd /
0
ba /
--
sqft
Raymond St
Montour Falls
,
New York
14865
Howard Hanna Horseheads
$400,000
--
bd /
0
ba /
2,336
sqft
101 S Catherine Street
Montour Falls
,
New York
14865
Cabins to Castles
$249,000
3
bd /
1
ba /
1,680
sqft
4408 Drew Road
Montour Falls
,
New York
14865
Smart Focus Realty
$235,000
--
bd /
0
ba /
--
sqft
Belle Cornell Drive
Montour Falls
,
New York
14865
Franzese Real Estate
$225,000
--
bd /
0
ba /
--
sqft
207 Catherine
Montour Falls
,
New York
14865
Warren Real Estate - Watkins Glen
$145,900
3
bd /
2
ba /
1,688
sqft
109 S Catherine Street
Montour Falls
,
New York
14865
Russell Real Estate Solutions
$110,000
2
bd /
2
ba /
852
sqft
252 Owego Street
Montour Falls
,
New York
14865
Cities In SCHUYLER, NY
Alpine
Beaver Dams
Bradford
Burdett
Cayuta
Hector
Mecklenburg
Montour Falls
Odessa
Reading Center
Rock Stream
Tyrone
Watkins Glen
Wayne
montour falls
USHUD.com on the Go!