Terms for commercial loans will be different from bank to bank but the majority of them will offer a 5 year term with 20-25 amortization.3) the bank will use a professional appraiser.4) depending on the terms of your loan it might be worth while to refinance once you rehab, rent and stabilize the property for at least 60-90 days to show track record. 

I'm not terribly encouraged by them even collecting my payments, but I do get a decent amount of international visitors and they almost exclusively use Booking so it's a worthwhile exposure for me. 

Is that a worth-while ROI?

I'm going to begin by looking in the West Hartford/Farmington area, but really I'm open to any thriving neighborhood so long as I can find a worthwhile deal (or make one!).

There should be a section on the move-in inspection that has "repairs needing to be done".If you're not wanting to pay for the repairs (which may be worthwhile if they're good tenants), then you could:A) Arrange something with them ie. they pay month on time for the year and you'll handle some repairs free of charge), B) Negotiate for them to cover half the costs of repairsC) Explain the above to them that this should have been voiced prior to move-in and they had agreed that the living conditions were satisfactory for them.

If you're in real estate it's extremely worthwhile building a relationship with one or more attorneys who deal with this stuff all the time.

Is anything in life that is truly worthwhile easy?

If people are paying $170k-$190k for no updates, linoleum etc, make sure your upgrades are worthwhile. 

You'll save more money and reputation in the long run.THERE ARE NO WORTHWHILE SHORTCUTSNo- You don't get access to the MLS just by having a licenceNo-You can't get the entire state unless you pay quarterly for each MLS.

Assuming that you're running a professional operation within the bounds of the law, this tenant sounds like more headache than they're worth, and I'd suggest looking into the legal ways of having them leave ASAP so that you can get a better tenant.  ...it may be worthwhile to just text the tenant and say  "Look, you're clearly unhappy with the property.