Best/cheapest fancy camera?

By "fancy" camera I mean like the ones professional photographers use… Or one like it that's way cheaper! Basically not a small, digital point and shoot one.

- What is a good "fancy" (DSLR or called something like that… ) to buy that's not over the top expensive. Nothing over about $200. The less- the better!

- Where is a good place to get one?

- How much?

- Places I can look for the best deals?

Thanks! I'm also taking a photography class and we have the fancy cameras, in which I am in love with. They look something like this:

http://catholichotdish.com/wp-content/uploads/2010/12/Nikon_D3100_DSLR_is_First_to_Bring_Real_Video_Autofocus_Nikon_D3100_Debuts_With_Low_Pricing_038_Fancy_Specs_1.jpg
Added (1). It doesn't have to be a DSLR… Just coming more than a point and shoot camera!
>>> Best/cheapest fancy camera?

How to auto focus in video mode on a nikon d90?

How do i focus in video mode on my d90 without rotating the ring?
>>> How to auto focus in video mode on a nikon d90?

Tips for shopping on Ebay?

I'm a photographer and am looking to upgrade my camera. I want to buy a Nikon D7000, preferably in a kit that comes with two lenses, a carrying case, and a memory card. I found a kit on Ebay for about $1, 200.
I've never bought anything off of Ebay before, and this looks pretty sketchy even though all the reviews I've read are positive.It's highly undervalued for a camera kit of its kind, which is why I feel it's sketchy.
Anyone have any tips or advice?
Here's the link to the camera, please if you think it's a rip off, let me know!
http://www.ebay.com/itm/NEW-Nikon-D7000-16-2-MP-SLR-Camera-18-200-mm-3-Lens-16-GB-Camera-Kit-More-/121055737930?pt=Digital_Cameras&hash=item1c2f7bf84a
>>> Tips for shopping on Ebay?

Best Portrait Settings for Nikon D3100?

I want to take stunning high depth portraits of my friends and of myself. I would like something you would see on Tumblr. -

Now some information - i have the regular Lens that came with the D3100, i am not an experienced photographer, the only settings i have and know of for portraits is the Portrait setting on the camera.
i am looking for more in depth settings, to change around and shutter options etc.
>>> Best Portrait Settings for Nikon D3100?

I am thinking about upgrading my camera?

I currently have a Nikon D3100, which would be better a Canon T3i or a Nikon D 3200
Added (1). I have 3 Nikon lenses with my Nikon an a Canon Eos rebel K2, 35mm format with 2 EF-S lenses
Added (2). I have 3 Nikon lenses with my Nikon an a Canon Eos rebel K2, 35mm format with 2 EF-S lenses
>>> I am thinking about upgrading my camera?

Canon EOS 60D DSLR or Nikon’s D7000?

I want a camera that's very good in low light situations, a camera that can take fast movements pictures (example: taking pictures of someone on a whitewater rafting), weddings, portraits, scenery. And also has a good battery life.
Which one will be best? I'm starting a new venture as a photographer but do not have enough money to buy the best and expensive camera. Please help me with suggestions. Thanks in advance.

In addition, can I get suggestions on which lens to use for each camera that can help me take bring life to my pictures? Thanks again.
>>> Canon EOS 60D DSLR or Nikon's D7000?

Canon EOS 60D DSLR or Nikon’s D7000? - 1

Canon EOS 60D DSLR or Nikon's D7000?

I want a camera that's very good in low light situations, a camera that can take fast movements pictures (example: taking pictures of someone on a whitewater rafting), weddings, portraits, scenery. And also has a good battery life.
Which one will be best? I'm starting a new venture as a photographer but do not have enough money to buy the best and expensive camera. Please help me with suggestions. Thanks in advance.
>>> Canon EOS 60D DSLR or Nikon's D7000? - 1

Where i get used nikon lenses in abu dhabi?

Where i get used nikon lenses in abu dhabi?
>>> Where i get used nikon lenses in abu dhabi?

Which one: Canon EOS 60D DSLR or Nikon’s D7000?

I want a camera that's very good in low light situations, a camera that can take fast movements pictures (example: taking pictures of someone on a whitewater rafting), weddings, portraits, scenery.
Which one will be best? I'm starting a new venture as a photographer but do not have enough money to buy the best and expensive camera. Please help me with suggestions. Thanks in advance.
>>> Which one: Canon EOS 60D DSLR or Nikon's D7000?

Wireless remote control for Nikon D3100 to auto-focus in video?

Okay, so I have a Nikon D3100 and have recently found that it's not possibly to auto-focus the camera without being behind it so that someone is able to push the shutter release button half-way down. Which is a problem for me.As I want to shoot a video of myself in front of the camera, and have the camera to auto-focus on me when I'm in front of the camera lens- which isn't possible as I cannot push down the shutter button without behind behind the camera.
Anyway, I was wondering if it is possible to buy a wireless remote that will enable me to use auto-focus whilst I'm in front of the camera.

Sorry if this doesn't make much sense, I don't have much experience when it comes to shooting video. Thank you, I appreciate your time.
>>> Wireless remote control for Nikon D3100 to auto-focus in video?