What is your budget? Affordable is relative.
Hodges and Beach is NOT walkable at all.
The only walkable neighborhoods in the city are Riverside & Avondale historic district, Springfield historic district, San Marco, parts of Murray Hill, and the beaches area East of 3rd Street.
Avondale is very nice, and if you like it, you'll also like Riverside and San Marco. Springfield is sort of the same, but not as revitalized yet.
Depending on your budget, I'd look at Riverside & Avondale and San Marco first.