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] => 1837 [1] => ERIE (SOUTH) [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1837 LocID: ERIE (SOUTH) Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1837 Igate: njhud LocID: 1837 Region: ERIE (SOUTH) State: NY 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 = 1837 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1837 [1] => ERIE (SOUTH) [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1837 LocID: ERIE (SOUTH) Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1837 Igate: njhud LocID: 1837 Region: ERIE (SOUTH) State: NY 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 = 1837 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1837 [1] => ERIE (SOUTH) [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1837 LocID: ERIE (SOUTH) Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1837 Igate: njhud LocID: 1837 Region: ERIE (SOUTH) State: NY 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 = 1837 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Erie (South)
| Hamburg, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Hamburg, Erie (South), New York
Displaying 1 to 10 of 70 Properties (0 foreclosures)
Keller WilliamsRealtyLancaster
$794,900
4
bd /
3
ba /
2,969
sqft
0 Stainton Drive
Hamburg
,
New York
14075
WNY Metro Roberts Realty
$749,900
4
bd /
3
ba /
2,813
sqft
5255 Oakridge Drive
Hamburg
,
New York
14075
eXp Realty
$720,000
4
bd /
2
ba /
2,720
sqft
5042 Woodway Court
Hamburg
,
New York
14075
WNY Metro Roberts Realty
$619,900
4
bd /
2
ba /
2,523
sqft
4160 Ridgefield
Hamburg
,
New York
14075
WNYbyOwner.com
$595,000
3
bd /
2
ba /
1,942
sqft
3790 Hampton Brook Drive
Hamburg
,
New York
14075
WNY Metro Roberts Realty
$569,900
4
bd /
2
ba /
2,407
sqft
5236 Woodrich Court
Hamburg
,
New York
14075
WNY Metro Roberts Realty
$549,900
8
bd /
0
ba /
2,228
sqft
67 Pierce Avenue
Hamburg
,
New York
14075
Keller Williams Realty WNY
$499,999
3
bd /
2
ba /
1,737
sqft
3398 Cedar Valley Way
Hamburg
,
New York
14075
Keller WilliamsRealtyLancaster
$489,900
4
bd /
3
ba /
1,868
sqft
5470 Abel Road
Hamburg
,
New York
14075
Nickel Realty
$480,000
3
bd /
2
ba /
2,112
sqft
4016 Connors Way
Hamburg
,
New York
14219
«
‹
1
2
3
›
»
Cities In ERIE (SOUTH), NY
Akron
Angola
Athol Springs
Boston
Bowmansville
Brant
Buffalo
Chaffee
Colden
Collins
Collins Center
Crittenden
Derby
East Aurora
East Concord
Eden
Elma
Farnham
Glenwood
Hamburg
Holland
Lake View
Lawtons
Marilla
North Collins
Orchard Park
Sardinia
South Wales
Springville
Tonawanda
West Falls
hamburg
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => erie-south [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: erie-south State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: erie-south State: NY 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 = 1837 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Earl Altheide
ASCII
Irish Jones Realty, LLC.
work
Call Today!
:
(716) 901-1518
I'm interested in properties in ERIE (SOUTH), NY
1843726
1843726
0
Contact Me
USHUD.com on the Go!