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;

22930 Dolorosa Street
Woodland Hills, CA 91367
Moe Abourched with Rodeo Realty, original listing - (310) 724-7100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,990,000
Beds: 5
Baths: Full: 6, ½: 1
Status: Active
SqFt: 6033 Square Feet
Agency: Rodeo Realty
Agency Phone: (310) 724-7100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Imagine waking up each morning to the soft glow of sunlight pouring through floor-to-ceiling glass doors that disappear into the walls, inviting the outdoors in. Step out onto your private balcony and take in the peaceful serenity of your lush surroundings. This is your new life in the heart of Walnut Acres. From the moment you enter this brand new architectural masterpiece, you’re greeted by soaring ceilings & an overwhelming sense of space and light. The contemporary design is sleek, yet every room feels warm and inviting. The fireplace crackles in the background as you relax in the spacious living room, the perfect balance of grandeur & comfort. The kitchen boasts custom cabinetry bathed in natural light. The aroma of freshly brewed espresso fills the air from your built-in machine, while gourmet meals come to life on Wolf appliances. The expansive pantry ensures ample space for your culinary adventures & entertaining essentials. Evenings are magical in your private home theater, where every film comes to life on a 100” screen and the 12-speaker Dolby Atmos surround-sound system enveloping the room in an immersive experience designed & installed by a Grammy award winning producer/audio mixer. Whether it’s a family movie night or a quiet evening alone, you’re truly at home. Stepping through 1 of the 3 glass pocket doors, you find yourself in a backyard that feels like a luxury retreat. The infinity pool sparkles in the sunlight, the gentle cascade of the waterfall offering a soothing soundtrack to your day. You lounge by the poolside or take a dip in the grand spa, letting the day’s worries melt away.<br /> Gather with friends around the outdoor fire pit, laughter filling the air as you prepare pizzas in the outdoor kitchen. The cabana is ready for guests to enjoy, complete with a full bathroom. Beyond the pool area lies a massive grassy yard, perfect for play, exercise, or simple enjoyment. At night, you retreat to your primary suite—1,200 square feet of pure luxury. Complete with your own sitting area and spa-like bath with triple-step shower. A wall of glass open to the night sky, offers an unparalleled sense of peace. Here, with private balconies and endless space, you find solace. This isn’t just a home—it’s a sanctuary where every moment feels like a celebration of life. A place for making memories, where each day feels like a paradise escape. Your dream is realized in this thoughtfully designed home, elevating everyday living to the extraordinary.
MlsNumber: --
ListingId: SR24219768


Listing Provided By: Rodeo Realty, original listing
Phone: (310) 990-9850
Office Phone: (310) 724-7100
Agent Name: Moe Abourched
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