Are street parking and the very small lot at the back are the only parking options ?

Yeah, but street parking is pretty easy in the neighborhood.

There are plenty of spots on the neighborhood streets directly around Agora that are very close walking distance.

Yes

Parking is a challenge, but it doesn't stop me. Fun place to visit

yes, and on the weekend, it isn't pretty! nor is it worth the aggravation!