1620840477

Rancho Mirage

ABOUT OUR RANCHO MIRAGE VACATION RENTALS

For decades, Rancho Mirage has been a popular travel destination for the rich and powerful including Frank Sinatra, Henry Kissinger, Albert Einstein, Fred Astaire, Bob Hope, Ginger Rogers, and Queen Elizabeth II. Nicknamed the Playground to the Presidents, several US leaders have vacationed here including Richard Nixon, Ronald Reagan, and Barack Obama. And our Rancho Mirage vacation rentals give you front row access to all this and more! Read on to learn more!

Rancho Mirage is a luxury resort destination located in the heart of the Coachella Valley. This refined desert city is all about high-end living in the sunshine. Exclusive country clubs, palatial estates, incredible luxury Rancho Mirage vacation rentals, world-class golf courses, palm trees, swimming pools, and gorgeous mountain views from almost every inch of the city. The weather here is sunny and warm some 350 days per year. Rancho Mirage is the perfect travel destination for those who want to vacation in a beautiful, elegant and cultured setting where the emphasis is on luxury resort-style living. Best of all, if you're looking for vacation rentals in Rancho Mirage CA, you're in the right place! Keep reading to see why!

LIFE AMONG THE RICH AND FAMOUS

Politicians, movie stars, sports figures and millionaires are part of the fabric of everyday life in Rancho Mirage. When you spend your vacation here, it is common to run into celebrities of all types. When you rent a vacation home in Rancho Mirage, you’ll be living among the rich and famous.

THINGS TO DO IN RANCHO MIRAGE

When you are not spending time together with your friends and family relaxing by the pool at one of our fabulous vacation rentals in Rancho Mirage, CA, you’ll be able to immerse yourself in the rich and decadent Rancho Mirage lifestyle. More than a dozen world-class golf courses, championship tennis courts, fine dining, gorgeous mountain trails for hiking, and many outdoor art exhibits, music festivals and fashion events. There is a lot to do in Rancho Mirage.

Rancho Mirage came to fame after World War II when philanthropists Walter and Leonore Annenberg, brought International Dignitaries and Presidents together at their estate known as Sunnylands. Today, Sunnylands is one of the jewels of the desert. When not being used for retreats to promote world peace, it is open for public tours. Rancho Mirage is also home to the Betty Ford Center, Eisenhower Medical Center, The Childrens Discovery Museum, the Agua Caliente Casino, and The River - a spectacular modern shopping, entertainment and dining pavilion right in the center of the city.

GOLF IN RANCHO MIRAGE

Rancho Mirage and the surrounding desert cities of the Coachella Valley are often referred to as the "golf capital of the world," with more than 130 private and public golf courses. There is a great assortment of tournament level courses, intermediate golf courses, and even wonderful golf courses for beginners. The beautiful weather, natural beauty and huge variety of courses at different skill levels add to the area's popularity as a top golf & vacation location. Acme House Company offers a variety of Rancho Mirage Vacation Home Rentals for golfers. We offer many Estates and Private Villas on the golf course.

THE PERFECT LOCATION

Located at the center of the Coachella Valley, Rancho Mirage is the perfect home base for your next visit to Southern California. Rancho Mirage is less than 2 hours from San Diego and Los Angeles, and just 20 minutes from the city of Palm Springs. It is also very close to neighboring Palm Desert and its El Paseo shopping district, often compared to Beverly Hills' Rodeo Drive. You’ll find hundreds of world-class clothing boutiques, jewelers, salons and designer show rooms on El Paseo.

Rancho Mirage is very popular as the place to stay when attending Modernism Week, The Palm Springs International Film Festival, The La Quinta Arts Festival, the many music festivals held at the nearby Indio Polo Grounds and the dozens of major philanthropic events held here throughout the year.

FOR ARCHITECTURE ENTHUSIASTS

Rancho Mirage is a sophisticated mix of California-style architecture. Elegant Spanish-style villas, stunning midcentury homes, and impressive contemporary residences that define the luxury lifestyle that has made this part of the country famous for its decadence. You’ll find exclusive gated communities of golf course homes, gorgeous palm tree-lined streets of single family residences that have been walled for privacy, and prestigious condominium complexes that emulate 5-star resorts. If you know where to look, you can even find pockets of simpler more modest homes that enjoy the same affluent surroundings and services as the palatial estates of Rancho Mirage. Acme House Company offers many vacation home rentals in Rancho Mirage at all different price levels.

