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;

15008 Larkspur St
Sylmar, CA 91342
Frank Monne with Keller Williams Larchmont, original listing - (323) 762-2600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,820,000
Beds: 8
Baths: Full: 7, ¾: 1
Status: Active
SqFt: 4049 Square Feet
Agency: Keller Williams Larchmont
Agency Phone: (323) 762-2600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1974
Notes: Stunning residence with flair, modern aesthetics and overflowing with amenities. Walking through the manicured,picturesque landscaping will be your first hint at what awaits. Walk through the double doors into the beamed, high vaulted living room ceiling, with the fireplace as the center piece- the wow factor kicks in. The kitchen area with gorgeous quartz counters, with top grade cabinets and stainless steel appliances dresses up the kitchen beautifully. The area is tiled in an exquisite Herringbone pattern. A 40 plus bottle beverage cooler/fridge for your wine collection and humidor to keep your Cohibas their freshest is just off to the side of the cozy breakfast nook.The master bedroom's bathroom, with his/hers vanity features a ceiling to floor glass shower door. The outdoor area of this home is an entertainer's dream. A heated infinity pool with a spa for relaxation makes Summer something to look forward to. A BBQ area with sink/bar to satisfy your guests appetite and thirst, along with a heated seated area with tv screen rounds it up. This property features two ADUs, each with it's own private entrance and address to provide income and functionality. The smallest, is one bedroom and one bath with new stainless steel appliances. It is vacant and has never been occupied. Projected rent is $1,800 monthly. The second ADU is a separate two story, recently built with three bedrooms and two and a half bathrooms. It is currently leased for $3,500 per month. There are two solar power systems- one is leased and the second one is paid for. Property is shown with appointment only. Buyers advised to verify/confirm all information provided to their satisfaction. Seller/broker makes not representation as to it's accuracy.Agent Remarks : County records show additional ADUs square footage as follows: 15508 1/2 has 550 square feet, while 13615 Borden Ave. has 1196 square feet.
MlsNumber: --
ListingId: 24-462065


Listing Provided By: Keller Williams Larchmont, original listing
Phone: (323) 762-2600
Office Phone: (323) 762-2600
Agent Name: Frank Monne
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