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.

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.

I would bet this one is going to make money for anyone who knows what they are doing.https://www.zillow.com/homedetails/1409-N-Hill-Ave-Pasadena-...

This is probably a tougher one considering most Hard Money / Private lenders that are go-to for BRRRRs like this focus on residential only - your best bet might be private money found here or in person networking or a local bank / credit union. 

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