However, I also see it as an opportunity to potentially pass on risk (maintenance/upkeep/repairs) to an Airbnb host, assuming insurance coverages work out, and/or ask for a premium on top of what I listed the unit for.

These include higher occupancy rates compared to short-term rentals, reduced operational hassles, and the potential for a stable income that can sometimes rival or exceed that of long-term leases.

If you claim you will live at the property for good loan terms but never intend on actually living there it's occupancy fraud and you could potentially get into legal trouble. 

When evaluating rental properties, aside from school districts and convenience, consider factors like neighborhood amenities (parks, restaurants, shopping), rental demand, job market trends, property condition, potential for appreciation, and rental income compared to expenses (including taxes, insurance, and maintenance).

Different areas offer varying qualities, but most hold investment potential.

We could potentially subdivide the lot into four lots and build a main house, a Junior Accessory Dwelling Unit (JADU), and an Accessory Dwelling Unit (ADU) on each lot.

I want to know when I've found a good deal in order to speak confidently with a potential seller.

One other potential concern that could arise in the field, is the basement unit in the case where it happens to not be unit which is "Legally Recognized" by the City.

This error in my calculation diminished my potential cash flow for year 1 and putting me in the negatives.

You don’t mention what your current income level is between you and your spouse with regards for the potential to help subsidize this entire endeavor.