An inquiry says children are living in "appalling conditions" and suffering impacts to their health.