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

19442 Superior Street
Northridge, CA 91324
Salima Sidiqi with eXp Realty of California Inc, original listing - (888) 584-9427

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,820,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 2972 Square Feet
Agency: eXp Realty of California Inc
Agency Phone: (888) 584-9427

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1960
Notes: Step into this exquisite Mid-Century Modern,a single-story haven offering over 3,400 sq ft of refined living space that instantly transports you to a serene retreat.Featuring an in-law suite,this home effortlessly combines luxury with functionality,all set against a backdrop of lush landscaping & undeniable curb appeal.The primary wing of the residence hosts 3 generously sized bedrooms & 2 tastefully updated bathrooms.The in-law suite,complete with its own living area, bedroom, kitchenette,& an easy-access bathroom, offers unparalleled flexibility & privacy.As you move through the home, you'll be captivated by the abundance of natural light that fills the expansive living room.This space is a true showstopper,featuring a dramatic floor-to-ceiling stacked stone fireplace anchoring the room.The oversized 12' sliding glass doors create a seamless transition between indoor & outdoor spaces,inviting you to enjoy the resort-style backyard.The home also includes a versatile library with fireplace & separate entrance,currently transformed into a state-of-the-art theater & music room,complete with a 120" 4K projection system.This adaptable space can easily serve as an additional bedroom,a cozy sitting room,or a game room.The heart of the home is the chef’s kitchen designed for both style & functionality. It boasts sleek porcelain floors, elegant granite countertops, finely crafted cabinetry with intricate detailing & premium Viking stainless steel appliances, including a built-in top of the line refrigerator. The chef’s kitchen, with its large bay window & ample pantry, flows effortlessly into the family room & formal dining area, making it an ideal space for both intimate gatherings & grand celebrations.Outside, the backyard is nothing short of spectacular. Designed for entertaining, it features a fully equipped outdoor kitchen & bar with three grills, a cooktop, sink, ambient lighting & a sound system. The pebble-finish pool & spa, complete with a waterfall, alongside a fire pit with built-in seating, create a resort-like atmosphere perfect for entertaining. Additional highlights include elegant crown moldings, smooth ceilings, recessed lighting & a primary suite with a walk-in closet & a spa-inspired bathroom. This home has been meticulously renovated to the highest standards & offers a unique blend of luxury & comfort. Located close to dining & shopping, this property is truly one of a kind. Don't miss your chance to experience this exceptional home in person!
MlsNumber: --
ListingId: SR24178448


Listing Provided By: eXp Realty of California Inc, original listing
Phone: (310) 985-9589
Office Phone: (888) 584-9427
Agent Name: Salima Sidiqi
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