SELECT u.userid, u.comp_name, c.userid, c.coupon_special, c.coupon_desc, c.coupon_website, c.coupon_phone, c.coupon_logo, DATE_FORMAT(c.coupon_expire,'%Y-%m-%d') as expiry_date FROM coupons c INNER JOIN users u ON c.userid=u.userid WHERE c.coupon_status='1' AND c.coupon_active='1' AND c.coupon_expire >= '2012-05-17' ORDER BY RAND() ;

AmericInn of Two Harbors

May Special

Mention that you visited the Two Harbors Chamber "Hot Deals" and get 10% off your room through the end of May!


Phone: 218-834-3000
Expires: 2012-05-31

Print Coupon

Cove Point Lodge

May Special!

Lakeview Lodge Room with Scandinavian Breakfast Buffet
$89: Queen Bed & Loveseat or 2 Queen Beds
$99: Lodge Room with Jacuzzi, Deck or Fireplace
$119: Lodge Room with Fireplace AND Jacuzzi

Valid Sun-Thurs nts through May 31
Add $30 for Fri or Sat
Not valid May 25-28


Phone: 800.598.3221
Expires: 2012-05-31

Print Coupon

Country Inn of Two Harbors

20%

20%

DISCOUNT ON ALL ROOM TYPES

 

Present day thru June 14 2012

MENTION THIS COUPON WHEN CALLING

PRINT A COPY AND BRING IT WITH

UPON CHECK - IN

834-5557

 


Phone: 877-604-5332
Expires: 2012-06-14

Print Coupon