DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND areas.stateID =
AND areas.areaID = 171' at line 10
Saint Ignace, United States The Kewadin Casino Lakefront Inn is the perfect spot for all four season. We are located in the hart of Michigan's Upper Peninsula, offering direct access to snowmobile trails, ATV'ing, gambling, and the many breathtaking views of Mother Nature. Our spacious guestrooms offer banner accommodations including Coffee Makers, Blow Dryers and Iron & Iron Board. For business travelers, we offer king rooms, with a working area, complete with data-port for Internet connection. Our beachfront property on Lake Huron offers our guests a panoramic view of Mackinac Island, picnic area, and the only recreation center in the straits area, complete with pool, whirlpool and arcade, to overlook the waterfront. We provide our guests a complementary continental breakfast, as well as nightly casino packages. Daily shuttle service is available to Kewadin Shores Casino and to the Mackinac Island ferry docks. Whether your stay is for business or pleasure, allow our excellent staff to welcome you, your family and friends to enjoy a trip filled with many memories, in a peaceful and serene setting.