Buy the house that has (mostly) everything you need in the house. It isn't perfect but with some tweaking and maybe a small extension in a few years it could be close. However, it is a road over from a less desirable area of the town.
Or
Buy a house which requires work which will take years and expense. Perhaps comprise on a bedroom and other factors you would rather have than not, but is in a better area.
It is fairly difficult to say which one would increase in value more because house prices are crazy anyway, but I suspect the nicer area would net you more, but you have to compromise more day to day and spend more on the property.
You want to stay long term too. So what do you do?