This thought led me into studying about becoming financially free and building generational wealth.

Can function as either co-living or one large multi-generation single family house.

No pocket listings = agents aren't even calling for new leads anymore, rising interest rate has nothing to do with an agent's ability to generate leads.If you mean multifamily apartments, 5 units and up, some of those agents will know, but not many until you are over 10 units which are more listed by only commercial brokers which I agree do understand seller finance.

House hacking lets you live in one unit and rent out the others, which can help cover your mortgage and generate some extra income.

I think the HELOC is the way to go if you can - However after reading your post, if you are talking about a 6 figure pay day, how long would the property take to generate that 6 figures in cash flow?

For Americans using their housing allowances, there’s a unique opportunity to acquire properties that generate strong yields without relying on appreciation alone.2.

The ability to generate more income for simply the cost of a building is another huge cost saving over buying an expensive commercial lot and developing it.

Quote from @Alberto Freites: Quote from @Malgorzata Sadowska: with the current market micro & macro trends, our market is poised to continue to go up for the foreseeable future.But do you think there are opportunities today to generate cash flow, or at least the property pays for itself?

that will not cash flow - you won't be generating "cash flow" from the property that will go beyond servicing the debt and allow you to pay down any principal. 

We basically want property to generate some cash flow and long term appreciation.