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] => 3243 [1] => QUEENS (NORTHWEST) [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3243 LocID: QUEENS (NORTHWEST) Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3243 Igate: njhud LocID: 3243 Region: QUEENS (NORTHWEST) 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 = 3243 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] => 3243 [1] => QUEENS (NORTHWEST) [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3243 LocID: QUEENS (NORTHWEST) Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3243 Igate: njhud LocID: 3243 Region: QUEENS (NORTHWEST) 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 = 3243 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] => 3243 [1] => QUEENS (NORTHWEST) [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3243 LocID: QUEENS (NORTHWEST) Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3243 Igate: njhud LocID: 3243 Region: QUEENS (NORTHWEST) 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 = 3243 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
|
Queens (Northwest)
| Kew Gardens, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Kew Gardens, Queens (Northwest), New York
Displaying 1 to 10 of 51 Properties (1 foreclosures)
ERA Top Service Realty, Inc.
FORECLOSURE
$189,900
2
bd /
2
ba /
832
sqft
84-70 129th Street
Kew Gardens
,
New York
11415
WINZONE REALTY INC.
$3,399,000
7
bd /
9
ba /
3,446
sqft
119-12 83rd Avenue
Kew Gardens
,
New York
11415
BETTER HOMES & ESTATES REALTY, LLC
$2,399,000
9
bd /
6
ba /
--
sqft
127-22 Kew Gardens Road
Kew Gardens
,
New York
11415
Keller Williams Realty Liberty
$1,750,000
5
bd /
4
ba /
--
sqft
80-60 Grenfell Street
Kew Gardens
,
New York
11415
Keller Williams Realty Landmark
$1,600,000
5
bd /
4
ba /
2,191
sqft
119-04 Audley Street
Kew Gardens
,
New York
11415
Folan Real Estate Group
$1,499,000
8
bd /
6
ba /
--
sqft
85-45 Abingdon Road
Kew Gardens
,
New York
11415
Douglas Elliman Real Estate
$1,350,000
5
bd /
5
ba /
--
sqft
116 Audley Street
Kew Gardens
,
New York
11415
Mitra Hakimi Realty Group LLC
$1,249,000
7
bd /
4
ba /
--
sqft
120-20 84 Avenue
Kew Gardens
,
New York
11415
Mitra Hakimi Realty Group LLC
$888,000
3
bd /
3
ba /
--
sqft
85-31 124 Street
Kew Gardens
,
New York
11415
Parkside Realty of Queens, Inc.
$869,000
3
bd /
2
ba /
1,400
sqft
84-24 123rd Street
Kew Gardens
,
New York
11415
«
‹
1
2
3
›
»
Cities In QUEENS (NORTHWEST), NY
Astoria
Corona
East Elmhurst
Elmhurst
Flushing
Forest Hills
Jackson Heights
Kew Gardens
Long Island City
Maspeth
Middle Village
Rego Park
Ridgewood
Sunnyside
Woodside
kew gardens
USHUD.com on the Go!