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] => 3380 [1] => WESTCHESTER (NORTH) [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3380 LocID: WESTCHESTER (NORTH) Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3380 Igate: njhud LocID: 3380 Region: WESTCHESTER (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 = 3380 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] => 3380 [1] => WESTCHESTER (NORTH) [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3380 LocID: WESTCHESTER (NORTH) Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3380 Igate: njhud LocID: 3380 Region: WESTCHESTER (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 = 3380 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] => 3380 [1] => WESTCHESTER (NORTH) [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3380 LocID: WESTCHESTER (NORTH) Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3380 Igate: njhud LocID: 3380 Region: WESTCHESTER (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 = 3380 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
|
Westchester (North)
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Westchester (North), New York
Displaying 1 to 10 of 23 Properties (1 foreclosures)
GLOBALIZED REALTY GROUP
FORECLOSURE
$405,000
--
bd /
0
ba /
--
sqft
112 Riverbend Dr
Peekskill
,
New York
10566
McGrath Realty Inc
$15,900,000
--
bd /
0
ba /
--
sqft
325-361 Old Post Road
Bedford
,
New York
10506
Exp Realty
$1,375,000
5
bd /
3
ba /
3,230
sqft
23 Round Hill Road
Chappaqua
,
New York
10514
Corcoran Legends Realty
$950,000
3
bd /
2
ba /
2,516
sqft
10 Wyche Way
Ossining
,
New York
10562
Exp Realty
$825,000
2
bd /
2
ba /
1,483
sqft
11 Brundage Street
Armonk
,
New York
10504
ZAZZARINO LOUIS
$679,000
3
bd /
3
ba /
2,820
sqft
37 Washington Ave
Ossining
,
New York
10562
Exp Realty
$599,900
--
bd /
3
ba /
2,800
sqft
1219 S Division Street
Peekskill
,
New York
10566
Corcoran Legends Realty
$475,000
1
bd /
2
ba /
1,378
sqft
1010 Eagle Bay Drive
Ossining
,
New York
10562
WALLACE ENRIQUE
$450,000
3
bd /
2
ba /
--
sqft
120 Haylan
Yorktown
,
New York
10598
Real Broker NY LLC
$449,000
--
bd /
0
ba /
--
sqft
11 Louis Drive
Katonah
,
New York
10536
«
‹
1
2
3
›
»
Cities In WESTCHESTER (NORTH), NY
Amawalk
Ardsley On Hudson
Armonk
Baldwin Place
Bedford
Bedford Hills
Briarcliff Manor
Buchanan
Chappaqua
Cortlandt Manor
Crompond
Cross River
Croton Falls
Croton On Hudson
Goldens Bridge
Granite Springs
Jefferson Valley
Katonah
Lincolndale
Maryknoll
Millwood
Mohegan Lake
Montrose
Mount Kisco
North Salem
Ossining
Peekskill
Pound Ridge
Purdys
Shenorock
Shrub Oak
Somers
South Salem
Verplanck
Waccabuc
Yorktown Heights
Local Mortgage Pro
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => westchester-north [3] => NY [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: westchester-north State: NY Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: westchester-north State: NY Experttype: lender 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 = 3380 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;
Lanie Conklin NMLS#106499
ASCII
Total Mortgage
work
Call Today!
:
(917) 532-4416
I'm interested in properties in WESTCHESTER (NORTH), NY
1847574
1847574
0
Contact Me
USHUD.com on the Go!