Erwan & Justine's apartment is very comfortable and they have great local tips for food, visiting and generally enjoying a stay in Bordeaux.
While the apartment isn't very close to the station it's located close enough to a lot of the major places to visit in Bordeaux.
I'd highly recommend staying at their place!