Name: SYRACUSE HARDCORE NEW YEAR’S DAY MATINEE 2026
Start: 2026-01-01T15:00:00
Location: The Song & Dance

World Ballet Company: THE NUTCRACKER

Friday, Dec 26, 2025 at 7:00pm

The Oncenter Crouse Hinds Theater

Syracuse, NY

Ladies Only Dance Party: brought to you by Middle Ages & 95x in support of Vera House

Friday, Dec 26, 2025 at 7:00pm

Middle Ages Beer Hall

Syracuse, NY

Ladies Only Dance Party: brought to you by Middle Ages & 95x in support of Vera House

Central New York Regional Farmers Market

Saturday, Dec 27, 2025 from 7:00am to 2:00pm

Central New York Regional Farmers Market

Syracuse, NY

Central New York Regional Farmers Market

Scars N’ Stripes Holiday Hangover!!!

Saturday, Dec 27, 2025 at 8:00pm

Middle Ages Beer Hall

Syracuse, NY

CowCalls

Saturday, Dec 27, 2025 at 8:00pm

The Song & Dance

Syracuse, NY

Central New York Regional Farmers Market

Sunday, Dec 28, 2025 from 7:00am to 2:00pm

Central New York Regional Farmers Market

Syracuse, NY

Jazz Jam

Sunday, Dec 28, 2025 at 3:00pm

Funk 'n Waffles

Syracuse, NY

Syracuse University Women's Basketball vs. Duke Blue Devils Womens Basketball

Sunday, Dec 28, 2025 at 4:00pm

JMA Wireless Dome

Syracuse, NY

Syracuse University Women's Basketball vs. Duke Blue Devils Womens Basketball

OPEN MIC NIGHT w/ ATTAMIZK & FRIENDS

Sunday, Dec 28, 2025 at 8:30pm

Funk 'n Waffles

Syracuse, NY

PEARLY BAKERS BEST

Monday, Dec 29, 2025 at 7:30pm

Funk 'n Waffles

Syracuse, NY

Miracle On 34th Street – The Musical (Touring)

Tuesday, Dec 30, 2025 at 7:30pm

The Oncenter Crouse Hinds Theater

Syracuse, NY

Miracle On 34th Street – The Musical (Touring)

Wednesday, Dec 31, 2025 at 2:00pm

The Oncenter Crouse Hinds Theater

Syracuse, NY

Syracuse University Men's Basketball vs. Clemson University Tigers Men's Basketball

Wednesday, Dec 31, 2025 at 2:00pm

JMA Wireless Dome

Syracuse, NY

Syracuse University Men's Basketball vs. Clemson University Tigers Men's Basketball

Miracle On 34th Street – The Musical (Touring)

Thursday, Jan 1, 2026 at 2:00pm

The Oncenter Crouse Hinds Theater

Syracuse, NY

SYRACUSE HARDCORE NEW YEAR’S DAY MATINEE 2026

Thursday, Jan 1, 2026 at 3:00pm

The Song & Dance

Syracuse, NY

SYRACUSE HARDCORE NEW YEAR’S DAY MATINEE 2026

Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"constantia-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"constantia-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
3	db.tokens.find( {"sef_url":{"$in":["usa","ny","oswego-county-ny","constantia-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.events_cache.find( {"_id":"759f6c40c23b09d86d1d7d73c2cdbf6e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"bb81dfa4ef191141700670f1075a633b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.count( {"address.town_sef_url":"constantia-ny","start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.01020050048828,43.25],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	33
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.01020050048828,43.25],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	30
9	db.events_radius_cache.count( {"_id":"bb81dfa4ef191141700670f1075a633b"} )	0	1
10	db.events_radius_cache.insert( {"_id":"bb81dfa4ef191141700670f1075a633b","radius":25,"modified":"MongoDate(0.07400000 1766593506)","created":"MongoDate(0.07400000 1766593506)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"geo":{"$geoWithin":{"$center":[[-76.01020050048828,43.25],0.36231884057971014]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 16 ).skip( 0 )	16	134
12	db.events_cache.count( {"_id":"759f6c40c23b09d86d1d7d73c2cdbf6e"} )	0	2
13	db.events_cache.count( {"_id":"759f6c40c23b09d86d1d7d73c2cdbf6e"} )	0	2
14	db.events_cache.insert( {"_id":"759f6c40c23b09d86d1d7d73c2cdbf6e","town_sef_url":"constantia-ny","data_key":["68a75b6903a70639b6cf4662","69036ae64389be6be5f6206e","68a75b6903a70639b6cf494b","69036ae84389be6be5f6297b","693321064389be6be5655384","68a75b6b03a70639b6cf56c5","693321064389be6be56555b8","69036ae94389be6be5f62da0","68a75b6c03a70639b6cf5cf3","693321074389be6be56558f4","68a75b6d03a70639b6cf6410","68a75b6e03a70639b6cf670a","693321084389be6be5655cf4","68a75b6e03a70639b6cf6a26","693321084389be6be56561e7"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Constantia Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":43.25,\"lng\":-76.01020050048828,\"latlng\":\"43.25,-76.010200500488\",\"city\":\"Constantia\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.24800000 1766593506)","created":"MongoDate(0.24800000 1766593506)"} , true)	0	2

Constantia

New York

Constantia Featured Events

World Ballet Company: THE NUTCRACKER

Ladies Only Dance Party: brought to you by Middle Ages & 95x in support of Vera House

Central New York Regional Farmers Market

Scars N’ Stripes Holiday Hangover!!!

CowCalls

Central New York Regional Farmers Market

Jazz Jam

Syracuse University Women's Basketball vs. Duke Blue Devils Womens Basketball

OPEN MIC NIGHT w/ ATTAMIZK & FRIENDS

PEARLY BAKERS BEST

Miracle On 34th Street – The Musical (Touring)

Miracle On 34th Street – The Musical (Touring)

Syracuse University Men's Basketball vs. Clemson University Tigers Men's Basketball

Miracle On 34th Street – The Musical (Touring)

SYRACUSE HARDCORE NEW YEAR’S DAY MATINEE 2026

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million people
rely on AmericanTowns each year to find & share local information.

Constantia Featured Events

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

20 million people
rely on AmericanTowns each year to find & share local information.