sql=select distinct top 199 premium,cast(datemmm+' '+datedd+' '+dateyyyy as datetime),ggevent.timeampm,ggevent.timehh,ggevent.timemm,genre,feature,ggevent.xid,groupname,longitudex as longitude,latitudex as latitude,ggevent.xid,timemm,timehh,timeampm,title,ggevent.zip,ggevent.city,ggevent.state,venue,location,datemmm,datedd,dateyyyy,groupname,ggevent.groupid,ggevent.areacode,ggevent.prefix,ggevent.suffix,ggevent.extension,description,ggevent.contact,ggevent.email,admission,cost,sqrt(power(69.1*(35.110055-latitudex),2)+power(53*(-89.945392-longitudex),2)) as miles from ggevent,gguser,zipcodes where approved='Y' and ggevent.title <> 'ggnew' and ggevent.title > ' ' and ggevent.groupid > ' ' and gguser.groupid=ggevent.groupid and zipcodes.zipcode=ggevent.zip and ggevent.xid=327740 order by cast(datemmm+' '+datedd+' '+dateyyyy as datetime)
Join us in Pigeon Forge, TN as Chapel Valley artists from across the country bring you, "CHRISTMAS IN THE SMOKIES"! A fantastic 3-day gospel music event you`ll surely enjoy!! The cost for this 3-day event is $349/person based on double-occupancy per room at the LeConte Hotel & Convention Center in Pigeon Forge, TN. If you are interested in attending this event, please call Mark Green @ 918.850.6446 for more information and he`ll put you in touch with Sonshine Promotions to reserve your spot. This event is already over 85% sold out as of 02/02/23!
DATE AND TIME
Event Date:
Dec 05 2024
Event Start Time:
6:00 p.m
Admission:
Ticketed Event
VENUE
Venue Name:
Chapel Valley`s Christmas In The Smokies
Venue Address:
Leconte Hotel and Convention Center 410 Pine Mountain Road