A buddy of mine who invests out in Phoenix once had a client facing a similar timing mismatch on a rehab project.. they ended up working closely with a local credit union who was more open to interim valuations.

Quote from @Kyle Carter: The comps that come from local real estate agents will be the best for this one.

I'd start with attending local investor meet ups.

DSCR recently came popular in the loan brokerage and private credit space with the rise of STRs and MTRs.Your local bank lenders will have the best rates typically.  

Hey Stefano Vrolijk,Speak with a local mortgage broker and get pre-approved for a loan. 

Your best bet is to find and contact all of the top local wholesalers and go to work for one of them and see what they do right and wrong and see if it's even a business you like.

I’m looking to connect with local investors to exchange insights, experiences, and potential opportunities.Thank you, and I look forward to building meaningful connections! 

I just need help on finding a path to get my hands on the capital  I highly recommend going and taking @Frank Rolfe's MHP bootcamp but also talk to local banks

Could you please recommend any local real estate agents?

Find your local REIA and start attending and find the Realtors there to build friendships with.