Title Page Background
DEBUG FN args: Array ( [0] => 95 [1] => [2] => [3] => agent ) BEFORE: Site: 95 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 95 Igate: njhud LocID: 95 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 = 95 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 95 [1] => [2] => [3] => lender ) BEFORE: Site: 95 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 95 Igate: njhud LocID: 95 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 = 95 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 95 [1] => [2] => [3] => other ) BEFORE: Site: 95 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 95 Igate: njhud LocID: 95 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 = 95 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

324 Vista Royale Drive
Palm Desert, CA 92211

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $575,000
Beds: 3
Baths:
Status: Active
SqFt: 1814 Square Feet
Agency: Showcase Homes, Inc.

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Dryer
Architectural Style: New Traditional
Construction Materials: Stucco
Heating: Central Furnace
Interior Features: Vaulted Ceiling(s), Cathedral Ceiling(s), Open Floorplan, Quartz Counters, Walk In Closet, Master Suite, 2 Master Bedrooms
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3

Window Features

Exterior Features: On Golf Course, Balcony
Parking Features: Garage, Driveway
Roof: Tile
View: Golf Course, Lake, Mountain, Panorama

Neighborhood/Schools

Elementary School/District: Gerald Ford
Middle/Junior High School/District: /Desert Sands Unified
High School/District: Palm Desert/Desert Sands Unified
Subvidision Name: Desert Falls Country Club

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Condominium
Year Built: 1989
Notes: Total Renovation just begins to describe this Stunning View property in the Heart of Palm Desert, known as Desert Falls CC. As one would say, taken down to the studs! True in this pristine property! An upper level, w/Views fr/every window -which have ALL been replaced -Vaulted Ceilings! 3 full bedrms, 2 full gorgeous bathrooms & a -half bath. Travertine floors throughout - gorgeous! A kitchen Remodel w/quartz counters, high quality Brookhaven cabinets- well thought of to be totally functional as well as beautiful. Brookhaven cabinets used throughout the property. This is a 'home'- comfortably furnished -offered turnkey ready for your enjoyment! Walls are smooth- one Terrific upgrade. Bathrooms so beautifully done - especially the Primary bath- Wow!<br /> Triple fairways, on the 16th fairway with lake view. Facing the San Gorgonio - (snowcapped) mountains & Chocolate Mountains Views. No other condos looking into your living room offering much privacy. Front patio also offers a Sunny exposure for enjoying the sun - Great pool and spa directly across the street & it has open views of the golf course! Quiet, Interior location. This location has it all- off Rt 10, adjacent to the JW Marriott, across from upscale shopping ctr w/restaurants, shops. Hiking! 5 minutes to renown Eisenhower Medical Center, McCallum Théâtre, Awesome Acrisure Arena & more restaurants than you can go to! Tennis, Pickle ball galore! Championship Golf Course!
MlsNumber: --


Listing Provided By: Showcase Homes, Inc., original listing
Phone: (760) 413-9153
Office Phone: (760) 568-2233
Agent Name: Francesca Vacatello
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App