Log Cabin Rentals in Pigeon Forge

SQL: SELECT TOP 997 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 = 1092 AND FeatureValue IN ('yes'))) And (EXISTS(SELECT * FROM RentalFeature WHERE RentalId = Rental.id AND FeatureId = 91 AND FeatureValue IN ('Cabin'))) ORDER BY Rental_Bedrooms,Rental_Priority DESC,NEWID(),Rental_DateDisplayed