PSD-95 is predominantly found in the central nervous system and is highly concentrated at excitatory synapses in the brain. It is primarily localized at the postsynaptic terminals of neurons, where it interacts with various proteins to maintain synaptic structure and function.