Stargate SG-1
Maybourne's Motel
Jack visits Maybourne in his motel room and they track down Colonel Simmons in episode 5x14 “48 Hours”.
Source: Stargate SG-1 Locations
Senator Kinsey's Hotel
Senator Kinsey is leaving his hotel when he is shot by someone who looks suspiciously like Jack in episode 6x14 “Smoke & Mirrors”.
Source: Stargate SG-1 Locations
Motel Hideout
Teal'c and Krista stay overnight in a hotel after he helps her flee her abusive boyfriend in episode 8x07 “Affinity”.
Jameson's Hotel
Daniel and Agent Barrett spy on the hotel where their believe Baal is staying in episode 9x07 “Ex Deus Machina”.
Vala's Hotel
An amnesiac Vala cares for Mitchell in a motel room in episode 10x08 “Memento Mori”.
Source: Stargate SG-1 Locations