Well... Clearwater is nice where I live, so is Valrico where Bill Rich lives, both are a good 45-60 minute drive to the field in Manatee County, just over the Sunshine Skyway Bridge.
There ARE NO OTHER Tampa Bay club C/L fields... there are some on the other coast near Palm Bay, or over towards Orlando, Jacksonville, or more south towards Venice.
FYI - They are battling the de-funding of flood insurance for flood zones, so buyer beware. If you want waterfront or beach community, some local residents were hit with 5 figure flood insurance this year!
That said, get with a realtor, pinpoint your job and the MCRC field on a map, ( 7315 71'st Ave East Palmetto, Florida 34222 ) and tell the realtor what you want or use one of the on-line realestate search engines.
Shopping long-distance is kinda hard, because no matter what I tell you, that won't be where you end up because either nothing you like will be available there, or something else will get your attention.
As far as what areas to avoid, almost every little berg has a low rent district, and a red light district, first decide what berg you will end up in, then maybe we can talk about what to avoid, if I'm familiar with that area.
Hope that helps!
EricV