The ability for a property to be profitable as an investment property is entirely reliant on how much you paid for it and where it is.
For it to work, you need the magic number where inexpensive property meets high rental market. A cheap mortgage is paramount for it to work, so that all the other costs don’t pile so high that profitability is impossible.
I understand that it wasn’t your original intention for the property, so it wouldn’t have been part of your consideration. Next time, if it’s your intention, you can find the property that’s just right.