For macro, you can get something relatively cheap like a Tamron 90mm f/2.8, or Sigma 105mm f/2.8 lens and they also do really good portraits too.

You can get close up adapters that are cheap too, but I think they make close up shots a bit harder to do than a proper macro lens.

D3200 is a good camera

put a 18-105Vr lens on it and it's very versatile. 18-140VR lens is supposedly slightly better, but it cost a lot more and for not as much gain per every extra dollar spent on it.

35/1.8Dx lens is a very good value for money lens.

So there's a specific recommendation: second hand D3200+18-105VR(they used to be able to come in a kit, so you may find some sold in that manner) .. then look for a 35/1.8Dx .. and it should keep you very close to your $500 budget .. maybe a teeny bit over.


ps. the only reason I give you Nikon examples is that I know them much more than I do other systems .. I'm sure Canon/Sony/Olympus/Pentax has something similar to offer too(I just don't know what they are).