On a similar note, the house will be rented at the time of appraisal, ideally the renter will be keeping it in good shape and clean but has anyone used any specific tips in the past to ensure the house is in the best condition possible for the appraisal?

Clean it up, de-populate it for a total reset.

They remodeled in 2004 and there is no evidence of it being such an old home except in the basement - but even there it's the best century home basement I've been in - very clean, organized, dry and no smells.The main level is rented out to a local radio station (1 room) and tax professional (2 rooms).

They need to clean their clothes and bedding to get rid of any eggs.The professionals I have spoken with tell me that bed bugs normally do not travel (like roaches). 

I'd tell them they were warned and you will be inspecting in one week to make sure it is clean. 

Im new in the investing space and im looking for more experienced commenters to give you more insight into how to navigate the financing aspect of things.On a more personal note, if you do get involved in buying a property from a family member, my advice would be for it to be a clean cut to minimize any future problems.

In my area the growth and demand for a little land and fresh mountain clean air & water is exponential.  

The Lease is very clear they are responsible for clogs they cause, damage from their use, cleaning, and water and moisture in their unit.

It took ten years for Citizens to voluteer to clean up the trash and start planting seagrass, which they continue to do.

I can't speak directly to what it will do on appraisal but I will say generally tenants in these markets just want to see a 'clean' basement with sealed & painted walls and plenty of lighting.