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] => 3369 [1] => SAN BERNARDINO (WEST INLAND EMPIRE) [2] => CA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3369 LocID: SAN BERNARDINO (WEST INLAND EMPIRE) Region: CA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3369 Igate: njhud LocID: 3369 Region: SAN BERNARDINO (WEST INLAND EMPIRE) 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 = 3369 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3369 [1] => SAN BERNARDINO (WEST INLAND EMPIRE) [2] => CA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3369 LocID: SAN BERNARDINO (WEST INLAND EMPIRE) Region: CA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3369 Igate: njhud LocID: 3369 Region: SAN BERNARDINO (WEST INLAND EMPIRE) 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 = 3369 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3369 [1] => SAN BERNARDINO (WEST INLAND EMPIRE) [2] => CA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3369 LocID: SAN BERNARDINO (WEST INLAND EMPIRE) Region: CA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3369 Igate: njhud LocID: 3369 Region: SAN BERNARDINO (WEST INLAND EMPIRE) 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 = 3369 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
California (CA) Foreclosure Listings
|
San Bernardino (West Inland Empire)
| Montclair, California
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Montclair, San Bernardino (West Inland Empire), California
Displaying 1 to 10 of 22 Properties (0 foreclosures)
Pinnacle Real Estate Group
$999,000
8
bd /
4
ba /
3,552
sqft
10391 Pradera Avenue
Montclair
,
California
91763
EXP REALTY OF CALIFORNIA INC
$819,000
5
bd /
3
ba /
2,700
sqft
4449 Howard Street
Montclair
,
California
91763
IRN Realty
$778,000
3
bd /
2
ba /
2,266
sqft
4834 Rawhide Street
Montclair
,
California
91763
GoGo Realtors R.H Corp.
$7,500
3
bd /
2
ba /
1,796
sqft
4585 Grand Ave
Montclair
,
California
91763
MAINSTREET REALTORS
$699,000
3
bd /
2
ba /
1,322
sqft
9733 Lehigh Avenue
Montclair
,
California
91763
KELLER WILLIAMS PREMIER PROPER
$639,900
3
bd /
3
ba /
2,134
sqft
10392 Via Palma
Montclair
,
California
91763
eXp Realty of California Inc.
$635,000
3
bd /
2
ba /
1,408
sqft
10279 Mills Avenue
Montclair
,
California
91763
Exp Realty of California Inc
$630,000
3
bd /
2
ba /
1,410
sqft
9732 Camulos Avenue
Montclair
,
California
91763
C&D REAL ESTATE INC.
$630,000
3
bd /
2
ba /
1,450
sqft
9839 Camulos Avenue
Montclair
,
California
91763
Universal Elite Inc.
$598,800
--
bd /
0
ba /
1,469
sqft
4950 San Bernardino Street
Montclair
,
California
91763
«
‹
1
2
3
›
»
Cities In SAN BERNARDINO (WEST INLAND EMPIRE), CA
Chino
Chino Hills
Fontana
Guasti
Lytle Creek
Montclair
Monterey Park
Mt Baldy
Ontario
Pomona
Rancho Cucamonga
Upland
montclair
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => san-bernardino-west-inland-empire [3] => CA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: san-bernardino-west-inland-empire State: CA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: san-bernardino-west-inland-empire 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 = 3369 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Sandra Rosetti
ASCII
RE/MAX Proper
work
Call Today!
:
(909) 333-9962
I'm interested in properties in SAN BERNARDINO (WEST INLAND EMPIRE), CA
1842359
1842359
0
Contact Me
USHUD.com on the Go!