> they do not accept such short term stays (23 weeks)
Yeah, one of the exceptions for length of tenancy terms is student accommodation. Normal private landlords aren't allowed to set tenancy lengths since 2017.
If you're not big on partying, then look at areas further out, city centre and west end are ludicrously priced and travel is relatively easy.