RANCHO MIRAGE VACATION RENTALS

Rancho Mirage has a wonderful selection of single family homes and villas available for rent – by the weekend, week, month or season. Acme House Company is proud to offer a fine collection of affordable and upscale vacation rentals in Rancho Mirage CA.

SQL: SELECT TOP 991 Rental.id AS Rental_id, Rental.CustomerId AS Rental_CustomerId, Rental.RentalTypeId AS Rental_RentalTypeId, Rental.ContentId AS Rental_ContentId, Rental.AddressId AS Rental_AddressId, Rental.SoftwareId AS Rental_SoftwareId, Rental.StaffId AS Rental_StaffId, Rental.ManagerId AS Rental_ManagerId, Rental.Title AS Rental_Title, Rental.Teaser AS Rental_Teaser, Rental.Bedrooms AS Rental_Bedrooms, Rental.Bathrooms AS Rental_Bathrooms, Rental.Sleeps AS Rental_Sleeps, Rental.Code AS Rental_Code, Rental.SoftwareCode AS Rental_SoftwareCode, Rental.UrlTitle AS Rental_UrlTitle, Rental.Priority AS Rental_Priority, Rental.EnabledFlag AS Rental_EnabledFlag, Rental.SoftwareEnabledFlag AS Rental_SoftwareEnabledFlag, Rental.DateCreated AS Rental_DateCreated, Rental.DateUpdated AS Rental_DateUpdated, Rental.DateDisplayed AS Rental_DateDisplayed, Address.id AS Address_id, Address.AddressTypeId AS Address_AddressTypeId, Address.Address1 AS Address_Address1, Address.Address2 AS Address_Address2, Address.City AS Address_City, Address.StateId AS Address_StateId, Address.CountryId AS Address_CountryId, Address.ZipCode AS Address_ZipCode, Address.Latitude AS Address_Latitude, Address.Longitude AS Address_Longitude, Address.DateCreated AS Address_DateCreated, Address.DateUpdated AS Address_DateUpdated, AddressType.id AS AddressType_id, AddressType.AddressType AS AddressType_AddressType, Content.id AS Content_id, Content.LanguageId AS Content_LanguageId, Content.HtmlContent AS Content_HtmlContent, Content.PageTitle AS Content_PageTitle, Content.MetaDesc AS Content_MetaDesc, Content.MetaKeywords AS Content_MetaKeywords, Content.DateCreated AS Content_DateCreated, Content.DateUpdated AS Content_DateUpdated, Customer.id AS Customer_id, Customer.AccountId AS Customer_AccountId, Customer.AddressId AS Customer_AddressId, Customer.Company AS Customer_Company, Customer.LegalName AS Customer_LegalName, Customer.Email AS Customer_Email, Customer.EnabledFlag AS Customer_EnabledFlag, Customer.ApiKey AS Customer_ApiKey, Customer.DateCreated AS Customer_DateCreated, Customer.DateUpdated AS Customer_DateUpdated, Manager.id AS Manager_id, Manager.CustomerId AS Manager_CustomerId, Manager.Title AS Manager_Title, Manager.Code AS Manager_Code, Manager.FeatureValue AS Manager_FeatureValue, Manager.Status AS Manager_Status, Manager.Commission AS Manager_Commission, Manager.DateCreated AS Manager_DateCreated, Manager.DateUpdated AS Manager_DateUpdated, RentalType.id AS RentalType_id, RentalType.RentalType AS RentalType_RentalType, Software.id AS Software_id, Software.CustomerId AS Software_CustomerId, Software.SoftwareTypeId AS Software_SoftwareTypeId, Software.ApiUrl AS Software_ApiUrl, Software.Code AS Software_Code, Software.Username AS Software_Username, Software.Password AS Software_Password, Software.ClientId AS Software_ClientId, Software.ApiKey AS Software_ApiKey, Software.ApiSecret AS Software_ApiSecret, Software.ApiToken AS Software_ApiToken, Software.ApiTokenSecret AS Software_ApiTokenSecret, Software.Title AS Software_Title, Software.AutoSyncFlag AS Software_AutoSyncFlag, Software.DateCreated AS Software_DateCreated, Software.DateUpdated AS Software_DateUpdated, Staff.id AS Staff_id, Staff.CustomerId AS Staff_CustomerId, Staff.StaffTypeId AS Staff_StaffTypeId, Staff.ContactId AS Staff_ContactId, Staff.Password AS Staff_Password, Staff.PasswordHash AS Staff_PasswordHash, Staff.EnabledFlag AS Staff_EnabledFlag, Staff.AccountAdminFlag AS Staff_AccountAdminFlag, Staff.LinkedInUser AS Staff_LinkedInUser, Staff.DateCreated AS Staff_DateCreated, Staff.DateUpdated AS Staff_DateUpdated, Staff.DateDisplayed AS Staff_DateDisplayed, Contact.id AS Contact_id, Contact.Company AS Contact_Company, Contact.FirstName AS Contact_FirstName, Contact.LastName AS Contact_LastName, Contact.Title AS Contact_Title, Contact.Email AS Contact_Email, Contact.DateBirth AS Contact_DateBirth, Contact.DateAnniversary AS Contact_DateAnniversary, Contact.DateCreated AS Contact_DateCreated, Contact.DateUpdated AS Contact_DateUpdated, (SELECT CAST(AVG(CAST(Rating As Decimal(4, 1))) As Decimal(4,1)) FROM Review WHERE RentalId = Rental.id AND EnabledFlag = 1) AS Rental_Rating, (SELECT COUNT(*) FROM RentalMedia INNER JOIN Media ON RentalMedia.MediaId = Media.id WHERE RentalMedia.RentalId = Rental.id AND Media.MediaTypeId IN (1, 2)) AS Rental_ImageCount, (SELECT COUNT(*) FROM RentalMedia INNER JOIN Media ON RentalMedia.MediaId = Media.id WHERE RentalMedia.RentalId = Rental.id AND Media.MediaTypeId IN (10, 11)) AS Rental_VideoCount, (SELECT COUNT(*) FROM Review WHERE Review.RentalId = Rental.id AND EnabledFlag = 1) AS Rental_ReviewCount, MinRateNight.MinNight As Rental_MinNightRate, AvgRateNight.AvgNight As Rental_AvgNightRate, MinRateWeek.MinWeek As Rental_MinWeekRate, MinRateMonth.MinMonth As Rental_MinMonthRate, (CASE WHEN MinRateNight.MinNight IS NULL AND MinRateWeek.MinWeek IS NULL THEN 9999999 WHEN MinRateNight.MinNight IS NOT NULL THEN MinRateNight.MinNight ELSE MinRateWeek.MinWeek / 7 END) AS Rental_MinRateSorted, (SELECT TOP 1 TurnDay FROM TurnDay WHERE TurnDay.RentalId = Rental.id) As Rental_TurnDay, '' As Rental_PromoCode, 0 As Rental_DiscountPer, (SELECT TOP 1 MinNights FROM Restriction WHERE Restriction.RentalId = Rental.id) As Rental_MinNights, (SELECT TOP 1 IIF(CHARINDEX('https://imagedelivery.net', Media.MediaUrl) >= 1, Media.MediaUrl, LOWER(CAST(CAST(Media.id AS VARCHAR) + ISNULL('-' + CAST(Media.MediaUrl AS VARCHAR(200)), '') + '.' + MediaType.MediaType AS VARCHAR(200)))) FROM Media INNER JOIN MediaType ON Media.MediaTypeId = MediaType.id INNER JOIN RentalMedia ON Media.id = RentalMedia.MediaId WHERE Media.MediaTypeId BETWEEN 1 AND 9 AND RentalMedia.RentalId = Rental.id AND Media.Position = 1 ORDER BY Media.Position) AS Rental_ImageUrl_1, (SELECT TOP 1 IIF(CHARINDEX('https://imagedelivery.net', Media.MediaUrl) >= 1, Media.MediaUrl, LOWER(CAST(CAST(Media.id AS VARCHAR) + ISNULL('-' + CAST(Media.MediaUrl AS VARCHAR(200)), '') + '.' + MediaType.MediaType AS VARCHAR(200)))) FROM Media INNER JOIN MediaType ON Media.MediaTypeId = MediaType.id INNER JOIN RentalMedia ON Media.id = RentalMedia.MediaId WHERE Media.MediaTypeId BETWEEN 1 AND 9 AND RentalMedia.RentalId = Rental.id AND Media.Position = 2 ORDER BY Media.Position) AS Rental_ImageUrl_2, (SELECT TOP 1 IIF(CHARINDEX('https://imagedelivery.net', Media.MediaUrl) >= 1, Media.MediaUrl, LOWER(CAST(CAST(Media.id AS VARCHAR) + ISNULL('-' + CAST(Media.MediaUrl AS VARCHAR(200)), '') + '.' + MediaType.MediaType AS VARCHAR(200)))) FROM Media INNER JOIN MediaType ON Media.MediaTypeId = MediaType.id INNER JOIN RentalMedia ON Media.id = RentalMedia.MediaId WHERE Media.MediaTypeId BETWEEN 1 AND 9 AND RentalMedia.RentalId = Rental.id AND Media.Position = 3 ORDER BY Media.Position) AS Rental_ImageUrl_3, (SELECT TOP 1 IIF(CHARINDEX('https://imagedelivery.net', Media.MediaUrl) >= 1, Media.MediaUrl, LOWER(CAST(CAST(Media.id AS VARCHAR) + ISNULL('-' + CAST(Media.MediaUrl AS VARCHAR(200)), '') + '.' + MediaType.MediaType AS VARCHAR(200)))) FROM Media INNER JOIN MediaType ON Media.MediaTypeId = MediaType.id INNER JOIN RentalMedia ON Media.id = RentalMedia.MediaId WHERE Media.MediaTypeId BETWEEN 1 AND 9 AND RentalMedia.RentalId = Rental.id AND Media.Position = 4 ORDER BY Media.Position) AS Rental_ImageUrl_4, (SELECT TOP 1 IIF(CHARINDEX('https://imagedelivery.net', Media.MediaUrl) >= 1, Media.MediaUrl, LOWER(CAST(CAST(Media.id AS VARCHAR) + ISNULL('-' + CAST(Media.MediaUrl AS VARCHAR(200)), '') + '.' + MediaType.MediaType AS VARCHAR(200)))) FROM Media INNER JOIN MediaType ON Media.MediaTypeId = MediaType.id INNER JOIN RentalMedia ON Media.id = RentalMedia.MediaId WHERE Media.MediaTypeId BETWEEN 1 AND 9 AND RentalMedia.RentalId = Rental.id AND Media.Position = 5 ORDER BY Media.Position) AS Rental_ImageUrl_5, (SELECT TOP 1 IIF(CHARINDEX('https://imagedelivery.net', Media.MediaUrl) >= 1, Media.MediaUrl, LOWER(CAST(CAST(Media.id AS VARCHAR) + ISNULL('-' + CAST(Media.MediaUrl AS VARCHAR(200)), '') + '.' + MediaType.MediaType AS VARCHAR(200)))) FROM Media INNER JOIN MediaType ON Media.MediaTypeId = MediaType.id INNER JOIN RentalMedia ON Media.id = RentalMedia.MediaId WHERE Media.MediaTypeId BETWEEN 1 AND 9 AND RentalMedia.RentalId = Rental.id AND Media.Position = 6 ORDER BY Media.Position) AS Rental_ImageUrl_6, (SELECT TOP 1 IIF(CHARINDEX('https://imagedelivery.net', Media.MediaUrl) >= 1, Media.MediaUrl, LOWER(CAST(CAST(Media.id AS VARCHAR) + ISNULL('-' + CAST(Media.MediaUrl AS VARCHAR(200)), '') + '.' + MediaType.MediaType AS VARCHAR(200)))) FROM Media INNER JOIN MediaType ON Media.MediaTypeId = MediaType.id INNER JOIN RentalMedia ON Media.id = RentalMedia.MediaId WHERE Media.MediaTypeId BETWEEN 1 AND 9 AND RentalMedia.RentalId = Rental.id AND Media.Position = 7 ORDER BY Media.Position) AS Rental_ImageUrl_7, (SELECT TOP 1 IIF(CHARINDEX('https://imagedelivery.net', Media.MediaUrl) >= 1, Media.MediaUrl, LOWER(CAST(CAST(Media.id AS VARCHAR) + ISNULL('-' + CAST(Media.MediaUrl AS VARCHAR(200)), '') + '.' + MediaType.MediaType AS VARCHAR(200)))) FROM Media INNER JOIN MediaType ON Media.MediaTypeId = MediaType.id INNER JOIN RentalMedia ON Media.id = RentalMedia.MediaId WHERE Media.MediaTypeId BETWEEN 1 AND 9 AND RentalMedia.RentalId = Rental.id AND Media.Position = 8 ORDER BY Media.Position) AS Rental_ImageUrl_8, (SELECT TOP 1 IIF(CHARINDEX('https://imagedelivery.net', Media.MediaUrl) >= 1, Media.MediaUrl, LOWER(CAST(CAST(Media.id AS VARCHAR) + ISNULL('-' + CAST(Media.MediaUrl AS VARCHAR(200)), '') + '.' + MediaType.MediaType AS VARCHAR(200)))) FROM Media INNER JOIN MediaType ON Media.MediaTypeId = MediaType.id INNER JOIN RentalMedia ON Media.id = RentalMedia.MediaId WHERE Media.MediaTypeId BETWEEN 1 AND 9 AND RentalMedia.RentalId = Rental.id AND Media.Position = 9 ORDER BY Media.Position) AS Rental_ImageUrl_9, (SELECT TOP 1 IIF(CHARINDEX('https://imagedelivery.net', Media.MediaUrl) >= 1, Media.MediaUrl, LOWER(CAST(CAST(Media.id AS VARCHAR) + ISNULL('-' + CAST(Media.MediaUrl AS VARCHAR(200)), '') + '.' + MediaType.MediaType AS VARCHAR(200)))) FROM Media INNER JOIN MediaType ON Media.MediaTypeId = MediaType.id INNER JOIN RentalMedia ON Media.id = RentalMedia.MediaId WHERE Media.MediaTypeId BETWEEN 1 AND 9 AND RentalMedia.RentalId = Rental.id AND Media.Position = 10 ORDER BY Media.Position) AS Rental_ImageUrl_10, (SELECT TOP 1 FeatureValue FROM RentalFeature WHERE RentalId = Rental.id AND FeatureId = 761) AS Rental_Feature_0, (SELECT TOP 1 Feature FROM Feature WHERE Id = 761) AS Rental_FeatureName_0 FROM Rental INNER JOIN Address On Rental.AddressId = Address.id INNER JOIN Content On Rental.ContentId = Content.id INNER JOIN Customer On Rental.CustomerId = Customer.id INNER JOIN RentalType On Rental.RentalTypeId = RentalType.id LEFT OUTER JOIN AddressType On Address.AddressTypeId = AddressType.id LEFT OUTER JOIN Manager On Rental.ManagerId = Manager.id LEFT OUTER JOIN Software On Rental.SoftwareId = Software.id LEFT OUTER JOIN Staff On Rental.StaffId = Staff.id LEFT OUTER JOIN Contact On Staff.ContactId = Contact.id LEFT OUTER JOIN (SELECT MIN(Rate.MinRate) As MinNight, Rate.RentalId FROM Rate WHERE PastFlag = 0 AND RateTypeId = 1 GROUP BY Rate.RentalId) As MinRateNight On MinRateNight.RentalId = Rental.id LEFT OUTER JOIN (SELECT CAST(AVG(CAST(Rate.MinRate AS FLOAT)) as INT) As AvgNight, Rate.RentalId FROM Rate WHERE PastFlag = 0 AND RateTypeId = 1 GROUP BY Rate.RentalId) As AvgRateNight On AvgRateNight.RentalId = Rental.id LEFT OUTER JOIN (SELECT MIN(Rate.MinRate) As MinWeek, Rate.RentalId FROM Rate WHERE PastFlag = 0 AND RateTypeId = 2 GROUP BY Rate.RentalId) As MinRateWeek On MinRateWeek.RentalId = Rental.id LEFT OUTER JOIN (SELECT MIN(Rate.MinRate) As MinMonth, Rate.RentalId FROM Rate WHERE PastFlag = 0 AND RateTypeId = 3 GROUP BY Rate.RentalId) As MinRateMonth On MinRateMonth.RentalId = Rental.id WHERE Rental.id IS NOT NULL AND Rental.CustomerId IN (1000) AND Rental.RentalTypeId IN (1) AND Rental.SoftwareId IN (3) AND Rental.EnabledFlag = 1 AND Rental.id NOT IN (1193) AND Address.StateId IN (@StateId0) AND Address.City IN (@City0) ORDER BY Rental_Priority DESC DESC,Rental_DateDisplayed
Chat with us