I hope you're not looking to buy a gentleman's club type property in Atenas, as I think that would be WAYYY off the mark. If you're talking about places to check out at the end of the day after you've been looking for some regular investment property, you're probably not going to have much luck either. If there were anything at all in Atenas itself, I'm sure it would be geared to a local tico market. Any halfway decent looking chicas are probably going to make the drive to where there will be more demand and money. If you don't want to make the half hour drive yourself, your best bet would probably be to look in Alajuela, which is only about 10 minutes away. I know that D'Pelufo's has a 2nd club out there near the airport. I'm sure there are probably a few other local places in Alajuela.
Now as to non-monger issues. I happen to like Atenas very much. Some of the more interesting eateries in CR are located in Atenas. They specialize in dishes made with corn. One of my favorites is the Fiesta del Maiz, but there are several others. As you probably already know Atenas has a slightly warmer climate than SJ, which some people might prefer. RBC actually sold them a little short in this regard. Some internationally recognized magazine, I forget which, a few years back awarded it the title of one of the best climates in the WORLD. It is also well located being only 35km from SJ and 50km from the Pacific. It is a bit further out from downtown than some would prefer (or you wouldn't have any hesitation about going into town for the evening vs. staying local) but it is not absolutely out of reach and, on the upside, it is more relaxed and idllyic than most of the more urban locations closer to SJ.
It will probably be a little difficult to find any super bargains in the Atenas area because property values have already risen dramatically in recent years due to the near completion of the alternate highway to the coast that will go between Atenas and Orotina (drastically shortening travel time). You're also not as likely to find what bargains there are by searching on line. Those internet sites, particularly english language sites, are geared to the gringo market, meaning the will list the much higher gringo prices. They will give you an idea of some of the types of properties that are available there, but will be no substitute for actually going there and driving around.
But as long as you are looking on line, check out
http://www.myatenas.com/.