Title Page Background
DEBUG FN args: Array ( [0] => 3332 [1] => [2] => [3] => agent ) BEFORE: Site: 3332 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3332 Igate: njhud LocID: 3332 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3332 [1] => [2] => [3] => lender ) BEFORE: Site: 3332 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3332 Igate: njhud LocID: 3332 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3332 [1] => [2] => [3] => other ) BEFORE: Site: 3332 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3332 Igate: njhud LocID: 3332 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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,150,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. To see more remarks click MORE or click on link https://my.flexmls.com/SusanWinters/search/listings/20241016153823773537000000?launched=true The gym has 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 © 2025 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => riverside-east [3] => CA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: riverside-east State: CA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: riverside-east State: CA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Benjamin Leaskou and Gannon King
Benjamin Leaskou and Gannon King
ASCIIDesert Lifestyle Properties
Call Today!: (760) 799-4290

Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => riverside-east [3] => CA [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: riverside-east State: CA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: riverside-east State: CA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Glen Hughes NMLS#1470873
Glen Hughes NMLS#1470873
ASCIIHughes Realty
Call Today!: (949) 322-7483

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App