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 ('mnhud','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 = 'mnhud', 0, 1), IF(i.igate = 'usahud', 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 ('mnhud','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 = 'mnhud', 0, 1), IF(i.igate = 'usahud', 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 ('mnhud','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 = 'mnhud', 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
|
Suffolk (East)
| Quogue, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Quogue, Suffolk (East), New York
Displaying 1 to 10 of 73 Properties (0 foreclosures)
Douglas Elliman Real Estate
$995,000
--
bd /
0
ba /
--
sqft
59 Old Main Road
Quogue
,
New York
11959
Compass
$9,500,000
7
bd /
7
ba /
6,970
sqft
27 Bay Road
Quogue
,
New York
11959
Brown Harris Stevens (Westhampton Beach)
$8,850,000
5
bd /
4
ba /
5,118
sqft
162 Dune Road
Quogue
,
New York
11959
Douglas Elliman Real Estate
$85,000
6
bd /
8
ba /
4,300
sqft
9 Rosebud Lane
Quogue
,
New York
11959
Coldwell Banker Reliable R E
$7,900,000
--
bd /
0
ba /
--
sqft
198 Dune Road
Quogue
,
New York
11959
Douglas Elliman Real Estate
$6,999,000
5
bd /
6
ba /
5,950
sqft
14 Pen Craig Road
Quogue
,
New York
11959
Douglas Elliman Real Estate
$65,000
5
bd /
3
ba /
4,500
sqft
10 Post Lane
Quogue
,
New York
11959
Corcoran
$65,000
4
bd /
4
ba /
2,500
sqft
3 Willow Lane
Quogue
,
New York
11959
Douglas Elliman Real Estate
$65,000
5
bd /
4
ba /
4,000
sqft
8 Indian Pipe Drive
Quogue
,
New York
11959
Saunders & Associates
$6,299,000
4
bd /
3
ba /
3,100
sqft
43 Dune Road
Quogue
,
New York
11959
«
‹
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
quogue
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 ('mnhud','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 = 'mnhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Joann Gerena and Sam Fama
ASCII
Belzak and Bodkin Realty Corp
work
Call Today!
:
(631) 495-1982
work
Or
:
(631) 682-2107
I'm interested in properties in SUFFOLK (EAST), NY
1836909
1836909
0
Contact Me
USHUD.com on the Go!