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] => 2268 [1] => GREENE [2] => PA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2268 LocID: GREENE Region: PA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2268 Igate: njhud LocID: 2268 Region: GREENE 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 = 2268 AND i.igate IN ('okhud','usahud','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 = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2268 [1] => GREENE [2] => PA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2268 LocID: GREENE Region: PA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2268 Igate: njhud LocID: 2268 Region: GREENE 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 = 2268 AND i.igate IN ('okhud','usahud','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 = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2268 [1] => GREENE [2] => PA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2268 LocID: GREENE Region: PA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2268 Igate: njhud LocID: 2268 Region: GREENE 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 = 2268 AND i.igate IN ('okhud','usahud','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 = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Pennsylvania (PA) Foreclosure Listings
|
Greene
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Greene, Pennsylvania
Displaying 1 to 10 of 34 Properties (1 foreclosures)
Westmoreland Real Estate Inc
FORECLOSURE
$105,000
3
bd /
2
ba /
--
sqft
222 S Pine
Carmichaels/cumblnd
,
Pennsylvania
15320
Realty ONE Group Gold Standard
$789,900
3
bd /
2
ba /
--
sqft
119 Meadowbrook Rd
Washingtn/ruff Creek
,
Pennsylvania
15370
Pittsburgh South Realty LP
$624,000
--
bd /
0
ba /
--
sqft
114 Harts
Carmichaels/cumblnd
,
Pennsylvania
15320
WHITETAIL PROPERTIES REAL ESTATE LLC
$499,000
2
bd /
2
ba /
--
sqft
131 Milliken Rd
New Freeport
,
Pennsylvania
15341
Coldwell Banker Real Estate Services
$359,999
4
bd /
4
ba /
--
sqft
160 Zimmer Ln
Waynsbrg/frankln Twp
,
Pennsylvania
15370
Realty ONE Group Gold Standard
$299,900
4
bd /
4
ba /
--
sqft
746 Hunters Ridge Road
Kirby/mt.morris
,
Pennsylvania
15349
Pittsburgh South Realty LP
$299,900
--
bd /
0
ba /
--
sqft
0 Happy Valley Road
Waynsbrg/frankln Twp
,
Pennsylvania
15370
eXp Realty, LLC
$275,000
3
bd /
2
ba /
--
sqft
119 High St
Dry Tav/rices Landing
,
Pennsylvania
15357
J.S. Walker Associates, Inc.
$249,000
3
bd /
1
ba /
1,460
sqft
135 Virginia Street
Mount Morris
,
Pennsylvania
15349
Century 21 Frontier Realty
$219,900
2
bd /
3
ba /
--
sqft
310 Baily Ave
Carmichaels/cumblnd
,
Pennsylvania
15320
«
‹
1
2
3
›
»
Cities In GREENE, PA
Aleppo
Bobtown
Brave
Carmichaels
Clarksville
Crucible
Dilliner
Garards Fort
Graysville
Greensboro
Holbrook
Jefferson
Mather
Mount Morris
Nemacolin
New Freeport
Nineveh
Rices Landing
Rogersville
Spraggs
Sycamore
Waynesburg
Wind Ridge
USHUD.com on the Go!