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] => 3334 [1] => ORANGE (SOUTH) [2] => CA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3334 LocID: ORANGE (SOUTH) Region: CA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3334 Igate: njhud LocID: 3334 Region: ORANGE (SOUTH) 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 = 3334 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3334 [1] => ORANGE (SOUTH) [2] => CA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3334 LocID: ORANGE (SOUTH) Region: CA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3334 Igate: njhud LocID: 3334 Region: ORANGE (SOUTH) 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 = 3334 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3334 [1] => ORANGE (SOUTH) [2] => CA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3334 LocID: ORANGE (SOUTH) Region: CA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3334 Igate: njhud LocID: 3334 Region: ORANGE (SOUTH) 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 = 3334 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
California (CA) Foreclosure Listings
|
Orange (South)
| Tustin, California
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Tustin, Orange (South), California
Displaying 1 to 10 of 44 Properties (0 foreclosures)
First Team Real Estate
$5,500,000
5
bd /
5
ba /
5,902
sqft
11755 Collar Avenue
Tustin
,
California
92782
First Team Real Estate
$2,600,000
4
bd /
3
ba /
3,152
sqft
2140 Chandler Drive
Tustin
,
California
92782
BHHS CA Properties
$2,523,000
5
bd /
3
ba /
3,337
sqft
12605 Prescott Avenue
Tustin
,
California
92782
eXp Realty of California Inc
$2,485,000
5
bd /
3
ba /
3,001
sqft
2573 Newman Avenue
Tustin
,
California
92782
Berkshire Hathaway HomeServices California Properties
$2,448,000
5
bd /
3
ba /
2,900
sqft
12475 Woodhall Way
Tustin
,
California
92782
Katnik Brothers R.E. Services
$2,398,000
4
bd /
3
ba /
3,337
sqft
2141 Palermo
Tustin
,
California
92782
Katnik Brothers R.E. Services
$2,395,000
6
bd /
4
ba /
3,069
sqft
11665 Allen
Tustin
,
California
92782
Katnik Brothers R.E. Services
$2,394,000
4
bd /
3
ba /
3,337
sqft
2201 Marselina
Tustin
,
California
92782
Seven Gables Real Estate
$2,200,000
5
bd /
3
ba /
2,600
sqft
2505 Lewis Drive
Tustin
,
California
92782
Katnik Brothers R.E. Services
$2,149,000
4
bd /
3
ba /
3,110
sqft
16332 Dawn Way
Tustin
,
California
92782
«
‹
1
2
3
›
»
Cities In ORANGE (SOUTH), CA
Aliso Viejo
Capistrano Beach
Corona Del Mar
Costa Mesa
Dana Point
East Irvine
El Toro
Foothill Ranch
Irvine
Ladera Ranch
Laguna Beach
Laguna Hills
Laguna Niguel
Laguna Woods
Lake Forest
Mission Viejo
Newport Beach
Newport Coast
Rancho Santa Margarita
San Clemente
San Juan Capistrano
Silverado
Trabuco Canyon
Tustin
tustin
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => orange-south [3] => CA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: orange-south State: CA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: orange-south 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 = 3334 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jill Rivera
ASCII
Coldwell Banker Realty
work
Call Today!
:
(949) 629-8467
I'm interested in properties in ORANGE (SOUTH), CA
1846494
1846494
0
Contact Me
Local Mortgage Pro
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => orange-south [3] => CA [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: orange-south State: CA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: orange-south State: CA Experttype: lender 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 = 3334 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
John Rodriguez NMLS#1228280
ASCII
iFinance Mortgage Inc.
work
Call Today!
:
(949) 456-7056
I'm interested in properties in ORANGE (SOUTH), CA
1846071
1846071
0
Contact Me
USHUD.com on the Go!