Brokensemaphore, where is your husband going to be working? West Yorkshire covers quite a large area; surely knowing that would help narrow things down a bit. Also, will he/you have a car for commuting and shopping? Do you need to live near a train station or near a good bus route? Do you think you'll be in this place long enough to be concerned about schools? School starts earlier here than in the US, so maybe that's an important consideration.
I also wouldn't rule out Bradford. There are nice, as well as nasty bits, as there are in Leeds and probably everywhere. In Leeds, Horsforth and Shadwell are areas that haven't been mentioned, which are closer to the outskirts than some of the others. There are several nice towns to the north of Leeds, notably Otley, Menston, Burley in Wharfedale, and Ilkley. All of these except Otley are on a train line into Leeds. Ilkley is pretty expensive, though. Wetherby is a nice town a bit further afield, and there are several really nice small towns between there and Leeds, but you would probably need a car to live in that area. Boston Spa is another nice area.
If you've found nice, affordable houses in Bradford, why not mention the areas they are in - people here may know whether or not they are ok.
Just read Yorkshire/Virginia's post, with which I am in basic agreement. But thought I would mention that the commute on the train from Ilkley is a different propostion than from any of the towns closer in to Leeds on that line. Ilkley is at the end of the line, so there is no trouble getting a seat during rush hour. People taking the train from Burley, Menston, or Guiseley can have trouble getting a seat during rush hour, and people in Guiseley have even been left standing at the station because of crowded trains.