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] => 2270 [1] => INDIANA [2] => PA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2270 LocID: INDIANA Region: PA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2270 Igate: njhud LocID: 2270 Region: INDIANA 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 = 2270 AND i.igate IN ('wihud','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 = 'wihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2270 [1] => INDIANA [2] => PA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2270 LocID: INDIANA Region: PA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2270 Igate: njhud LocID: 2270 Region: INDIANA 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 = 2270 AND i.igate IN ('wihud','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 = 'wihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2270 [1] => INDIANA [2] => PA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2270 LocID: INDIANA Region: PA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2270 Igate: njhud LocID: 2270 Region: INDIANA 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 = 2270 AND i.igate IN ('wihud','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 = 'wihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Pennsylvania (PA) Foreclosure Listings
|
Indiana
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Indiana, Pennsylvania
Displaying 1 to 10 of 88 Properties (5 foreclosures)
CENTURY 21 FRONTIER REALTY
FORECLOSURE
$79,500
3
bd /
2
ba /
--
sqft
606 Twenty Six St
Derry Twp
,
Pennsylvania
15717
MERIDIAN REAL ESTATE GROUP
FORECLOSURE
$64,900
2
bd /
1
ba /
--
sqft
124 E Burrell St
Blairsville Area
,
Pennsylvania
15717
MERIDIAN REAL ESTATE GROUP
FORECLOSURE
$64,900
5
bd /
2
ba /
--
sqft
1264 Smyrna Rd
S Mahoning/plumville
,
Pennsylvania
15759
REALTY ONE GROUP GOLD STANDARD
FORECLOSURE
$59,900
2
bd /
1
ba /
--
sqft
175 Hancock Street
Cherryhll Twp/clymer
,
Pennsylvania
15728
REALTY ONE GROUP LANDMARK
FORECLOSURE
$125,000
4
bd /
1
ba /
--
sqft
712 Salt St
Saltsburg Area
,
Pennsylvania
15681
CENTURY 21 FAIRWAYS REAL ESTATE
$99,900
--
bd /
0
ba /
--
sqft
0 Blackleggs
Conemaugh/young Twps - Ind
,
Pennsylvania
15681
Colony Realty Group, Ltd
$99,900
--
bd /
0
ba /
--
sqft
141 Tire Road
Strongstown
,
Pennsylvania
15957
REALTY ONE GROUP LANDMARK
$92,000
3
bd /
1
ba /
--
sqft
755 Morris St
Cherryhll Twp/clymer
,
Pennsylvania
15728
REALTY ONE GROUP LANDMARK
$88,900
3
bd /
1
ba /
--
sqft
55 Walnut St
Burrel/blacklick
,
Pennsylvania
15716
WHITETAIL PROPERTIES REAL ESTATE LLC (PA)
$879,000
4
bd /
2
ba /
1,700
sqft
1491 Clyde Rd
Armagh
,
Pennsylvania
15920
«
‹
1
2
3
›
»
Cities In INDIANA, PA
Alverda
Arcadia
Armagh
Aultman
Beyer
Black Lick
Blairsville
Brush Valley
Chambersville
Cherry Tree
Clarksburg
Clune
Clymer
Commodore
Coral
Creekside
Dilltown
Dixonville
Ernest
Gipsy
Glen Campbell
Heilwood
Hillsdale
Home
Homer City
Indiana
Josephine
Kent
Lucernemines
Marchand
Marion Center
Mc Intyre
Mentcle
Northpoint
Penn Run
Plumville
Robinson
Rochester Mills
Rossiter
Saltsburg
Shelocta
Smicksburg
Starford
Strongstown
West Lebanon
USHUD.com on the Go!