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
| Olyphant, Pennsylvania
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Olyphant, Lackawanna, Pennsylvania
Displaying 1 to 10 of 13 Properties (0 foreclosures)
LUXE Homes Real Estate LLC
$900
1
bd /
1
ba /
600
sqft
102 Delaware Avenue
Olyphant
,
Pennsylvania
18447
Berkshire Hathaway Home Services Preferred Properties
$61,000
4
bd /
1
ba /
1,904
sqft
134 S Valley Avenue
Olyphant
,
Pennsylvania
18447
Berkshire Hathaway Home Services Preferred Properties
$50,000
--
bd /
0
ba /
--
sqft
109 Black Walnut Drive
Olyphant
,
Pennsylvania
18447
Keller Williams Real Estate-Clarks Summit
$475,000
4
bd /
2
ba /
2,454
sqft
323 Sanko Drive
Olyphant
,
Pennsylvania
18447
CLASSIC PROPERTIES
$325,000
8
bd /
2
ba /
704
sqft
207 209 Lackawanna Avenue
Olyphant
,
Pennsylvania
18447
CLASSIC PROPERTIES
$325,000
--
bd /
0
ba /
1,793
sqft
207 209 Lackawanna Avenue Avenue
Olyphant
,
Pennsylvania
18447
Keller Williams Real Estate-Clarks Summit
$299,999
3
bd /
2
ba /
1,888
sqft
840 Spruce Street
Olyphant
,
Pennsylvania
18447
Berkshire Hathaway Home Services Preferred Properties
$265,000
4
bd /
3
ba /
4,960
sqft
105 Black Walnut Drive
Olyphant
,
Pennsylvania
18447
REALTY NETWORK GROUP
$230,000
4
bd /
2
ba /
2,850
sqft
306 Delaware Avenue
Olyphant
,
Pennsylvania
18447
ERA One Source Realty
$209,000
4
bd /
1
ba /
1,700
sqft
653 E Pine Street
Olyphant
,
Pennsylvania
18447
«
‹
1
2
›
»
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
olyphant
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!