Mel's flat is very cozy and good located in the city. If you want to visit Arcachon or the Dune du Pilat it's the perfect place. The trainstation Bordeaux-Saint-Jean is just a 2 minutes walk away. But if you want to visit the city only the way is really long for walking. It takes about 25-30 minutes but thats okay. If you don't want to walk you can catch a bus or tram at the station Bordeaux-Saint-Jean.
The flat itself is small but good equipped for a short city trip. The view from the sofa/bed is fantastic, at the day and espacially at night. The kitchen is small but okay like the rest of the flat.
The big windows and glassdoor for the balcony is not airtight so you hear a lot of noise from the street and train station. Furthermore it gets really cold at night.
But in total the flat is optimal for a short trip and if I will be in Bordeaux once more I would choose Mels flat again.