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] => 1839 [1] => FRANKLIN [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1839 LocID: FRANKLIN Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1839 Igate: njhud LocID: 1839 Region: FRANKLIN 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 = 1839 AND i.igate IN ('nyhud','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1839 [1] => FRANKLIN [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1839 LocID: FRANKLIN Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1839 Igate: njhud LocID: 1839 Region: FRANKLIN 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 = 1839 AND i.igate IN ('nyhud','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1839 [1] => FRANKLIN [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1839 LocID: FRANKLIN Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1839 Igate: njhud LocID: 1839 Region: FRANKLIN 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 = 1839 AND i.igate IN ('nyhud','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Franklin
| Tupper Lake, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Tupper Lake, Franklin, New York
Displaying 1 to 10 of 42 Properties (0 foreclosures)
Merrill L. Thomas - Gillis Team
$85,000
2
bd /
1
ba /
960
sqft
53 Leboeuf Street
Tupper Lake
,
New York
12986
Merrill L. Thomas - Gillis Team
$69,900
--
bd /
0
ba /
--
sqft
## Broad Street
Tupper Lake
,
New York
12986
Merrill L. Thomas - Gillis Team
$69,000
2
bd /
1
ba /
1,012
sqft
138 Main Street Street
Tupper Lake
,
New York
12986
Merrill L. Thomas - Gillis Team
$644,900
4
bd /
2
ba /
2,422
sqft
1730 State Route 30
Tupper Lake
,
New York
12986
Merrill L. Thomas - Gillis Team
$599,900
4
bd /
1
ba /
2,344
sqft
1718 State Route 30
Tupper Lake
,
New York
12986
Merrill L. Thomas - Gillis Team
$59,900
--
bd /
0
ba /
--
sqft
00 Ny State Route 3 West
Tupper Lake
,
New York
12986
Merrill L. Thomas - Gillis Team
$499,000
--
bd /
1
ba /
240
sqft
30 Old Hotel Road
Tupper Lake
,
New York
12986
Coldwell Banker Whitbeck Assoc Tupper Lake
$49,900
--
bd /
0
ba /
--
sqft
344 Park Street
Tupper Lake
,
New York
12986
Coldwell Banker Whitbeck Assoc Tupper Lake
$45,000
1
bd /
1
ba /
806
sqft
41 Prospect Street
Tupper Lake
,
New York
12986
Coldwell Banker Whitbeck Assoc Tupper Lake
$375,000
--
bd /
0
ba /
7,848
sqft
76 Demars Blvd
Tupper Lake
,
New York
12986
«
‹
1
2
3
›
»
Cities In FRANKLIN, NY
Bombay
Brainardsville
Brushton
Burke
Chateaugay
Constable
Dickinson Center
Fort Covington
Gabriels
Hogansburg
Lake Clear
Malone
Moira
North Bangor
Owls Head
Paul Smiths
Rainbow Lake
Saint Regis Falls
Saranac Lake
Tupper Lake
Vermontville
Whippleville
tupper lake
USHUD.com on the Go!