So you know where I am coming from, in addition to my IT activities, I have been selling and installing video surveillance systems into small businesses for a few years.
In order to select the right equipment, there are a couple of initial questions you need to get to.
1. Do you need just one camera or do you need multiple cameras?
2. Do you need to record the surveillance video to hard disk for proof of a break in or to identify someone caught on video?
If the answer to both questions is no, you can use a single IP based surveillance camera.
If the answer to either question is yes, you should use standard non-IP cameras and an IP based DVR. While you could use a PC as a DVR, I don't recommend it. First it would have to stay on all the time. Second, it is easier for an intruder to find a PC while a DVR can be pretty effectively hidden since it is much smaller.
The systems sold by Cotsco and Sam's are usually multiple camera units with a DVR. If you go that way, make sure the DVR is an IP based unit. Not all of them are. Also most of those systems use wired cameras, not wireless one's so you would have to be selective.
The next question is does the camera need to be disguised or hidden or can you use a standard appearing camera? A standard wireless IP camera can be had for in the $200 range while a hidden camera can be double that or more. Hidden cameras are available in all sorts of units like clocks, radios, thermostats, books etc.
Most of these types of systems can trigger on motion detect. They can also send emails when they are triggered so if you can receive emails on your phone, you can be immediately alerted when the camera detects motion.
Triggering on audio is a problem. Those types of systems are too unreliable and are prone to false alarms. Almost anything can trigger them from wind, dogs barking in the neighborhood, or a loud car passing by.
One other thing is that the camera should be able to see in low light using infrared if possible while showing color in good light. Most intrusions will be at night while the lights are off. Make sure the camera you choose has an infrared option.
As I recall, you live in an apartment so I'm guessing that you could get by with a single IP based camera assuming you do not want to record. There are dozens of sources for those but both Linksys and Dlink sell models which should work for you.
Here is a camera from Dlink which should work for you
http://www.dlink.com/products/?pid=510Here is a wireless color camera with infrared LED's built in for low light.
http://securityturf.net/eshop/index.php?main_page=product_info&cPath=2_22&products_id=334One thing with wireless cameras connected to a DVR - Each wireless camera needs a separate wireless receiver which plugs into the DVR ports. These may or may not even be mentioned in ads so you need to ask. Otherwise you may end up with a wireless camera you can't connect to anything. Note that this only applies to non IP cameras.
If you need a hidden camera, check here or use Google
http://securityturf.net/eshop/index.php?main_page=index&cPath=2_18