If you do buy the condo, make sure you get the correct insurance, H06 landlord policy that will protect you for loss of income and rents, liability and wrongful eviction.
We lived in Dublin for many years, and we are looking to move back up there.
We were very impressed with Clayton; small town flavor, but close to everything.
I think it would be next best to Walnut Creek.
Good luck and may God bless