The second weekend of Fiesta, good choice. Usually the mass influx is for the first weekend anyway, there are alot of motels along the I-25 corridor near the park. If driving is not a problem there are several along I-40 West of the river. I think Rt66 Casino does a promo during that time also. Make sure you put on your list of things to do the Balloon Museum, If you haven't been in a while it is a must do place, any of the 'Glows', special shapes on Thursday and Friday. You can PM me for dining ideas too.
Bill