That's in Lafayette Square in St. Louis. It's a pretty nice neighborhood from what I understand. In fact, I think the yellow house in that picture is currently for sale for $475k, which tends to be on the higher side in St. Louis. I doubt you'll need 4 beds and 2.5 baths, though.
The Central West End is nice as well.
Soulard is apparently pretty nice as well. The Soulard Market sells fresh produce (and other stuff) and has been operating since the early 19th century, I think.
Thanks to
Urban St. Louis - View Forum - Photography - Showcase St. Louis for the pictures
Downtown (a little bit of it). A lot of lofts have been built downtown, but they can be on the higher end, depending on what you want.
If you decide on St. Louis
Coldwell Banker Gundaker -- Your site for St. Louis Real Estate (http://www.cbgundaker.com/buying/ - broken link) may help, as well as stltoday.com or craigslist.
Some shops and cafes in The Loop.
some of the Old North St. Louis is undergoing renovation, but I won't lie to you, a lot of it is ugly. However, if this renovation continues, it may be a good investment opportunity. Old North St. Louis Restoration Group is working on the area, restoring old buildings and putting up new houses that fit in with the older style.
The Ugly:
http://img99.imageshack.us/img99/8430/some1carescopyup8.jpg (broken link)
Coming back:
http://img183.imageshack.us/img183/3542/nm1de6.jpg (broken link)
Anyway, I hope you like the pictures. They are NOT mine, by the way. Check out
Urban St. Louis - View Forum - Photography - Showcase St. Louis to see lots more pictures. You can't tell everything about a city by pictures, but I hope this helps. apartments on Craigslist can be had for as low as about $450, and a high-end downtown loft might cost you $1500. Crime can be bad, but if you use common sense you should be okay. I've heard that the North Side tends to have more crime than the rest of the city, but I don't live there so I can't tell you for sure. There are great neighborhoods in St. Louis, and I'd think you could walk or ride the MetroBus or MetroLink betwee most of them.
And there's also the Blues (NHL), Cardinals (MLB), Rams (NFL), and (hopefully) an MLS team in a few years.