So, I don't think comparable sales of properties that can be built on would be very useful and non-buildable lots are likely to be all over the map depending on a wide range of factors making each of them unsuitable for building.

I take issue with the comps due to the quality of the properties selected (mine is fully updated while theirs was not) and one of the properties is now an accountants office.

The way these softwares work is that you normally have to select some sort of dropdown or checkbox to get the classification that you want.

All available loopholes, which allowed deregulation of units were, unfortunately, closed by our elected officials, except the substantial rehab strategy, which requires 80% vacancy throughout the building and 75% replacement of all building-wide systems, you are essentially forced to renovate the complete building and still at the mercy of DHCR.. which has the final saying

Most lenders are going to be limited to using the lower of appraiser's opinion of market rent or the actual in place lease (or in some cases 110% of market if lease is greater) so it sounds like you just need to roll the dice on a new appraisal but I'd recommend having some rent comps on hand for the appraiser up front just to avoid the same issue.  75% cash out pending positive DSCR is widely available at most DSCR lenders. 

How are you guys selecting your contractors and materials to do a rehab.

You can invest in any market selecting the ones that you believe are seeing the most growth, and do it from anywhere.

If you are not familiar with the area (selecting a location because property is cheaper than your home base), often that great deal might be 10 blocks in the wrong direction and you get burned. 

https://biggerpockets.getregistered.net/conference-2024@Alexandra Hughes Pailet  I just tried to register, but I can't seem to figure out the pricing upfront, it took me straight to selecting workshops and entering details, please let me know where I Can find ticket pricingundefined

My suggestion would be to select someone with the most forum posts or most reviews.