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] => 217 [1] => ORANGE (NORTH) [2] => CA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 217 LocID: ORANGE (NORTH) Region: CA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 217 Igate: njhud LocID: 217 Region: ORANGE (NORTH) State: CA 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 = 217 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 217 [1] => ORANGE (NORTH) [2] => CA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 217 LocID: ORANGE (NORTH) Region: CA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 217 Igate: njhud LocID: 217 Region: ORANGE (NORTH) State: CA 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 = 217 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 217 [1] => ORANGE (NORTH) [2] => CA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 217 LocID: ORANGE (NORTH) Region: CA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 217 Igate: njhud LocID: 217 Region: ORANGE (NORTH) State: CA 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 = 217 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
California (CA) Foreclosure Listings
|
Orange (North)
| Garden Grove, California
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Garden Grove, Orange (North), California
Displaying 21 to 30 of 65 Properties (2 foreclosures)
HPT Realty
$1,200,000
3
bd /
2
ba /
1,485
sqft
9701 Maureen Drive
Garden Grove
,
California
92841
Award, Inc
$1,150,000
3
bd /
3
ba /
1,276
sqft
12652 Tunstall Street
Garden Grove
,
California
92845
SCCE, Inc
$1,150,000
4
bd /
2
ba /
1,303
sqft
13802 Barney Circle
Garden Grove
,
California
92843
First Team Real Estate
$1,100,000
4
bd /
2
ba /
1,491
sqft
12802 West Street
Garden Grove
,
California
92840
RE/MAX College Park Realty
$1,100,000
4
bd /
2
ba /
1,682
sqft
5281 Acacia Avenue
Garden Grove
,
California
92845
SCCE, Inc
$1,075,000
4
bd /
3
ba /
1,698
sqft
6812 Chapman Avenue
Garden Grove
,
California
92845
Smart Real Estate Solutions
$1,034,000
3
bd /
2
ba /
1,578
sqft
12051 Loraleen Street
Garden Grove
,
California
92841
Advance Estate Realty
$1,020,000
3
bd /
2
ba /
1,343
sqft
14356 Taft Street
Garden Grove
,
California
92843
Keller Williams OC Coastal Realty
$1,000,000
3
bd /
2
ba /
1,213
sqft
12132 Onyx Circle
Garden Grove
,
California
92845
Re/Max One
$1,000,000
5
bd /
2
ba /
1,904
sqft
5522 Trinette Avenue
Garden Grove
,
California
92845
«
‹
1
2
3
4
5
›
»
Cities In ORANGE (NORTH), CA
Anaheim
Atwood
Brea
Buena Park
Cypress
Fullerton
Garden Grove
La Habra
La Palma
Los Alamitos
Orange
Placentia
Stanton
Villa Park
Westminster
Yorba Linda
garden grove
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => orange-north [3] => CA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: orange-north State: CA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: orange-north State: CA 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 = 217 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Katherine Bryant-Beach
ASCII
Century 21 Moore Real Estate
work
Call Today!
:
(720) 839-3931
I'm interested in properties in ORANGE (NORTH), CA
1840908
1840908
0
Contact Me
USHUD.com on the Go!