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 Sector = 'Residential Sale' AND (Status = 'For Sale' OR Status = 'Under Offer' OR Status = 'Sale Agreed' OR Status = 'Sold') order by AskingPrice asc OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY
r
Save Search Showing 21 - 21 of 21
Showing 21 - 21 of 21
//Google tag (gtag.js) //