This location would probably not permit a modular home since it's located on the peninsula, but it would be easy to check with the city Architecture Review Board to see what is actually permitted. The city has their own "rules" and then there might be additional requirements added by the neighborhood association, if there is one. My understanding is that you are referring to a "modular" home, as stated and not a "manufactured" home which generally refers to a mobile home. You might also check with some modular home builders to see if they can help you determine where they can build their homes. Let me know if you'd like some names of local Modular home builders. Good luck!
Carolina One Real Estate