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;

42012 Eagles Nest
Big Bear Lake, CA 92315

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,299,000
Beds: 5
Baths: 5
Status: Active
SqFt: 5254
Agency: Keller Williams Big Bear Lake Arrowhead

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2000
Notes: You'll love this Lakefront home in the gated Eagle Knoll Estates. Beautiful Acacia flooring in the living room and custom wood burning fireplace with wood storage area. Vaulted ceilings with massive windows to take in the view of the lake, and spectacular sunsets. This 5-bedroom home with 5 full baths has room for large families, extended family and friends. Modern kitchen with stainless steel appliances, indoor BBQ with stainless hood vent, center island bar and walk-in pantry. Main level primary suite with its own fireplace, deluxe bathroom and huge walk-in closet with built in cabinets. Upstairs you'll find the large game room with wet bar, fireplace and room for pool table and other games plus 3 bedrooms (one on suite) and 2 full baths. Downstairs is a custom 11 seat theater with sound panels and tiered leather chair seating. Huge walk-in storage basement. Oversized heated garage can accommodate 6-8 cars plus a full bath with a urinal. Deluxe private dock with canopy cover hardware. Heated driveway to melt the snow. Low HOA fees include open space, park and tennis courts. Huge walk-in storage basement. With stunning sunset views overlooking the serene lakefront, along with direct access to biking and hiking trails and just a few minutes stroll from shopping, this home personifies all the natural peace and beauty Big Bear has to offer.
MlsNumber: 219111775


Listing Provided By: Keller Williams Big Bear Lake Arrowhead, original listing
Name: Keller Williams Big Bear Lake Arrowhead
Phone: (909) 866-4949
Office Name: Keller Williams Big Bear Lake Arrowhead
Office Phone: (909) 805-4141
Agent Name: Steve Hirschler
Disclaimer: Copyright © 2024 California Desert Association of REALTORS ®, 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