Financing question for rehab property

[N Modi]

I am looking to purchase rehab property in NJ. Property has five apartments, retail stores at ground level as well as separate small warehouse/office. Asking price range is around 500k.
Property requires rehab prior to renting out. There are no tenants in apartments or in retail. Question is about financing the deal. Considering there is no cash-flow being generated when purchasing the property as well as rehab work required, what is the best way to approach financing?
My credit is excellent but I wish to put no equity (also wish to finance rehab expense). I am not interested in going through hard-lending route. Does banks/credit union provide construction loan for rehabbing property or would they provide mortgage (purchase price + rehab expense) on entire property? What kind of terms would I expect for this type of loan? Also, if you can recommend bank/credit union dealing in this type of scenario, it would be appreciated.
Thanks