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] => 1780 [1] => MONMOUTH (NORTH) [2] => NJ [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1780 LocID: MONMOUTH (NORTH) 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: 1780 Region: MONMOUTH (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 = 1780 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] => 1780 [1] => MONMOUTH (NORTH) [2] => NJ [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1780 LocID: MONMOUTH (NORTH) 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: 1780 Region: MONMOUTH (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 = 1780 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] => 1780 [1] => MONMOUTH (NORTH) [2] => NJ [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1780 LocID: MONMOUTH (NORTH) 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: 1780 Region: MONMOUTH (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 = 1780 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
|
Monmouth (North)
| Leonardo, New Jersey
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Leonardo, Monmouth (North), New Jersey
Displaying 1 to 9 of 9 Properties (0 foreclosures)
Coldwell Banker Res. Brokerage
$809,900
3
bd /
4
ba /
2,864
sqft
500 Ocean Boulevard
Leonardo
,
New Jersey
07737
Refined Dreams Realty
$789,000
4
bd /
4
ba /
1,670
sqft
35 Florence Avenue
Leonardo
,
New Jersey
07737
Adele Demoro
$685,000
5
bd /
3
ba /
2,754
sqft
49 Hosford Avenue
Leonardo
,
New Jersey
07737
RE/MAX 1st. CLASS
$675,000
4
bd /
2
ba /
1,830
sqft
155 Mabel Avenue
Leonardo
,
New Jersey
07737
RE/MAX 1st. Advantage
$599,000
4
bd /
2
ba /
2,154
sqft
16 Kelvin Avenue
Leonardo
,
New Jersey
07737
RE/MAX Homeland Realtors
$559,000
--
bd /
0
ba /
--
sqft
372-0 Monmouth Avenue
Leonardo
,
New Jersey
07737
eXp Realty, LLC
$525,000
3
bd /
2
ba /
1,188
sqft
33 Florence Avenue
Leonardo
,
New Jersey
07737
Heritage House Sotheby's International Realty
$435,000
5
bd /
2
ba /
--
sqft
122 Burlington Avenue
Leonardo
,
New Jersey
07737
Keller Williams Realty East Monmouth
$389,900
2
bd /
1
ba /
1,134
sqft
410 Glenmary Avenue
Leonardo
,
New Jersey
07737
Cities In MONMOUTH (NORTH), NJ
Adelphia
Asbury Park
Atlantic Highlands
Belford
Belmar
Cliffwood
Eatontown
Fair Haven
Fort Monmouth
Hazlet
Highlands
Holmdel
Keansburg
Keyport
Leonardo
Lincroft
Little Silver
Matawan
Middletown
Monmouth Beach
Morganville
Navesink
Oceanport
Port Monmouth
Red Bank
Rumson
Shrewsbury
Tennent
Wickatunk
leonardo
USHUD.com on the Go!