Depending on your budget and musical tastes, if you want an older home, you might enjoy either Highland Park/Pecan Valley on the Southeast Side or South Presa/Blue Star area just south of Downtown. You can also look at the Jefferson area around Fredericksburg Road and Alta Vista/Monte Vista/ just north of Downtown (though it is pricey). The 78216 zip code along 281 also has nice older homes.
For a more modern home and a wider selection of clubs and restaurants, the North Central area along the 281 corridor is the place to be. But there are many nice areas across the city.
Because you have no kids, I would avoid the Alamo Heights area, where you will pay a huge premium for a school district you wont use.
Let me know what area you are going to work in and I can give you a better idea. Click on my photo to email me.