To cry out of frustration

[MaMattoo]

So, we were desperately house hunting last year to get near a good state school as DS starts in Sept at Reception. That did not work out, property markets being slippery and on the upward meant we looked and found nothing that suited us near schools that we liked. Zero there.
We then got poor DS 3.6 to get through 4+ assessment for some local well reputed, over subscribed prep schools. We did not get through. Zero there.
So now I am stuck at the end of the admissions time, with a 'good' to 'okay' primary school for which I filled forms, which I can see from my bedroom. We will get in. It is just that I dont particularly like the school. But I am all out of options. yes?
In year admissions seems to be a clear as mud process. Thus I am unsure what my options are. Small rented house, next to a so-so school. And I can do NOTHING about it. Moving house is now too late an idea. And moving wont guarantee anything.
AIBU to be sitting in puddles of tears about it?

What are your objections to th school?

A talented child can still excel at a normal school. Other things have a big influence - parental involvement is actually the stronger indicator of educational attainment.

And, you know, he's three and a half, ease up on him a bit!

I think a good to okay school within sight may be a good idea after all. Schools are up and down a lot of the time and it may well be outstanding next time? I would certainly avoid in year admissions, I had to do this twice for my DD and it affected her friendships/confidence enormously. She is now thankfully at a secondary school. I would also advise a school with friends locally, as there is nothing worse than a child not having any playmates nearby as they grow up.

Also agree with Rhonda a bright child will excel whatever the school.

My DD went to a school that went from Good to special measures while she was there but still did really well!

She's now at high school and in the G&T programme. So don't panic, it's not all about the Ofsted!

Thank you for your replies. I am just so upset that my hands are tied.
I am not putting any pressure on my child, which is why I took prep assessments on face value. I did not tutor him at any level. He is calm, happy child with a mind of his own!!
I can't describe what I don't like - it's just a feeling/vibe I get.
I guess the whole you don't have a choice though you might think you do bothers me. A lot.
I just want him to be in a good school and settle down. Here, we are kind of stuck. If we buy a home away from here I will fall into the in year loop hole automatically won't I? So it's a no win situation.

Also agree with Rhonda a bright child will excel whatever the school

That's wonderful but what about the not-so-bright children?

Or do mumsnetters only have bright children?

OP I guess you could not send him to school this year, and put him on the waiting list for the school(s) you like?

Thanks yes, I guess that is an option but he seems to be ready for school. Full of questions and curiously, nosy about concepts and workings of the car and the fridge and laptop..it would be unfair..
I guess I shall take advice about letting a child shine if he will, he will do so anywhere. The next point out of the school would be at 7 right?