It costs the same thing to fix a hot water heater or remodel a bathroom on a $200K house as a $100K house.   

A classic drop n swap, what has been referred to in the previous mentions.

When it was clear water was running from the unit.

Start with maintenance notes that you may regularly reference, such as air filter size, water shut-off location, etc.

Drop your thoughts below.

With most price drops (as in "hot, don't touch")?

Drop me a line to connect, and if you’re in  the Tyler or East Texas area, let’s go get lunch or have a beer.  

Appears the guests may have left the faucet "on" when the pipes were frozen and when no water came out, forgot to turn it "off".What may have caused the overflow of the sink is maybe the drain lines were also frozen?

If they can't do that, keep shopping.This may require digging up the foundation, sealing it from the outside, and installing a french drain to keep water away from the walls.

.$275000 with 25% down, taxes $4080, insurance is 3000 yr and rents is $3800 month, Water $400 mth.