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 ('wahud','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 = 'wahud', 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 ('wahud','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 = 'wahud', 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 ('wahud','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 = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Suffolk (East)
| Mastic, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Mastic, Suffolk (East), New York
Displaying 1 to 10 of 61 Properties (0 foreclosures)
LAFFEY REAL ESTATE
$950,000
--
bd /
0
ba /
--
sqft
1540 Montauk Highway
Mastic
,
New York
11950
Your Team D&G Realty Ltd
$79,990
--
bd /
0
ba /
--
sqft
Vl Stuyvesant Avenue
Mastic
,
New York
11950
Brookhampton Realty
$679,900
3
bd /
2
ba /
1,662
sqft
49 Carlin Drive
Mastic
,
New York
11950
Masciale & Assoc Inc
$649,000
5
bd /
3
ba /
2,000
sqft
205 Burney Boulevard
Mastic
,
New York
11950
Charles Rutenberg Realty Inc
$630,000
4
bd /
2
ba /
--
sqft
166 Somerset Avenue
Mastic
,
New York
11950
Exit Realty Achieve
$629,999
4
bd /
3
ba /
--
sqft
194 Shinnecock Avenue
Mastic
,
New York
11950
Brookhampton Realty
$629,900
4
bd /
3
ba /
2,016
sqft
41 Dana Avenue
Mastic
,
New York
11950
Island Advantage Realty LLC
$599,000
3
bd /
2
ba /
1,765
sqft
11 Reeves Place
Mastic
,
New York
11950
Douglas Elliman Real Estate
$595,000
3
bd /
2
ba /
--
sqft
159 Main Avenue
Mastic
,
New York
11950
WINZONE REALTY INC
$589,999
3
bd /
2
ba /
--
sqft
12 Meadowmere Avenue
Mastic
,
New York
11950
«
‹
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
mastic
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 ('wahud','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 = 'wahud', 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!