SELECT TOP (100) PropertyDetails.PropertyID, PropertyDetails.CostRange, Contacts.UserID, PropertyDetails.RentSale, PropertyDetails.Location, PropertyDetails.CostRange * Currencies.ShillingFactor AS Shillings, PropertyDetails.CostRange * Currencies.KShillingFactor AS KShillings, PropertyDetails.CostRange * Currencies.TShillingFactor AS TShillings, PropertyDetails.CostRange * Currencies.DollarFactor AS Dollars, @DeCurrency AS DollarsShillings, PropertyDetails.CostRange * Currencies.EuroFactor AS Euros, PropertyDetails.CostRange * Currencies.SudanPoundFactor AS SudanPounds, PropertyDetails.CostRange * Currencies.PoundFactor AS Pounds, PropertyDetails.LastVisitedDate, PropertyDetails.FeaturedHomes, PropertyDetails.Sold, PropertyDetails.New, PropertyDetails.HotDeal, PropertyDetails.OnOffer, PropertyDetails.Reduced, Districts.District, PropertyDetails.ShortLet, PropertyDetails.BackOnMarket, PropertyDetails.Foreclosure, PropertyDetails.Comming, PropertyDetails.Furnished, PropertyDetails.BedRooms, HouseCartegories.CategoryName, Agents.AgentImage, Agents.FirstName, Agents.ContactTelNumber, PropertyDetails.HouseCategory, HouseCartegories.PropertyType, PropertyDetails.NewImageURL AS ImageURL, PropertyDetails.UnderConstruction, PropertyDetails.PropertySize, PropertyDetails.Units, PropertyDetails.Description, HouseCartegories.NasReatorsCodes, PropertyDetails.Title, PropertyDetails.Bathrooms, PropertyDetails.HidePrice, Agents.WhatsAppNumber, PropertyDetails.SurroundingLocations, Regions.RegionName, PropertyDetails.CurrencyName, PropertyDetails.Taken, Contacts.BoostEndDate, PropertyDetails.AgentID, Agents.AverageRating, PropertyDetails.Beautiful, HouseCartegories.StandAlone, PropertyDetails.Verified, Agents.WhatsAppCallLink, Contacts.Company, Contacts.FirstName AS Expr1, Contacts.LastName, PropertyDetails.BNBRental, PropertyDetails.OpenHouseDateTime, PropertyDetails.HousePlan, PropertyDetails.BoostEndDate AS PropertyBoostEndDate, PropertyDetails.Investment, PropertyDetails.FixAndFlip, PropertyDetails.Underpriced, PropertyDetails.Valentine FROM Currencies INNER JOIN PropertyDetails INNER JOIN Districts ON PropertyDetails.DistrictID = Districts.DistrictID INNER JOIN Contacts ON PropertyDetails.UserID = Contacts.UserID ON Currencies.CurrencyName = PropertyDetails.CurrencyName INNER JOIN Countries ON Contacts.CountryID = Countries.ID INNER JOIN HouseCartegories ON PropertyDetails.HouseCategory = HouseCartegories.ID INNER JOIN Agents ON PropertyDetails.AgentID = Agents.AgentID INNER JOIN Regions ON Districts.Region = Regions.RegionID WHERE (PropertyDetails.Disable = 0) AND (PropertyDetails.Remove = 0) AND (Contacts.ExpiryDate >= GETDATE()) AND (Contacts.Disabled = 0) AND (Countries.ID = 228) AND (HouseCartegories.PropertyType = 'House') AND (PropertyDetails.RentSale = 'Sale Price') AND (PropertyDetails.CostRange * Currencies.ShillingFactor >= 50000000) AND (PropertyDetails.CostRange * Currencies.ShillingFactor <= 200000000) AND (PropertyDetails.Taken = 0) ORDER BY Shillings, PropertyDetails.LastVisitedDate