This is a very well-positioned flat in Bordeaux, 2 minutes walk from a tram station located on the river (the station itself being a 5 minute tram ride from the main train station). Bordeaux is a very walkable city, and the positioning of the flat made it very easy for us to explore the city.
The flat is relatively cool in terms of temperature but be warned that there is no air conditioning so at the very hot times in the year (i.e. 30C plus) the flat might be a bit warm at night.