For investing principles and deal analysis, The Book on Rental Property Investing by Brandon Turner is excellent, it covers cash flow, evaluating deals, and basic financing strategies.

I’m in search of a comprehensive guide that covers the fundamental aspects of real estate investing, such as key principles for successful investments, effective lending strategies, thorough deal analysis techniques, understanding syndications, and property management best practices.

Basically, I'm trading $300-$500 per month for this benefit.

What a strange concept, I thought.But in my research I am now wondering what some experts might think about.....what I'm thinking....Ok, so if I finance a conventional mortgage (conventional as in amortizing), the principle adds a substantial amount of cost to my monthly payment. 

No prepayment penalty & paying down principle plus sweat equity (valu add) may be good for some?

If you all know of a post or other resource you can link to with basics like this, I'm happy to read that instead of you typing a bunch of stuff out ha!

The key is specialization, not geography.When you’re interviewing CPAs, ask them this very basic question:“How do you handle taxes and accounting differently for real estate agents versus real estate investors?”

Finally met with someone who was recommended from a really good source and the result of the meeting was basically what I had predicted, so no financial advisor for us.

I've thought about it a bit, but the tax burden whenever I've looked here in The Netherlands has been pretty high comparatively speaking, and regulations are a bit tough to swallow as a potential landlord (even if I largely agree in principle with them). 

In my over half century investing in real estate I have never really found a book or singular resource that "ties together the essentials - investing principles, lending strategies, dal analysis, syndications and PM best practices" as you ask.