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
| Stone Harbor, New Jersey
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Stone Harbor, Cape May, New Jersey
Displaying 1 to 10 of 33 Properties (0 foreclosures)
COMPASS RE - Avalon
$9,999,000
5
bd /
6
ba /
3,000
sqft
10521 Golden Gate
Stone Harbor
,
New Jersey
08247
DILLER & FISHER - SH
$7,449,000
7
bd /
8
ba /
3,541
sqft
136 107th
Stone Harbor
,
New Jersey
08247
Avalon/Stone Harbor Real Estate
$7,395,000
5
bd /
5
ba /
3,000
sqft
10403 3rd
Stone Harbor
,
New Jersey
08247
PREMIER HOMES REAL ESTATE, LLC
$7,395,000
5
bd /
5
ba /
3,000
sqft
10403 3rd Ave
Stone Harbor
,
New Jersey
08247
Avalon/Stone Harbor Real Estate
$7,195,000
5
bd /
5
ba /
2,723
sqft
10311 Sunrise
Stone Harbor
,
New Jersey
08247
PREMIER HOMES REAL ESTATE, LLC
$7,195,000
5
bd /
5
ba /
2,723
sqft
10311 Sunrise Dr
Stone Harbor
,
New Jersey
08247
Avalon/Stone Harbor Real Estate
$7,195,000
5
bd /
5
ba /
2,628
sqft
10315 Sunrise
Stone Harbor
,
New Jersey
08247
PREMIER HOMES REAL ESTATE, LLC
$7,195,000
5
bd /
5
ba /
2,628
sqft
10315 Sunrise Dr
Stone Harbor
,
New Jersey
08247
Avalon/Stone Harbor Real Estate
$6,795,000
5
bd /
7
ba /
3,025
sqft
8601 Pennsylvania
Stone Harbor
,
New Jersey
08247
PREMIER HOMES REAL ESTATE, LLC
$6,795,000
5
bd /
7
ba /
3,025
sqft
8601 Pennsylvania Ave
Stone Harbor
,
New Jersey
08247
«
‹
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
stone harbor
USHUD.com on the Go!