V happy in guiseley and meets all the criteria you are looking for, as others have said. We can ride from our house, 12 mins on the train to leeds and a good range of local schools. There are a number of new builds going up which can be cheaper than the traditional old stone property. There is a big development of an old hospital (High Royds) which I’d avoid, unless you like lunatic asylums from the 1800s. They are promoting it under a number of different names to loose the hospital link. On the plus side it does have a bridleway running through it! Seriously consider anything on the wharfedale line as most of the villages are really nice. If you like the area but want to spend less, look at otley, but you will be without a train station.
Feel free to drop me a line if you are looking for any local info on guiseley or would like a guided tour.