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] => 1858 [1] => ORANGE (SOUTH) [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1858 LocID: ORANGE (SOUTH) Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1858 Igate: njhud LocID: 1858 Region: ORANGE (SOUTH) 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 = 1858 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1858 [1] => ORANGE (SOUTH) [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1858 LocID: ORANGE (SOUTH) Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1858 Igate: njhud LocID: 1858 Region: ORANGE (SOUTH) 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 = 1858 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1858 [1] => ORANGE (SOUTH) [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1858 LocID: ORANGE (SOUTH) Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1858 Igate: njhud LocID: 1858 Region: ORANGE (SOUTH) 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 = 1858 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Orange (South)
| Warwick, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Warwick, Orange (South), New York
Displaying 1 to 10 of 13 Properties (0 foreclosures)
TK Real Estate Group, Inc
$1,250,000
4
bd /
3
ba /
--
sqft
11 Deer Meadow Road
Warwick
,
New York
10990
Better Homes and Gardens Real Estate Green Team
$1,100,000
4
bd /
3
ba /
4,190
sqft
14 Warwick Lake Parkway
Warwick
,
New York
10990
Better Homes and Gardens Real Estate Green Team
$995,000
4
bd /
3
ba /
3,756
sqft
30 Warwick Lake Parkway
Warwick
,
New York
10990
BHG Real Estate Green Team
$979,000
4
bd /
3
ba /
3,167
sqft
29 West Meadow Way
Warwick
,
New York
10990
BHG Real Estate Green Team
$899,000
4
bd /
3
ba /
3,100
sqft
26 West Meadow Way
Warwick
,
New York
10990
Better Homes and Gardens Real Estate Green Team
$799,999
4
bd /
1
ba /
1,722
sqft
183 West Street
Warwick
,
New York
10990
Compass Greater NY, LLC
$679,000
4
bd /
2
ba /
2,250
sqft
141 E Ridge Road
Warwick
,
New York
10990
Better Homes and Gardens Real Estate Green Team
$624,900
4
bd /
3
ba /
2,192
sqft
2 Whitefield Avenue
Warwick
,
New York
10990
Better Homes and Gardens Real Estate Green Team
$449,000
3
bd /
2
ba /
1,332
sqft
108 Mcewen Street
Warwick
,
New York
10990
Better Homes and Gardens Green Team
$169,500
2
bd /
1
ba /
400
sqft
197a Wheeler Rd
Warwick
,
New York
10921
«
‹
1
2
›
»
Cities In ORANGE (SOUTH), NY
Central Valley
Chester
Cuddebackville
Florida
Goshen
Greenwood Lake
Harriman
Highland Falls
Highland Mills
Huguenot
Middletown
Monroe
New Hampton
Otisville
Pine Island
Port Jervis
Slate Hill
Southfields
Sparrow Bush
Tuxedo Park
Warwick
West Point
Westtown
warwick
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => orange-south [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: orange-south State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: orange-south 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 = 1858 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
JoAnn Maxwell
ASCII
Howard Hanna Rand Realty
work
Call Today!
:
(914) 850-2782
I'm interested in properties in ORANGE (SOUTH), NY
1846983
1846983
0
Contact Me
USHUD.com on the Go!