By Cynthia Trammell There is a strange moment in real estate when you realize the property you have spent hours studying is not going to