query
RESULTSET
query
  ADDRESS BOOK_NOW_URL CITY DISPLAY END_DATE LATITUDE LONGITUDE NAME PHONE_1 PRIMARY_CATEGORY START_DATE TEASER
1 09223 Mt. McSauba Rd. [empty string] Charlevoix candlelight_hike 2020-02-28 20:00:00.0 [empty string] [empty string] Candlelight Hike at Mt. McSauba 231-547-3253 Outdoor Recreation 2019-12-20 17:00:00.0 Enjoy a candlelight hike at Mt. McSauba
2 3001 Church Road [empty string] Petoskey Camp_Daggett_Torchlight_Snowshoe-2 2020-01-25 21:00:00.0 [empty string] [empty string] Camp Daggett Torchlight Snowshoe 231-347-9742 Outdoor Recreation 2020-01-25 17:00:00.0 Snowshoe the trails at Camp Daggett by torchlight
3 220 Clinton St [empty string] Charlevoix Winter_Folk_Concert1 2020-01-27 20:30:00.0 [empty string] [empty string] Winter Folk Concert (231) 547-2651 Arts & Culture 2020-01-27 18:30:00.0 Winter folk concert series.
4 5052 M-66 [empty string] Charlevoix Paint_and_Sip 2020-01-29 20:00:00.0 [empty string] [empty string] Paint and Sip (231) 437-6500 Arts & Culture 2020-01-29 18:00:00.0 Paint and sip at 1918 Cellars
5 212 Bridge St [empty string] Charlevoix French_Place_Cooking_Class_2 2020-01-30 21:00:00.0 [empty string] [empty string] That French Place Cooking Class 231-437-6037 Culinary Event 2020-01-30 18:00:00.0 That French Place presents Macarons
6 109 Mason St [empty string] Charlevoix Shadowfest 2020-02-01 17:00:00.0 45.3159101 -85.25871569999998 Charlevoix Shadowfest 231-547-2101 Festivals 2020-02-01 10:30:00.0 Enjoy an action packed weekend filled with kids activities, live entertainment, craft beer tent and chili cook off.
7 [empty string] [empty string] [empty string] Cabin_Fever2 2020-02-01 21:00:00.0 [empty string] [empty string] Cabin Fever [empty string] Arts & Culture 2020-02-01 19:30:00.0 Cabin Fever with The Easy Picks and The Dirk Kroll Band
8 461 E. Mitchell Street [empty string] Petoskey Cabin_Fever 2020-02-01 21:00:00.0 [empty string] [empty string] Cabin Fever at Crooked Tree 231.347.4337 Arts & Culture 2020-02-01 19:30:00.0 Cabin Fever at Crooked Tree Center for the Arts
9 109 Clinton St [empty string] Charlevoix Dabble_in_the_Arts_1 2020-02-06 20:00:00.0 [empty string] [empty string] Dabble in the Arts 231-547-3554 Arts & Culture 2020-02-06 18:00:00.0 Art classes at Charlevoix Circle of Arts
10 212 Bridge St [empty string] Charlevoix French_Place_Cooking_Class_3 2020-02-06 21:00:00.0 [empty string] [empty string] That French Place Cooking Class 231-437-6037 Culinary Event 2020-02-06 18:00:00.0 That French Place presents Pasta and Sauces
11 800 Bay Harbor Drive [empty string] Bay Harbor Voices-Without-Borders-Presents-A-Time-to-Shine 2020-02-08 21:00:00.0 [empty string] [empty string] Voices Without Borders Presents: A Time to Shine 2314392610 Arts & Culture 2020-02-08 19:00:00.0 [empty string]
12 109 Clinton St [empty string] Charlevoix Floral_Design_Class2 2020-02-13 20:00:00.0 [empty string] [empty string] Floral Design Class (231) 547-3554 Arts & Culture 2020-02-13 18:00:00.0 Floral Design Class at Charlevoix Circle of Arts
13 212 Bridge St [empty string] Charlevoix French_Place_Cooking_Class_4 2020-02-13 21:00:00.0 [empty string] [empty string] That French Place Cooking Class 231-437-6037 Culinary Event 2020-02-13 18:00:00.0 That French Place presents French Hors d'oeuvres
14 120 Water St [empty string] Boyne City Chocolate_Covered_Boyne_ 2020-02-15 17:00:00.0 [empty string] [empty string] Chocolate Covered Boyne (231) 582-9009 Culinary Event 2020-02-14 09:00:00.0 A weekend full of chocolate
15 [empty string] [empty string] [empty string] Free_Fishing_Weekend_Winter 2020-02-16 23:00:00.0 [empty string] [empty string] Free Fishing Weekend Winter [empty string] Outdoor Recreation 2020-02-15 00:00:00.0 Enjoy a weekend of free fishing.
16 [empty string] [empty string] Petoskey Petoskey_Winter_Carnival_ 2020-02-15 00:00:00.0 [empty string] [empty string] Petoskey Winter Carnival (231)348-0388 Family Event 2020-02-15 00:00:00.0 A fun wintertime tradition.
17 800 Bay Harbor Drive [empty string] Bay Harbor Choir_of_Men 2020-02-15 21:00:00.0 [empty string] [empty string] Choir of Men 231-439-2600 Arts & Culture 2020-02-15 19:30:00.0 Choir of Men
18 109 Clinton St [empty string] Charlevoix Third_Thursday_Pour_Series2 2020-02-20 19:30:00.0 [empty string] [empty string] Third Thursday Pour Series (231) 547-3554 Arts & Culture 2020-02-20 18:00:00.0 Third Thursday Pour Series
19 102 Mason [empty string] Charlevoix Dogman 2020-02-22 14:00:00.0 45.3367808 -85.24564069999997 Dogman Challenge 231-237-0900 Outdoor Recreation 2020-02-22 12:00:00.0 A challenging fat bike race to find the elusive Dogman.
20 203 Mason St. [empty string] Charlevoix live_from_charlevoix_3 2020-02-22 22:00:00.0 [empty string] [empty string] Live from Charlevoix [empty string] Entertainment 2020-02-22 20:00:00.0 Live from Charlevoix presents Jill Jack
21 219 E Lake St [empty string] Petoskey Sunday_Series_GLC_Orchestra-2 2020-02-23 17:00:00.0 [empty string] [empty string] Sunday Series Great Lakes Chamber Orchestra (231) 487-0010 Arts & Culture 2020-02-23 16:00:00.0 Sunday Series presents Violin, Horn, Piano Trio
22 220 Clinton St [empty string] Charlevoix Winter_Folk_Concert_2 2020-02-24 20:30:00.0 [empty string] [empty string] Winter Folk Concert 231-547-2651 Arts & Culture 2020-02-24 18:30:00.0 Enjoy a night of folk music!
23 109 Clinton St [empty string] Charlevoix Painting_Class_at_the_Circle2 2020-02-27 20:00:00.0 [empty string] [empty string] Painting Class at the Circle 231-547-3554 Arts & Culture 2020-02-27 18:00:00.0 Painting class at Charlevoix Circle of Arts
24 212 Bridge St [empty string] Charlevoix French_Place_Cooking_Class_5 2020-02-27 21:00:00.0 [empty string] [empty string] That French Place Cooking Class 231-437-6037 Culinary Event 2020-02-27 18:00:00.0 That French Place presents Macaron
25 3001 Church Road [empty string] Petoskey Camp_Daggett_Torchlight_Snowshoe-1 2020-02-29 21:00:00.0 [empty string] [empty string] Camp Daggett Torchlight Snowshoe 231-347-9742 Outdoor Recreation 2020-02-29 17:00:00.0 Snowshoe the trails at Camp Daggett by torchlight
26 109 Clinton St [empty string] Charlevoix Dabble_in_the_Arts_2 2020-03-05 20:00:00.0 [empty string] [empty string] Dabble in the Arts 231-547-3554 Arts & Culture 2020-03-05 18:00:00.0 Art classes at Charlevoix Circle of Arts
27 212 Bridge St [empty string] Charlevoix French_Place_Cooking_Class_6 2020-03-05 21:00:00.0 [empty string] [empty string] That French Place Cooking Class 231-437-6037 Culinary Event 2020-03-05 18:00:00.0 That French Place presents Advanced Instant Pot
28 220 Clinton St [empty string] Charlevoix Michigan_Lumbering_Days 2020-03-10 20:00:00.0 [empty string] [empty string] AL & DAVIE EICHER-MICHIGAN'S 231-547-2651 Arts & Culture 2020-03-10 18:30:00.0 Michigan history at Charlevoix Public Library
29 109 Clinton St [empty string] Charlevoix Floral_Design_Class 2020-03-12 20:00:00.0 [empty string] [empty string] Floral Design Class (231) 547-3554 Arts & Culture 2020-03-12 18:00:00.0 Floral Design Class at Charlevoix Circle of Arts
30 109 Clinton St [empty string] Charlevoix Floral_Design_Class4 2020-03-12 20:00:00.0 [empty string] [empty string] Floral Design Class (231) 547-3554 Arts & Culture 2020-03-12 18:00:00.0 Floral Design Class at Charlevoix Circle of Arts
31 212 Bridge St [empty string] Charlevoix French_Place_Cooking_Class_7 2020-03-12 21:00:00.0 [empty string] [empty string] That French Place Cooking Class 231-437-6037 Culinary Event 2020-03-12 18:00:00.0 That French Place presents Ice Cream
32 26215 Main St [empty string] Beaver Island Saint_Patricks_Day_Beaver_Island 2020-03-14 23:00:00.0 [empty string] [empty string] Saint Patricks Day on Beaver Island (231) 448-2505 Festivals 2020-03-14 08:00:00.0 Celebrating on the Emerald Isle
33 800 Bay Harbor Drive [empty string] Bay Harbor Canadian_Brass 2020-03-15 18:00:00.0 [empty string] [empty string] Canadian Brass 231-439-2600 Arts & Culture 2020-03-15 16:00:00.0 Canadian Brass
34 220 Clinton St [empty string] Charlevoix Mackinac_Island_History 2020-03-17 20:00:00.0 [empty string] [empty string] STEVE BRISSON-MACKINAC ISLAND HISTORY 231-547-2651 Arts & Culture 2020-03-17 18:30:00.0 Learn more about the history of Mackinac Island
35 109 Clinton St [empty string] Charlevoix Third_Thursday_Pour_Series3 2020-03-19 19:30:00.0 [empty string] [empty string] Third Thursday Pour Series (231) 547-3554 Arts & Culture 2020-03-19 18:00:00.0 Third Thursday Pour Series
36 219 E Lake St [empty string] Petoskey Sunday_Series_GLC_Orchestra3 2020-03-22 17:00:00.0 [empty string] [empty string] Sunday Series Great Lakes Chamber Orchestra (231) 487-0010 Arts & Culture 2020-03-22 16:00:00.0 Sunday Series presents Brass Quintet & DrumHeads
37 220 Clinton St [empty string] Charlevoix Bombs_Away 2020-03-24 20:00:00.0 [empty string] [empty string] RIC MIXTER-BOMBS AWAY! 231-547-2651 Arts & Culture 2020-03-24 18:30:00.0 Charlevoix Public Library presents Bombs Away!
38 5052 M-66 [empty string] Charlevoix Paint_and_Sip2 2020-03-25 20:00:00.0 [empty string] [empty string] Paint and Sip (231) 437-6500 Arts & Culture 2020-03-25 18:00:00.0 Paint and sip at 1918 Cellars
39 109 Clinton St [empty string] Charlevoix Painting_Class_at_the_Circle2-1 2020-03-26 20:00:00.0 [empty string] [empty string] Painting Class at the Circle 231-547-3554 Arts & Culture 2020-03-26 18:00:00.0 Painting class at Charlevoix Circle of Arts
40 220 Clinton St [empty string] Charlevoix Winter_Folk_Concert_3 2020-03-30 20:30:00.0 [empty string] [empty string] Winter Folk Concert 231-547-2651 Arts & Culture 2020-03-30 18:30:00.0 Winter folk concert series.
41 109 Clinton St [empty string] Charlevoix Dabble_in_the_Arts_3 2020-04-02 20:00:00.0 [empty string] [empty string] Dabble in the Arts 231-547-3554 Arts & Culture 2020-04-02 18:00:00.0 Art classes at Charlevoix Circle of Arts
42 220 Clinton St [empty string] Charlevoix Spring_Author_Series_1 2020-04-07 20:00:00.0 [empty string] [empty string] Charlevoix Public Library Author Series (231) 547-2651 Arts & Culture 2020-04-07 18:30:00.0 Charlevoix Public Library Spring Author Series
43 109 Clinton St [empty string] Charlevoix Floral_Design_Class5 2020-04-09 20:00:00.0 [empty string] [empty string] Floral Design Class (231) 547-3554 Arts & Culture 2020-04-09 18:00:00.0 Floral Design Class at Charlevoix Circle of Arts
44 400 Bridge St [empty string] Charlevoix Easter-Egg-Hunt 2020-04-11 15:00:00.0 [empty string] [empty string] Easter Egg Hunt 231-547-2101 Family Event 2020-04-11 14:00:00.0 Kids of all ages Welcome.
45 220 Clinton St [empty string] Charlevoix Charlevoix_Public_Library_Author_Series2 2020-04-14 20:00:00.0 [empty string] [empty string] Charlevoix Public Library Author Series (231) 547-2651 Arts & Culture 2020-04-14 18:30:00.0 Charlevoix Public Library spring author series.
46 109 Clinton St [empty string] Charlevoix Third_Thursday_Pour_Series4 2020-04-16 19:30:00.0 [empty string] [empty string] Third Thursday Pour Series (231) 547-3554 Arts & Culture 2020-04-16 18:00:00.0 Third Thursday Pour Series
47 220 Clinton St [empty string] Charlevoix Charlevoix_Public_Library_Author_Series_3 2020-04-21 20:00:00.0 [empty string] [empty string] Charlevoix Public Library Author Series (231) 547-2651 Arts & Culture 2020-04-21 18:30:00.0 Charlevoix Public Library author series.
48 109 Clinton St [empty string] Charlevoix Painting_Class_at_the_Circle2-1-1 2020-04-23 20:00:00.0 [empty string] [empty string] Painting Class at the Circle 231-547-3554 Arts & Culture 2020-04-23 18:00:00.0 Painting class at Charlevoix Circle of Arts
49 219 East Lake Street [empty string] Petoskey Take_to_the_Sky 2020-04-25 21:00:00.0 [empty string] [empty string] Take to the Sky 231.487.0010 Arts & Culture 2020-04-25 19:00:00.0 Great Lakes Chamber Orchestra presents Take to the Sky
50 220 Clinton St [empty string] Charlevoix Winter_Folk_Concert_Series 2020-04-27 20:30:00.0 [empty string] [empty string] Winter Folk Concert http://www.charlevoixlibrary.org/ Arts & Culture 2020-04-27 18:30:00.0 Winter folk concert series.
51 212 Bridge St [empty string] Charlevoix French_Place_Cooking_Class_8 2020-04-30 21:00:00.0 [empty string] [empty string] That French Place Cooking Class 231-437-6037 Culinary Event 2020-04-30 18:00:00.0 That French Place presents Macaron
52 800 Bay Harbor Drive [empty string] Bay Harbor Northern_Michigan_Chorale 2020-05-03 21:00:00.0 [empty string] [empty string] Northern Michigan Chorale 231-439-2600 Arts & Culture 2020-05-02 19:00:00.0 NORTHERN MICHIGAN CHORALE PRESENTS: 38TH ANNUAL SPRING CONCERT
53 219 E Lake St [empty string] Petoskey Sunday_Series_GLC_Orchestra4 2020-05-03 17:00:00.0 [empty string] [empty string] Sunday Series Great Lakes Chamber Orchestra (231) 487-0010 Arts & Culture 2020-05-03 16:00:00.0 Sunday Series presents Double Reeds
54 109 Clinton St [empty string] Charlevoix Dabble_in_the_Arts_4 2020-05-07 20:00:00.0 [empty string] [empty string] Dabble in the Arts 231-547-3554 Arts & Culture 2020-05-07 18:00:00.0 Art classes at Charlevoix Circle of Arts
55 [empty string] [empty string] Boyne City Boyne_City_National_Morel_Mushroom_Festival_ 2020-05-17 20:00:00.0 [empty string] [empty string] Boyne City National Morel Mushroom Festival 231-582-6222 Festivals 2020-05-14 08:00:00.0 Experts compete in the National Mushroom Hunt!
56 109 Clinton St [empty string] Charlevoix Floral_Design_Class6 2020-05-14 20:00:00.0 [empty string] [empty string] Floral Design Class (231) 547-3554 Arts & Culture 2020-05-14 18:00:00.0 Floral Design Class at Charlevoix Circle of Arts
57 109 Clinton St [empty string] Charlevoix Third_Thursday_Pour_Series5 2020-05-21 19:30:00.0 [empty string] [empty string] Third Thursday Pour Series (231) 547-3554 Arts & Culture 2020-05-21 18:00:00.0 Third Thursday Pour Series
58 1687 M-119 [empty string] Petoskey Staffords_Marathon 2020-05-23 14:00:00.0 [empty string] [empty string] Stafford's Top of Michigan Marathon (231) 348-8280 Outdoor Recreation 2020-05-23 08:00:00.0 Run the Little Traverse Wheelway
59 5052 M-66 North [empty string] Charlevoix Local-Appreciation-Day-at-Castle-Farms-1 2020-05-25 17:00:00.0 [empty string] [empty string] Local Appreciation Day at Castle Farms 231-237-0884 x222 Family Event 2020-05-25 09:00:00.0 [empty string]
60 109 Clinton St [empty string] Charlevoix Painting_Class_at_the_Circle5 2020-05-28 20:00:00.0 [empty string] [empty string] Painting Class at the Circle 231-547-3554 Arts & Culture 2020-05-28 18:00:00.0 Painting class at Charlevoix Circle of Arts
61 [empty string] [empty string] Beaver Island Beaver_Island_Birding_Trail_Warblers_on_the_Water 2020-05-31 17:00:00.0 [empty string] [empty string] Beaver Island Birding Trail Warblers on the Water 231-448-2505 Outdoor Recreation 2020-05-29 08:00:00.0 The festivities include presentations and field trips by expert field guides.
62 109 Clinton St [empty string] Charlevoix Dabble_in_the_Arts_5 2020-06-04 20:00:00.0 [empty string] [empty string] Dabble in the Arts 231-547-3554 Arts & Culture 2020-06-04 18:00:00.0 Art classes at Charlevoix Circle of Arts
63 1 Boyne Mountain Road [empty string] Boyne Falls Dirty_Dog_Dash 2020-06-06 17:00:00.0 [empty string] [empty string] Dirty Dog Dash (844)773-8321 Outdoor Recreation 2020-06-06 08:30:00.0 Test your endurance at the Dirty Dog Dash.
64 219 East Lake Street https://www.greatlakescfa.org/event-detail/great-lakes-chamber-orchestra-violins-of-hope/?glm_event_from=2019-04-28T16:00:00 Petoskey Great_Lakes_Chamber_Orchestra_1 2020-06-07 18:00:00.0 [empty string] [empty string] Great Lakes Chamber Orchestra 231.487.0010 Arts & Culture 2020-06-07 16:00:00.0 Great Lakes Chamber Orchestra presents Beethoven Symphony No 9 with Chorus
65 109 Mason [empty string] Charlevoix Summer_Open_House2 2020-06-11 20:00:00.0 [empty string] [empty string] Summer Merchant Open House 231-547-2101 Family Event 2020-06-11 16:00:00.0 Welcome Back!
66 109 Clinton St [empty string] Charlevoix Floral_Design_Class7 2020-06-11 20:00:00.0 [empty string] [empty string] Floral Design Class (231) 547-3554 Arts & Culture 2020-06-11 18:00:00.0 Floral Design Class at Charlevoix Circle of Arts
67 [empty string] [empty string] [empty string] Trout-Tournament 2020-06-14 17:00:00.0 [empty string] [empty string] Trout Tournament [empty string] Outdoor Recreation 2020-06-12 05:00:00.0 Fish for prizes
68 [empty string] [empty string] [empty string] Summer_Free_Fishing_Weekend 2020-06-14 23:00:00.0 [empty string] [empty string] Summer Free Fishing Weekend [empty string] Outdoor Recreation 2020-06-13 00:00:00.0 Free fishing weekend in Michigan.
69 109 Clinton St [empty string] Charlevoix Third_Thursday_Pour_Series6 2020-06-18 19:30:00.0 [empty string] [empty string] Third Thursday Pour Series (231) 547-3554 Arts & Culture 2020-06-18 18:00:00.0 Third Thursday Pour Series
70 [empty string] [empty string] Beaver Island Beaver_Island_Bike_Festival_2 2020-06-21 17:00:00.0 [empty string] [empty string] Beaver Island Bike Festival 231-448-2505 Festivals 2020-06-19 08:00:00.0 The Beaver Island Bike Festival is your opportunity to experience the unique unspoiled beauty of Lake Michigans most remote island by bicycle in a festival atmosphere.
71 8321 Front Street [empty string] Bay Harbor Bay_Harbor_InWater_Boat_Show 2020-06-21 15:00:00.0 [empty string] [empty string] Bay Harbor Lake Marina In Water Boat Show 231-439-2544 Festivals 2020-06-19 10:00:00.0 [empty string]
72 102 Michigan Ave [empty string] Charlevoix Charlevoix-Marathon 2020-06-20 13:05:00.0 [empty string] [empty string] Charlevoix Marathon 248-921-2720 Outdoor Recreation 2020-06-20 06:04:00.0 [empty string]
73 [empty string] [empty string] Boyne City Michigan_Mountain_Mayhem 2020-06-20 17:00:00.0 [empty string] [empty string] Michigan Mountain Mayhem Spring Classic [empty string] Outdoor Recreation 2020-06-20 09:00:00.0 It is a road bike event and is a timed challenge ride on the toughest terrain Michigan has to offer and will test you both mentally and physically
74 109 Clinton St [empty string] Charlevoix Seeing_the_Light 2020-06-26 17:00:00.0 [empty string] [empty string] Seeing the Light 231-547-3554 Arts & Culture 2020-06-25 09:00:00.0 Seeing the Light Plein Air Workshop with Kurt Anderson
75 28599 Hideaway Trail [empty string] Beaver Island Beaver_Island_Eco_Festival_ 2020-06-27 18:00:00.0 [empty string] [empty string] Beaver Island Sustainability Fair 231-838-2883 Arts & Culture 2020-06-26 16:30:00.0 BEAVER ISLAND Sustainability Fair celebrates nature and sustainability
76 109 Mason [empty string] Charlevoix Summer_ArtShow 2020-06-28 15:00:00.0 [empty string] [empty string] Summer Art Show 231-547-2101 Arts & Culture 2020-06-27 09:00:00.0 Art and craft show
77 4000 Main St [empty string] Bay Harbor Bay_Harbor_Vintage_Car_and_Boat_Festival 2020-06-27 16:00:00.0 [empty string] [empty string] Bay Harbor Vintage Car and Boat Festival 231-439-2700 Festivals 2020-06-27 10:00:00.0 The Bay Harbor Vintage Car and Boat Festival kicks off the summer in Bay Harbor with a fantastic collection of classic cars and wooden boats
78 109 Mason St [empty string] Charlevoix Charlevoix-Concert-Series-2 2020-07-02 21:00:00.0 45.3158664 -85.25875300000001 Live on the Lake presents Hurricane 231-547-2101 Entertainment 2020-07-02 19:00:00.0 Live on the Lake brings in local, regional, and nationwide artists playing a variety of musical genres from classic orchestra to reggae, bluegrass to percussion. 
79 4000 Main Street [empty string] Bay Harbor Bay_Harbor_4th_of_July_ 2020-07-03 22:30:00.0 [empty string] [empty string] Bay Harbor 4th of July 231-439-2700 Festivals 2020-07-03 11:00:00.0 4th of July Celebration at Bay Harbor
80 28 S. Lake Street [empty string] Boyne City Boyne_City_4th_of_July_Festival_ 2020-07-04 23:00:00.0 [empty string] [empty string] Boyne City 4th of July Festival 231-582-6222 Festivals 2020-07-04 08:00:00.0 Celebrating the 4th of July!
81 26215 Main St [empty string] Beaver Island 4th_of_July_on_Beaver_Island 2020-07-04 23:00:00.0 [empty string] [empty string] 4th of July on Beaver Island 231-448-2505 Festivals 2020-07-04 09:00:00.0 Happy 4th of July from Beaver Island
82 401 East Mitchell Street [empty string] Petoskey 4th_of_July_Petoskey 2020-07-04 21:00:00.0 [empty string] [empty string] 4th of July in Petoskey 231-348-2755 Festivals 2020-07-04 18:00:00.0 4th of July celebration in Petoskey
83 109 Clinton St [empty string] Charlevoix Watercolor_Sketchbook 2020-07-07 13:00:00.0 [empty string] [empty string] Watercolor Sketchbook 231-547-3554 Arts & Culture 2020-07-06 10:00:00.0 Watercolor Sketchbook with Patrick Kelly Wise
84 109 Mason St [empty string] Charlevoix Charlevoix-Concert-Series-3 2020-07-09 21:00:00.0 45.3158664 -85.25875300000001 Live on the Lake 231-547-2101 Entertainment 2020-07-09 19:00:00.0 Live on the Lake brings in local, regional, and nationwide artists playing a variety of musical genres from classic orchestra to reggae, bluegrass to percussion. 
85 [empty string] [empty string] Boyne City Boyne_Thunder 2020-07-11 18:00:00.0 [empty string] [empty string] Boyne Thunder (231) 582-9009 Family Event 2020-07-10 18:00:00.0 A weekend full of big, fast, beautiful boats
86 400 Bridge St [empty string] Charlevoix Art-and-Craft-Show 2020-07-12 18:00:00.0 [empty string] [empty string] Art & Craft Show [empty string] Arts & Culture 2020-07-11 10:00:00.0 Art and Craft Show
87 26275 Main St [empty string] Beaver Island Beaver_Island_Museum_Week_ 2020-07-18 00:00:00.0 [empty string] [empty string] Beaver Island Museum Week (231) 448-2254 Arts & Culture 2020-07-12 00:00:00.0 Beaver Island History Week
88 28599 Hideaway Trail [empty string] Beaver Island Beaver_Island_Music_Festival 2020-07-18 20:00:00.0 [empty string] [empty string] Beaver Island Music Festival (231) 838-2883 Festivals 2020-07-16 10:00:00.0 Enjoy a wide variety of musical experiences!
89 109 Mason St [empty string] Charlevoix Charlevoix-Concert-Series-4 2020-07-16 21:00:00.0 45.3158664 -85.25875300000001 Live on the Lake 231-547-2101 Entertainment 2020-07-16 19:00:00.0 Live on the Lake brings in local, regional, and nationwide artists playing a variety of musical genres from classic orchestra to reggae, bluegrass to percussion. 
90 309 Petoskey Avenue [empty string] Charlevoix Venetian-Festival 2020-07-25 23:00:00.0 [empty string] [empty string] Venetian Festival 231-547-3872 Festivals 2020-07-18 12:00:00.0 What began in 1930 as a candle lit boat parade in Charlevoix’s picturesque harbor, has become an eight day celebration of family and community pride. With both national and local music acts performing in three waterfront parks, a Kid’s Day, fifteen athletic tournaments, two nights (Friday and Saturday) of world class fireworks and the acclaimed Venetian boat parade, there is something for everyone at the Charlevoix Venetian Festival held the fourth week of each July in “Charlevoix the Beautiful.”
91 4000 Main Street [empty string] Bay Harbor Bay_Harbor_Arts_Festival_ 2020-07-25 18:00:00.0 [empty string] [empty string] Bay Harbor Arts Festival 231-439-2700 Arts & Culture 2020-07-24 16:00:00.0 [empty string]
92 109 Mason St [empty string] Charlevoix Charlevoix-Concert-Series-5 2020-07-30 21:00:00.0 45.3158664 -85.25875300000001 Live on the Lake 231-547-2101 Entertainment 2020-07-30 19:00:00.0 Live on the Lake brings in local, regional, and nationwide artists playing a variety of musical genres from classic orchestra to reggae, bluegrass to percussion. 
93 109 Mason St [empty string] Charlevoix Charlevoix-Concert-Series-7 2020-08-06 21:00:00.0 45.3158664 -85.25875300000001 Live on the Lake 231-547-2101 Entertainment 2020-08-06 19:00:00.0 Live on the Lake brings in local, regional, and nationwide artists playing a variety of musical genres from classic orchestra to reggae, bluegrass to percussion. 
94 [empty string] [empty string] [empty string] Homecoming_on_Beaver_Island 2020-08-09 00:00:00.0 [empty string] [empty string] Homecoming on Beaver Island [empty string] Family Event 2020-08-08 00:00:00.0 [empty string]
95 319 N. Lake St [empty string] Boyne City Antique_Auto_Show__Flea_Market 2020-08-09 16:00:00.0 [empty string] [empty string] Antique Auto Show & Flea Market (231) 582-3642 Festivals 2020-08-08 09:00:00.0 Annual Antique Auto Show and Flea Marketing coming to Boyne City.
96 [empty string] [empty string] [empty string] Waterfront-Art-Fair 2020-08-08 18:00:00.0 [empty string] [empty string] Waterfront Art Fair [empty string] Arts & Culture 2020-08-08 09:00:00.0 Held in grassy East Park on Round Lake make the Charlevoix Waterfront Art Fair a spectacular visual experience
97 109 Mason [empty string] Charlevoix Side-Walk-Sales 2020-08-15 18:00:00.0 45.3180632 -85.25840040000003 Sidewalk Sales 231-547-2101 Family Event 2020-08-13 09:00:00.0 Great sales downtown Charlevoix.
98 109 Mason [empty string] Charlevoix Live_on_Lake_1 2020-08-13 21:00:00.0 [empty string] [empty string] Live on the Lake 231-547-2101 Entertainment 2020-08-13 19:00:00.0 Live on the Lake brings in local, regional, and nationwide artists playing a variety of musical genres from classic orchestra to reggae, bluegrass to percussion. 
99 210 State [empty string] Charlevoix Live_on_the_Lake_2 2020-08-20 21:00:00.0 [empty string] [empty string] Live on the Lake 231-547-3250 Entertainment 2020-08-20 19:00:00.0 Live on the Lake brings in local, regional, and nationwide artists playing a variety of musical genres from classic orchestra to reggae, bluegrass to percussion. 
100 109 Clinton St [empty string] Charlevoix Pocket_Sketching 2020-09-09 17:00:00.0 [empty string] [empty string] Pocket Sketching (231) 547-3554 Arts & Culture 2020-09-07 09:00:00.0 Pocket Sketching at Charlevoix Circle of Arts
101 26215 Main St [empty string] Beaver Island Emerald_Isle_Irish_Festival 2020-09-13 00:00:00.0 [empty string] [empty string] Emerald Isle Irish Festival (231) 448-2505 Festivals 2020-09-11 00:00:00.0 Emerald Isle Irish Festival on Beaver Island
102 4000 Main Street [empty string] Petoskey Balloons_over_Bay_Harbor 2020-09-18 21:00:00.0 [empty string] [empty string] Balloons over Bay Harbor (231) 439-2004 Family Event 2020-09-18 17:00:00.0 Hot air balloons over Bay Harbor
103 4000 Main Street [empty string] Petoskey Balloons_over_Bay_Harbor2 2020-09-19 21:00:00.0 [empty string] [empty string] Balloons over Bay Harbor (231) 439-2004 Family Event 2020-09-19 07:30:00.0 Hot air balloons over Bay Harbor
104 120 Water St [empty string] Boyne City Boyne_City_Fall_Harvest_Festival 2020-09-26 16:00:00.0 [empty string] [empty string] Boyne City Fall Harvest Festival (231) 582-9009 Festivals 2020-09-26 08:00:00.0 Boyne City celebrates the fall harvest
105 307 Chicago Avenue [empty string] Charlevoix Leif-Eriksson-Day-Row--Run 2020-10-03 12:00:00.0 [empty string] [empty string] Leif Eriksson Day Row & Run 2316752240 Outdoor Recreation 2020-10-03 09:00:00.0 A 1 mile boat race and 5k foot race to celebrate the life of Leif Eriksson and the viking way.
106 26215 Main St [empty string] Beaver Island Bite_of_Beaver_Island 2020-10-04 14:00:00.0 [empty string] [empty string] Bite of Beaver Island (231) 448-2505 Culinary Event 2020-10-03 12:00:00.0 [empty string]
107 109 Mason [empty string] Charlevoix Apple-Festival 2020-10-11 16:00:00.0 [empty string] [empty string] Apple Festival 231-547-2101 Culinary Event 2020-10-09 10:00:00.0 All things fall harvest! Friday & Saturday: 10-6 Sunday: 10-4
108 [empty string] [empty string] [empty string] BridgeDrop 2021-01-01 00:00:00.0 [empty string] [empty string] Charlevoix Bridge Drop 231-547-2101 Festivals 2020-12-31 13:00:00.0 Celebrate the New Year in Charlevoix with the annual Bridge Drop. Who wants to watch a ball drop when you can see downtown Charlevoix's bridge drop to ring in the New Year?
CACHED true
EXECUTIONTIME 0
SQL select b.display, b.name, b.teaser, b.latitude, b.longitude, c.book_now_url , start_date , end_date , c.address , c.city , event_types.name as `primary_category` , c.phone_1 from events b left outer join events__contacts__link on b.id_events = events__contacts__link.id_events left outer join contacts c on events__contacts__link.id_contacts = c.id_contacts left outer join event_types on b.primary_category = event_types.id_event_types where 1 = 1 and ids_events = 1 and b.ids_events = 1 and ( b.start_date is not null and ( ( b.end_date is null and b.start_date >= '2020-01-25' and b.start_date <= '2021-01-25' ) or ( b.start_date <= '2021-01-25' and b.end_date >= '2020-01-25' ) ) ) group by b.id_events order by b.start_date, replace(b.name, "The ", "")