Looking for a ground up design of a database to host real estate files and be accessible from both a web based front end and locally. Must have the ability to manually input information as well as import files from .csv, .xlsx formats and export to the same. In the data import, should be able to mark and correlate which data gets mapped to where. Should also have ability to define custom fields on a as needed basis.
Must have a calendar function for reminders and be able to sync with google calendar, send e-mail or sms.
It will need perform some simple mathematical functions and have the ability to query the DB for data mining, modeling, and predictive analysis.
Currently using vTigerCRM in a limited capacity, so if it can be customized to work in this fashion, please mention.