The great thing about staying in Sainte-Foy-La-Grande is that you don't necessarily need your own transport. The train system is excellent: Bordeaux is an hour away, St Emilion for exploring the vineyards is 25 minutes and Bergerac, with its airport, great shops and restaurants, just 15 minutes.
The TGV from Paris to Libourne takes three hours; change here and then take the train to Ste Foy - it takes around 30 minutes. The schedules are the same as above.
Coming by road from Bergerac, take the D936 direct to Ste Foy.