Earlier today I heard an interview with M.L Longworth on NPR. She has started a series of mysteries set in Aix-en-Provence ([http://www.npr.org/2014/08/15/340411514/mystery-writer-weaves-intricate-puzzles-in-sleepy-french-town][1]).
Then tonight I saw someone ask a question about good reads set in Greece. Somehow that confluence of info and question got me to Stop, You're Killing Me!, a website with lists fun books set in locations all over the world -- http://www.stopyourekillingme.com/LocationCats/index.html. This link goes to the locations index. You can click down to brief blurbs on the works. Note that they are not all in or translated into English. There are multiple indices to click into besides location.
I clicked through to some individual titles, and I'm sure you're ahead of me here, all my experimental clicks ended up at Amazon. It's another way to approach finding relevant fiction of this genre for our trips. My husband and I love reading these kinds of novels, either contemporary or historical, set in places we've been, want to go or are at the moment. This will be a great resource for us.