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','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 = 3320 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 = 3320 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;

27821 Peninsula Drive
Lake Arrowhead, CA 92352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1306 Square Feet
Agency: Keller Williams - Big Bear / Lake Arrowhead
Agency Phone: (909) 866-4949

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Townhouse
Year Built: 1973
Notes: Welcome to your lakeside retreat at 27821 Peninsula #405 in the heart of Lake Arrowhead, nestled within the serene beauty of the San Bernardino National Forest. This charming 3-bedroom, 2-bathroom condo offers 1,306 square feet of comfortable living space, ideal for those seeking both tranquility and adventure. Step inside to discover an inviting atmosphere with ample natural light and a seamless flow between the living, dining, and kitchen areas. The well-appointed kitchen boasts modern appliances with a deep farm sink and a cozy dining area perfect for casual dining or entertaining guests. Unwind in the primary bedroom, complete with a private bathroom and scenic views of the surrounding forest from its private patio. Two additional bedrooms provide versatility for guests, a home office, or a cozy den. One of the highlights of this property is its exclusive access to a picturesque walking path that meanders along the tranquil shores of the lake. Imagine starting your mornings with a leisurely stroll or enjoying sunset picnics by the water's edge the possibilities are endless. Conveniently located near shops, restaurants, and recreational activities, this condo offers the perfect blend of convenience and seclusion. Whether you're an outdoor enthusiast or simply seeking a peaceful retreat, 27821 Peninsula #405 is sure to exceed your expectations. Don't miss your chance to experience lakeside living at its finest. Schedule your private showing today and make this Lake Arrowhead gem your own!
MlsNumber: --
ListingId: RW24084036


Listing Provided By: Keller Williams - Big Bear / Lake Arrowhead, original listing
Phone: (909) 744-2877
Office Phone: (909) 866-4949
Agent Name: Nikki Howard
Disclaimer: Copyright © 2024 Keller Williams Realty, 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