Campus housing has been under tremendous headwinds for the last 4 years.These properties were sold with extremely aggressively optimistic projections, as well as a price that represented a significant premium to fair market value.So sorry to hear about your investment.

For those who have or had section 8 investments (especially in my market) how would you describe your experience?

While @Phillip Austin mentioned Raleigh is a higher returns its just very much a appreciation market, you will not find rentals that cashflow, so depending on your goals its a good or bad market.

Until the lease ends and then the legal notice time in your market has passed.

The STR market here has become way more saturated and competitive especially in San Juan. 

new construction gets valued at a way higher premium. this is a false statement. new construction will always beat existing Very market dependent.

Two properties available in the highly sought-after Gresham Park area—one on-market, one off-market.

There are really great REI opportunities in different markets - markets in the Midwest and Southeast of the country are particularly lucrative - where not only are the purchase prices reasonable for most RE investors, but the homes are turnkey (new builds or completely rehabbed homes, tenant ready, systems 10 years of life remaining on them, property management teams in place) with appreciating home value AND appreciating rent.

You could put most of your funds in the stock market and access them when needed for a HML.

So it could take a decade to get to todays market rent. 2) it’s almost impossible if not impossible to non-renew a tenant, especially if you’re not an owner occupant. 3) As a seller, even if I could remove paying tenants I never would without a non-refundable payment from a potential buyer that covers all vacancies for 6 months if they fail to complete the purchase. 4) You MIGHT say as a buyer that’s worth it.