Every market is diffrent. For a return like that it aounds like it is a nice turnkey property. This may suit someone looking to capitalize on appreciation in the market and has a large sum of money they want to invest. The deal you mention I wouldnt be intrested in because I couldnt carry that. Maybe look at property that needs work or purchasing a single family home or condo, Moving, then renting it out. That househacking startygy could make more sense in your market.
For me persoanlly. I invested in a 2unit in Reading PA. Much cheaper market. I got my duplex for $170k. It is outdated and I have been fixing it up as I go. As I live in it. It does not cashflow. When I leave I anticipate a break even if not slighlty positive cashflow with market rents and some more updating.
Some of these pod casts cherry pick great deals in my opinion. Not that its imposible. But it should NOT be the standard you set for yourself. Because then you would never purchase haha. For a househack you should really be focused on your needs in your market. My househack was no Homerun deal. But I like where I live, and now that I actually own it I can start realizing the benfits of real estate investing. My living expenses are less than 90% of the people that live around me. Being that I probably pay around $600/mo bottom line, And that gets me a home Im happy to live in. I was able to increase the value of my property by fixing it up over the last year as well. All the while paying down my mortgage and saving money on taxes.
Focus on your needs and not trying to keep up with the househacking Jones's who get these crazy returns. It wouldnt surprise me if they fudge the numbers a little for more views, and take into account the year they did it. I doubt that many people have been getting those homerun deals since COVID and the drop of inventory unless it was a "genuine" off market deal they found and negotiated directly with the seller.