My girlfriend and I had an amazing time in Guia. We arrived in mid October and stayed for a whole month. The flat is very spacious, has a lot of light and is equipped with everything you need (including washing machine, beach chairs, umbrella, ...) . Probably the best thing was the short distance to the beach where you can experience wonderful sunsets. Staying in October / November wasn't a bad choice. You have the area for almost yourself and the weather was warm enough to jump into the pool or sea.
If you arrive by car (recommended) you get a parking spot in the garage, which is directly accessible by elevator.
As for remote workers: internet is great. Just the dinning table / chairs were not that comfy.
Thank you to Catarina, our host, who was very responsive and helped us with everything we needed.
Bairro
As we were there in October the area was very calm. You have a small supermarket in walking distance, but for more we went to Continente in the Algarve Shopping center (15 mins by car).
Other than that you have the amazing and very large beach and lagoon around you. You can even walk on the beach to the next town (Armação de Pêra).
Lugares recomendados nas proximidades
The beach bar Os Salgados, is a 5 minutes walk away and good for working remotely. Try the fries or one of the cocktails. The restaurant Museo dos Salgado (15 mins walk) and O cantinho da Susi.