You probably won't get a better location for your trip. A two minute walk to the train which has you in Cascais in less than ten minutes and into Lisbon in just over half an hour. We purcased a Beach Pass train ticket for €12 for seven days which entitled us to unlimited travel on the train thereafter. The local beach is a short stroll of less than five minutes, however we preferred the nearby Estoril beach, which took less than five minutes on the train. You won't get any views from your apartment but the location makes up for this. The apartment itself is really tastily decorated and was very comfortable and quiet. Ideal for a family of six.