<cfset a = 'on'>
<cfinclude template="header.cfm">
    <Table style="padding-left:20px;padding-right:20px;background-color: #fffed5;" align="center" width="100%"><tr><Td  valign="top">

<font face="verdana" size=+1>
<center>
<h1>
Meet Your 2018 Finalists</h1></center>
<p>


<cfquery name="Getcats" dataSource="#ds#">
	select distinct category from cca2018
	order by CATEGORY
</cfquery>

<Cfloop from="1" to="#getcats.recordcount#" index="i"><cfoutput>
<h2 style="font-family: helvetica;font-size: 14pt;">#getcats.category[i]#</h2></cfoutput>

<font face=helvetica  size=-1>

	<Cfif #getcats.category[i]# eq 'Rooftop Bar'>
	The establishment that is the best place to relax with a cocktail after a full day of NYC shopping, touring or exploring cultural institutions.</Cfif>

<Cfif #getcats.category[i]# eq 'Entertainment Service'>
The ticket service who can find the best seats, provide the most efficient service and help guests procure that hard to find ticket</Cfif>

<Cfif #getcats.category[i]# eq 'Family Friendly Experience'>
Destinations that make traveling with children a superior experience are important contributors to the NYC hospitality industry.</Cfif>
	
	
<Cfif #getcats.category[i]# eq 'Health & Beauty'>
	Salons, spas, fitness, medical and more, that offer guests the best overall experience.</Cfif>
	
<Cfif #getcats.category[i]# eq 'Hotel Restaurants'>
	
	Not just a place to lay your head, hotels provide some of the best dining experiences. Which one stands out?</Cfif>
	
	<Cfif #getcats.category[i]# eq 'Live Entertainment Venue'>
	
	Jazz clubs, cabarets, comedy clubs, burlesque and more offer guests a chance to experience known celebrities and up and comers. Who does it the best?</Cfif>
	
<Cfif #getcats.category[i]# eq 'New Restaurant'> 
	The new epicurean arrival on the NYC dining scene, based on cuisine, service, ambience, who is the best new addition.</Cfif>
	
	<Cfif #getcats.category[i]# eq 'New Venue'>
	Showing the vibrancy of tourism in New York City, more attractions and venues have opened in the same year than ever before.</Cfif>


<Cfif #getcats.category[i]# eq 'Restaurant Experience'>
	
	The best overall dining experience in a city that is one the world's eating meccas. Based on the feedback from millions of guests concierges are the qualified to make this judgment.</Cfif>
	
<Cfif #getcats.category[i]# eq 'Specialty Retailer'>
	The distinctive store that offers guests a combination of unique products and great shopping experiences. These retailers leave shoppers with lasting memories of New York City shopping.</Cfif>
	
<Cfif #getcats.category[i]# eq 'Steak House'>
	The restaurant in a city that has become a mecca for a steak meal that guests say best met their carnivore desires.</Cfif>

<Cfif #getcats.category[i]# eq 'Tour'>
	The tour service creates the best experience including information, convenience, and fun.</Cfif>
	
<Cfif #getcats.category[i]# eq 'Tourist Attraction'>

With many fantastic New York City venues, which one creates the best overall experience that guests return to the concierges gushing about the most</Cfif>

<Cfif #getcats.category[i]# eq 'Transportation Service'> 
	Many services make is easy to get around NYC by land, sea or air, which one offers the greatest experience and value.
	</Cfif>
<br><br>


<Cfquery name="getnoms" dataSource="#ds#">
	select * from cca2018
	where category = '#getcats.category[i]#'
	order by company
</cfquery>	

<Cfif parameterexists(url.showall)>
	<cfoutput query="Getnoms">
<b>#company#</b>
	<br> 
		#excellence#
		
		<Cfif #photo1# is not ''>
		<img src="https://conciergechoiceawards.com/2018pics/#photo1#" style="max-width: 600px;"><br>
		</Cfif>
		<Cfif #photo2# is not ''>
		<img src="https://conciergechoiceawards.com/2018pics/#photo2#" style="max-width: 600px;"><br>
		</Cfif>
		<Cfif #photo3# is not ''>
		<img src="https://conciergechoiceawards.com/2018pics/#photo3#" style="max-width: 600px;"><br>
		</Cfif>
		<p>
						</cfoutput>
	
	<cfelse>
<cfoutput query="Getnoms">
	
<li>		<Cfif #photo1# is not ''><a href="meet-finalists.cfm?finalist=#company#"></cfif>#company#</a>
</li></cfoutput>

</cfif>
</Cfloop>		



 </Td></tr></Table>
<cfinclude template="footer.cfm">