Is it gramatically correct to say Where it is at?

Because the Word "at" is a preposition and it is considered grammatically incorrect to end a sentence with a preposition.

No. It is wrong because the "at" is unnecessary. An English sentence may properly end with preposition, for example: Forcing English to comply with Latin grammatical rules is a school-marm trick that no natural speaker puts up with.