If you belong to a HOA then you can simply ask for a copy of the CC&R's. (Covenants, Conditions and Restrictions)
If you live in 28207, all the deed restrictions will be on record in the Mecklenburg County Register of Deeds. In that zip code, you may find some restrictions that are no longer enforceable. For the most accurate information, you should hire an attorney to do a title search and advise which restrictions are applicable. You will need to make a special request to also pull any owners association records when they search title.
If you want to find out what the building restrictions are, you should go to planning and zoning to find out about setbacks and the building permit counter to ask about applicable codes and code required upgrades. There was some recent talk of a historic overlay district which may prohibit "McMansions" in the Myers Park and Dilworth areas, so you should ask about that also. If you appreciate an answer, please give "thumbs up". For the most helpful answer, please say thanks with a "best answer" click.
the county courthouse will have a copy of the deed restrictions. Also if you have an HOA the management company for yoru association will have a copy of them on file that you can request a copy of.
Keller Williams Realty-Ballantyne Area Market Center