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

1195 S Minton Avenue
Big Bear City, CA 92314

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $715,000
Beds: 5
Baths: 2
Status: Active
SqFt: 1692
Agency: Berkshire Hathaway HomeServices California

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7,800 sqft
Property Type: Residential
Year Built: 1986
Notes: Charming 5-Bedroom Gambrel-Style Retreat in Scenic Upper Moonridge<br /> <br /> Nestled in the tranquil environs of Upper Moonridge, this picturesque 5-bedroom, 2-bath Gambrel-style home offers the perfect blend of rustic charm and modern comfort. As you step inside, you'll be greeted by the warm ambiance created by the brick wood-burning fireplace, complete with an efficient insert that promises cozy winter evenings.<br /> <br /> The living area boasts traditional tongue-and-groove beamed ceilings that enhance the home's character, complementing the durable and stylish laminate flooring found throughout. The open kitchen is a chef's delight, featuring ample space for culinary creations and casual dining. It's well-equipped with stainless steel appliances and offers a layout perfect for entertaining or enjoying quiet meals at home.<br /> <br /> Each of the five bedrooms is thoughtfully designed to provide a peaceful retreat for family and guests alike, ensuring comfort and privacy. The two bathrooms are well-appointed, providing convenience for both daily living and hosting visitors.<br /> <br /> Extending the living space outdoors, the home features a spectacular wrap-around deck, ideal for soaking up the natural beauty of the surroundings. The highlight of this outdoor oasis is the inviting hot tub, an ideal spot for unwinding under the stars after a day of mountain adventures.<br /> Located in the sought-after area of Upper Moonridge, this home is a stone's throw from local attractions, the lake, Village, Zoo, hiking trails, and ski resorts, making it a perfect year-round sanctuary.<br /> <br /> This home is an active and successful vacation rental and lucrative investment opportunity. <br /> <br /> Experience mountain living at its finest in this beautifully crafted home, where every detail adds to a sense of welcoming warmth and serene escape. Don't miss the opportunity to own this exceptional property.
MlsNumber: PW24081982


Listing Provided By: Berkshire Hathaway HomeServices California, original listing
Name: Berkshire Hathaway HomeServices California
Phone: (714) 998-8810
Office Name: BHHS CA Properties
Office Phone: (714) 602-2626
Agent Name: Michelle Trail
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