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 = 97 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 97 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 97 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;

2295 Westlake Drive
Kelseyville, CA 95451

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $669,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2047
Agency: RE/MAX Lake County Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 51,836 sqft
Property Type: Residential
Year Built: 1978
Notes: Discover your dream lakefront living at this stunning 3-bedroom, 2-bath Buckingham home, a true oasis on the shores of Clear Lake. Immerse yourself in the enchanting curb appeal of this meticulously maintained property, with its low-maintenance landscaping. Inside, experience the allure of a "new home" ambiance, from the custom stone fireplace in the main living room to the vaulted ceiling and lake views in the family room, complete with a custom entertainment center with surround sound system. There is a very nice, private outdoor sitting area just off the family room for you to enjoy the morning air while reading a book or having that first cup of coffee. The kitchen is very spacious with plenty of cabinets with all stainless-steel appliances and a breakfast bar. Every corner boasts spectacular lake views, from the dining room and breakfast nook to the primary bedroom with deck access. The guest bathroom has plenty of natural light that emanates from the glass block shower/tub wall! You’ll witness the most magnificent Clear Lake sunsets from the expansive back deck that steps down to the well-kept backyard. This home even offers a fully finished 2-car garage complete with cabinets and workbench, a detached golf cart garage, and a 4x4 Side by Side ATV vehicle for all your outdoor work and adventures. There is also a shared lake access road that you can drive the included 4x4 ATV down to the lower portion of the large property and the lake. Embrace the Buckingham lifestyle with marina access, a community park, and endless possibilities for lakeside enjoyment. Your lakeside dream awaits .
MlsNumber: LC23176548


Listing Provided By: RE/MAX Lake County Realty, original listing
Name: RE/MAX Lake County Realty
Phone: (707) 262-5700
Office Name: RE/MAX Gold Lake County
Office Phone: (707) 262-5700
Agent Name: Mary Lunas
Disclaimer: Copyright © 2024 Lake County 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