That is Beautiful! I would say that it is in very good condition. The flexible part of the stem is something that I have found broken to often. It looks fine. If the bowl is meerschaum, it looks heavily colored. Show us the inside of the bowl. It may be made of clay. As far as value, who knows...