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] => 2249 [1] => CAMBRIA [2] => PA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2249 LocID: CAMBRIA Region: PA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2249 Igate: njhud LocID: 2249 Region: CAMBRIA 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 = 2249 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2249 [1] => CAMBRIA [2] => PA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2249 LocID: CAMBRIA Region: PA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2249 Igate: njhud LocID: 2249 Region: CAMBRIA 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 = 2249 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2249 [1] => CAMBRIA [2] => PA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2249 LocID: CAMBRIA Region: PA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2249 Igate: njhud LocID: 2249 Region: CAMBRIA 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 = 2249 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Pennsylvania (PA) Foreclosure Listings
|
Cambria
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Cambria, Pennsylvania
Displaying 1 to 10 of 431 Properties (1 foreclosures)
CENTURY 21 FRONTIER REALTY
FORECLOSURE
$90,000
3
bd /
2
ba /
--
sqft
137 Damian Dr
Westmont Hilltop School District
,
Pennsylvania
15905
BHHS Preferred Johnstown
$5,900,000
--
bd /
0
ba /
--
sqft
1317 Main Street
Johnstown
,
Pennsylvania
15909
RSR, REALTORS, LLC
$1,500,000
--
bd /
0
ba /
--
sqft
155 Johns Street
Johnstown
,
Pennsylvania
15901
Re/max Results Realty Group
$949,000
--
bd /
0
ba /
6,032
sqft
1210 2nd Street
Cresson
,
Pennsylvania
16630
Re/max Results Realty Group
$899,000
--
bd /
0
ba /
5,000
sqft
3720 New Germany Road
Ebensburg
,
Pennsylvania
15931
HOWARD HANNA BARDELL REALTY ALTOONA
$849,900
--
bd /
0
ba /
--
sqft
224 St. Mary Street
Loretto
,
Pennsylvania
15940
REALTY ONE GROUP LANDMARK
$790,000
--
bd /
0
ba /
--
sqft
844 Hills Plaza
Ebensburg
,
Pennsylvania
15931
Howard Hanna Bardell Realty Altoona
$724,900
5
bd /
4
ba /
4,727
sqft
1200 Evergreen Road
Summerhill
,
Pennsylvania
15958
BHHS Preferred Johnstown
$699,000
--
bd /
0
ba /
--
sqft
1640 Scalp Avenue
Johnstown
,
Pennsylvania
15904
Lang Real Estate
$699,000
4
bd /
2
ba /
2,800
sqft
246 Spring Hill Lane
Loretto
,
Pennsylvania
15940
«
‹
1
2
3
›
»
Cities In CAMBRIA, PA
Ashville
Beaverdale
Belsano
Blandburg
Carrolltown
Cassandra
Chest Springs
Colver
Coupon
Cresson
Dunlo
Dysart
Ebensburg
Elmora
Elton
Emeigh
Fallentimber
Flinton
Gallitzin
Glasgow
Hastings
Johnstown
Lilly
Loretto
Marsteller
Mineral Point
Nanty Glo
Nicktown
Northern Cambria
Parkhill
Patton
Portage
Revloc
Saint Benedict
Saint Boniface
Saint Michael
Salix
Sidman
South Fork
Spangler
Summerhill
Twin Rocks
Vintondale
Wilmore
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cambria [3] => PA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cambria State: PA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cambria 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 = 2249 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Diane Roberts
ASCII
REALTY ONE GROUP LANDMARK JOHNSTOWN
work
Call Today!
:
(814) 418-8718
I'm interested in properties in CAMBRIA, PA
1846902
1846902
0
Contact Me
USHUD.com on the Go!