Properties for rent at Burbridge DuCann estate agents Northern Ireland 2

Burbridge DuCann Estate Agents

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 Rental' AND (Status = 'For Rent' OR Status = 'Under Offer' OR Status = 'Let Agreed' OR Status = 'Let') order by PropertyUpdated desc OFFSET 70 ROWS FETCH NEXT 10 ROWS ONLY

r

Save Search Showing 71 - 80 of 81

Showing 71 - 80 of 81

Previous
1
2
3
4
5
6
7
8
9
Next

//Google tag (gtag.js) //