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, t2.est_type, t3.ent_type FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Outdoor/Patio' AND t1.est_id = t3.est_id AND t3.ent_type = 'Live Music' AND substring(t1.est_name,1,1) = 'p ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
1 - 2 of 2 Results |
|
Place to Go: Bars/Nightclubs Catering Deli Delivery Ice Cream Parlor Outdoor/Patio Pizza Receptions/Weddings Reservations Accepted Restaurants Take Out WiFi Hotspots
Amenities Birthday Parties Catering Children's Menu Delivery Family Friendly Featured Hotspots Happy Hour Live Music Meetings Outdoor/Patio Receptions/wedding Reservations Accepted Take Out Wi-Fi
Place to Go: Bars/Nightclubs Boat Cruises Fun Nightclub Outdoor/Patio Restaurants Seasonal Fun Summer Destinations Transportation
Amenities Banquet Birthday Parties Brunch Catering Corporate Team Building Family Friendly Family Fun Live Music Outdoor/Patio Receptions/wedding Reservations Accepted Water Fun
1 - 2 of 2 Results |