scoped out select and join for homes due to large amount of fields