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] => 1866 [1] => ROCKLAND [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1866 LocID: ROCKLAND Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1866 Igate: njhud LocID: 1866 Region: ROCKLAND 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 = 1866 AND i.igate IN ('nyhud','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 = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1866 [1] => ROCKLAND [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1866 LocID: ROCKLAND Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1866 Igate: njhud LocID: 1866 Region: ROCKLAND 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 = 1866 AND i.igate IN ('nyhud','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 = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1866 [1] => ROCKLAND [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1866 LocID: ROCKLAND Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1866 Igate: njhud LocID: 1866 Region: ROCKLAND 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 = 1866 AND i.igate IN ('nyhud','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 = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Rockland
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Rockland, New York
Displaying 11 to 20 of 25 Properties (7 foreclosures)
SOHN REAL ESTATE CORP
$1,099,900
--
bd /
0
ba /
--
sqft
302-306 Piermont Avenue
Piermont
,
New York
10968
InstaHomes Realty LLC
$1,000,000
2
bd /
2
ba /
--
sqft
143 Bethune Boulevard
Spring Valley
,
New York
10977
Cohen And Cohen Consulting Realty Inc
$899,000
5
bd /
4
ba /
2,534
sqft
101 Ridge Road
Clarkstown
,
New York
10956
COHEN & COHEN CONSULTING INC
$899,000
5
bd /
3
ba /
2,534
sqft
101 Ridge Road
New City
,
New York
10956
BUY NY REALTY LLC
$896,000
4
bd /
3
ba /
3,166
sqft
28 Mayfield St Valley Cottag
Valley Cottage
,
New York
10989
Douglas Elliman Real Estate
$825,000
3
bd /
2
ba /
1,440
sqft
12 Hillside Drive
Stony Point
,
New York
10980
COHEN & COHEN CONSULTING INC
$799,000
5
bd /
3
ba /
1,930
sqft
44 Twin Elms Lane
New City
,
New York
10956
World Properties Int'l Sea to Sky Realty
$745,000
4
bd /
3
ba /
2,525
sqft
40 Millspaugh Lane
Clarkstown
,
New York
10954
WINZONE REALTY INC.
$699,000
4
bd /
3
ba /
--
sqft
65 New Clarkstown Road
Out Of Area Town
,
New York
10954
Real Broker NY LLC
$579,000
2
bd /
2
ba /
1,184
sqft
273 High Avenue
Orangetown
,
New York
10960
«
‹
1
2
3
›
»
Cities In ROCKLAND, NY
Arden
Bear Mountain
Bellvale
Blauvelt
Blooming Grove
Bullville
Congers
Fort Montgomery
Garnerville
Haverstraw
Hillburn
Howells
Johnson
Monsey
Mountainville
Nanuet
New City
New Milford
Nyack
Orangeburg
Palisades
Pearl River
Piermont
Pomona
Sloatsburg
Sparkill
Spring Valley
Sterling Forest
Stony Point
Suffern
Sugar Loaf
Tallman
Tappan
Thiells
Tomkins Cove
Unionville
Valley Cottage
West Haverstraw
West Nyack
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => rockland [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: rockland State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: rockland 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 = 1866 AND i.igate IN ('nyhud','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 = 'ushud', 0, 1) LIMIT 0, 1;
Mary Ann Mitchell
ASCII
eXp Realty
work
Main
:
(845) 551-9140
I'm interested in properties in ROCKLAND, NY
1838778
1838778
0
Contact Me
USHUD.com on the Go!