Haven't been out in a while, but if you're downtown,
Tabulounge/Club Rive,
Metro on Houston, or just hop around all the bars; its always hit or miss down there, but your best bet would be to try on a Saturday.
Club Antro, although they might be closed soon while under investigation by TABC; they've had 2 shootings in the last month.
The Mansion, on Callaghan/Fred. Rd.
Posh on Broadway/Sunset is nice on Fridays.
There's a few others, check out
this site for more