Three secondary schools here. One only 6 years old, but supposed to be good, very good Ofsted etc. Right at the other end of town, so caters mainly for that end of town, the villages on that side of town and the next town a few miles on. No-one my side of town would send their children there simply because it doesn't make sense with 2 great schools on our doorstep, but most of those I know who live near the new school seem to like it.
The two other schools are right next door to one another, their playing fields literally merging. Both are really good, one especially has brilliant academic reputation, in Ofsted's best of best list etc, although the other is also well regarded.
No real competition to get into those 2 - everyone living in the town itself (i.e. not villages) is in catchment for both. Children living in villages nearby are 'allocated' to one or other of the two schools, but can still apply to the other and always get in except in really oversubscribed years - this is very rare. I don't know anyone in the 10 years I've lived here who hasn't got into their first choice. Many of us only put one choice down on the application form.
No selection, academic or otherwise. House prices aren't affected because everyone is in catchment for both schools - so you could live in the roughest area (and there are a few!) or the most expensive house in the town, and you'd have the same chance of getting into the schools.
In practise, parents seem to choose the school they like the feel of best, although there is a minority but growing trend for parents to let each child choose for themselves, because of the schools being next to one another. I know lots of families with children at both schools.