@Bradley Buxton makes a very good point to make sure to do your due diligence as you won't be an owner occupant like your in-laws.Last bit of advice: Because this is a friendly deal, you want to take your time to make sure you structure it in a way that maximizes tax and cashflow benefits for both parties. 

I would like to explore the possibility of getting my first property in CC custome built.

I have not started, completed or participated in a syndication so tough to assess an ROI at this time.

Quote from @Stephen Fleming: Quote from @Caleb Brown: I would do one thing at a time.

Hopefully I am not being too ambitious given this would be my first ever home purchase.

Whoever gives me the most business and has an excellent close record will first be presented with off-market opportunities. 

To get into this field you could join First Deal by Brandon Turner.

For a number of years the majority of my time has been devoted to investing and developing.

I've not yet invested in my first property, but I plan to purchase my first one by the end of 2023.

As opposed to regurgitating some general platitudes which is what you will get if you ask the first question.