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] => 1779 [1] => MIDDLESEX (SOUTH) [2] => NJ [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1779 LocID: MIDDLESEX (SOUTH) 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: 1779 Region: MIDDLESEX (SOUTH) 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 = 1779 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] => 1779 [1] => MIDDLESEX (SOUTH) [2] => NJ [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1779 LocID: MIDDLESEX (SOUTH) 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: 1779 Region: MIDDLESEX (SOUTH) 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 = 1779 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] => 1779 [1] => MIDDLESEX (SOUTH) [2] => NJ [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1779 LocID: MIDDLESEX (SOUTH) 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: 1779 Region: MIDDLESEX (SOUTH) 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 = 1779 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
|
Middlesex (South)
| Plainsboro, New Jersey
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Plainsboro, Middlesex (South), New Jersey
Displaying 1 to 10 of 22 Properties (0 foreclosures)
Coldwell Banker Residential Brokerage
$850,000
5
bd /
3
ba /
2,742
sqft
33 Groendyke Lane
Plainsboro
,
New Jersey
08536
Berkshire Hathaway HomeServices Fox & Roach, Real
$819,000
3
bd /
3
ba /
--
sqft
70 Riverwalk
Plainsboro
,
New Jersey
08536
Berkshire Hathaway HomeServices Fox & Roach, Real
$799,000
4
bd /
4
ba /
2,157
sqft
41 Perrine Road
Plainsboro
,
New Jersey
08536
Berkshire Hathaway HomeServices Fox & Roach, Real
$778,000
3
bd /
3
ba /
2,948
sqft
40 Riverwalk
Plainsboro
,
New Jersey
08536
Berkshire Hathaway HomeServices Fox & Roach, Real
$768,000
3
bd /
3
ba /
--
sqft
73 Riverwalk
Plainsboro
,
New Jersey
08536
Berkshire Hathaway HomeServices Fox & Roach, Real
$758,000
3
bd /
3
ba /
--
sqft
81 Riverwalk
Plainsboro
,
New Jersey
08536
Berkshire Hathaway HomeServices Fox & Roach, Real
$738,000
3
bd /
3
ba /
--
sqft
71 Riverwalk
Plainsboro
,
New Jersey
08536
Berkshire Hathaway HomeServices Fox & Roach, Real
$728,000
3
bd /
3
ba /
--
sqft
82 Riverwalk
Plainsboro
,
New Jersey
08536
Berkshire Hathaway HomeServices Fox & Roach, Real
$728,000
3
bd /
3
ba /
--
sqft
84 Riverwalk
Plainsboro
,
New Jersey
08536
Coldwell Banker Res. Brokerage
$650,000
3
bd /
2
ba /
2,216
sqft
197 Cranbury Neck Road
Plainsboro
,
New Jersey
08536
«
‹
1
2
3
›
»
Cities In MIDDLESEX (SOUTH), NJ
Cranbury
Dayton
East Brunswick
Helmetta
Kendall Park
Milltown
Monmouth Junction
Monroe Township
New Brunswick
North Brunswick
Old Bridge
Parlin
Plainsboro
Sayreville
South Amboy
South River
Spotswood
plainsboro
USHUD.com on the Go!