A quick discounted cash analysis results in most of the indicators - Cash-on-Cash, Profitability Index (PI), IRR, ROI, etc. - indicating this property will not be profitable over the long term.

For example - Vanguard Total Stock Market Index Fund (VTSAX) is made up of ~ 2% REITs.

I can use the use the cash to either invest in tax free muni- bond index funds or other less risky investments.

Should I sell the company stock and use it toward REI or put it into an Index Fund? 

Do you often change your targeted market area, price point, renter index just to make a deal work?

The motivation behind this endeavor is to mitigate the overexposure of my investment portfolio to index funds and the stock market, seeking to establish a diversified foundation with the inclusion of real estate assets.Given that this marks my initial venture into real estate investment, I am eager to dip my toes in the proverbial waters and assess whether I possess the aptitude for this venture.

Well, being B's mtg is a PMM, it may have priority but the same probably won't hold true for C's mtg, unless C's money went to pay off A's mtg in which case see equitable subrogation above.These examples don't take into account mis-indexed documents, actual knowledge vs constructive knowledge, competency of the parties, jurisdiction where the land is located, problems with the legal description, misspelled names (look up "idem sonome" for more information) and a whole host of other potential problems.

s, who often are into index funds, who then are in the actual stocks.

For a point of reference the "Crime Index" which is a rating 1-100 on how safe a city is (100 being the safest) High Point scores a horrendous 9.

High Point sits at a 8 out 100 on the crime index (with 100 being the safest) [Down 1 point, since last post].