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] => 2277 [1] => LEHIGH [2] => PA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2277 LocID: LEHIGH Region: PA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2277 Igate: njhud LocID: 2277 Region: LEHIGH 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 = 2277 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] => 2277 [1] => LEHIGH [2] => PA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2277 LocID: LEHIGH Region: PA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2277 Igate: njhud LocID: 2277 Region: LEHIGH 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 = 2277 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] => 2277 [1] => LEHIGH [2] => PA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2277 LocID: LEHIGH Region: PA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2277 Igate: njhud LocID: 2277 Region: LEHIGH 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 = 2277 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
|
Lehigh
| Allentown, Pennsylvania
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Allentown, Lehigh, Pennsylvania
Displaying 1 to 10 of 233 Properties (0 foreclosures)
IronValley RE of Lehigh Valley
$4,500,000
--
bd /
0
ba /
19,200
sqft
1226 West Green Street
Allentown
,
Pennsylvania
18102
Keller Williams Real Estate - Allentown
$4,300,000
--
bd /
0
ba /
--
sqft
808 W Hamilton Street
Allentown
,
Pennsylvania
18101
Keller Williams Real Estate
$4,300,000
--
bd /
0
ba /
22,400
sqft
808 West Hamilton Street
Allentown
,
Pennsylvania
18101
Keller Williams Real Estate - Allentown
$4,300,000
--
bd /
0
ba /
--
sqft
943 W Hamilton
Allentown
,
Pennsylvania
18101
Keller Williams Real Estate - Allentown
$4,300,000
--
bd /
0
ba /
46,000
sqft
943 W Hamilton Street
Allentown
,
Pennsylvania
18101
Keller Williams Real Estate
$4,300,000
--
bd /
0
ba /
46,000
sqft
943 West Hamilton Street
Allentown
,
Pennsylvania
18101
HowardHanna TheFrederickGroup
$3,295,000
--
bd /
0
ba /
9,111
sqft
514 528 North 22nd Street
Allentown
,
Pennsylvania
18104
Keller Williams Real Estate
$3,200,000
--
bd /
0
ba /
21,318
sqft
22 North 6th Street
Allentown
,
Pennsylvania
18101
HowardHanna TheFrederickGroup
$3,200,000
--
bd /
0
ba /
44,196
sqft
2236 South 12th Street
Allentown
,
Pennsylvania
18103
BHHS Regency Real Estate
$2,449,000
17
bd /
12
ba /
12,214
sqft
134 138 7th
Allentown
,
Pennsylvania
18101
«
‹
1
2
3
›
»
Cities In LEHIGH, PA
Alburtis
Allentown
Bethlehem
Breinigsville
Catasauqua
Center Valley
Coopersburg
Coplay
East Texas
Emmaus
Fogelsville
Germansville
Laurys Station
Limeport
Macungie
Neffs
New Tripoli
Old Zionsville
Orefield
Schnecksville
Slatedale
Slatington
Trexlertown
Whitehall
Zionsville
allentown
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => lehigh [3] => PA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: lehigh State: PA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: lehigh 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 = 2277 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;
Greta Kistler
ASCII
Howard Hanna Real Estate Services - The Frederick Group
work
Call Today!
:
(610) 751-2200
I'm interested in properties in LEHIGH, PA
1847055
1847055
0
Contact Me
USHUD.com on the Go!