It takes place in mainly takes place in New York. However, there are scenes that features Los Angeles and a coastal resort in Mexico.
Any city, especially seaports.
Of course there is sex in sex and the city. I really enjoy it. :D
"The Catch" - Also the episode in which Charlotte and Harry get married.
No.