Title Page Background
DEBUG FN args: Array ( [0] => 184 [1] => [2] => [3] => agent ) BEFORE: Site: 184 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 184 Igate: njhud LocID: 184 Region: State: 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 = 184 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 184 [1] => [2] => [3] => lender ) BEFORE: Site: 184 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 184 Igate: njhud LocID: 184 Region: State: 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 = 184 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 184 [1] => [2] => [3] => other ) BEFORE: Site: 184 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 184 Igate: njhud LocID: 184 Region: State: Experttype: other 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 = 184 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

355 River Ranch Road
Markleeville, CA 96120
Pamela Francis with Compass, original listing - (530) 645-2777

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,150,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2566 Square Feet
Agency: Compass
Agency Phone: (530) 645-2777

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Lovely custom built home with all the bells and whistles a chef to an auto restorer or wood craftsman could imagine. When it was designed and built it was with the intention this would be their Dream Home. It was for many enjoyable years. After many years of Holidays and Family gatherings, it has become more home than one can keep up with. This home is looking for a family to continue the love & memories. Beautiful vaulted ceilings, engineered wood & tile floors, floor to ceiling river rock gas fireplace, gourmet kitchen with breakfast nook, custom hickory cabinets & 8' doors, granite slab counters throughout, river rock hearth(in the kitchen) for an electric wood stove, formal dining room with a pellet stove and a large laundry room, with a sink, many cabinets, & counter space, with a .5 bath. The large Master Ensuite has a river rock & log fireplace, vaulted ceilings, large walk in tile shower, jacuzzi tub and walk in closet. Beautiful wood clad windows throughout every room in the home with breathtaking views & natural sunlight. This single story home is surrounded by mature trees, that also line the long & private driveway, providing privacy & colors. No need to worry if your heat source happens to have an outage because you have solar to back up your in floor hydronic heat, installed by the owner, a second generation plumber. In the attached 1200 approx. s.f. garage, you can drive through and/or open it up to enjoy the views and sunshine while tinkering on cars or whatever your hobby may be. Then as a bonus there is an approx. 900 s.f. barn that accommodates MORE vehicles & toys and an additional approx. 600 s.f. open room upstairs that can be turned into a generous living space. All of these amenities sit on a breathtaking, 14 acres, in a private, gated River Ranch Estates community. Looking for an escape from the noise, traffic & crowds? You have found it! Think of the possibilities to grow if you desire!
MlsNumber: --
ListingId: 141534


Listing Provided By: Compass, original listing
Phone: 545-0590
Office Phone: (530) 645-2777
Agent Name: Pamela Francis
Disclaimer: Copyright © 2025 South Tahoe Association of REALTORS®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App