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] => 232 [1] => SHASTA [2] => CA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 232 LocID: SHASTA Region: CA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 232 Igate: njhud LocID: 232 Region: SHASTA 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 = 232 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] => 232 [1] => SHASTA [2] => CA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 232 LocID: SHASTA Region: CA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 232 Igate: njhud LocID: 232 Region: SHASTA 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 = 232 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] => 232 [1] => SHASTA [2] => CA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 232 LocID: SHASTA Region: CA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 232 Igate: njhud LocID: 232 Region: SHASTA 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 = 232 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
|
Shasta
| Oak Run, California
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Oak Run, Shasta, California
Displaying 1 to 10 of 18 Properties (0 foreclosures)
Shasta Land Services
$4,575,000
2
bd /
2
ba /
4,400
sqft
26602 Snider Ranch Road
Oak Run
,
California
96069
Shasta Land Services
$2,495,000
--
bd /
0
ba /
--
sqft
Oak Run To Fern Road
Oak Run
,
California
96069
Shasta Realty Group
$675,000
4
bd /
4
ba /
3,232
sqft
23612 Little Ridge Road
Oak Run
,
California
96069
Shasta Sotheby's International Realty
$431,000
--
bd /
0
ba /
--
sqft
005 Beaver Road
Oak Run
,
California
96069
Josh Barker Real Estate
$225,000
3
bd /
2
ba /
1,150
sqft
14069 Zig Zag Lane
Oak Run
,
California
96069
Shasta Sotheby's International Realty
$185,000
--
bd /
0
ba /
--
sqft
Donkey Mine Road
Oak Run
,
California
96069
Real Brokerage Technologies
$175,000
2
bd /
1
ba /
1,440
sqft
13599 Oak Run Road
Oak Run
,
California
96069
Relevant Real Estate
$159,900
2
bd /
2
ba /
1,494
sqft
30366 Bridger Way
Oak Run
,
California
96069
Shasta Sotheby's International Realty
$140,000
--
bd /
0
ba /
--
sqft
12012 Oak Run Road
Oak Run
,
California
96069
Better Homes and Gardens Real Estate Reliance Partners
$125,000
3
bd /
2
ba /
1,680
sqft
27529 Oak Run To Fern Road
Oak Run
,
California
96069
«
‹
1
2
›
»
Cities In SHASTA, CA
Anderson
Bella Vista
Big Bend
Burney
Cassel
Castella
Cottonwood
Fall River Mills
French Gulch
Hat Creek
Igo
Lakehead
Millville
Montgomery Creek
Oak Run
Obrien
Old Station
Palo Cedro
Platina
Redding
Round Mountain
Shasta
Shasta Lake
Shingletown
Whiskeytown
Whitmore
oak run
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => shasta [3] => CA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: shasta State: CA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: shasta 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 = 232 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;
Randy Campbell
ASCII
eXp Realty
work
Call Today!
:
(530) 227-2862
I'm interested in properties in SHASTA, CA
1847044
1847044
0
Contact Me
USHUD.com on the Go!