The challenge we're facing is the lack of short term rental data for the appraiser, and we won't know if it will meet the debt service coverage ratio (DSCR) requirements until the appraisal is complete.Has anyone dealt with a similar situation?

As they are getting paid to provide a service.

He is also in the service, is an investor and also an investor focused agent in your area.

Do you pay for cable service in these units?

We don't allow any "deal-making" in the forums, which includes advertising your services or properties, looking for partners, etc.

Don’t forget to include the cost of the loan servicer. 

What is the cost of the service?

When it comes to real estate, here's a general list of eligible assets and their depreciable lifespans that you should know: Residential Rental Property = 27.5 yearsThis includes any building or structure where 80% or more of its gross rental income is from residential units.That means:- Apartment buildings- Single-family rental homes- Duplexes, triplexes, and quadplexes- Mobile homes (used for residential rental)- Any kind of residential lodging facility where the primary purpose is long-term rentalCommercial Property = 39 yearsThis includes non-residential properties like:-Office buildings-Retail stores and shopping centers-Warehouses-Industrial complexes-Hotels and motels that do not qualify as residential rental propertyLand Improvements = 15 yearsThese include sidewalks, roads, fencing, some landscaping, and parking lots that are separate from the building.Personal Property = 5 or 7 yearsPersonal property used in a rental activity usually has a 5 or 7-year life.This includes most furniture, appliances, carpeting and various machinery.Qualified Improvement Property (QIP) = 15 yearsGenerally, this includes any improvements made to the interior of a non-residential building after the building was placed in service, excluding elevators, enlargements, and the internal structural framework.Computers and Related Peripheral Equipment = 5 yearsVehicles = 5 yearsNote that the land itself is not depreciable.

DSCR loans go up to 80% of the purchase price and depending on the Debt Service Coverage Ratio and your credit score you can expect rates on a 30 yr loan ranging from High 6%- Mid 8%. 

I know there are services that provide proof of funds but I view that as misrepresentation.