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;

825 Bishorn Drive
Lake Arrowhead, CA 92352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,470,000
Beds: 5
Baths: 6
Status: Active
SqFt: 4145
Agency: RE/MAX Lakeside

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 23,306 sqft
Property Type: Residential
Year Built: 1997
Notes: Welcome to this exquisite Charming French Country Home, where elegance and charm meet modern convenience. Situated on a lush half-acre parcel of land, this residence offers a serene retreat from the hustle and bustle of everyday life. Step inside and be captivated by the stunning spiral staircase, a focal point that sets the tone for the timeless beauty found throughout. The main level features a warm and inviting country kitchen, complete with a butler's pantry for added functionality. Each of the five bedrooms boasts its own private bath, providing unparalleled comfort and luxury for family and guests alike. Entertain with ease in the formal dining room, perfect for hosting gatherings both intimate and grand. A dedicated office space offers a quiet sanctuary for work or study, while the family room provides a cozy spot for relaxation by one of two classic fireplaces and a freestanding cast iron stove. Adding to the allure of this home are the Sorenson ceilings, hand-hued beams, and extensive custom handmade woodworking throughout, enhancing the charm and character of every room. Outdoors, the expansive deck beckons for al fresco dining and entertaining, overlooking the yard enclosed by a wrought iron-style fence. A tranquil outdoor entry waterfall pond adds to the ambiance, creating a peaceful oasis for relaxation. Car, boating, ATV and outdoor enthusiasts will appreciate the eight-car garage, complete with ample storage space and loft above, with energy-efficient solar panels installed on the garage, you can enjoy reduced energy costs while doing your part for the environment. <br /> With its perfect blend of charm, sophistication, and modern amenities, this French Country Home offers a lifestyle of luxury and comfort. Don't miss your chance to make this dream property your own. Schedule a viewing today! Contact Pat Morris, 909 844 0099, [email protected]
MlsNumber: RW24076689


Listing Provided By: RE/MAX Lakeside, original listing
Name: RE/MAX Lakeside
Phone: (909) 307-5665
Office Name: RE/MAX LAKESIDE
Office Phone: (909) 337-9999
Agent Name: PAT MORRIS
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