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;

104 State Highway 173
Lake Arrowhead, CA 92352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $695,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 1480 Square Feet
Agency: KELLER WILLIAMS BIG BEAR
Agency Phone: (909) 866-4949

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1962
Notes: Welcome to this charming cabin right off Highway 173, featuring a peek-a-boo lake view from both levels and a retaining wall. Nestled in the woods, this turn-key home showcases a spacious living room with beamed ceilings, a split face limestone fireplace, and new hardwood-finish floors. The large dining area and fully renovated kitchen boast modern finishes and ample storage. Enjoy your mornings and evenings on the deck with its delightful peek of the lake. The home features a level entry bedroom, with a fully upgraded bathroom. Upstairs is the primary bedroom with an additional bathroom that features an en-suite jetted tub. Natural light fills the home through numerous windows and a glass slider off the main floor. Additional amenities include a separate laundry room upstairs with a window overlooking pine trees, and a large unfinished basement with potential for extra living or storage space. Recent upgrades include the new limestone fireplace, hardwood finish-floors, light fixtures, fresh interior paint, entry steps, retaining wall, and new landscaping. New concrete driveway is currently being completed. This is your all season getaway! During the winter, enjoy the cozy fireplace and central heat, or take an adventure to our local ski resorts: Snow Valley, Big Bear, and Snow Summit. The house not only includes Lake Rights to Lake Arrowhead, but also comes with a 2006 Supra Launch 21' boat. Enjoy your summers on the lake for some fun in the sun (with a launch ramp near by) or head to The Village and dine at gourmet restaurants and explore local and designer name shops! During fall and spring, enjoy the beautiful weather while boating, fishing, having a picnic by the lake, or taking one of the many hiking trails our mountain has to offer.
MlsNumber: --
ListingId: EV24122767


Listing Provided By: KELLER WILLIAMS BIG BEAR, original listing
Phone: (719) 439-7190
Office Phone: (909) 866-4949
Agent Name: ALLYSON STAPLETON
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