Not sure where the Comp USAs are, but there are several cute neighborhoods near CCAD that will still be far enough away from Ohio State. Try Victorian, Italian or German Village. All cute- with some really pricey and some not so pricey rentals. $500 for a 2 bedroom will be tough- but if you go through independent realtors, you should be able to find something. See if you can get your hands on a Columbus Alive or TriVillage (Suburaban) Newspaper somehow- they both have rental properties listed and will give you a good idea of
C-bus goings on. When in Columbus, I highly recommend checking out Wholly Craft on High St.