Joshua Tree Dog Friendly Rentals
For many of us, there is no relaxing on vacation while we are worried about our furry little pups back home. To many of us, these incredible creatures are our deepest form of solitude and closest friends. So, it is no surprise that many deeply desire to bring them along; after all, don’t they deserve some time away to relax and explore just as we do? Well, if you share this feeling, then we here at Hi-Desert Dwellings have your back! Our Joshua Tree dog friendly rentals are the perfect properties in which to stay with your furry friend.
SQL: SELECT TOP 1000 Rental.id AS Rental_Id, Rental.Code AS Rental_Code, Rental.AddressId AS Rental_AddressId, Rental.Title AS Rental_Title, Rental.Bedrooms AS Rental_Bedrooms, Rental.Bathrooms AS Rental_Bathrooms, Rental.Sleeps AS Rental_Sleeps, ISNULL(Rental.Priority, 0) AS Rental_Priority, Rental.UrlTitle AS Rental_UrlTitle, Rental.DateCreated AS Rental_DateCreated, Rental.DateDisplayed AS Rental_DateDisplayed 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 LEFT OUTER JOIN (SELECT TOP 1 Special.Code, Special.DiscountPer, RentalGroup.RentalId FROM Special INNER JOIN WebPage On Special.WebPageId = WebPage.id INNER JOIN RentalGroup On WebPage.id = RentalGroup.WebPageId WHERE WebPage.WebPageTypeId = 10 AND WebPage.HiddenFlag = 0 AND getDate() BETWEEN WebPage.DateStarts AND WebPage.DateEnds ORDER BY WebPage.DateStarts DESC) As Special ON Special.RentalId = Rental.id WHERE Rental.id IS NOT NULL AND Rental.CustomerId IN (1000) AND Rental.RentalTypeId IN (1) AND Rental.EnabledFlag = 1 And (EXISTS(SELECT * FROM RentalFeature WHERE RentalId = Rental.id AND FeatureId = 25 AND FeatureValue IN ('Yes'))) ORDER BY Rental_MinRateSorted,Rental_MinNightRate,Rental_MinWeekRate,Rental_Priority DESC,Rental_DateDisplayed