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

712 Villa Grove Avenue
Big Bear City, CA 92314

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,999
Beds: 3
Baths: 3
Status: Active
SqFt: 1810
Agency: eXp Realty of California, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7,665 sqft
Property Type: Residential
Year Built: 2003
Notes: Nestled in the desirable Moonridge area, this newer home built in 2003 offers an idyllic mountain retreat with breathtaking east-facing views of the treetops and majestic peaks! Ideal for outdoor enthusiasts and nature lovers, this property boasts a prime location just a 4-minute drive from the vibrant Moonridge Corridor, offering easy access to local attractions like Moonridge Coffee, Dank Donuts, Big Bear Alpine Zoo, and scenic hiking trails. And only 5-7 minutes to Bear Mountain and Snow Summit! Step inside to discover a thoughtfully designed open floorplan featuring wood tongue-and-groove vaulted ceilings and floor-to-ceiling glass, flooding the main entry level with natural light and inviting outdoor living onto the balcony. The spacious great room is anchored by a rock fireplace, perfect for cozy evenings by the fire. Downstairs, 3 bedrooms, including a serene primary suite, provide ample space for rest and relaxation, each offering its own fan for added comfort. The kitchen is a chef's delight with new stainless appliances, abundant cabinetry, ample counter space, a center island, windows and lighting that bathe the space in warmth and light. Outside, a large front patio adorned with string lights and a hot tub beckons for leisurely evenings under the stars, while the expansive back balcony offers multiple lounge areas to soak in the stunning mountain vistas. Schedule your showing today and start envisioning the memories waiting to be made in this enchanting retreat!
MlsNumber: EV24086080


Listing Provided By: eXp Realty of California, Inc., original listing
Name: eXp Realty of California, Inc.
Phone: (888) 584-9427
Office Name: EXP REALTY OF CALIFORNIA INC.
Office Phone: (888) 584-9427
Agent Name: JONATHAN VASQUEZ
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