I am looking to create a database that I can store and manage apartment complex information (such as owner name, owner address, owner phone, site APN#, site address, number of units, year built, purchase price, sale date, photos, map). I need to be able to also add dated notes and reminders (integrate with Outlook calendar if possible).
I have the County Assesor data as an Excel file. This data has all the above information except for: owner phone, number of units (sometimes they have # of units), year built, purchase price, sale date, photos and map.
I am not sure if this is possible or not but often times I know the property address and the owner name and owner's address but I don't know the phone number. I would like to do batch telelphone lookup searches through a site like [url removed, login to view] and be able to then import the phone numbers into my database.
Ideally the application/database would have a very easy to use GUI that would allow me to easily import the assessor and [url removed, login to view] data, add my own data as well as easily add new customizable fields for tracking future data.
This may not be very clear so contact me for clarification. I am not very savvy with programing or databases.