SELECT COUNT(*) AS TotalRows
FROM inquest.BizOCEvents, inquest.BizOCBiz
WHERE inquest.BizOCEvents.EvtID>0 AND ("2026-10-03">=EvtStartDate AND EvtEndDate <="2026-10-06") AND ((EvtDayOpt="V" AND ((EvtVariousDays LIKE "%2026-10-03%") OR (EvtVariousDays LIKE "%2026-10-04%") OR (EvtVariousDays LIKE "%2026-10-05%") OR (EvtVariousDays LIKE "%2026-10-06%") OR (EvtVariousDays LIKE "%2026-10-07%") OR (EvtVariousDays LIKE "%2026-10-08%") OR (EvtVariousDays LIKE "%2026-10-09%"))) OR (EvtDayOpt<>"V" AND ( (EvtDays LIKE "%6%") OR (EvtDays LIKE "%0%") OR (EvtDays LIKE "%1%") OR (EvtDays LIKE "%2%") OR (EvtDays LIKE "%3%") OR (EvtDays LIKE "%4%") OR (EvtDays LIKE "%5%") )))
"4th July Fireworks"
Town Of Estes Park
ⲴLake Estes
PhoneHours: 9:00 PM
-9:45 PM
Event Pasted Date: (Jul 4th)
"Big Foot Days"
Visit Estes Park
Ⲵ500 Big Thompson Ave
📞 (970) 577-9900
Hours: 9:00 AM
-5:00 PM
Event Passed. Next: (Apr, 2027)
"Classic Car Show"
Estes Park Car Club
Ⲵ660 Community Dr
📞 (806) 681-3612
Hours: 9:00 AM
-11:00 AM
Event Passed. Next: (May, 2027)
"Cowboy Sing-A-Long"
Town Of Estes Park
ⲴBond Park
📞 (970) 586-5331
Hours: 7:00 PM
-9:00 PM
Event Passed. Next: (Jun, 2027)
"Dine Around"
Town Of Estes Park
Ⲵ123 Elms
PhoneHours: 4:30 PM
-7:30 PM
Event Passed. Next: (Mar, 2027)
"Elk Fest"
Town Of Estes Park
ⲴBond Park
📞 (970) 586-5331
9:00 AM-4:00 PM
Fri Sat Sun Mon Tue Wed Thu
