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

966 Willow Creek Road
Lake Arrowhead, CA 92352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $569,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1705
Agency: Real Broker

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1965
Notes: Welcome to your cozy retreat nestled in the heart of Lake Arrowhead, California! This inviting 3-bedroom with den, 2.5-bathroom condo is the epitome of comfort and convenience, offering a perfect blend of relaxation and recreation. Step inside to the main level and discover a spacious living area adorned with warm wood accents, rustic charm and a crackling fireplace, ideal for cozy evenings with loved ones! The kitchen boasts vintage timeless appliances and ample counter space, making meal preparation a breeze with the pantry nestled behind a beautiful barn door. Each of the four bedrooms provides a peaceful haven for rest and rejuvenation after a day of exploring the beauty of Lake Arrowhead. Two of the bedrooms are located on the bottom floor accompanied by a spacious full bathroom and laundry room with access to storage closet. The master suite features its own bathroom for added privacy and luxury and has an open floor plan with the added/optional den space which can be used for a sitting entertainment room/exercise room, guest or nursery. The opportunities are endless! Outside, not only 1 but 2 private areas await with a large courtyard on the bottom level and a beautiful balcony on the main level offering breathtaking views of the surrounding forest and glimpses of the shimmering snow capped mountains. Imagine sipping your morning coffee as you soak in the tranquil ambiance of this mountain paradise. Located in the charming Forest Shores Community, this condo grants you access to a sparkling swimming pool, Lake Rights to the beautiful Tavern Bay where you can sink your toes in the sandy beaches and enjoy lounging, snack bars, groomed beaches, music, UCLA Conference Center and more ensuring endless entertainment for the whole family. Low HOA! Conveniently situated near hiking trails, boutique shops, and gourmet restaurants, you'll have everything you need right at your fingertips. Don't miss your chance to make this Lake Arrowhead retreat your own slice of heaven as a Second Home or Primary Residence. Come experience the magic of mountain living with a touch of beach living in this delightful condo!
MlsNumber: NDP2402780


Listing Provided By: Real Broker, original listing
Name: Real Broker
Phone: (619) 248-6434
Office Name: Real Broker
Office Phone: (619) 248-6434
Agent Name: Gabriele Ceideburg
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. 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