Sandy to St Ives is a complete arse of a journey - no direct route due to river being in the way.
Cambourne a bit better but not much really. You are looking at places a looong way from Sandy if you are looking at Alconbury - he will spend a lot of time sat in traffic at the Black Cat roundabout everyday. Swavesey also bloody miles away over country roads.
Also bear in mind that the new A428 highway will be being built - currently have everything crossed for orange route which seems most popular locally but lots of currently lovely looking countryside may be affected.
If you don't want to look actually in Sandy then what about surrounding villages such as Potton, Gamlingay, Waresley, Abbotsley (at risk from pink and purple routes)
St Neots is um, not nice, but massively cheaper than Cambridge, quicker into London than Sandy and will get much quicker into Cambridge if the orange route is built. Have a look at the propsed routes as they also make it very obvious where new housing developments around St Neots are likely. Schools currently not great in St Neots either but hopefully will change as so many people being priced out of Cambridge.
There are also lots of lovely villages going South round Biggleswade. I don't know Biggleswade so well as I tend to go to St Neots/Huntingdon/Cambridge but it's a reasonable size market town and again a good selection of villages roundabout.
Basically I think you are much better looking local to Sandy or South in Biggleswade as commuting to Sandy/London from Alconbury/Swavesey/St Ives/Cambourne will drive your husband bonkers.