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 ('nvhud','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 = 'nvhud', 0, 1), IF(i.igate = 'usahud', 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 ('nvhud','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 = 'nvhud', 0, 1), IF(i.igate = 'usahud', 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 ('nvhud','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 = 'nvhud', 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
|
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 21 Properties (0 foreclosures)
Corcoran Country Living
$875,000
3
bd /
2
ba /
3,199
sqft
880 Salisbury Turnpike
Red Hook
,
New York
12571
Mid Hudson Valley Realty Corp.
$799,900
7
bd /
4
ba /
4,500
sqft
8 Orlich Road
Red Hook
,
New York
12571
Coldwell Banker Village Green - Redhook
$65,000
--
bd /
0
ba /
--
sqft
0 Cornell Ave
Red Hook
,
New York
12572
LEGRAND REAL ESTATE RH
$599,000
3
bd /
2
ba /
4,200
sqft
7589 Old Post Road
Red Hook
,
New York
12571
BHHS HUDSON VALLEY PROP-R
$489,000
3
bd /
2
ba /
1,598
sqft
43 Colonial Drive
Red Hook
,
New York
12571
LeGrand Real Estate, Inc.
$450,000
--
bd /
0
ba /
--
sqft
0 Norton Road
Red Hook
,
New York
12571
Win Morrison Realty-K
$399,999
2
bd /
1
ba /
1,124
sqft
10 Phillips Street
Red Hook
,
New York
12571
Coldwell Banker Village GreenR
$399,000
3
bd /
2
ba /
1,468
sqft
6 Hapeman Hill
Red Hook
,
New York
12571
Coldwell Banker Village Green - Redhook
$399,000
3
bd /
2
ba /
1,468
sqft
6 Hapeman Hill Road
Red Hook
,
New York
12571
Exp Realty
$30,000
--
bd /
0
ba /
--
sqft
Albie Road
Red Hook
,
New York
12572
«
‹
1
2
3
›
»
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 ('nvhud','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 = 'nvhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Anthony Buoncora
ASCII
Century 21 Alliance Group
work
Call Today!
:
(845) 235-2321
I'm interested in properties in DUTCHESS, NY
1840500
1840500
0
Contact Me
USHUD.com on the Go!