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 = 'Family Fun ' AND t1.est_id = t3.est_id AND t3.ent_type = 'Reservations Accepted' AND substring(t1.est_name,1,1) = 'g ' 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: Arcades Bowling Alleys Family Fun Fun Golf Miscellaneous Other Reservations Accepted Restaurants
Amenities Arcade Games Banquet Batting Cages Birthday Parties Bowling Bumper cars Corporate Team Building Family Friendly Family Fun Indoor Sports Lazer tag Mini golf Other Reservations Accepted Team building
Place to Go: Bars/Nightclubs Boat Rental Cafés Family Fun Fast Food Hiking Trails Hotel/Resort Restaurants Seasonal Fun Summer Destinations Winter Destinations skiing
Amenities Banquet Biking Canoeing Family Friendly Family Fun Fishing Boats Fishing Guides Hiking Trails Horseback Riding Pontoons Receptions/wedding Reservations Accepted Seasonal Fun skiing Sleigh Rides Snowshoeing Water Fun
1 - 2 of 2 Results |