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] => 1769 [1] => BERGEN (CENTRAL) [2] => NJ [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1769 LocID: BERGEN (CENTRAL) Region: NJ State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1769 Igate: njhud LocID: 1769 Region: BERGEN (CENTRAL) 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 = 1769 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] => 1769 [1] => BERGEN (CENTRAL) [2] => NJ [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1769 LocID: BERGEN (CENTRAL) Region: NJ State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1769 Igate: njhud LocID: 1769 Region: BERGEN (CENTRAL) 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 = 1769 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] => 1769 [1] => BERGEN (CENTRAL) [2] => NJ [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1769 LocID: BERGEN (CENTRAL) Region: NJ State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1769 Igate: njhud LocID: 1769 Region: BERGEN (CENTRAL) 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 = 1769 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
|
Bergen (Central)
| Tenafly, New Jersey
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Tenafly, Bergen (Central), New Jersey
Displaying 21 to 30 of 42 Properties (0 foreclosures)
Prominent Properties Sotheby's International Realty-Englewood Cliffs
$2,700,000
6
bd /
4
ba /
--
sqft
90 Essex Drive
Tenafly
,
New Jersey
07670
Keller Williams - Tenafly
$2,325,000
6
bd /
6
ba /
--
sqft
64 North Lyle Avenue
Tenafly
,
New Jersey
07670
Keller Williams Town Life
$2,325,000
6
bd /
6
ba /
--
sqft
64 North Lyle Avenue
Tenafly
,
New Jersey
07670
Keller Williams - Tenafly
$2,199,000
4
bd /
3
ba /
--
sqft
44 Bliss Avenue
Tenafly
,
New Jersey
07670
Keller Williams Town Life
$2,199,000
4
bd /
3
ba /
--
sqft
44 Bliss Avenue
Tenafly
,
New Jersey
07670
Keller Williams - Tenafly
$2,099,000
6
bd /
5
ba /
--
sqft
150 Sunset Lane
Tenafly
,
New Jersey
07670
Keller Williams Town Life
$2,099,000
6
bd /
5
ba /
--
sqft
150 Sunset Lane
Tenafly
,
New Jersey
07670
Keller Williams - Tenafly
$2,000
1
bd /
1
ba /
--
sqft
274 County Road
Tenafly
,
New Jersey
07670
Keller Williams Town Life
$2,000
1
bd /
1
ba /
--
sqft
274 County Road
Tenafly
,
New Jersey
07670
Keller Williams - Tenafly
$1,999,999
4
bd /
3
ba /
--
sqft
36 Forest Road
Tenafly
,
New Jersey
07670
«
‹
1
2
3
4
5
›
»
Cities In BERGEN (CENTRAL), NJ
Alpine
Bergenfield
Carlstadt
Closter
Cresskill
Demarest
Dumont
East Rutherford
Emerson
Garfield
Hackensack
Harrington Park
Hasbrouck Heights
Haworth
Hillsdale
Little Ferry
Lodi
Lyndhurst
Maywood
Montvale
Moonachie
New Milford
North Arlington
Northvale
Norwood
Oradell
Paramus
Park Ridge
River Edge
Rochelle Park
Rutherford
Saddle Brook
South Hackensack
Tenafly
Teterboro
Township Of Washington
Wallington
Westwood
Wood Ridge
Woodcliff Lake
tenafly
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => bergen-central [3] => NJ [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: bergen-central State: NJ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: bergen-central 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 = 1769 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;
Giselle Azcona-Lubbock
ASCII
Coldwell Banker Realty
work
Call Today!
:
(646) 670-8192
I'm interested in properties in BERGEN (CENTRAL), NJ
1840066
1840066
0
Contact Me
USHUD.com on the Go!