Yep, I had to jump at the offer, drove out there tuesday night after work to go check it out, everything looked good and it was full of water and fish when I got there, so I didn't have to ask him if we could run a leak test before I paid. Just got back from picking it up tonight, everything went off without a hitch so far.
Thanks again guys for all the advice, we were able to move it without any incidents so far. Nothing broke or cracked in transit, but we haven't filled the tanks yet, so I can't know for sure that there wont be an issue, but so far it's looking great.
We're going to use it kind of like a room divider for now, but the back was painted black so we can't really view it from both sides. I'm going to be doing some touch up on the stand and put some doors/paneling on the of the stand to make it look a bit nicer from the other room. I was also thinking of putting a couple of small shelves in the side to keep our extra supplies in.