Essentially, this deal did not meet your financing contingency (assuming you had a financing contingency) as it didn't meet the appraisal value so you need to renegotiate either way.

Is there a web site or even a tool on Bigger Pockets to be able to figure that out? 

Rhett P.First off, "O.N.E." is an O & E which is an Owner's and Encumbrances report, essentially a title search on the current owner for any liens on the property in question.  

Isn't this a great tool...

My understanding of those types of deals is very limited, essentially an investor provides cash, and I provide a rate.  

Although I wouldn't consider myself an expert in this field, he's doing a good job giving me the tools and information I need in order to get the knowledge he has.  

If the seller is asking too much for the property then one of the tools you can do to determine if the value fits your investment criteria is a reverse cash flow analysis, otherwise known as a discounted cash flow analysis, to see if the purchase price makes sense, especially if your using a cap rate as your benchmark.

Here's my take: ln my state (Colorado) this would be dicey- it is not legal to broker a real estate deal with our a license-- BUT, since you  would be a part owner (essentially a partner in the deal), not a broker working for a fee or commission... maybe that's OK?

This site has a rental property analyzer tool, which you should try to use and get more information about this property.

Essentially, I've been pre-approved by several lenders until they find out one thing, then the $200k I was pre-approved for drops to $60k.I work for Enterprise and my pay structure is that I'm guaranteed 48 hrs per week and make at least $39,000/yr. this is where I've gotten the $200k pre-approvals.However, it's broken down on my paystub as 40 hrs of normal work and 8 hrs of overtime each week.