We stayed for a week at Elsas place. Her and her boyfriend were really nice, discrete but always helpful when we had a problem.
The room itself is cozy and clean, you'll have your own private bathroom so it's almost as if you have your own flat.
Elsa lives 300m away from train station Francelos, from where it takes 15 minutes to station General Torres or 25 to Sao Bento. Only problem is that trains don't come that often and don't always stop at every station, so you should be flexible and have some time to spare if you want to go to city center.
However, the beach is just a 15 minutes walk away from her flat, so I imagine it could be a great place for relaxing beach holidays!
All in all, we had a great time and it was quite perfect for our chill holidays!