When most loan officers hear no from a Realtor, they stop trying to get business from that agent. I'm here to tell you that no just means "not right now". Never give up on a potential relationship!
Here's my story - At one point in my origination career, I moved to a new area just when rates were climbing. Looking for every way I could to develop new Realtor contacts, I tried this approach. The listing agent was a high-producing Realtor and at the end of the transaction, I asked if we could meet for lunch to discuss doing more business together. He said he was grateful for the great service I had provided, but had a lender that had been with him for many years. I finished the conversation by letting him know I would love to work with him anytime in the future. I contacted him by email and phone for the next six months hoping to work with him again. One day, he called and explained that his current lender was not performing well and asked if I would like to be his preferred lender. This was the start of a highly profitable relationship.