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] => 1836 [1] => DUTCHESS [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1836 LocID: DUTCHESS Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1836 Igate: njhud LocID: 1836 Region: DUTCHESS 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 = 1836 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] => 1836 [1] => DUTCHESS [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1836 LocID: DUTCHESS Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1836 Igate: njhud LocID: 1836 Region: DUTCHESS 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 = 1836 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] => 1836 [1] => DUTCHESS [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1836 LocID: DUTCHESS Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1836 Igate: njhud LocID: 1836 Region: DUTCHESS 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 = 1836 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
|
Dutchess
| Red Hook, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Red Hook, Dutchess, New York
Displaying 1 to 10 of 16 Properties (0 foreclosures)
Upstate Down
$5,750,000
6
bd /
5
ba /
7,482
sqft
285 Becker Hill Road
Red Hook
,
New York
12571
Gary DiMauro Real Estate, Inc. - Hudson
$2,475,000
4
bd /
4
ba /
2,590
sqft
667 Budds Corners
Red Hook
,
New York
12571
Keller Williams Realty Hudson Valley North
$2,199,000
6
bd /
6
ba /
5,025
sqft
163 Hapeman Hill
Red Hook
,
New York
12571
Gary DiMauro Real Estate, Inc. - Rhinebeck
$1,695,000
4
bd /
4
ba /
2,500
sqft
34 Sky-park Lane
Red Hook
,
New York
12571
Fresh Air Realty
$1,500,000
3
bd /
3
ba /
2,762
sqft
59-62 Mitchell
Red Hook
,
New York
12571
Fresh Air Realty
$1,500,000
3
bd /
3
ba /
2,762
sqft
59-62 Mitchell Lane
Red Hook
,
New York
12571
Coldwell Banker American Homes
$1,250,000
5
bd /
5
ba /
--
sqft
145 Whalesback Road
Red Hook
,
New York
12571
Patricia A. Hinkein Realty
$1,250,000
3
bd /
3
ba /
3,120
sqft
38 Cookingham Lane
Red Hook
,
New York
12571
Corcoran Country Living
$1,150,000
3
bd /
4
ba /
2,395
sqft
3986 9g
Red Hook
,
New York
12571
Prudential Serls
$1,125,000
8
bd /
2
ba /
4,875
sqft
14 Linden Farm Lane
Red Hook
,
New York
12571
«
‹
1
2
›
»
Cities In DUTCHESS, NY
Amenia
Annandale On Hudson
Bangall
Barrytown
Beacon
Billings
Castle Point
Chelsea
Clinton Corners
Dover Plains
Fishkill
Glenham
Holmes
Hopewell Junction
Hughsonville
Hyde Park
Lagrangeville
Millbrook
Millerton
Newburgh
Pawling
Pine Plains
Pleasant Valley
Poughkeepsie
Poughquag
Red Hook
Rhinebeck
Rhinecliff
Salt Point
Staatsburg
Stanfordville
Stormville
Tivoli
Vails Gate
Verbank
Wappingers Falls
Wassaic
Wingdale
red hook
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => dutchess [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: dutchess State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: dutchess 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 = 1836 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;
Arleen Sepulveda
ASCII
Keller Williams Hudson Valley North
work
Call Today!
:
(845) 401-2540
I'm interested in properties in DUTCHESS, NY
1840338
1840338
0
Contact Me
USHUD.com on the Go!