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] => 2303 [1] => WESTMORELAND [2] => PA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2303 LocID: WESTMORELAND Region: PA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2303 Igate: njhud LocID: 2303 Region: WESTMORELAND 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 = 2303 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] => 2303 [1] => WESTMORELAND [2] => PA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2303 LocID: WESTMORELAND Region: PA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2303 Igate: njhud LocID: 2303 Region: WESTMORELAND 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 = 2303 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] => 2303 [1] => WESTMORELAND [2] => PA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2303 LocID: WESTMORELAND Region: PA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2303 Igate: njhud LocID: 2303 Region: WESTMORELAND 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 = 2303 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
|
Westmoreland
| Seward, Pennsylvania
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Seward, Westmoreland, Pennsylvania
Displaying 1 to 6 of 6 Properties (0 foreclosures)
RE/MAX TEAM, REALTORS
$289,900
3
bd /
2
ba /
2,541
sqft
191 Locust Street
Seward
,
Pennsylvania
15954
RE/MAX POWER Associates
$270,000
3
bd /
2
ba /
2,798
sqft
605 Griffith Road
Seward
,
Pennsylvania
15954
BHHS Preferred Ligonier
$2,000
--
bd /
0
ba /
--
sqft
628 Route 56
Seward
,
Pennsylvania
15954
BHHS Preferred Ligonier
$150,000
4
bd /
2
ba /
1,263
sqft
1217 5th Street
Seward
,
Pennsylvania
15954
KW EXCLUSIVE REAL ESTATE
$119,500
4
bd /
2
ba /
3,182
sqft
2092 Rt 711 Hwy
Seward
,
Pennsylvania
15954
RE/MAX POWER Associates
$110,000
3
bd /
1
ba /
1,368
sqft
99 Chestnut Street
Seward
,
Pennsylvania
15954
Cities In WESTMORELAND, PA
Acme
Adamsburg
Alverton
Apollo
Ardara
Armbrust
Arona
Avonmore
Bolivar
Bovard
Bradenville
Calumet
Champion
Claridge
Crabtree
Darragh
Delmont
Derry
Donegal
East Vandergrift
Export
Forbes Road
Grapeville
Greensburg
Hannastown
Harrison City
Herminie
Hostetter
Hunker
Hutchinson
Hyde Park
Irwin
Jacobs Creek
Jeannette
Jones Mills
Larimer
Latrobe
Laughlintown
Ligonier
Lowber
Loyalhanna
Luxor
Madison
Mammoth
Manor
Monessen
Mount Pleasant
Murrysville
New Alexandria
New Derry
New Florence
New Kensington
New Stanton
Norvelt
Penn
Pleasant Unity
Pricedale
Rector
Rillton
Ruffs Dale
Salina
Scottdale
Seward
Slickville
Smithton
Southwest
Stahlstown
Sutersville
Tarrs
Torrance
Trafford
United
Vandergrift
Webster
Wendel
West Newton
Westmoreland City
Whitney
Wyano
Youngstown
Youngwood
Yukon
seward
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => westmoreland [3] => PA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: westmoreland State: PA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: westmoreland 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 = 2303 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;
Heather Schultheis
ASCII
Re/Max Heritage
work
Call Today!
:
(724) 787-1308
I'm interested in properties in WESTMORELAND, PA
1842468
1842468
0
Contact Me
Local Mortgage Pro
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => westmoreland [3] => PA [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: westmoreland State: PA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: westmoreland State: PA Experttype: lender 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 = 2303 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;
Gregory Incardona
ASCII
Motto Mortgage Keystone
work
Office
:
(412) 334-4504
I'm interested in properties in WESTMORELAND, PA
1837782
1837782
0
Contact Me
USHUD.com on the Go!