The place Bob is talking about is called Olde Mill Inn. Its a little motel right across Dixie Hwy a lot of people really seem to like it. The website is http://www.oldemillinnofclarkston.com
and the phone number is 248/623-0300. The location and price can't be beat.
If you prefer a chain with a pool, fitness rooms etc. take a look at the accommodations list under the fans tab of this website. There is a full list of all of the closest motels & hotels.