To spell it out a little bit more:
You don't need to subscribe to any services other than your DSL or Cable modem service as you do today for a wired internet connection.
1) You need to buy a wireless router:
http://www.bestbuy.com/site/olspage.jsp?id=cat01024&type=category&categoryRep=cat01000
I have the Linksys one mentioned there. You'll find 802.11B only routers are cheaper, but you may as well get a 'G' router as they provide more bandwidth. You may be able to take advantage of that if you're doing computer-to-computer transfers and/or have a very high bandwidth cable service. They're also not that much more than the 'B' ones. 'G' is backwards compatible with 'B', so you don't lose out on anything by going 'G'.
2) If you have an Apple laptop, it will have wireless networking built-in. If you have a PC laptop, it may or may not have it. If it doesn't, you'll need to buy a Wi-Fi PCMCIA card, like one listed here:
http://www.bestbuy.com/site/olspage.jsp?type=category&id=cat01032
3) If you're wirelessly connecting a desktop machine, it will likely not have wireless networking built in, and you'll need to buy a card like one of these:
http://www.bestbuy.com/site/olspage.jsp?type=category&id=cat01031
Most are PCI cards that fit inside your machine, although there are also some USB external options as well. Either one is fine.
4) Connect your cable to your cable modem
5) Connect cable modem to wireless router from step 1
6) Plug in your WiFi access card into your laptop or desktop (if it needs it), and you may have to do some software setup. If you're on a Mac, you should see it right away. If you're on a PC and it doesn't work, call whomever is the designated computer nerd in the family (there's always one!), and have them set it up for you
At this point the only thing "wired" is the cable modem and router, which can be hidden away anywhere. All of your machines will now be able to access the internet wirelessly.
Other notes:
-You can enable various levels of security on your router to prevent other people/neighbours from snooping your internet traffic or stealing your service. The simplest is WEP, and then there are more secure methods like WPA, etc. The linksys router has all of these built in. Some routers also allow you to lock access based on MAC address. Each machine has a unique MAC (ethernet) address and you can tell your router to only allow those specific machines to connect.
-Some routers allow you to increase the transmission power to get better range. eg. the linksys mentioned above lets you go up to 300mw. I think it starts off at like 60mw or something. I've got mine set to about 120mw and can hit all parts of my house without any problem.
Hope that helps and doesn't make it sound more complicated than it is.