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

19346 Olivos Drive
Tarzana, CA 91356

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,325,000
Beds: 5
Baths: 4
Status: Active
SqFt: 5025
Agency: Re/Max One

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25,864 sqft
Property Type: Residential
Year Built: 1952
Notes: Private Gated CUSTOM BUILT Estate W POOL,LIGHTED SPORTS COURT & GUEST UNIT!BEST STREET IN TARZANA!Elegant Ranch completely reimagined inside & out.HALF ACRE+ nearly flat lot!5000+ Sqft of living area.Rich wood floors throughout,designer tiles in baths w/tasteful accents,granite counters,calming color pallet graces every rm some w artisanal texture-style painted walls-luxury lighting,hardware & fixtures throughout.Skylights,built in bookshelves & cabinets.5 FIREPLACES-each one a decorator’s masterpiece w imported stone,tiles or granite.Primary Suite retreat w sitting area,fireplace,built-in shelves,A-frame & pitched combo ceilings.Oversized Walk-in closet,decorators collection bath w swank tile,hand crafted mirrors,crystal light fixture,free-standing high gloss ceramic bathtub–direct access to rear yard & semi-private patio.Gourmet Kitchen,built in eating area,light,bright,opulent tiles,granite counters,6 burner WOLF STOVE,THERMADOR FRIG & FREEZER,glass farm door,pitched ceiling–mega counter space,giant center island.Bay window accents the Den/Makers Rm,w/built in floor to ceiling bookshelves & cubbies–oversized formal dining rm looks out to backyard & warmed w stylish fireplace.Classic Office w/fireplace,wood shelves & built-in desk.Other bedrooms-one ensuite w trendy bathroom tiles,walk in closet & gorgeous farm doors & another bedroom set upstairs has multi angled ceiling,A-frame wall,room for king size bed & more.Vintage stone vessel sink graces guest bath.Family room 20 ft.VAULTED CEILINGS w EXPOSED A-FRAME HONED WOOD BEAMS,fireplace,built in bookshelves & cabinets & 8 foot built in full bar.Authentic library w rich floor to ceiling bookshelves.Mud Room & gorgeous Utility Rm.3-CAR GARAGE w direct access.Brick driveway,walkways,entry stairs,stone paths-architectural decorations throughout.Rolling grassy front lawn,pebbled rock sanctuary eating area w bubbling fountain & flowers–sit under the arbor cascading w lights & plenty of room for couches,chairs & coffee tables.Attached covered wood arbor spans nearly the entire length of the back natural stone patio–step directly into the shaded patio from the kitchen,dining room or living room.A swimmer’s pool,Built in BBQ & separate free-standing fireplace,flagstone patio deck.PICKLE BALL ANYONE-LIGHTED SPORTS COURT!281 Sqft DETACHED GUEST UNIT w/brick flooring & Moroccan inspired tile bath.3 zone AC,GENERAC BACKUP GENERATOR,Sonos,surround sound,security sys.Truly a Wow home!Award winning Wilbur Charter School.
MlsNumber: SR24085870


Listing Provided By: Re/Max One, original listing
Name: Re/Max One
Phone: (818) 674-1745
Office Name: RE/MAX One
Office Phone: (818) 346-7362
Agent Name: Billy Wynn
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.


Local Real Estate Expert

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','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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;
Real Estate Expert Photo for Carlo Panosian
Carlo Panosian
ASCIIPreferred Real Estate Expert
Call Today!: (818) 926-5751

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App