Title Page Background
HFQUERY 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 = 219 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 219 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 219 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

7582 Buckbrush Drive
Portola, CA 96122
Scott Ulch with California Outdoor Properties, Inc - Vacaville, original listing - (707) 455-4444

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,000
Beds: --
Baths: --
Status: Active
SqFt: 6100 Square Feet
Agency: California Outdoor Properties, Inc - Vacaville
Agency Phone: (707) 455-4444

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Commercial Sale-Other
Year Built: --
Notes: Lake Davis Resort is a family-owned business striving to provide a safe, clean, and friendly environment. It is a fantastic getaway at the lake with beautiful cabins and peaceful surroundings. Just steps to Lake Davis, which provides a variety of recreational activities such as fishing, kayaking, hiking, and, in the winter, snowshoeing and snowmobiling. One hour to the vibrant city of Reno and 90 minutes to Lake Tahoe, this little gem boasts Four cabins with full kitchens, all linens, pots, pans, utensils, and internet TV. It has 11 Motel room options, from 2-bedroom suites with kitchens to standard rooms with mini-fridges, microwaves, and coffee makers. The last four years have seen a steady clientele of renters from governmental agencies, fishermen, recreationists, hunters, bicyclists, and wedding parties. Selling as a fully operational functioning business with essential furniture and equipment included. This is a must for anyone interested in living the recreational dream while providing an income through a running business, private resort, family compound, or corporate retreat.<br /> <br /> Property Highlights:<br /> <br /> · Located at beautiful Lake Davis, California - Resort to be sold as a turnkey business<br /> <br /> · 4 cabins with full kitchens (one 2-bedroom cabin, three 1-bedroom cabins)<br /> <br /> · Motel with 9 standard rooms in addition to one 2-bedroom suite with kitchen, and one 1-bedroom suite with kitchen<br /> <br /> · Four-season mountain adventures include fishing, kayaking, standup paddle boarding, hiking, biking, snowshoeing, snowmobiling, ATV/UTV riding, motorcycle riding, golfing<br /> <br /> · 1/4 mile from Lake Davis, just outside Portola, CA. 60 miles to Lake Tahoe and 50 miles from Reno, NV<br /> <br /> · 5 buildings total 6100 +/- sq. ft including 21 beds, 44 guests using hide-a-beds<br /> <br /> · Kubota tractor with snowblower and bucket, Honda garden tractor with snowblower<br /> <br /> · Internet TV, Starlink, and fiber optic onsite<br /> <br /> · Across the street from a convenience store/bait shop/boat and kayak rental<br /> <br /> · Year-round availability. Reservations for 2025 already
MlsNumber: --
ListingId: 20241075


Listing Provided By: California Outdoor Properties, Inc - Vacaville, original listing
Office Phone: (707) 455-4444
Agent Name: Scott Ulch
Disclaimer: Copyright © 2024 LandLeader. 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