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;

22532 Skyview Lane
Crestline, CA 92325

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $825,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3541
Agency: Coldwell Banker Sky Ridge Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 33,089 sqft
Property Type: Residential
Year Built: 2007
Notes: Custom built home in Crestline's best kept secret neighborhood! Situated on nearly three quarters of an acre that backs up to national forest property, this home will suit even the pickiest of buyers. Walking into the home one will note an open concept living room/ kitchen/ dining area with stunning high ceilings. A gorgeous wood burning fireplace is located in the living room, perfect for gathering around during the winter months. The kitchen is appointed with granite counter tops, a high-end Jenn-Air chef's stove, microwave drawer and food pantry. Located off of the kitchen is a mudroom that features an appliance pantry, coat closet and a large laundry room with a sink. A huge family room is located above the two car garage with plenty of space for the kiddos toys. Walking down the hallway off of the kitchen is two ample sized guest bedrooms with a full bath in between the two rooms. The primary suite is located on the other side of the home which features a gas stove, ensuite bathroom complete with a jacuzzi tub, dual shower, as well as walk-in closet. The fourth bedroom (currently being used as an office) is located off of the main living area. The lowest level of the home boasts a massive game room, the third and final three piece bath, and is plumbed for a wet bar. Located on either side of the game room is single car garage- one is currently being utilized for storage while the other is being utilized as a workshop. Did I forget to mention the RV garage? You cannot forgot that! In addition to the RV garage, this home has a whole house automatic transfer switch generator, ev charger, zoned heating, central vac system, bose sound system and 50 year presidential roof! One cannot help but notice the attention to detail and quality of this home, call your agent to schedule a private showing today.
MlsNumber: EV24052931


Listing Provided By: Coldwell Banker Sky Ridge Realty, original listing
Name: Coldwell Banker Sky Ridge Realty
Phone: (909) 336-2131
Office Name: COLDWELL BANKER SKY RIDGE RLTY
Office Phone: (909) 336-2131
Agent Name: JULIE BAUERSCHMIDT
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