A console application runs at the command prompt console. It has no graphical UI only plain text. Usually these are for utilities that don't require a lot of interaction.
A windows application is a windows form(s) application that has a typical looking windows graphical UI.
A web application is an application that runs on a web server and serves HTML and is accessed thru a web browser.