I am the guy who took multiple stabs at trying to solve the first six or eight steps of a modified version of the 'Drake Equation' using the best available data. Verdict: within 50 parsecs (roughly 165 light-years), there might be 4-6 Earth-like worlds and maybe triple that number of marginally habitable planets. This does not mean 'worlds with sapient aliens,' merely worlds with life.
I included one such marginal planet (Dagon's World) in my 'Empire' series, and much of the current WIP is set on another.