unfortunately, due to the location of the property and association regulations the pilings cannot be concrete.
Your soils guy may be an excellent source for options, along with steel pipe pin options you may wish to investigate helical micro-piles as well, such as those provided by
AB Chance. They are excellent for resisting uplift and have fair bearing capacities, their advantages include speed of installation, and are much more noise-friendly than driven piles.