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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

23026 Mobile Street
West Hills, CA 91307

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,599,888
Beds: 5
Baths: 5
Status: Active
SqFt: 2650
Agency: MRS REALTY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7,500 sqft
Property Type: Residential
Year Built: 1957
Notes: Don’t miss this newly constructed Smart Home, with modern vibes throughout and designer’s touches. The 2200 sqft, 4 bedrooms and 3.5 bathrooms, main house has an open floor plan with plenty of natural lights, lots of storage space, recess lighting, and tile floors throughout except for laminated floors in bedrooms. The entire house has custom doors, closets and kitchen cabinets. The Kitchen includes high-end appliances, including a minibar refrigerator, a huge kitchen island with quartz countertop and a large walk-in pantry.  Spacious open family room with a custom modern built entertainment center and sliding doors for indoor outdoor entertainment. Extra Large Master Bedroom with walk-in closet, and amazing Master bathroom, with a huge shower, and sliding glass doors leading to the backyard. The Backyard features a large attached concrete patio, with gas fire pit and hanging gas heaters, a large turf area, and planters with fruit trees. The outdoor kitchen includes an extra large Bar with a pizza oven, built-in refrigerator, BBQ, gas burner, and a sink. In addition this home has security Cameras, Solar with no electrical bill, & fully enclosed gated front yard. Washer and dryer included in the sale. Attached is the 450 sq ft permitted 1 bedroom & 1 bathroom ADU, with its own separate entrance and address. The ADU has vaulted ceilings, recess lighting, and a full size kitchen with all appliances. This home is located in a Prime area within minutes away from Warner Center, 101 Freeway, The Village at Topanga, Topanga Westfield Mall, the Commons of Calabasas and El Camino Shopping Center. Must see to appreciate ! Property is also available for rent.
MlsNumber: SR23160717


Listing Provided By: MRS REALTY, original listing
Name: MRS REALTY
Phone: (818) 312-5070
Office Name: MRS. Realty
Office Phone: (818) 312-5070
Agent Name: Orly Ben-David
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