@TeeEm has passed on this one, so I'll have a go.
Topology is a very wide field - and the first division you might identify is between
General Topology and
Algebraic Topology. General topology generalizes the topological notions that we find in good wholesome everyday spaces like
Rn to more general sets (and indeed to some pretty pathological monsters). It tends to get taught in the second year at university after you've understood what the topological aspects of ordinary spaces actually are. There's a very good book by Sutherland called "
Introduction to Metric and Topological Spaces" that has been around for donkeys years. But be warned: we do general topology because we have to, not necessarily because we like it! It is not a sexy subject until you get into advanced applications such as fractals.
You've already noted that the fact that universities don't tend to start doing algebraic topology until the third year suggest that it is not really amenable to an elementary treatment. That's very true, it's a subject that builds on what you learn in the first couple of years of university, and represents a pay-off for all that unmotivated slog that you've gone through! So, with that warning in mind, here's a few recommendations:
One of the standard books these days is Allan Hatcher's "
Algebraic Topology". It's very good and it's available in a free online version as well as in print. Try reading the first couple of chapters to get a feeling for the subject. Next up is Singer and Thorpe's "
Lecture Notes on Elementary Topology and Geometry", which gives a good overview of the subject. Finally Massey's "
Algebraic Topology: an Introduction", which is a nice treatment of the beginnings of homotopy theory, but which excludes homology.
Another approach, of course, is to use google and Wikipedia. There's lots of interesting material out there!