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, t7.event_type FROM est_overview AS t1, type_of_est as t2, daily_events as t7 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Reservations Accepted' AND t1.est_id = t7.est_id AND t7.dotw = 'Saturday' AND t7.event_type = 'Curb side to go ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Place to Go: Bars/Nightclubs Catering Outdoor/Patio Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out WiFi Hotspots
call ahead for order and hours of operation
Place to Go: Bars/Nightclubs Cafés Catering Hookah Lounge Outdoor/Patio Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out WiFi Hotspots
call ahead for order and hours of operation
1 - 2 of 2 Results |