SELECT t1.est_id, t1.icon, t1.est_name, t1.est_street, t1.est_city, t1.est_state, t1.est_zip, t1.est_phone, t1.accnt_type, t1.percentoffcard, t3.ent_type, t4.cuisine_type, t5.music_type FROM est_overview AS t1, type_of_entertain as t3, type_of_cuisine as t4, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t3.est_id AND t3.ent_type = 'Dancing ' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Buffet' AND t1.est_id = t5.est_id AND t5.music_type = 'Alternative ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
1 - 1 of 1 Result |
|
Music: All Types Alternative Bar Top 40 Classic Rock Country
Cuisine: All Types American Buffet Catering Custom Menu Italian
Amenities Arcade Games Banquet Big Screen TV Birthday Parties Catering College Football Corporate Team Building Dancing Darts Family Friendly Jukebox Ladies Night Live Music NFL Sunday Ticket Outdoor/Patio Pool Tables Pull tabs Receptions/wedding Reservations Accepted Texas Hold'em
1 - 1 of 1 Results |