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] => 3383 [1] => ORANGE (NORTH) [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3383 LocID: ORANGE (NORTH) Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3383 Igate: njhud LocID: 3383 Region: ORANGE (NORTH) State: NY 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 = 3383 AND i.igate IN ('nyhud','usahud','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 = 'nyhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3383 [1] => ORANGE (NORTH) [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3383 LocID: ORANGE (NORTH) Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3383 Igate: njhud LocID: 3383 Region: ORANGE (NORTH) State: NY 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 = 3383 AND i.igate IN ('nyhud','usahud','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 = 'nyhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3383 [1] => ORANGE (NORTH) [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3383 LocID: ORANGE (NORTH) Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3383 Igate: njhud LocID: 3383 Region: ORANGE (NORTH) State: NY 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 = 3383 AND i.igate IN ('nyhud','usahud','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 = 'nyhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Orange (North)
| Newburgh, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Newburgh, Orange (North), New York
Displaying 1 to 10 of 20 Properties (0 foreclosures)
Voro LLC
$975,000
11
bd /
7
ba /
3,200
sqft
86 Lander Street
Newburgh
,
New York
12550
Khadeejah Johnson, Licensed Real Estate Broker
$79,999
--
bd /
0
ba /
--
sqft
25 Kohl Ave
Newburgh
,
New York
12550
Voro LLC
$7,000
--
bd /
0
ba /
--
sqft
158 N Plank Road
Newburgh
,
New York
12550
Century 21 Sherlock Homes
$698,000
--
bd /
0
ba /
--
sqft
S Route 52
Newburgh
,
New York
12550
Success Power Brokers
$599,000
4
bd /
2
ba /
3,355
sqft
79 Hickory Hill Road
Newburgh
,
New York
12550
Four Seasons Sotheby's Int'l-K
$525,000
3
bd /
2
ba /
1,586
sqft
66 Balmville Road
Newburgh
,
New York
12550
John J Lease REALTORS Inc
$499,999
4
bd /
2
ba /
2,352
sqft
48 Ramblewood Drive
Newburgh
,
New York
12550
eXp Realty
$450,000
3
bd /
2
ba /
1,300
sqft
115 Gardnertown Road
Newburgh
,
New York
12550
Douglas Elliman Real Estate
$429,000
3
bd /
2
ba /
--
sqft
240 Orleans Road
Newburgh
,
New York
12550
Curasi Realty, Inc.
$390,000
3
bd /
1
ba /
2,301
sqft
66 Paffendorf Drive
Newburgh
,
New York
12550
«
‹
1
2
›
»
Cities In ORANGE (NORTH), NY
Campbell Hall
Circleville
Cornwall
Cornwall On Hudson
Maybrook
Middletown
Montgomery
New Windsor
Newburgh
Pine Bush
Rock Tavern
Salisbury Mills
Thompson Ridge
Walden
Washingtonville
newburgh
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => orange-north [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: orange-north State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: orange-north State: NY 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 = 3383 AND i.igate IN ('nyhud','usahud','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 = 'nyhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Dulce Ferrera & Gloria Rivera
ASCII
Dream Home Team @ KW Realty Hudson Valley United
work
Dulce
:
(914) 433-1168
work
Gloria
:
(917) 816-4167
I'm interested in properties in ORANGE (NORTH), NY
1839995
1839995
0
Contact Me
USHUD.com on the Go!