Tucked away in an unbeatable location, this gorgeous property is just waiting to be enjoyed by the right homebuyer