<cfinclude template="header.cfm">

<table width="900">

<Tr>
<Td width="50%">

<Table>
<Tr><Td style="background-color:25408d"><centeR>
<font face="verdana" size="+2" color="white">
VISITING THE BIG APPLE?<Br>
<Table><Tr><TD></TD></Tr></Table>
<font face="verdana" size="+1" color="yellow">
Save Big Now with NYC CouponPak!<Br><Table><Tr><TD></TD></Tr></Table>

</Td></Tr>
<Tr><Td bgcolor="white" style="padding:10px;">
<Font face="verdana" size="+2" color="49ad53">
NYC CouponPak is your source for hundreds of dollars in
savings when you visit New York City. There
is no other convenient product to get all of
these offers in one place</Font><Font face="verdana" size="+2" color="#da192e">...for only $9.95!</Font>
<p><font face="verdana" size="-1">
NYC CouponPak offers you over 35 coupons and $100s of dollars
in savings to top visitor attractions, retailers, entertainment,
restaurants, transportation services, and more. Many families
and NYC visitors cover the cost of the NYC CouponPack with
only one coupon. Unlike any other tourist savings vehicle,
the NYC CouponPak brings all the savings together in
one place. You can print 'em all or just the ones you want.
<p><Font face="verdana" style="font-size:14pt;font-weight:bold;" color="#da192e">
Save Big Now with NYC CouponPak!
</Font>

</Td></Tr></table>

</Td>
<Td style="background-image:url('nyc_illustration2.png');vertical-align:bottom">
<Br><Br><br>
<a href="https://nyccouponpak.com/purchase.cfm"><img src="yellowburst.png" alt="New York City Savings" width="300" border="0"></a>

</Td>

</TAble>

<table width="900" style="background-color:#d5e8ca">
<TR><TD align="center">

<table style="width: 800px;">
<tbody>
<tr>
<td width="200" valign="top">
<table style="width: 100%;">
<tbody>
<tr style="background-color: #cd9452;">
<td><center><span style="color: white; font-family: verdana;"><strong>Dining &amp; Nightlife</strong></span></td>
</tr>
<tr style="background-color: #ffffff;">
<td style="padding: 4px;">
<p><a href="https://nyccouponpak.com/purchase.cfm"><img src="http://www.cityguideny.com/uploads2/87773/dining-pak-bari.jpg" alt="NYC Dining Discounts" width="200" height="133" border="0"/></a><br />
<cfquery name="getdiscounts" datasource="cityguide">
select id,itemname,expire,description
from ListingsCoupons where mag = 1 and (tablename = 'Restaurants' or tablename = 'Nightlife')
order by expire
</cfquery>

<cfoutput query="getdiscounts">
<cfif #dateformat(expire,'mm/dd/yyyy')# gt #dateformat(now(),'mm/dd/yyyy')#>
<cfif #getdiscounts.itemname# is not #itemname[currentrow-1]# and #itemname# does not contain 'Macy' and #itemname# does not contain 'Toys'><span style="font-size: 10pt;font-family:verdana;">
<strong>#getdiscounts.itemname#</strong> - #description#</span><table><Tr><Td></Td></Tr></table>
</cfif></cfif></cfoutput>
</td>
</tr>
<tr style="background-color: #cd9452;">
<td>&nbsp;</td>
</tr>
</tbody>
</table>
</td>
<td width="200" valign="top">
<table style="width: 100%;">
<tbody>
<tr style="background-color: #f60035;">
<td><center><span style="color: white; font-family: verdana;"><strong>Attractions</strong></span></td>
</tr>
<tr style="background-color: #ffffff;">
<td style="padding: 4px;">
<p><a href="https://nyccouponpak.com/purchase.cfm"><img src="http://www.cityguideny.com/uploads2/87773/sightsee-pak-circle42.jpg" alt="NYC Attractions Coupons" width="200" height="133"  border="0"/></a><br />

<cfquery name="getdiscounts" datasource="cityguide">
select id,itemname,expire,description
from ListingsCoupons where mag = 1 and (tablename = 'ToursAttractions' or tablename = 'Family Fun')
order by expire
</cfquery>

