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] => 3285 [1] => SUFFOLK (EAST) [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3285 LocID: SUFFOLK (EAST) Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3285 Igate: njhud LocID: 3285 Region: SUFFOLK (EAST) 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 = 3285 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] => 3285 [1] => SUFFOLK (EAST) [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3285 LocID: SUFFOLK (EAST) Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3285 Igate: njhud LocID: 3285 Region: SUFFOLK (EAST) 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 = 3285 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] => 3285 [1] => SUFFOLK (EAST) [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3285 LocID: SUFFOLK (EAST) Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3285 Igate: njhud LocID: 3285 Region: SUFFOLK (EAST) 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 = 3285 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
|
Suffolk (East)
| Hampton Bays, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Hampton Bays, Suffolk (East), New York
Displaying 1 to 10 of 76 Properties (0 foreclosures)
Douglas Elliman Real Estate
$7,999,000
5
bd /
6
ba /
6,591
sqft
11 Lighthouse Road
Hampton Bays
,
New York
11946
Douglas Elliman Real Estate
$3,000,000
4
bd /
2
ba /
2,894
sqft
41 Oak Lane
Hampton Bays
,
New York
11946
Nest Seekers International
$2,999,999
5
bd /
6
ba /
4,000
sqft
6 Wilson Avenue
Hampton Bays
,
New York
11946
Nest Seekers International
$2,995,000
5
bd /
5
ba /
6,000
sqft
11 Bay View Drive
Hampton Bays
,
New York
11946
Douglas Elliman Real Estate
$2,800,000
4
bd /
3
ba /
3,500
sqft
6 Bay View Drive
Hampton Bays
,
New York
11946
Douglas Elliman Real Estate
$2,595,000
3
bd /
4
ba /
2,550
sqft
33 Mineola Court
Hampton Bays
,
New York
11946
Compass
$2,495,000
4
bd /
4
ba /
2,805
sqft
64 Romana Drive
Hampton Bays
,
New York
11946
Douglas Elliman Real Estate
$2,399,000
3
bd /
4
ba /
3,200
sqft
28 Canoe Place Road
Hampton Bays
,
New York
11946
Douglas Elliman Real Estate
$2,240,000
5
bd /
3
ba /
4,014
sqft
8 Mill Pond Road
Hampton Bays
,
New York
11946
Corcoran
$2,200,000
3
bd /
2
ba /
1,890
sqft
4 Red Creek Road
Hampton Bays
,
New York
11946
«
‹
1
2
3
›
»
Cities In SUFFOLK (EAST), NY
Amagansett
Aquebogue
Bellport
Blue Point
Bridgehampton
Brookhaven
Calverton
Center Moriches
Coram
Cutchogue
East Hampton
East Marion
East Moriches
East Quogue
Eastport
Farmingville
Greenport
Hampton Bays
Holtsville
Jamesport
Laurel
Manorville
Mastic
Mastic Beach
Mattituck
Medford
Middle Island
Miller Place
Montauk
Moriches
Mount Sinai
New Suffolk
Orient
Patchogue
Peconic
Port Jefferson
Port Jefferson Station
Quogue
Remsenburg
Ridge
Riverhead
Rocky Point
Sag Harbor
Sagaponack
Selden
Shelter Island
Shelter Island Heights
Shirley
Shoreham
Sound Beach
South Jamesport
Southampton
Southold
Speonk
Upton
Wading River
Wainscott
Water Mill
Westhampton
Westhampton Beach
Yaphank
hampton bays
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => suffolk-east [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: suffolk-east State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: suffolk-east 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 = 3285 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;
Charlie Green
ASCII
RealtyConnectUSA
work
Call Today!
:
(631) 394-0903
I'm interested in properties in SUFFOLK (EAST), NY
1842250
1842250
0
Contact Me
USHUD.com on the Go!