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;

805 Riverside Avenue
Sugarloaf, CA 92386

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,900
Beds: 2
Baths: 2
Status: Active
SqFt: 1080
Agency: eXp Realty of Greater Los Angeles, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2,500 sqft
Property Type: Residential
Year Built: 1993
Notes: Imagine living just steps from a national forest, close to renowned ski resorts like Bear Mountain and Snow Summit, with easy access to Highway 38 and free local bus rides from your street. Located in the charming community of Sugarloaf, near Big Bear High School, this custom-designed single-family home was built in 1993 and has been meticulously upgraded to enhance both its functionality and aesthetic appeal. It features new Milgard windows, an upgraded electrical panel, and exterior paint from 2021 with a fresh interior coat applied in 2023. The remodeled kitchen boasts new cabinets with soft-close and glass doors, stainless steel appliances, and advanced lighting including a remote-controlled fixture offering a spectrum of colors. The house's flooring has been updated with stylish wood-look laminate on the ground floor and soft carpeting upstairs. The fireplace has been optimized for greater warmth. The property features a large deck with a built-in fire pit and two sheds, providing ample storage and relaxation spaces. The fenced yard offers privacy and is ideal for pets and entertaining, with enough room for a spa. This home combines practical upgrades with a prime location to offer a lifestyle of comfort and convenience, free from HOA restrictions. Perfect for those who cherish both home comforts and outdoor adventures.<br /> <br /> ### Key Points to Maintain Within Character Limit:<br /> <br /> - Prime location: steps from national forest, close to Bear Mountain and Snow Summit.<br /> - Built in 1993, extensive recent upgrades.<br /> - 1,080 sqft over two levels, 2 bedrooms, 1.5 baths.<br /> - Wall gas heater, serviced fireplace.<br /> - New Milgard windows, upgraded electrical panel, fresh paint.<br /> - Remodeled kitchen: new cabinets with soft-close and glass doors, stainless steel appliances, advanced lighting.<br /> - Wood-look laminate flooring downstairs, plush carpeting upstairs.<br /> - Large deck with built-in fire pit, two sheds, fenced yard.<br /> - Gravel driveway, no HOA.
MlsNumber: SR24087626


Listing Provided By: eXp Realty of Greater Los Angeles, Inc, original listing
Name: eXp Realty of Greater Los Angeles, Inc
Phone: (888) 652-1314
Office Name: eXp Realty of Greater Los Angeles, Inc.
Office Phone: (888) 584-9427
Agent Name: Samuel Silver
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