Coffee

The entire area you mentioned has hundreds of cafes, bars, and taverns where you can enjoy a real Greek coffee.

I can suggest a few ideas for the setting and ambiance, somewhat overlooked by regular tourists:

The cafe in the garden of the Numismatic Museum, a stone's throw from Syntagma Square. (There's sometimes live music)

https://www.nummus.gr/en/refreshment-room-cafe/

Since there are no signs indicating a cafe, here's where it is. Go through the entrance gate; it's just after.

https://maps.app.goo.gl/L7v2v1SZcut1z5Sj7

This entire pedestrian street on Drakou Street, in the upper part of Koukaki, has some nice cafes and delicious pastries to enjoy under the trees.

https://maps.app.goo.gl/ygQ1JshmVsUXVRP3A

Dexameni

In Kolonaki, in front of a garden, at the foot of Mount Lycabettus and right next to an open-air cinema.

https://maps.app.goo.gl/HcFGH7K63cPBJNdf9

Thank you but specifically looking for a place that cooks the coffee in hot sand .

Coffee in the hot sand is a Turkish thing, not a Greek thing.

Aware , but there is one in Omonia but don’t want to go up there. Interested to know if there are others .

Go up to Omonia. I don't see why that would be a problem. It's a cosmopolitan and multi-ethnic neighborhood, you'll have a better chance of finding some Turkish coffee.

The area you're looking for is the tourist center of Athens. Tourists who come to Athens are offered Greek cafes, not Turkish ones.

If you don't find anything else, I think you'll have to take a flight to Istanbul. :))

I am aware and have been around Omonia, but don’t want to make a special trip there just for coffee…..

Our hotek had a breakfast that included hot sand coffe. I tried it. Not good, to me. I am a coffee drinker so so have a experiential view of coffees.
I hope you like it. I was glad I did not have to search it out and pay and be so disappointed.

Which hotel ? My main question is where can it be found in the areas I specified