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 = 3332 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 = 3332 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 = 3332 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;

3 Beach Dunes Court
Rancho Mirage, CA 92270
Susan Winters-McIntosh with Equity Union, original listing - (747) 217-4515

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $7,200,000
Beds: 5
Baths: Full: 5, ½: 2
Status: Active
SqFt: 8019 Square Feet
Agency: Equity Union
Agency Phone: (747) 217-4515

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Experience the Epitome of Privacy, Luxury, Activity & Relaxation! This is one of a kind privately gated estate with a 5-star resort like setting on nearly 2 acres with breathtaking panoramic views and a plethora of private amenities! Including a regulation Pickleball court, Basketball court, & shuffleboard court. Fly high on the in-ground trampoline or meet on the main lawn for a game of vintage croque. The expansive resort-style pool features a large swim deck and a spa that cascades elegantly into the water, complete with a diving board and a firepit to warm up on those cool Winter evenings. Meander beyond the pool area and invite nature into your dining experience with the lush citrus lined garden arbor dappled with twinkling sunlight and gentle shade, laced with string lights and the sound of natural waterfalls, creating an exquisite setting for outdoor dinner parties, or intimate moments. Right outside the arbor you will find the lake-like Koi Pond complete with a dock, cascading natural rock waterfalls and two streams that flow in and throughout the backyard with bridges and pathways for your own private wildlife-filled nature walk. Next, you can drive your golf ball over the pond to the 9-hole PGA designed putting green. The Private Gym/Yoga studio has corner sliding glass walls that allow the entire gym to open to the outside, complete with a treadmill, elliptical trainer, weight machine and free weights! Experience the luxury of your own 3-D Home Theater with individual comfort-controlled stage seating for 9. After the movie head over to the billiard room that opens to the outdoor entertainment patio with a full kitchen and bar including a built-in beer keg tap, scotsman icemaker, sink, refrigerator, BBQ, stovetop burners, warming drawer, dishwasher and a plethora of bar seating. Just beyond the outdoor kitchen is the outdoor living room with a designer linear fireplace, radiant ceiling heaters, electric awning, built in TV, all with panoramic lush garden and mountain views. The elegant Primary Suite is privately located at one end of the house and features stunning garden and mountain views, a soaring tongue and groove ceiling, fireplace, wet bar with wine fridge and sitting area. The en-suite master bathroom features dual sinks and vanities, 2 water closets, 2 large walk-in closets, a shower, and a large soaking tub with views of a spa-like water feature & stunning mountain views. There are 4 generous guest suites, each with their own lanai and in-suite baths. One of the guest suites is in a separate guest house complete with its own living room & kitchenette. The formal living room has a soaring tongue and groove ceiling, custom art niches, fireplace, and a party size sit-down quartz bar with scotsman ice maker and refrigerator. The formal dining room with built-in buffet, comfortably seats 10+ guests with a wall of glass that opens to a enchanting water feature and pond. The family room with fireplace and breakfast area is open to an Epicurean kitchen equipped with a professional stainless series 6 burner stove, 2 ovens, 2 dishwashers, warming drawer, beverage refrigerator, 2 sinks, a standalone refrigerator and freezer and a massive pantry perfect for creating and savoring exquisite meals. The office has 2 built-in desks and walk-in closet. The laundry room is outfitted with a built-in ironing station, drip to dry with drain, and a surplus of counters and cabinetry. 2 more rooms that were built for a wine room and a ballet studio that are both currently being used for a second refrigerator, a wine refrigerator and storage. House and guest house 2 car garages can park at least 4 cars. Massive 70-kW Solar system is paid for. The private well is owned and provides water for the yard and Koi Pond. Electric blinds, sonos music system, and central vac system throughout. The custom builder built it for himself and spared no expense. Partially furnished and some furniture is staged and available for purchase outside escrow.<br /> This Lush tropical paradise is incredible, and there is nothing at this price that can touch it! Located in one of the most exclusive enclaves in Rancho Mirage has everything you could possibly want for a Desert destination home, it's a place you'll never have to leave, unless of course, you want to head 5 miles down the road to El Paseo the "Rodeo Drive" of the Desert!
MlsNumber: --
ListingId: 219118374


Listing Provided By: Equity Union, original listing
Phone: (760) 989-0244
Office Phone: (747) 217-4515
Agent Name: Susan Winters-McIntosh
Disclaimer: Copyright © 2024 California Desert Association of REALTORS&#174;, 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 = 3332 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;
Real Estate Expert Photo for Tamara Wentworth
Tamara Wentworth
ASCIIeXp Realty
Call Today!: (949) 292-9305

Local Mortgage Pro

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 = 3332 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;
Real Estate Expert Photo for Andy Chaar, NMLS#2002494
Andy Chaar, NMLS#2002494
Call Today!: (702) 324-2224

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App