You definatley need to look at
www.sunstateaviation.com . They have an excellent fleet of very nice aircraft at very reasonable prices. They also have a preferencial arrangement with the local Super 8 motel on US192 so theres plenty to do outside of flying!!
They've got excellent instructors also. I've flown with them for on three occaisions and have logged about sixty hours on their wonderful 172's.
Jim
p.s I'm in no way affiliated with them- just a satisfied customer.