Couple hundred bucks a door monthly cash flow, solid ROI, and yes plenty appreciation. (#1 appreciating city 2023)I know many investors that have house-hacked with your exact criteria and done really well. 

New to RE investing, have watched tons of BP episodes.My goal is to pursue mid-long term buy and hold rental properties, either single or multi-family.

Hi Orchid,Have you looked into multi-families in the area?

There are multiple billion dollar companies dumping money into the city, such as Intel, Google, Honda, and Amazon.

Quote from @Dennis Knapp: Investment Info:Small multi-family (2-4 units) buy & hold investment.

Columbus has become a major tech hub in the midwest with large companies like Intel investing $20 billion, Amazon investing $3.5 billion, Google building 2 new data centers: one in downtown Columbus and the other in right outside of U.S. 33 in Lancaster.I recommend working with an investor-friendly agent who focuses on cold-outreach methods like cold-calling, cold-texting, etc to bring you off-market deals.

Would be happy to connect and see if we could add each other value.I'm very interested in multi-family BRRR deals.

I invest in Pennsylvania where I find to be some opportunity there in terms of cash-flow particularly with multi-family within the $300,000 range and even lower. 

She is absolutely crushing multi and ADU multi in all parts of LA and knows the regulations for all of these options

One client came in hot looking for a multi-unit in Phoenix - they wanted to roll over gains, keep taxes deferred, and jump into a hotter market.