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 else AFTER: Site: 1779 Igate: njhud 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 i.igate IN ('njhud','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 = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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 else AFTER: Site: 1779 Igate: njhud 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 i.igate IN ('njhud','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 = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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 else AFTER: Site: 1779 Igate: njhud 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 i.igate IN ('njhud','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 = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New Jersey (NJ) Foreclosure Listings
|
Middlesex (South)
| South Amboy, New Jersey
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
South Amboy, Middlesex (South), New Jersey
Displaying 1 to 10 of 52 Properties (1 foreclosures)
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$351,900
4
bd /
3
ba /
2,713
sqft
416 Catherine Street
South Amboy
,
New Jersey
08879
J.J. ELEK REALTY CO.
$999,900
--
bd /
0
ba /
3,548
sqft
171 N Stevens Avenue
South Amboy
,
New Jersey
08879
Better Homes and Gardens Real Estate Murphy & Co.
$999,000
8
bd /
6
ba /
--
sqft
32 Heston Avenue
South Amboy
,
New Jersey
08879
Keller Williams Realty West Monmouth
$999,000
--
bd /
0
ba /
8,000
sqft
3602 State Route 35
South Amboy
,
New Jersey
08879
HALLMARK REALTORS
$875,000
--
bd /
0
ba /
1,732
sqft
1800 State Route 35
South Amboy
,
New Jersey
08879
REALMART REALTY LLC
$824,900
4
bd /
2
ba /
2,624
sqft
104 N Rosewell Avenue N
South Amboy
,
New Jersey
08879
RE/MAX FIRST REALTY, INC.
$800
--
bd /
0
ba /
1,465
sqft
1133 State Route 35 Highway
South Amboy
,
New Jersey
08879
Heritage House Sotheby's International Realty
$799,000
3
bd /
2
ba /
2,806
sqft
1 Osprey Drive
South Amboy
,
New Jersey
08879
J.J. ELEK REALTY CO.
$779,000
--
bd /
0
ba /
3,020
sqft
228 David Street
South Amboy
,
New Jersey
08879
J.J. ELEK REALTY CO.
$775,000
4
bd /
3
ba /
2,800
sqft
306 Elm Street
South Amboy
,
New Jersey
08879
«
‹
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
south amboy
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => middlesex-south [3] => NJ [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: middlesex-south State: NJ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: middlesex-south 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 = 1779 AND i.igate IN ('njhud','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 = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Angela & Scott Pappas
ASCII
TeamPappas, eXp Realty
work
Call Today!
:
(908) 220-2295
I'm interested in properties in MIDDLESEX (SOUTH), NJ
1840773
1840773
0
Contact Me
USHUD.com on the Go!