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] => 1772 [1] => CAPE MAY [2] => NJ [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1772 LocID: CAPE MAY Region: NJ State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1772 Region: CAPE MAY State: NJ 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 = 1772 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1772 [1] => CAPE MAY [2] => NJ [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1772 LocID: CAPE MAY Region: NJ State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1772 Region: CAPE MAY State: NJ 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 = 1772 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1772 [1] => CAPE MAY [2] => NJ [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1772 LocID: CAPE MAY Region: NJ State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1772 Region: CAPE MAY State: NJ 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 = 1772 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New Jersey (NJ) Foreclosure Listings
|
Cape May
| Avalon, New Jersey
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Avalon, Cape May, New Jersey
Displaying 1 to 10 of 48 Properties (0 foreclosures)
BERKSHIRE HATHAWAY HOME SERVICES FOX & ROACH
$24,999,000
6
bd /
8
ba /
7,240
sqft
5499 Dune
Avalon
,
New Jersey
08202
Berkshire Hathaway HomeServices Fox & Roach, Real
$24,999,000
6
bd /
7
ba /
7,240
sqft
5499 Dune Drive
Avalon
,
New Jersey
08202
BERKSHIRE HATHAWAY HOME SERVICES FOX & ROACH
$10,495,000
6
bd /
6
ba /
4,219
sqft
4209 Bayberry
Avalon
,
New Jersey
08202
Berkshire Hathaway HomeServices Fox & Roach, Real
$10,495,000
6
bd /
5
ba /
4,219
sqft
4209 Bayberry Road
Avalon
,
New Jersey
08202
COMPASS RE - Avalon
$8,595,000
6
bd /
7
ba /
5,700
sqft
4277 5th
Avalon
,
New Jersey
08202
Long & Foster Real Estate
$6,995,000
6
bd /
6
ba /
--
sqft
135 77th Street
Avalon
,
New Jersey
08202
COMPASS RE - Avalon
$6,995,000
4
bd /
3
ba /
2,436
sqft
83 E 25th
Avalon
,
New Jersey
08202
BERKSHIRE HATHAWAY HOME SERVICES FOX & ROACH
$6,875,000
5
bd /
6
ba /
5,174
sqft
4120 Bayberry
Avalon
,
New Jersey
08202
Berkshire Hathaway HomeServices Fox & Roach, Real
$6,875,000
5
bd /
5
ba /
5,174
sqft
4120 Bayberry Road
Avalon
,
New Jersey
08202
DILLER & FISHER - SH
$6,384,000
6
bd /
8
ba /
--
sqft
25 E 12th
Avalon
,
New Jersey
08202
«
‹
1
2
3
›
»
Cities In CAPE MAY, NJ
Avalon
Cape May
Cape May Court House
Cape May Point
Dennisville
Goshen
Green Creek
Marmora
Ocean City
Ocean View
Rio Grande
Sea Isle City
South Dennis
South Seaville
Stone Harbor
Strathmere
Tuckahoe
Villas
Whitesboro
Wildwood
Woodbine
avalon
USHUD.com on the Go!