From Traquair, the SNT follows a road and climbs gently before taking to a forest path. Here the Tweed valley narrows, and you’ll get some nice views from clearings. After linking a few different tracks along the wooded hillside, you’ll rejoin the road and take it the rest of the way to Cardrona, a village with a coffee shop and a few other amenities.
From there, follow the cycle path (a converted railway) over a bridge and through a resort golf course. Past the course, you’ll see the ruined Horsbrugh Castle nearby. The cycle path continues along the edge of forestry and fields. Eventually, a walker's path detours slightly from the cycle path, but they both follow the river until Peebles town centre. Peebles has all sorts of accommodations, including a holiday park with campsites.
Sources:
https://www.walkhighlands.co.uk/borders/traquair-peebles.shtml
https://youtu.be/cFtbC4TV4VI