The property I am looking at aesthetically is much nicer looking from the front.

My only hope is that the rehab company doesn't go in and make the interior Modern with white walls and white counter-tops but keeps honest to the cabin aesthetic. 

It's such a great concept (although a tad kitschy for my minimalist aesthetic), but there aren't any destinations that feature shipping containers.

If you allow your tenants to maintain their lots like a garbage dump in the name of personal aesthetics you own a trailer park.

Above market rate rent (I agree with the comments here - reach out and renegotiate the rate) and very few required repairs/etc (I have found that my section 8 tenants are totally easy going and as was mentioned, the inspections through the program have nothing to do with aesthetics, only safety). 

Can't comment on the location or the aesthetics.

This will serve as an incentive to him to help you in any way possible to find a qualified tenant such as:- allowing you to show the place multiple times when you have a good prospect AND keep it neat and tidy so it is aesthetically appealing.

I do however recognize that it's easy to say "replace the 3 tiles" with no idea as to what condition the place is in (or any of the other aesthetics).

He or she should know where to spend the extra money and where you can get away with cutting back in such a way you don't lose integrity or aesthetic. 

The $5-10K would be more for aesthetic upgrades to improve rents in one of the units.