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
| Moosic, Pennsylvania
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Moosic, Lackawanna, Pennsylvania
Displaying 1 to 10 of 54 Properties (0 foreclosures)
Classic Properties Kingston
$949,000
4
bd /
5
ba /
6,815
sqft
26 Kipling Drive
Moosic
,
Pennsylvania
18507
Classic Properties Kingston
$850,000
--
bd /
4
ba /
6,000
sqft
4810 Birney Avenue
Moosic
,
Pennsylvania
18507
Keller Williams Real Estate-Clarks Summit
$82,900
--
bd /
0
ba /
--
sqft
Railroad Street
Moosic
,
Pennsylvania
18507
Classic Properties Kingston
$65,000
--
bd /
0
ba /
--
sqft
511 Poppy Drive
Moosic
,
Pennsylvania
18507
ERA One Source Realty
$59,900
--
bd /
0
ba /
--
sqft
Lot #108 Snapdragon Drive
Moosic
,
Pennsylvania
18507
ERA One Source Realty
$59,900
--
bd /
0
ba /
--
sqft
Lot #114 Snapdragon Drive
Moosic
,
Pennsylvania
18507
ERA One Source Realty
$59,900
--
bd /
0
ba /
--
sqft
Lot #115 Snapdragon Drive
Moosic
,
Pennsylvania
18507
ERA One Source Realty
$59,900
--
bd /
0
ba /
--
sqft
Lot #129 Orchid Drive
Moosic
,
Pennsylvania
18507
ERA One Source Realty
$59,900
--
bd /
0
ba /
--
sqft
Lot #69 Wisteria Lane
Moosic
,
Pennsylvania
18507
ERA One Source Realty
$59,900
--
bd /
0
ba /
--
sqft
Lot #71 Wisteria Lane
Moosic
,
Pennsylvania
18507
«
‹
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
moosic
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!