I am married and just starting my CFII at DCA. My wife lives in Vancouver, Washington, so we have been on opposite coasts for about a year now. It is really tough, but my wife is very supportive and she comes down every couple months, or I go home for course completion breaks etc.
It isn't easy and you better have a really strong marriage if you are going to live apart for 2-3 years.
If your wife is thinking of moving with you, make sure she is prepared for you to study a lot, so you may not have as much time to spend together as she/you would like. Your hours will be crazy as you'll often not know your schedule until the previous evening.
That being said, I am very happy with DCA and feel as though I could not have made a better choice.
Yep, tons of apartments, don't know how affordable they are as I bought a place instead of renting.
If you have more specific questions post 'em and I will do my best to answer.