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;

23916 Cresta Drive
Crestline, CA 92325

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $475,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1520
Agency: Southland Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7,668 sqft
Property Type: Residential
Year Built: 1990
Notes: Welcome to your private serene mountain home conveniently located close to everything. As you drive into your oversized 2-car garage, you walk up a short interior staircase to the living area or enter from the outside stairs to the spacious front deck. Just off the entry, the beautiful mosaic-patterned slate floor of the living room and dining room awaits you. From the window seat of the living room the morning sun lights up the room. Morning coffee on the sunny front deck starts the day off right! Ceiling fans and custom lighting highlight the wood beamed ceilings of both the living room and family room. The family room with brass light fixtures and decorator vinyl flooring faces the backyard where the birds sing and the squirrels gather in the oaks and pines. A stone fireplace warms the inviting family room. Out the french doors another large deck, perfect for barbecuing, awaits you. New stainless steel energy saving appliances for the chef in your family appoint the well organized, tiled kitchen with lots of cabinet space and pantry storage. Enjoy the bay window for plants or herbs above the sink for a nice yard view. The kitchen, family room and dining room all have views out to the partially terraced and fenced backyard. There is a convenient half bath in the family room. Up the carpeted stairs from the family room, the third level has three generous sized bedrooms that provide accommodations for you and your family and guests. The large master suite has cathedral ceilings, boasts a full bath with tub, and stairs to the back deck. Abundant windows give panoramic far off forest and mountain views. A second bedroom also has cathedral ceilings with views out the back. The office, or third bedroom, contains bamboo floors with abundant storage and shelves. All three bedrooms have mirrored closet doors, and there is a second full bath with tub for the additional two bedrooms. This home is very private and very quiet and designed for entertaining. In addition to the garage, there is a dedicated parking place for your guests on the street, and lighting on the stairs and staircases both front and back. The laundry room has HE appliances is in the garage. The large garage has a large amount of storage for your workshop or gear. Additionally, there is a fenced outdoor storage area next to the garage for more of your toys and tools. A Generac generator ensures your comfort should the power go out. New roof, new paint inside and out in 2020.
MlsNumber: CV24104497


Listing Provided By: Southland Properties, original listing
Name: Southland Properties
Phone: (626) 914-6999
Office Name: SOUTHLAND PROPERTIES
Office Phone: (626) 914-6999
Agent Name: Gregory Jackson
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