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 = 197 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 = 197 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 = 197 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;

901 Sharon St
Frazier Park, CA 93225

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $475,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2299
Agency: Compass

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1984
Notes: Welcome to this charming traditional-style home in the wonderful Pinon Pines Estates. With a great layout and mountain or nature views from every window, this home offers a serene retreat from the hustle and bustle of city life. The kitchen features granite countertops, stainless steel appliances, ample cabinetry, and a sweet breakfast nook. The kitchen is open to the family room, which features a wood-burning fireplace, perfect for cozy evenings. A dining area, formal living room, and powder room complete the main level. The upper level is home to the primary bedroom with an en suite bath and walk-in closet, along with an additional guest bedroom and full guest bathroom. The lower level offers a wood-paneled bedroom, ideal for an office or guests, along with a laundry room with a side-by-side full-sized washer and dryer. The property also includes a large, 2-car direct access garage with a workbench and a storage shed in the side yard. The large 1/3 acre lot is adorned with mature trees and landscaping, providing a picturesque setting for outdoor activities. Enjoy the charming brick front porch and the rear deck for al fresco dining, as well as the convenience of ducted, central heating. While this home needs a little TLC and cosmetic repairs, it boasts a brand new roof and an outstanding location in Pinon Pines, just one house over from a large open space preserve. Whether you're seeking a peaceful escape or a nature lover's paradise, this home offers the perfect opportunity to create your own haven. Don't miss out on the chance to make this property your own and enjoy the tranquility and natural beauty it has to offer.
MlsNumber: 24-392475


Listing Provided By: Compass, original listing
Name: Compass
Office Name: Compass
Office Phone: (310) 230-5478
Agent Name: Allen Blankenship
Disclaimer: Copyright © 2024 TheMLSCLAW. 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