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)
| East Hampton, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
East Hampton, Suffolk (East), New York
Displaying 21 to 30 of 89 Properties (3 foreclosures)
Brown Harris Stevens (East Hampton)
$6,800,000
3
bd /
3
ba /
2,100
sqft
19 Will Curl Highway
East Hampton
,
New York
11937
Douglas Elliman Real Estate
$6,495,000
6
bd /
8
ba /
9,000
sqft
198 Two Holes Water Road
East Hampton
,
New York
11937
Town & Country Real Estate (Bridgehampton)
$5,400,000
5
bd /
7
ba /
5,040
sqft
167 Montauk Hwy
East Hampton
,
New York
11937
The Agency Hamptons
$4,995,000
5
bd /
7
ba /
5,271
sqft
26 Three Mile Harbor Drive
East Hampton
,
New York
11937
HAMPTON COUNTRY REAL ESTATE INC
$4,900,000
7
bd /
4
ba /
--
sqft
240 Montauk Hwy & 5 Buckskill Rd
East Hampton
,
New York
11937
The Agency Hamptons
$4,490,000
4
bd /
4
ba /
--
sqft
55 Sammys Beach
East Hampton
,
New York
11937
Brown Harris Stevens (East Hampton)
$4,395,000
5
bd /
5
ba /
4,600
sqft
25 Alewive Brook Road
East Hampton
,
New York
11937
Brown Harris Stevens (Sag Harbor)
$4,395,000
5
bd /
6
ba /
5,255
sqft
5 Guernsey Lane
East Hampton
,
New York
11937
Douglas Elliman Real Estate
$3,995,000
4
bd /
4
ba /
2,400
sqft
21 Old Stone
East Hampton
,
New York
11937
Town & Country Real Estate (Bridgehampton)
$3,995,000
--
bd /
0
ba /
--
sqft
7 King Street
East Hampton
,
New York
11937
«
‹
1
2
3
4
5
›
»
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
east hampton
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!