@Sunflower2019 Sadly, unless someone in your family has additional needs, or there are 2 children of different genders over the age of 10, you are probably never going to get an offer... Especially as your youngest won't be over 10 for nearly 10 years!
By the time you get anywhere near an offer, your DD will probably have left home/left for uni. (Because more and more people in more need, will keep coming onto the list...)
Have you thought about picking properties, not only in 'undesirable areas' but also rural/semi remote with no amenities or public transport? (If you have no car that's no good of course...) My friend did this after being classed as 'suitably housed'... she picked a house in a village 3.5 miles from any shops or doctors or anything, with no public transport.
And after a year and a half of bidding on nearly 100 properties on a housing association list, and only being 40th to 70th on the list each time, she started ending up at No 5, and then No 4, and then No 6, and then No 2, and then on the fifth attempt, she was 1st. She got an offer, she took it, and she is still there! After 5 years.
She loves it too. Says it's the best place she has ever lived. There are no real amenities and no public transport, but there is a little pub, a Church, a little parish hall that has village groups, course, and meet-ups, and a strong, close community who rally round and help anyone who is in need. It's also in a stunningly pretty area.
The house is lovely too, and in a little cul de sac of just 12 properties, and it has beautiful views. She also has a tenancy for life, and only pays £70 a week rent, (and all of the repairs and maintenance is included obviously...)