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

Foreclosure: 21946 Crest Forest Drive
Cedarpines Park, CA 92322

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $398,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1728
Agency: CENTURY 21 Desert Rock

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 28,300 sqft
Property Type: Residential
Year Built: 1971
Notes: Adorable 3 Bedrooms 2 Bathrooms and bonus room currently set up as a bar, but can easily be a fourth bedroom, office, family room or game room, just bring your ideas to this very spacious home with approximately over 1700 square feet of living space, entry level on Crest Forest is second floor and features the kitchen, large living room, a large bedroom and bathroom, then you take the stairs down to the first floor, or entry level from Fir St to the first floor and you will find 2 bedrooms, the second bathroom and the bar that has a rustic design and may be a good place to entertain friends and or family or celebrate those holidays with good company, both first and second floors have balcony to contemplate the beautiful mountains, you may not be able to find a larger lot than this one, it is approximately 28,300 square feet of which much of it can be use as parking space or do anything you want, it appear that this site was compose of several lots that were converted in just one lot, the lot goes from one street to the other, From Crest Forest to Fir St with access from both directions, with parking space in the front to accommodate may be 3 cars, and so much space in the back where you can park several cars and beautify the rest of the unused space, the home also offer a large basement that can be use for storage or for anything you want. this may be a perfect home for Fulltime use or Vacation Getaway, from there, it's only about 20 minutes to Lake Arrowhead and about 30 minutes to go down the hill to the inland empire and about 45 minutes to the Ontario international airport.
MlsNumber: HD24001718


Listing Provided By: CENTURY 21 Desert Rock, original listing
Name: CENTURY 21 Desert Rock
Phone: (760) 244-8557
Office Name: CENTURY 21 Desert Rock
Office Phone: (760) 244-8557
Agent Name: Fidel Carranza
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