Today 2026-07-02
Today 2026-07-03
SELECT EvtID, EvtCat, EvtBizID, EvtName, EvtAddress, EvtPhone, EvtURL, EvtImage, EvtStartDate, EvtEndDate, EvtDayOpt, EvtVariousDays, EvtDays, EvtMonSeqNbr, EvtMonSeqDay, EvtDayMonDates, EvtStartTime, EvtEndTime, EvtDesc, EvtMemo, EvtLastEditDate, EvtTestYN, EvtPhoto, EvtSelcDates, bizID, bizPriority, bizCat, bizName, bizAddress, bizPhone, bizURL, bizImage, bizPreBeginDate, bizPreDays, bizPreOpenTime, bizPreCloseTime, bizPreEndDate, bizPrimeBeginDate, bizPrimeDays, bizPrimeOpenTime, bizPrimeCloseTime, bizPrimeEndDate, bizHolidayDates, bizPostBeginDate, bizPostDays, bizPostOpenTime, bizPostCloseTime, bizPostEndDate, bizMemo, bizLastEditDate, bizTestYN, bizAcctPostedID FROM inquest.BizOCEvents, inquest.BizOCBiz WHERE inquest.BizOCEvents.EvtBizID = inquest.BizOCBiz.bizID AND EvtID>0 AND ((("2026-07-01">=EvtStartDate) AND ("2026-07-01"<=EvtEndDate) AND (EvtDays LIKE "%3%")) OR (("2026-07-02">=EvtStartDate) AND ("2026-07-02"<=EvtEndDate) AND (EvtDays LIKE "%4%")) OR (("2026-07-03">=EvtStartDate) AND ("2026-07-03"<=EvtEndDate) AND (EvtDays LIKE "%5%"))) ORDER BY EvtName ASC LIMIT 6 Offset 0
--
Evt#: 4, When Select: 3
"Farmers Market" 
Town Of Estes Park Ⲵ500 Big Thompson Ave
📞 (303) 775-9058
8:00 AM-1:00 PM
Tue Wed Thu Fri Sat Sun Mon
"Karaoke Nite"
Lonigans Ⲵ110 W. Elkhorn Ave.
📞 (970) 586-4346
9:00 PM-11:00 PM
Tue Wed Thu Fri Sat Sun Mon
"Test Big Event "
Town Of Estes Park Ⲵ170 MacGregor Avenue
📞 (970) 586-5331
9:00 AM-11:00 AM
Open All Week
"Test Event"
The Rock Inn Mountain Tavern Ⲵ1234 emsdt stret
📞 (344) 344-3344
9:00 AM-11:00 AM
Tue Wed Thu Fri Sat Sun Mon