NSPIRE inspections will more accurately reflect the true physical conditions of properties and ensure that property owners adopt sound maintenance practices to eliminate health and safety hazards that may pose a threat to residents.

You can't compete against the all-inclusives unless you offer complimentary food and booze or you're cheap, as you seem to be confirming.This being said:1) Properties in Mexico/Cancun trade in USD so you have no foreign exchange risk in Mexico while properties in Colombia are traded in COP, the Colombian peso, which has been tanking over the years, eliminating any hope for capital gains for American investors.2) You can get a mortgage in Mexico but you can't in Colombia so even with lower revenue, Cancun would likely still be more profitable, even if you don't take capital gains into account.3) The political risk is much higher in Colombia, especially at this present time.Is Cartagena a bad investment?

Does this in general eliminate the possibility of doing part-time STR in condos?

Even if you could it all you're doing is deferring taxes instead of eliminating them. 

Will this eliminate your chances of being a victim?

I was trying to eliminate or reduce the taxes.

You know they will want to add more bedrooms to your house by eliminating the dining room and any den or other similar space and turning it into more bedrooms, right? 

You may also want to look at a cash out refinance to eliminate one or more Heloc or a few credit cards to lower your DTI and outgoing monthly debts.A heloc is a risk since its an open end mortgage like a credit card which carries a higher risk versus a 30 year mortgage. 

This tends to eliminate appraiser incompetence and requires adherence to guidelines set by the Appraisal Institute.  

Next we have actions to on-shore US manufacturing industry by eliminating foreign advantages in trade (this is where tariffs come into things) and forcing foreign business to invest in US domestic operations.