It’s the oldest saying in the proverbial “book of real estate”, but it’s true. Location is everything!
You will always have to sacrifice something when buying a house. If I can give you one piece of advice, it is to really prioritize the location of the home over everything else!