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] => 1788 [1] => WARREN (COUNTY) [2] => NJ [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1788 LocID: WARREN (COUNTY) Region: NJ State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1788 Igate: njhud LocID: 1788 Region: WARREN (COUNTY) 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 = 1788 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] => 1788 [1] => WARREN (COUNTY) [2] => NJ [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1788 LocID: WARREN (COUNTY) Region: NJ State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1788 Igate: njhud LocID: 1788 Region: WARREN (COUNTY) 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 = 1788 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] => 1788 [1] => WARREN (COUNTY) [2] => NJ [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1788 LocID: WARREN (COUNTY) Region: NJ State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1788 Igate: njhud LocID: 1788 Region: WARREN (COUNTY) 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 = 1788 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
|
Warren (County)
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Warren (County), New Jersey
Displaying 1 to 10 of 180 Properties (3 foreclosures)
MARK DUKE
FORECLOSURE
$550,000
4
bd /
3
ba /
2,864
sqft
38 Stony Brook Rd
Blairstown
,
New Jersey
07825
MARK DUKE
FORECLOSURE
$439,900
3
bd /
2
ba /
--
sqft
296 Buckley Avenue
Oxford
,
New Jersey
07863
MARK DUKE
FORECLOSURE
$309,900
5
bd /
2
ba /
2,411
sqft
57 Hill St
Washington
,
New Jersey
07882
RE/MAX Town & Valley
$3,300,000
4
bd /
3
ba /
--
sqft
65 Wishing Well Road
Knowlton Twp.
,
New Jersey
07832
Fiedler Realty, LLC
$1,500,000
15
bd /
15
ba /
8,400
sqft
2 E Washington Ave
Washington Boro
,
New Jersey
07882
remax supreme
$1,450,000
5
bd /
3
ba /
3,800
sqft
245 Route 46
Independence Twp.
,
New Jersey
07838
Keller Williams Real Estate
$1,450,000
4
bd /
6
ba /
3,632
sqft
201 Lows Hollow Rd
Lopatcong Twp.
,
New Jersey
08886
Keller Williams Realty Prosperity
$1,250,000
5
bd /
4
ba /
--
sqft
101 Beatty Road
Mansfield
,
New Jersey
07865
Keller Williams Prosperity Realty
$1,250,000
5
bd /
4
ba /
--
sqft
101 Beatty Road
Mansfield
,
New Jersey
07865
Keller Williams Prosperity Realty
$1,250,000
5
bd /
4
ba /
--
sqft
101 Beatty Rd
Mansfield Twp.
,
New Jersey
07865
«
‹
1
2
3
›
»
Cities In WARREN (COUNTY), NJ
Allamuchy
Belvidere
Blairstown
Broadway
Buttzville
Changewater
Columbia
Delaware
Great Meadows
Hackettstown
Hope
Johnsonburg
Oxford
Phillipsburg
Port Murray
Stewartsville
Vienna
Washington
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => warren-county [3] => NJ [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: warren-county State: NJ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: warren-county 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 = 1788 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;
Karen Pardonner
ASCII
Coldwell Banker
work
Call Today!
:
(908) 797-2941
I'm interested in properties in WARREN (COUNTY), NJ
1840878
1840878
0
Contact Me
USHUD.com on the Go!