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] => 216 [1] => NEVADA (County) [2] => CA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 216 LocID: NEVADA (County) Region: CA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 216 Igate: njhud LocID: 216 Region: NEVADA (County) 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 = 216 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] => 216 [1] => NEVADA (County) [2] => CA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 216 LocID: NEVADA (County) Region: CA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 216 Igate: njhud LocID: 216 Region: NEVADA (County) 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 = 216 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] => 216 [1] => NEVADA (County) [2] => CA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 216 LocID: NEVADA (County) Region: CA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 216 Igate: njhud LocID: 216 Region: NEVADA (County) 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 = 216 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
|
Nevada (County)
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Nevada (County), California
Displaying 1 to 10 of 325 Properties (0 foreclosures)
Martis Camp Realty, Inc.
$25,000,000
7
bd /
7
ba /
10,000
sqft
10981 Olana Drive
Truckee
,
California
96161
Martis Camp Realty, Inc.
$17,995,000
7
bd /
7
ba /
10,458
sqft
9493 Clermont Court
Truckee
,
California
96161
Martis Camp Realty, Inc.
$13,795,000
6
bd /
7
ba /
7,180
sqft
8070 Villandry Drive
Truckee
,
California
96161
Martis Camp Realty, Inc.
$13,500,000
4
bd /
4
ba /
5,794
sqft
10865 Holmgrove Court
Truckee
,
California
96161
Martis Camp Realty, Inc.
$9,995,000
5
bd /
5
ba /
4,782
sqft
8600 Hildene Court
Truckee
,
California
96161
Martis Camp Realty, Inc.
$9,495,000
5
bd /
5
ba /
5,664
sqft
10957 Olana Drive
Truckee
,
California
96161
Carr Long Real Estate
$8,995,000
7
bd /
7
ba /
10,676
sqft
19505 Glades Court
Truckee
,
California
96161
Tahoe Mountain Realty
$7,795,000
4
bd /
4
ba /
4,493
sqft
10970 Olana Drive
Truckee
,
California
96161-0000
Tahoe Mountain Realty
$7,500,000
--
bd /
0
ba /
--
sqft
00000 Donner Pass Road
Truckee
,
California
96161-0000
Martis Camp Realty, Inc.
$6,995,000
5
bd /
5
ba /
5,161
sqft
7340 Lahontan Drive
Truckee
,
California
96161
«
‹
1
2
3
›
»
Cities In NEVADA (County), CA
Cedar Ridge
Chicago Park
Floriston
Grass Valley
Nevada City
Norden
North San Juan
Penn Valley
Rough And Ready
Smartsville
Soda Springs
Truckee
Washington
USHUD.com on the Go!