I’m with @JoJoSM2 and @skankingpiglet - I went for a compromise on both. I got a nice house in an acceptable area. I wasn’t prepared to live in something super tiny in my preferrred area, no was I prepared to move even further out to get a boss housemate.
I agree with the other posters We could have afforded a tiny house with a courtyard garden in an amazing area Or a lovely big house with massive garden in a nice area but not as desirable We went with the big house as we want more kids and I'm not willing to live in a tiny house! It's all about compromise and everyone has different levels they are happy with! Good luck