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

1943 Estes Road
Los Angeles, CA 90041

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,999,999
Beds: 4
Baths: 4
Status: Pending
SqFt: 3449
Agency: Keller Williams - Downtown LA

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1971
Notes: This exquisitely redesigned 4 bed, 4 bath home, tucked into the Eagle Rock hills, is an entertainer's paradise - providing mid century charm, space for hosting gatherings & comfort for everyday living. Enter into the welcoming foyer where the high ceilings & gorgeous white oak engineered floors begin. Continue to the kitchen where no detail has been spared from the center island, farmhouse sink, high-end appliances & walls of cabinets. Host intimate meals with loved ones or dinner parties in the dining area & attached Ipe wood deck. Step down into the living room with striking stone fireplace, vaulted ceiling & skylight. Relax on the covered patio or soak in the Canadian cedar hot tub while enjoying the scenic tiered drought-tolerant landscaping. The first level also includes a family room, guest bed, guest bath, convenient mudroom with laundry & versatile studio space with 3/4 bath that could function as a bedroom, workshop, or gym. Upstairs, the welcoming landing is the perfect layout for a home office or homework area. The primary suite, the epitome of luxury & relaxation, has incredible views & spa-like ensuite with double sinks, privacy commode, walk-in shower & soaking tub. The 2nd bedroom is full of whimsy with a unique lofted bed & secret room behind a bookshelf for your own hidden library or playroom. The long driveway & attached 2-car garage provided ample off-street parking & storage. Recent upgrades include a new roof, electrical & HVAC. This home truly has it all!
MlsNumber: P1-17272


Listing Provided By: Keller Williams - Downtown LA, original listing
Name: Keller Williams - Downtown LA
Phone: (213) 797-7000
Office Name: Keller Williams - Downtown LA
Office Phone: (213) 797-7000
Agent Name: Dave Knight
Disclaimer: Copyright © 2024 Keller Williams Realty, 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