I'm working on building a database for commercial properties. I will be collecting the property address, tax address, recorded property owner (on title) and then 1-3 owners and their home addresses/phone numbers.
I've done a ton of research with other CRMs and it finally seems like I can do what I want with Zoho. I'm trying to build where I can effectively cold call (i.e. Phone Burner app) and use direct mail marketing (such as Print Genie). The problem is I won't have contacts for every property or email addresses for every contact. I will however, have a unique property owner for every property (i.e. 123 Main Street LLC).
Below I'll describe an example data structure I'd like to track and make sure there's two way syncing across the different apps I'll use.
Property Fields: Address, Mailing Address (where taxes are sent... these could be anonymous PO Boxes), Property Owner (i.e. 123 Main Street LLC or John Smith Trust) other misc. data (i.e. # of units).
Owner Fields: Mailing Address (could be unique, i.e. their home... individuals), Phone Number(s), Email(s) - i.e. John Smith as owner #1, Jane Doe as owner #2 (and their unique info)
Organization Fields (i.e. the Account module): Relationship to Property Owner, or where a common owner is identified, this is where it's tracked (i.e. 123 Main Street LLC is owned by Goldman Sachs or if it's owned by an individual, I'd want to track this),& corporate Address