That will allow him to concentrate on clients with more immediate needs, but tells him that you're still in the market (with him) at some future date.
If you feel really badly, you can offer him a gift certificate to a nice local restaurant, or perhaps a gas card, or gift card for the local theatre. Meanwhile, if he was really great... recommend him to any of your friends and family that are looking for a house, or thinking of selling.
One approach I take when we cannot locate the "right" property is to locate properties that are not currently on the market. If the properties fit my clients criteria, I approach the current owner, and ask if they would like to sale.
Realty Executives- Hedges
Talk to your agent and explain your situation. Sometimes buyers decide to wait and then the property they want hits the market so stay in touch with your agent and be loyal to that agent unless you have cause not to. The agent can continue to send you property listings so you stay on top of the market.
All the best,
This happens more often than people realize, and discussing the situation with your realtor is going to be best for everyone.