It is because есть is an affirmative state of being (=is), and doesn't inherently indicate possession. The wrong sentence you listed literally means "my friend is big house".

The preposition у is...