Alternatively, I could hope that my next assignment will be in a better market with more options, maybe lower rates, and more cash on hand.Should I accept that no market is perfect and get in the game now, or hold out for a year to enter a potentially better market with more capital to invest?

That appears to just be the going rate for the risk on the lender side.

While initially enthusiastic about the potential of the property, upon inspection, I found myself overwhelmed by the extent of work required for its rehabilitation.As a beginner in this field, I must admit that I feel ill-equipped to accurately assess the necessary renovations and calculate the total cost of rehabilitation.

I don't recommend it unless you are an experienced investor who understands the risks and how to overcome them for the next 5+ years.We hit a peak market in 2023.

I wrote "I am looking to raise private money" on my name tag and now I have several potential passive partners for my next deal.

However, those who can weather the storm stand to benefit from potentially lower interest rates and growing demand for rental units.Despite the challenges, there are opportunities for buyers with sufficient resources to capitalize on the market's current conditions.

haha I would like to believe people are getting much more creative and tapping into the potential of "house hacking" now.

I have been preapproved and have been touring potential houses.

It’s got great bones and potential but I’m just at a loss as to how to move forward. 

Perhaps your kids could help you with video editing, marketing, and other things.While you are getting active income, you could potentially look at wholesaling or fix and flip.When you wholesale, you don't need a license and you don't need money.