After running around from shop to shop for 2 months not able to pin point the problem, let alone fixing it, it only took 2 days to get from this forum a bunch of good advices that nailed it!
Based on what you guys suggested, I managed to find a pair of sympathetic ears in a Sears service supervisor. ("yeah, yeah, it sure sound like it's the bearing, ... I think you're right, it has to be the bearing...") ;-)
The noise is now gone. The car drive smoothly on the road. Total cost for putting in a new bearing (labor & part): $106. And to borrow from the Visa ad: "... to have found a place for sound advice, priceless!"
Thank you very much!