Quote from @Moshe Mindick: It’s nice to get the BS, PL, and detailed GL in excel.

I need two things- Get property details from address.

When there is no court involved there is no case number (that's a simple indicator to look for in a notice if you have not researched the details of the property code) so you have to look elsewhere, but, where and what to look for?

U want an attorney NOW to explain to you in detail the laws surrounding how the mechanics work.

Once approved, your business can promptly begin running soft credit pulls on clients.For more detailed information, you can refer to Soft Pull Solutions' guide on setting up business credit report access.

My realtor found the city building inspection report which details that the unit needs to be de converted as it cannot be brought up to code.

I can provide more details but these are the highlights. 

If you know of any in these areas, please share the details!

thank you for the detailed answer!

In general I think you need to give a lot more detail if you want good detailed feedback.