A "portfolio loan" is one that none of the big Agencies will go for, so a (typically, local) bank will hold it on their books permanently. 

I had no permanent residential address in the US.

Is there any data to support wether or not the crime would have a permanent impact on the homes rentability or overall value?  

I have met with several other local banks who are willing to lend towards the purchase of the land, then roll that cost into a construction loan, then into a permanent mortgage product (if you plan on holding).

So yes, if you can afford to put down $200,000 and see NO return from it for 25 years, but THEN you get a fat check for $1,500,000 (in 2040 dollars) when you sell (it should have been for $3,000,000, except for the great crash of  2025), then yes, many people use this approach.

Modular is basically the same as site built except its made in a factory then permanently put in place at the location you desire

Without an Exclusive Buyer's Agent Agreement, I'd say that realtor is out like the fat kid in 5th grade dodge ball!

I'm not updating an appliance which would eventually need to be replaced, this would be a permanent solution.

If you don't remove it, and it isn't made operable, some cities will require the fireplace to be made inoperable by disconnecting the gas, covering the fireplace opening over and permanently closing off the chimney to avoid a tenant from using it for wood/trash burning. 

Numbers are numbers, last time I checked they don't smack you or call you fat so I don't understand how they come with emotions.