In short....the location is perfect.
I would suggest that the owner should finish the renovation and deep clean the place before putting it on the market. The price is to high for what it is.