Close accommodation to the train station but you will need to catch a bus to get to Bordeaux city. Bus from the airport drops you straight at the door of the apartment.