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;

22651 Calvert Street
Woodland Hills, CA 91367
David Leif with Rodeo Realty, original listing - (818) 999-2030

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,390,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 4548 Square Feet
Agency: Rodeo Realty
Agency Phone: (818) 999-2030

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1952
Notes: Welcome to this stunning home located in the prestigious Walnut Acres neighborhood of Woodland Hills. Spanning over 4,500 square feet on a sprawling 3/4-acre lot, this four-bedroom, four-bathroom home is an entertainer's dream. As you step inside, you are greeted by a spacious living room featuring a wood-burning stove, creating a warm and inviting atmosphere. The adjacent entertaining room features a historic, 1920’s Speak Easy Chicago custom bar, bar stools, booth, and a wood burning fireplace, perfect for family gatherings and entertaining friends. Watch your favorite movie in the custom theater room which showcases mahogany paneling, a stage and 6-person seating. The primary suite has a jacuzzi tub, a walk-in shower, and his-and-her closets. The beautifully designed kitchen features a central island, a cozy nook, and a walk-in pantry, ideal for culinary enthusiasts. Step outside to the expansive backyard, where you'll find a custom-built lodge with a wood-burning fireplace, providing a picturesque setting for gatherings. The cabana-style pool and spa add to the charm and functionality of this outdoor oasis. In addition, there is over 400 square feet of raised garden beds, 15 fruit tree orchard, plus a large chicken coop ready for chickens. The backyard also features one of the last standing, original walnut trees from the historic Diamond Walnut Company. This property also includes a junior ADU complete with a kitchen, bedroom, and laundry room, perfect for guests or additional income. Additionally, there is an eight-car garage that can be converted into another income producing ADU if desired. This property also includes fully owned solar system. Located minutes from the Westfield Topanga, the Village, the Calabasas Commons, and the L.A. Ram’s training facilities, where you will find plenty of shopping, fine dining and entertainment. Experience luxury living in a prime location with this exceptional Walnut Acres estate.<br /> www.22651calvert.com
MlsNumber: --
ListingId: SR24152409


Listing Provided By: Rodeo Realty, original listing
Phone: (818) 201-4592
Office Phone: (818) 999-2030
Agent Name: David Leif
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