Not sure what happened, but the SharePoint Foundation Application Web service is stuck on "Upgrading" status.
Browsing the site gives a 404. Tried restarting IIS, AppPools etc.
Have no clue how to resolve - I did try running the following command:
stsadm -o provisionservice -action start -servicetype spwebservice
This has not helped - any assistance much appreciated!