If you will be working in RTP, look at Apex. I live there and work in Morrisville ( which right next to RTP ). Granted I work from 7-4 but at that time of the morning I get to work in 20 minutes. Which compared to any NJ commute I had is a dream
Also, there are really nice ( and only 2 years old ) apartments literally across from the elementary school my daughter attends. 1 - it's a great school and 2 - he can walk safely if he had to or if you drive it's a hop-skip away. I think the rents there are in your range. Here is a link, with photos and floor plans.
Creekside Hills Apartments in Apex, NC | Apartments.com
The school also has ( which we use and love) a before and after school program through the YMCA. You can drop him off at 7am and it is open until 6pm. Best part is the program is all at the school. No need to drop him off any place else. It is a year round school so we also use them for the track out programs. If you are not aware of that -some schools here are tradtional and others like mine are year round. Meaning they go to school for about 9 weeks at a time then they are off for about 3. For the working parents you would use the track out programs out there. The YMCA as I mentioned has it and best part also is you drop you kid off at the school. They will bus him back to the YMCA for the day then have him back at the school ready for pick up
We love Apex, it's a great town, close to shopping and good commute to rtp, morrisvile and my husband works in Durham. Takes him about 45 minutes. Good luck!