He also mentioned that he noticed excessive trash and beer cans around the second floor tenant's trash cans, piling up for weeks without being taken out.

Congratulations on getting this deal underway.

They're just in a different pile on the table, that you can get back with a better hand...or in this case, a better property.

@Jenny Zhang congratulations on your flip!

Congratulations on your investment.

:The BiggerPockets Landlord High Council is pleased to announce that you have been issued the:Maintenance Merit Badge -- HVAC Level 1Please accept our congratulations on this auspicious accomplishment.You will receive the HVAC Level 2 Maintenance Merit Badge the first time you replace the thermocouple in a furnace and the HVAC Level 3 Maintenance Merit Badge the first time you replace a blower motor and capacitor.Please continue to share your landlord maintenance accomplishments.

:D  The next day, I piled my tools in my car and drove over there to start rehabbing it.A few random, specific tips:Depending on how good the lawn care / other tenants are, the outside of the house may look OK, or not so good. 

@Mitchell Pollard First off congratulations.

Congratulations and I wish you a ton of success.

Congratulations on jumping in, @Mike Monisky!