select id,pname from pages2_prods where sitename='sheffield-student-properties.co.uk' and etyp='c' and online=1 order by pname Title here..
View Professional Apartments To Rent Sheffield