I'm guessing a three bedroom place isn't an option? Unless your friend was going to give you cheap rent then just move anyway, plenty of people live with room-mates they haven't met before. If you always rely on other people to give you a push to do things then it is never going to happen.

Find a new place.

Just go without him.

You are more than halfway there - you have a car and some money. Don’t give up just because this fell through. If you can find a place you can afford on your own, do that. If not look for a roommate or rent a room with someone else. Giving up too soon won’t help you in this or any other situation in life. Learn to adapt, make new plans, and follow through. It’s a lesson in life that will help you in many things.

Thank you all for the advice but I live in a very expensive city & moving is really hard atm so with his help it was making it easier & faster for me I’ve been trying to find places but it’s just far out of my price range.