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

28502 Sunny Ridge Ter
Castaic, CA 91384
Neal Weichel with RE/MAX of Santa Clarita, original listing - (661) 255-2650

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,390,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2479 Square Feet
Agency: RE/MAX of Santa Clarita
Agency Phone: (661) 255-2650

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Truly spectacular new single story home with views of the valley and a small fortune in improvements already made for you! Between the lot premium and builder options the owner has almost $300,000 in desirable upgrades put in. Plus, another $100,000+ for the landscape, hardscape and window treatments so nothing to do but move in! And the choices are amazing with no expense spared! Awesome Dacor Professional Kitchen Appliance package with upgraded quartz counters and back splash. Beamed ceilings and neutral plank style tile flooring throughout. Paid solar. 3-car tandem garage with epoxy floors, storage and power walls. There is amazing light throughout the home and the tasteful window treatments are there. Check out the attached upgrade list for the 4 pages(!) of improvements. The Seller took the 4th bedroom office option (used currently as a den) and also the covered outside California room which was nicely hardscaped with a neutral flooring. This wonderful space is not included in the square footage. The front has a stunning floating walkway and the back offers an elevated conversation are with firepit, fountain and pergola that can be open or closed with BBQ cook station. The lot is definitely pool-sized with absolutely endless views of the Santa Clarita Valley. From top to bottom this home is truly one of a kind. The Williams Ranch community is new with many amenities (pool/clubhouse/paseo walking trails/amphitheater/orchards) being built as we speak. As you enter the master planned community you can’t help but be taken by all the open space, acres of vineyards and impressive floorplans including many with large view lots like 28502 Sunny Ridge. Come see for yourself and be very impressed!
MlsNumber: --
ListingId: SR24178719


Listing Provided By: RE/MAX of Santa Clarita, original listing
Phone: (661) 313-4663
Office Phone: (661) 255-2650
Agent Name: Neal Weichel
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