<cfoutput query="getdiscounts">
<cfif #dateformat(expire,'mm/dd/yyyy')# gt #dateformat(now(),'mm/dd/yyyy')#>
<cfif #getdiscounts.itemname# is not #itemname[currentrow-1]# and #itemname# does not contain 'Macy' and #itemname# does not contain 'Toys'><span style="font-size: 10pt;font-family:verdana;">
<strong>#getdiscounts.itemname#</strong> - #description#</span><table><Tr><Td></Td></Tr></table>
</cfif></cfif></cfoutput>
</td>
</tr>
<tr style="background-color: #f60035;">
<td>&nbsp;</td>
</tr>
</tbody>
</table>
</td>
<td width="200" valign="top">
<table style="width: 100%;">
<tbody>
<tr style="background-color: #00b23f;">
<td><center><span style="color: white; font-family: verdana;"><strong>Shopping</strong></span></td>
</tr>
<tr style="background-color: #ffffff;">
<td style="padding: 4px;"><a href="https://nyccouponpak.com/purchase.cfm"><img src="http://www.cityguideny.com/uploads2/87773/century21-200.jpg" alt="NYC Shopping Coupons" width="200" height="133" border="0"/></a><br />

	<cfquery name="getdiscounts" datasource="cityguide">
select id,itemname,expire,description
from ListingsCoupons where mag = 1 and (tablename = 'Shopping')
order by expire
</cfquery>

<cfoutput query="getdiscounts">
<cfif #dateformat(expire,'mm/dd/yyyy')# gt #dateformat(now(),'mm/dd/yyyy')#>
<cfif #getdiscounts.itemname# is not #itemname[currentrow-1]# and #itemname# does not contain 'Macy' and #itemname# does not contain 'Toys'><span style="font-size: 10pt;font-family:verdana;">
<strong>#getdiscounts.itemname#</strong> - #description#</span><table><Tr><Td></Td></Tr></table>
</cfif></cfif></cfoutput>


</td>
</tr>
<tr style="background-color: #00b23f;">
<td>&nbsp;</td>
</tr>
</tbody>
</table>
</td>
<td width="200" valign="top">
<table style="width: 100%;">
<tbody>
<tr style="background-color: #483f94;">
<td><center><span style="color: white; font-family: verdana;"><strong>Transportation</strong></span></td>
</tr>
<tr style="background-color: #ffffff;">
<td style="padding: 4px;">
<p>
<a href="https://nyccouponpak.com/purchase.cfm"><img src="http://www.cityguideny.com/uploads2/87773/pak-trans.jpg" alt="Save on New York City Travel" width="200" height="133" border="0"/></a><br />

<cfquery name="getdiscounts" datasource="cityguide">
select id,itemname,expire,description
from ListingsCoupons where mag = 1 and (tablename = 'CarServices')
order by expire
</cfquery>

<cfoutput query="getdiscounts">
<cfif #dateformat(expire,'mm/dd/yyyy')# gt #dateformat(now(),'mm/dd/yyyy')#>
<cfif #getdiscounts.itemname# is not 'a'><span style="font-size: 10pt;font-family:verdana;">
<strong>#getdiscounts.itemname#</strong> - #description#</span><table><Tr><Td></Td></Tr></table>
</cfif></cfif></cfoutput>


</td>
</tr>
<tr style="background-color: #483f94;">
<td>&nbsp;</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>

<center><span style="font-size: 16pt; color: #da192e; font-family: verdana;"><strong><br /></strong></span></center><center><a style="text-decoration: none;" href="https://nyccouponpak.com/purchase.cfm"><span style="font-size: 16pt; color: #da192e; font-family: verdana;"><strong>All of these examples and much more &bull; Save Big Now with NYC CouponPak</strong> </span></a></center>

<Cfquery name="Getcolin" dataSource="cityguide">
select copy from columntable
where id = 87773
</cfquery>

<cfoutput query="getcolin">
#copy#</cfoutput>


</TD></TR>
</table>
<br>
<br>
<Table style="background-color:25408d" width="900">
<Tr><Td><centeR>
<Font face="verdana" size="+2" color="white">
<b>Buy the NYC CouponPak now for only $9.95!</b>
</Font></centeR></Td>
<td>
<img src="logo-crop.png" height=100 border="0">

</td></Tr></Table>
<cfinclude template="footer.cfm">