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;

23450 Glenridge Drive
Newhall, CA 91321

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,295,000
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 3840 Square Feet
Agency: Realty World Legends of Santa Clarita Valley Inc.
Agency Phone: (661) 799-9400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: Prestigious Hidden Valley Estates Entertainers Tri Level Largest Model On Cul-De-Sac With Solar. 3,840 Sq. Ft. 6 Bedrooms, 4 Baths, 3 Car Garage w/Wide Driveway. Private Gated Front Entrance. New Paint Through Entire Home. Both Upstairs & Downstairs A/C Units. Formal Entry & Open Floor Plan w/ Spacious Sunken Living Room, Cathedral Ceilings, Lots of Windows for Natural Light, Wood Floors. Custom Window Treatments, Formal Dining for Large Family Entertaining & Celebrations. Bright Chefs Kitchen, Tons of Counter & Cupboard Space, Bay Window for Views, Large Kitchen Island w/Storage, Tiled Floors, Custom Lighting, Refrigerator is Included, Newer Double Ovens, Double Sinks, 5 Burner Gas Stovetop, Dishwasher, Breakfast Nook Has Direct Access To Huge Family Room w/Cozy Brick Fireplace, Wet Bar, Valley Views, Large Balcony. First Floor Bedroom Large Bedroom/ Office Has It's Own Bathroom w/Shower & Vanity. Downstairs Mother In Law/Office/Guest Quarters w/Private Entrance, A Living Room w/Fireplace, Wet Bar, Custom Flooring, Breakfast Nook, Large Bedroom, Bathroom w/Walk In Shower, Large Vanity, Covered Patio & Views Is Perfect For A Potential Rental. Dramatic Wooden Stairs Lead to Upstairs Double Door Entry Master Suite. Lots of Natural Light, Ceiling Fan, Walk In Closet, Room For Very Large Furniture / Gym Equipment or Retreat. Master Bathroom is Beyond Huge! Separate Soaking Tub & Glass Lined Shower, Two Separate His / Hers Vanities w/Storage & Large Mirrors. Additional Make Up Area, Large Closet, Custom Flooring. Additional Bedrooms Are Large, Lots Of Closet Space, Custom Window Treatments, Custom Flooring. Hall Bathroom Has A Tub/Shower, Private Large Vanity Area w/Storage, Custom Flooring. Upstairs Laundry Room w/Storage With Full Size Washer & Dryer Is Included. Private Professionally Landscaped & Hardscaped Back Yard with Views of City Boasts Persimmon, Lemon, Myer Lemon, Grapes, Plum, Palmetto & Orange Trees. Circular Stairs To Go From First Floor To Lower Floor From Outside. Leased Low Cost Tesla Solar Unit (Can Be Removed), Car Charger Ready, 3 Car Garage w/Lots of Storage Has Direct Access to Inside Home. Outside security cameras. Close to Winning Schools, Shopping, Restaurants. Very Low Home Owners Association Dues Offer Tennis Courts, Clubhouse, Pool, Spa, Children's Play Area, Common RV Storage, Community Park. Minutes to 5 Freeway For Quick Access to Los Angeles. No Mello Roos.
MlsNumber: --
ListingId: SR24101222


Listing Provided By: Realty World Legends of Santa Clarita Valley Inc., original listing
Phone: (661) 510-8183
Office Phone: (661) 799-9400
Agent Name: Samuel Heller
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