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] => 2273 [1] => LACKAWANNA [2] => PA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2273 LocID: LACKAWANNA Region: PA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2273 Igate: njhud LocID: 2273 Region: LACKAWANNA State: PA 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 = 2273 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2273 [1] => LACKAWANNA [2] => PA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2273 LocID: LACKAWANNA Region: PA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2273 Igate: njhud LocID: 2273 Region: LACKAWANNA State: PA 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 = 2273 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2273 [1] => LACKAWANNA [2] => PA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2273 LocID: LACKAWANNA Region: PA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2273 Igate: njhud LocID: 2273 Region: LACKAWANNA State: PA 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 = 2273 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Pennsylvania (PA) Foreclosure Listings
|
Lackawanna
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Lackawanna, Pennsylvania
Displaying 1 to 10 of 908 Properties (6 foreclosures)
CLASSIC PROPERTIES
FORECLOSURE
$88,000
3
bd /
1
ba /
1,200
sqft
401 Bowman Street
Dickson City
,
Pennsylvania
18519
ERA One Source Realty
FORECLOSURE
$800
1
bd /
1
ba /
2,100
sqft
622 N 622 Main
Scranton
,
Pennsylvania
18504
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$456,500
3
bd /
2
ba /
2,640
sqft
135 Burcher Ave
Clarks Summit
,
Pennsylvania
18411
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$26,900
3
bd /
1
ba /
1,636
sqft
1512 Cedar Ave
Scranton
,
Pennsylvania
18505
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$195,500
3
bd /
1
ba /
1,252
sqft
830 Maple Street
Scranton
,
Pennsylvania
18505
RIVER REALTY SERVICES INC
FORECLOSURE
$128,656
3
bd /
2
ba /
1,978
sqft
Rr4 Box 86 Route 438
Dalton
,
Pennsylvania
18414
The Hub Real Estate Group LLC
$99,995
2
bd /
1
ba /
950
sqft
2205 Kelly Avenue
Scranton
,
Pennsylvania
18508
REALTY NETWORK GROUP
$99,900
--
bd /
0
ba /
--
sqft
Scranton Cdale Highway
Archbald
,
Pennsylvania
18403
ERA One Source Realty
$99,900
--
bd /
0
ba /
--
sqft
Lot # 31 South Circle
Clarks Summit
,
Pennsylvania
18411
ERA One Source Realty
$99,900
--
bd /
0
ba /
--
sqft
Lot # 56 South Circle
Clarks Summit
,
Pennsylvania
18411
«
‹
1
2
3
›
»
Cities In LACKAWANNA, PA
Archbald
Carbondale
Chinchilla
Clarks Summit
Dalton
Dickson City
Elmhurst
Fleetville
Jermyn
Jessup
La Plume
Moosic
Moscow
Old Forge
Olyphant
Peckville
Ransom
Scranton
Taylor
Waverly
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => lackawanna [3] => PA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: lackawanna State: PA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: lackawanna State: PA 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 = 2273 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Dave Kwiatkowski
ASCII
eXp Realty
work
Call Today!
:
(570) 702-1527
I'm interested in properties in LACKAWANNA, PA
1841287
1841287
0
Contact Me
USHUD.com on the Go!