Would you live in a money pit located in a great location, or a house in great condition but in a location you aren't fond of?

My husband and I are facing this dilemma, and I was wondering what my fellow jellies would do in this situation.

This is keeping me up nightly. Such a difficult decision.

*note- There is very little money to make needed improvements to the money pit.