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;

352 Lookout Drive
Big Bear City, CA 92314

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 4
Baths: 5
Status: Active
SqFt: 3752
Agency: eXp Realty of California INC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1988
Notes: If you want views, this stunner is at the Top of the world! Magnificent 360 degree visuals of the entire Big Bear Valley on almost a full acre! Privacy from all areas of the home. This home would be an amazing vacation rental for guests to experience authentic Big Bear Charm and the 4 changing seasons! The unparalleled views provide the most amazing light inside the interior! At 3,752 sq. ft., this is one of the lowest priced per square foot w/the biggest on wow factors -Kitchen w/ separate pantry, Dining room w/ wet bar and skylights. There are 3 large suite-style bedrooms, each has it's own incredible view to all directions and an extra 4th bedroom, 4.5 bathrooms. Laundry room, Office, Workshop, Library. 5 fireplaces, 3 brick & 2 local Big Bear Valley native rock masonry reveals true craftmanship! (one with a free-standing-high-efficiency Lopi wood stove, one w/ soaring 30' chimney), real "Hob Nail" wood floors, AND...ample square footage of outdoor living with almost 2000 sq. feet of decking to enjoy gatherings with friends and family. Guests will be in awe at the replica gold mine with ore cars on tracks & certified historical museum pieces on site. No need to worry about year round access, just flip the switch on your heated driveway. Has 2-car garage & ample parking, fenced dog run, alarm/video system and comes furnished per inventory! Bragging rights...it was on Big Bear Soroptimist Home Tour!
MlsNumber: 32202971


Listing Provided By: eXp Realty of California INC., original listing
Name: eXp Realty of California INC.
Phone: (888) 584-9427
Office Name: EXP Realty
Office Phone: (888) 584-9427
Agent Name: Kim Boda
Disclaimer: Copyright © 2024 Big Bear 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