There are no beaches in the Netherlands that far away from a major city though

Are you still talking about the Netherlands? Unless it’s on one of the islands, I don’t see how a house near the beach could be in a bad location