SELECT Name, DisplayAddress, Address1, Address2, Town, PostCode, AskingPrice, PriceText, Status, Bedrooms, ReceptionRooms, PropertyID, AreaName, PropertyType, County, AgentID, Media, Strapline, PropertyAdded, PropertyUpdated, PriceOnApplication, ThumbMed, Description FROM qryProperties WHERE (Available=1 OR ShowProp='Y') AND (Description Like @0 OR Town Like @0 OR DisplayAddress Like @0 OR Address2 Like @0 OR AreaName Like @0 OR PostCode Like @0) AND Sector = 'Residential Rental' AND (Status = 'For Rent' OR Status = 'Under Offer' OR Status = 'Let Agreed' OR Status = 'Let') order by PropertyAdded desc OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY
Save Search Showing 1 - 10 of 64
Showing 1 - 10 of 64