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] => 1775 [1] => GLOUCESTER (NORTH) [2] => NJ [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1775 LocID: GLOUCESTER (NORTH) Region: NJ State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1775 Igate: njhud LocID: 1775 Region: GLOUCESTER (NORTH) 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 = 1775 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1775 [1] => GLOUCESTER (NORTH) [2] => NJ [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1775 LocID: GLOUCESTER (NORTH) Region: NJ State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1775 Igate: njhud LocID: 1775 Region: GLOUCESTER (NORTH) 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 = 1775 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1775 [1] => GLOUCESTER (NORTH) [2] => NJ [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1775 LocID: GLOUCESTER (NORTH) Region: NJ State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1775 Igate: njhud LocID: 1775 Region: GLOUCESTER (NORTH) 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 = 1775 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New Jersey (NJ) Foreclosure Listings
|
Gloucester (North)
| Clarksboro, New Jersey
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Clarksboro, Gloucester (North), New Jersey
Displaying 1 to 8 of 8 Properties (0 foreclosures)
Compass New Jersey, LLC - Moorestown
$795,000
4
bd /
2
ba /
4,139
sqft
37 Whiskey Mill Road
Clarksboro
,
New Jersey
08020
BHHS Fox & Roach Mullica Hill
$719,900
4
bd /
2
ba /
3,250
sqft
112 Robert Botto Way
Clarksboro
,
New Jersey
08020
BHHS Fox & Roach Mullica Hill
$585,000
4
bd /
2
ba /
2,086
sqft
6 Marino Drive
Clarksboro
,
New Jersey
08020
BHHS Fox & Roach Mullica Hill
$479,000
2
bd /
2
ba /
2,222
sqft
27 Jubilee Drive
Clarksboro
,
New Jersey
08020
Keller Williams Realty - Cherry Hill
$375,000
--
bd /
0
ba /
--
sqft
150 Timberlane Road
Clarksboro
,
New Jersey
08020
BHHS Fox & Roach Mullica Hill North
$355,000
3
bd /
1
ba /
1,320
sqft
27 W Cohawkin Road
Clarksboro
,
New Jersey
08020
Axon Real Estate
$5,000
--
bd /
0
ba /
--
sqft
324 Borrelli Boulevard
Clarksboro
,
New Jersey
08020
Realty Mark Advantage
$1,700
1
bd /
1
ba /
3,760
sqft
290 Kings Highway
Clarksboro
,
New Jersey
08020
Cities In GLOUCESTER (NORTH), NJ
Bridgeport
Clarksboro
Gibbstown
Mantua
Mickleton
Mount Royal
National Park
Paulsboro
Swedesboro
Thorofare
Wenonah
Westville
Woodbury
Woodbury Heights
clarksboro
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => gloucester-north [3] => NJ [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: gloucester-north State: NJ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: gloucester-north State: NJ 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 = 1775 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Michelle Terry
ASCII
Keller Williams Washington Township
work
Call Today!
:
(609) 517-1358
I'm interested in properties in GLOUCESTER (NORTH), NJ
1845972
1845972
0
Contact Me
USHUD.com on the Go!