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 ('txhud','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 = 'txhud', 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 ('txhud','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 = 'txhud', 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 ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Suffolk (East)
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Suffolk (East), New York
Displaying 1 to 10 of 3192 Properties (74 foreclosures)
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$999,990
4
bd /
3
ba /
1,967
sqft
970 N Sea Rd
Southampton
,
New York
11968
Clear Coast Realty LLC
FORECLOSURE
$85,000
1
bd /
1
ba /
684
sqft
259 Newcastle
Ridge
,
New York
11961
RE/MAX Best
FORECLOSURE
$688,750
3
bd /
2
ba /
--
sqft
10 Heather Drive
Remsenburg
,
New York
11960
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$675,000
--
bd /
0
ba /
--
sqft
98 N Clinton St
Center Moriches
,
New York
11934
Island Advantage Realty LLC
FORECLOSURE
$639,900
3
bd /
2
ba /
1,754
sqft
55 Gaetano Lane
Coram
,
New York
11727
Island Advantage Realty LLC
FORECLOSURE
$632,000
4
bd /
3
ba /
2,000
sqft
18250 County Road 48
Cutchogue
,
New York
11935
RE/MAX Signature Real Estate
FORECLOSURE
$599,990
3
bd /
1
ba /
--
sqft
1975 Cox Neck Road
Mattituck
,
New York
11952
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$585,000
4
bd /
1
ba /
1,502
sqft
127 Bayview Avenue
East Patchogue
,
New York
11772
Island Advantage Realty LLC
FORECLOSURE
$584,900
3
bd /
2
ba /
924
sqft
217 Bayview Terrace
Port Jefferson
,
New York
11777
American Way Real Estate Inc
FORECLOSURE
$574,900
3
bd /
2
ba /
--
sqft
17 Chardonnay Drive
Coram
,
New York
11727
«
‹
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
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 ('txhud','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 = 'txhud', 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!