I'm not sure if there is an 'ideal' – but I don't think I could compromise on: well, you have to fancy them, obviously, things like honesty/decency, similar intelligence, similar values, OK with money
My 'ideal' man had all those things the OP mentioned (okay, he was at uni, but he's likely to get a decent job from it, and I didn't note 'sporty' as a necessity). I probably made concessions on a few things – like him being 'too' into biking, forgetting things, etc. but it was all very small and crucially, none of it felt like like I was giving up anything – I didn't secretly resent him; I accepted it was part of who he is.
My mum's friend has had a number of boyfriends in the past, but she says she was too picky and feels 'it's too late now'. I think that's very sad.
Don't dismiss someone because they aren't sporty btw – I certainly wasn't. But I realised that if I was going to stay with my then OH, I would probably have to take up biking, (it was more because I didn't understand what he was talking about most of the time!) and I happily did.
As far as job goes – it's far more important to me that that person has some sort of (though not too much) ambition/drive – as long as he isn't a lazy sod then I don't really mind what kind of job he has, as long as he can support himself.
One other crucial thing you need to look for in a partner though, is make damn well sure they fancy you!