You're looking for 3 bedrooms. Rent will probably run into the $1200+ range for a single family home, although you may find something for less.
Cary schools are good. All schools in Wake County are managed as part of the Wake County Public School System.
Wake County Public School System
If your husband is a truly skilled carpenter, he will be able to find work. I can't speak about wages. Is he a wood worker, or a framer?
And nails? I bite mine...