Definitely not the one of the due torri that is accessible. It's a long way up!
The city centre is a little unusually shaped, taking us a while to get the hang of it. Piazza Nettuno is structurally the centre, with roads typically radiating out from it. However it's not as simple as a circular centre, as each road has a different level of interest. On the Southern side, Via Farini is the fancy shopping area, but do have a look at the porticoes above the southern side of that road - some serious artistry evidenced.
The Basilica (di San Petronio) in the opposite corner of Pizza Nettuno to the Neptune fountain/statue is well worth a look around, allowing for someone to just sit down and take it in or have brief sit downs if really taking it all in. Plenty of other churches offering the chance of a 5-10 minute rest of weary legs, whilst also there is usually plenty to see. The food streets in the old criss-cross block around via Clavature / Via Caprarie are 'high density' in terms of seeing a lot without having to walk too far. As mentioned in another thread, do avoid any recognition of the african street beggars as they are very persistent. They are nicely placed between Piazza Nettuno & Le due torri.
Quite a few cobbled streets, so do beware of spending too much time on these, as it can go quickly through the bones.
There are some good wine bars, this not the cheapest for wines bought off the shleves, but brought genuine 'southern warmth' to cooking, ambience and by the glass wine choice - In Vino Veritas Via Garibaldi Giuseppe, 9F which is due south of Piazza Nettuno fountain. I got the impression they were quite happy to open anything if you were going to have a couple of glasses from the bottle. Faccioli is more centrally located and doesn't have the same ambience, but does have age/character. A good option for a glass of something good or modest, especially as it is so centrally located.
Best selection in wine shops is Enoteca Italiana on via Marsala heading towards the student quarter ( a very brief walk north west of piazza nettuno). Prices are a little inflated (maybe + 5-10% ) but the selection is very large, and there are a few seats to grab a coffee or glass of wine, or even a light bite, whilst the other person browses the shelves. Much better value, and in my mind a better shop, is the rather oddly / inaccurately named wine shop Enoteca caffe Bazar on Via Guerrazzi, 8. The prices are very competitive, but with plenty of choice from the humdrum, through the quirky to the blingy.
Museums etc. that might / might not appeal, including some utterly quirky medical museums that are a combination of artistic / ghoulish / scientific. The tourist office in Piazza Nettuno are good / helpful.
Eating out we've had surprisingly mixed experiences. For a very chilled time, In vino veritas mentioned above would be my choice. Good rustic food and good food friendly wines set at wooden tables between shelves of wine. For more interesting food with a very decent wine list, Sette Tavoli has done us well. The setup here is unusual, in that the chef takes on a different region of Italy every month, showcasing the regional style in the dishes. It's a similar distance walk from the centre (maybe 10 mins) and has the option to eat outside on a very quiet street, which should be plenty warm enough to do now, or inside. I remember we had a very fairly priced bottle of Les Cretes Chardonnay cuvee Bois from Aosta last time, and it was brilliant. They also had (wet) smoked Mozzarella in the antipasti, so I got the name of their supplier to chase that the next day. It is obscenely tasty.
Another that might appeal, though around 1pm it's pretty manic, is Tamburini. This is a famed food shop near the Due Torri, but they also serve up 'cafetteria' food. It's chaotic and confusing, but the food is rustic & tasty & fairly priced.
If buying balsamic vinegar to take home, trading up rapidly increases quality. The difference between (say) a 5 and an 8 year old can be immense. The 20-30 year old ones are noticeably better, but by the time you've got to this level, it's a case of diminishing extra return. Playing at the 8-10 year old level seems to be ideal value for money.
The local gelato is generally very good (the simplest advice is be wary of places that mound it up with lots of toppings over it in the tray. The best are generally displayed 'flat'. Even the less good ones are still very good though. There was also one place (I think Gelateria Gianni on via Monte Grappa) that did Pere e Gorgonzola (Pear and Gorginzola blue cheese) that I'm kicking myself for not trying. There is real innovation afoot in gelato flavours, with some utterly bizarre ones that I suspect are made for the sort of restaurants that believe in molecular gastronomy.
Also worth checking the tourist site for events - there is always something going on in Bologna, and chance might bring up something really interesting.
To finish here's the Bologna section of the crib sheet I took away last year. As ever, way more listed than we'd need, but nice to be able to fall back to it when needed:
[This next one might be worth checking - they seemed to be organising a few bus tours from the tourist office / tourist office website. Prices as you'll see below are modest]. If you really want to splash the cash, then Bologna has a number of balsamic vinegar produce tours (also Parmesan and Prosciutto producers). They aren't cheap, but we self-organised a visit to Ermete Medici's place and it was very interesting.
Red bus tour The fascinating Park-Museum of Ca ' Ghirona will be the focus of "summer in Villa": 5 September at 17.30 we will start for Ponte Ronca (via l. da Vinci 19) to admire the art collections and the surrounding nature with final buffet offered at the restaurant Giocondo. Cost 18 euros, departing from Piazza Nettuno.
Markets
Fri/Sat : Piazza VIII Agosto (Also with flea market up the steps in the giardini publici)
Mercato delle Erbe – via Ugo Bassi 2 (7:15-1pm & 5-7pm Thu Sat pm
Via Clavature/Drapperie Mon Tues Wed Fri Sat: 7 am to 1pm and 4:15 to 7:30 pm; Thursday: 7am to 1pm
Piazza Aldrovandi street market thu pm
Farmer’s market, via di gomito 30, Wed 2.30pm to 6.30pm (Summer hours approx. 4pm to 8pm). Out of town
Mercato del collezionismo, Piazza VIII Agosto, Thu 8.30-6pm
Restaurants
Ciacco – via San Simone 1/c nr Piazza Maggiore/Jewish Quarter (051265441) ~€40 Cellar of an old Palazzo soecialising in seafood Sun
* Divinis – Via Battibecco 4c (Enoteca for breakfast, aperitivi, tasty food) Tue Eve, Wed
Ristorante Scacco Matto, via Broccaaindosso 63b tel 051 263404 Mon lunch
Trattoria Gigina, via Stendhal 1 sat/aug (moderate) 051/622300 Sat Aug
Trattoria del Rosso, via Augusto Righi 30 (moderate-) 051/236730 Aug
Osteria del Sole, Vicolo Ranocci 1 (buy food in market & eat with wines on communal tables) 8-14; 19-20:45
*Trattoria Caminetto d’Oro, via de’ Falegnami 4 (moderate+) wed/sun
Trattoria Meloncello, via Saragozza 240a (typically Bolognese) (moderate) 051/6143947 mon pm / tue
Trattoria Anna Maria, via delle Belle Arti 17a (moderate – famous pasta) 051/266894 mon
*Trattoria Serghei, via Piella 12 (Moderate – good soups) 051/233533 Sat/Sun Aug
Osteria da Madon, via San Vitale 75 (lunchtimes, moderate)
Le Maschere, via Zappoli 5 Sun (Fish – Romagna meets Egypt)
Al Salaam, via Centotrecento 24 (Charming Middle-Eastern) 051244173 Sun
Bottega Albertini, via dei coltelli 9/2 (creative & value) 051 228532 Sun
Acqua Pazza (South-East of the centre), via Murri 168 Sat lunch Mon
Ai Butteri (South-East of the centre), via Murri 22 Sun
Dello Starlino, via Murri 71 Tue
Da Vito, via Monte Albano 5 (Opp. Santuario di San Luca) Tue
*Broccaindossa – via Broccaindossa 7a (succession of antipasti & desserts)
Fantoni – via del Pratello 11 (great VFM)
Faccioli – via Altabella 15b (nr due Torre) (wines and light snacks)Enoteca vini d’Italia - via Emilia Levante 142 (Tasting and snacks) Sun
Birreria Amadeus – via G. Dagnini 1 (SE of city & with NZ beer!)
[Slow] All'Osteria Bottega - Via Santa Caterina, 51 Bologna +39 051 585111
Osteria dell'Orsa - Via Mentana, 1
Ristorante Franco Rossi - Via Goito, 3 (elegant) 051.238818
Trattoria Battibecco - Via Battibecco, 4b 051 223298 (somewhat fancy)
Come una Volta, via Crocetta 15 (traditional – emphasis on the pasta)
* Sette Tavoli, via Cartoleria 15 / 2 , Phone: 051272900 http://www.settetavoli.it (varies weekly by region) Vicolo Colombina, Vicolo Colombina, 5 Really good simple food nr. P. Maggiore
Noir, P. dei Tribunali 6, 051 220118 / 3887562938 (Marco Fadiga bistrot – specialising in fish & seafood) Sun
Di Sandro al Navile, Locanda Lame via del Sostegno 15, 051 634 3100 (Classic Bolognese food) Sun eve
*Tre Leoni, Via F Turati 112, 051 614 3643, elegant not ostentatious, moderate Sun Eve Mon
AlCambio, via Stalingrado 150, 051 328118 Sat lunch Sun
Food Shops
Via Oberdan 45 (Cheese); 16 (Salumeria); 10 (Caffe Terzi – fine coffee); 13 (Bakery); 11 Metalworking (Kitchen)
Via Portanova 7a (Wide Variety), 12/b (Aroma) coffee bar & beans, plus chocs.
Strada Maggiore 35a (Salumeria); 31 Scaramagli (Gastronomia)
Via dei Mille 3 “Salumeria dall’Olio” (also good selection of dried porcini)
Via Orefici 6 – Bottega del Caffe, 19 Eataly
Via Clavature 17a (Roccati Chocolates)
Via pescherie vecchie 2b (Franceschini), mushrooms truffles and balsamic; 3 (Baita) cheese +); 14a (Pescheria del Pavaglione)
Via Massarenti 175 (Drogheria Facchini)
via San Felice 13 (Pielle: coffee preserves etc.), 24 (Ugo: Gelato)
via Cadriano 27/2 L’angolo della Freschezza (cheeses +)
*via Galliera 27, Antica drogheria della Pioggia (old fashioned confectionary etc.)
*Drogheria Olimpia, via Andrea Costa 67c (interesting selection from Italy and abroad) Enoteca Drogheria Gilberto, via Drapperie 9 (Saturday – candlelit aperitivi, rest of time a shop)
Pescheria Brunelli, via Drapperie 6
Antica Aguzzeria del Cavallo, via Drapperie 12b (metalworking)
via Zamboni 8 (Il banco del Pane) – bread and desserts
via A. Di Vincenzo 33d (La Bolognina) fresh handmade pasta
Pasticceria Zanarini, Piazza Galvani 1 (coffee/cakes/ice-cream) mon
Bar-Pasticceria Lambertini, Piazza Aldrovandi 23 via San Vitale (next to food market) Gamberini, via Ugo Bassi 12 (nr Ugo Bassi Market)
Stregate, via Portanuova 7a (tisanes, infusions, chocalates and spices)
La Bolognina, via A di Vicenzo 33/d (fresh pasta)
Pastificio Dolce Sana, via Nani 11/d (fresh pasta)
Le Sfogline, via Belvedere 7a (artisan pasta & torta di Riso)
La Sfogliatella, via Lame 28 (fresh pasta)
Pasticceria Atti e Figli, via Caprarie 7 (Pastries) & via Drapperie 6 (Bread) thu pm / sun
Bar Pasticceria Billi (at foot of steps to Basilica di San Luca) via de Coubertin 1 (artisan)
Plus others in the criss-cross of streets around Tamburini (via Caprarie 1)
Cremeria Funivia, via Porrettana 158/4d & Piazza Cavour 1 (creamy)
*Cremeria Scirocco, via Barelli 1c, creative gelati, including candied celery (sedano candito) & gorgonzola e Noci (walnut) Tonno e Cipolle (Tuna and onion!)
Il Gelatauro, via San Vitale 98b (special focus on ingredients from around the world)
Gelateria delle Moline, via delle Moline 13b (with Sicilian desserts & granite)
Gelateria Gianni, via San Vitale 2 & via Montegrappa 11 (good quality)
Gelateria Ugo, via San Felice 24
Sorbetteria Castiglione, via Castiglione 44 (inc. Sugar free ice cream)
Stefino gelateria artigianale, via Gelleria 49b (good ice-creams and granite)
*Gino Fabbri Pasticcere, via Cadriano 27/2 (Wide variety of cakes & pastries – best in the city)
Il Forno di Calzalori, via delle fragole 1 (Very good bread & biscuits)
I sogni dei Golosi, via Irnerio 17e (artisan bread & cakes/desserts)
Forno Pallotti, via del borgo san pietro 59 (good bread & fresh pasta & coffee & pastries)
Risto Pallotti, via Irnerio 17 (Bistro in student quarter – same people as the bakery above)
Gastronomia Scaramagli, strada Maggiore 31, wines sweets & 25 types of rice.
Majani, via de Carbonesi 5 (good but pricey)
Pasticceria D’Azeglio, via D’Azeglio 69 (traditional including Ciambella)
Salumeria Pasquini e Brusiani, via delle Tofane 38 (Salame Rosa and Mortadella)
Enoteche
Via Castiglione 79a (Enoteca alla Porta, to buy & taste in nice wood lined room)
Cantina di S. Urbano, via degli Ortolani 32/c (wineshop SE edge of city)
Via Marsala 2b (Enoteca Italiano - con degustazione in the evening) Via Petroni (University quarter): 9 large Enoteca Alla Porta large (Enoteca / Drogheria); 9b bio cafe/restaurant (alce Nero)
Cantina Bentvoglio, Via Mascarella 4b (winetasting/food/jazz)
Bottega del Vino Olindo Faccioli, via Altabella 15/b (1 room for tasting, the other for meals)
Zampa e Osvaldo, via Andrea Costa 127 (nice place for a glass of wine & salume/cheese ‘till late)
Antica Drogheria Calzalori, via G. Petroni 9 (1900 labels)
Caffè Bazar, via Guerrazzi 8cGodot Wine Store, via Santo Stefano 12b
Scaramgli dal 1912, Strada da Maggiore 31
Tumadei, via Ortolani 32
Vinicola, via San Felice 48°
Other Shops
Kelemata - Via U. Bassi, 31 & via dell' Independenza (about half way up going north, on the left). My preferred deodorants in very natural fragrances and relatively inexpensive