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 ('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] => 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 ('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] => 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 ('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
|
Westmoreland
| Irwin, Pennsylvania
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Irwin, Westmoreland, Pennsylvania
Displaying 1 to 10 of 13 Properties (0 foreclosures)
REALTY ONE GROUP GOLD STANDARD
$900,000
--
bd /
0
ba /
--
sqft
28 Fairwood Drive
Irwin
,
Pennsylvania
15642
CENTURY 21 FAIRWAYS REAL ESTATE
$79,900
--
bd /
0
ba /
--
sqft
Lot 2 Wendel Road
Irwin
,
Pennsylvania
15642
CENTURY 21 FAIRWAYS REAL ESTATE
$79,900
--
bd /
0
ba /
--
sqft
Lot 3 Wendel Road
Irwin
,
Pennsylvania
15642
CENTURY 21 FAIRWAYS REAL ESTATE
$79,900
--
bd /
0
ba /
--
sqft
Lot 4 Wendel Road
Irwin
,
Pennsylvania
15642
COLDWELL BANKER REALTY
$69,000
4
bd /
2
ba /
--
sqft
701 Pennsylvania Avenue
Irwin
,
Pennsylvania
15642
REALTY ONE GROUP GOLD STANDARD
$650,000
--
bd /
0
ba /
--
sqft
14139 Route 30
Irwin
,
Pennsylvania
15642
CENTURY 21 FAIRWAYS REAL ESTATE
$575,000
4
bd /
3
ba /
--
sqft
11775 Frieda Dr
Irwin
,
Pennsylvania
15642
CENTURY 21 FAIRWAYS REAL ESTATE
$564,900
3
bd /
2
ba /
--
sqft
630 Caruthers Lane
Irwin
,
Pennsylvania
15642
INTEGRITY PLUS REALTY
$3,750,000
--
bd /
0
ba /
--
sqft
2155 Gracin Ln
Irwin
,
Pennsylvania
15642
CENTURY 21 FAIRWAYS REAL ESTATE
$34,900
--
bd /
0
ba /
--
sqft
0 Caruthers Lane
Irwin
,
Pennsylvania
15642
«
‹
1
2
›
»
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
irwin
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 ('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;
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 ('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;
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!