The realtor sounds extremely negligent to not correctly inform the buyer about the true situation until after offer is made. That should be a flag. Realtors understand loss aversion and that you can get very fixated on a particular house. Better to get you to start thinking the house will be yours then break the bad news to you. People just don't buy houses often enough, and they get too emotionally attached, to make rational decisions. Listen to the author talk about how this is the place where he might raise a child. That sounds so portentous, but really wherever you live is where you might raise a child.
Owning a house can be great, but the best way to do it is to think about it like buying a used car. Realize the people you are working with are nicer, smarter used car salesmen. Check everything out with true third parties and be ready to back out.