Are the "water stains" circular like from a pot or are they large irregular shaped stains? Are they mainly in high traffic areas? Is the wood raised, cupped, does it have excessive gaps?
What needs to be done is to resand and finish the floor. This is something that is better left to the pros, as you can do some serious damage if you are not careful.