Unlike many areas across England, affordable housing has been deemed suitable in Newark and Sherwood, a new study suggests.