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, t4.cuisine_type, t5.music_type FROM est_overview AS t1, type_of_cuisine as t4, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Subs' AND t1.est_id = t5.est_id AND t5.music_type = 'CD Player ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Music: All Types Bar Top 40 CD Player Classic Rock Country Cover Music Dinning Music DJ House Jukebox Live Concerts Live Music Pop Rock Top 40
Cuisine: All Types American BBQ BBQ Chicken Pizza Breakfast Buffet Burgers Chicken Custom Menu Options Hot Dogs Italian Meat Other Pasta Pizza Salad Seafood Snacks Soup Southern Southern BBQ Specialty Sandwhich Steakhouse Steaks Subs Take out Wings
Music: Alternative CD Player Country Oldies Rock Top 40
Cuisine: American Buffet Cookies Muffins Organic Pizza Seafood Soup Steaks Subs Vegetarian
1 - 2 of 2 Results |