I am in need of a Real Estate web database. I have seen a ton of scripts out there and need your opinion on who you feel would most likely match my criteria below, does not have to match all.. Thanks..
1. Payment and Membership
a. My customers will Pay to view the listings and will need another access level to add listings to the site for a fee.
2. Customers will need there own personal settings section
a. Adjust phone, address, e-mail, etc
b. Save their favorite search criteria's (multiple)
i.. Macro search features can be used by pull down
ii. The saved search criteria will also be used for customer "Alert e-mails"(ex. Every time the database is updated a cron job will check the new information against the customers saved search criteria and send "Alert e-mail" to inform them of a new property)
c. Add properties to a "watch list" and alert then via e-mail when a date expires on one of their "watch list" listings
3. From the search output
a. Customers will choose items with a checkbox and either add to watch list, Print or export those to CVS, TSV, and XLS?
b. Customers will need to be able to adjust how the output looks. Either a thin band (1 line) of information or large detailed output (multiline with picture)
4. Backups/failover
a. Need to replicate east coast west coast databases when new data is entered
b. Cron job for backup
5. Statistics on user activity, listings, new members, e-mails (from alerts)
6. Cron job for customer "Alert e-mails"
a. Need to be able to adjust how often the script would be run
b. Adjust how much information is sent to the customer in the e-mail from the listing (ex. number of new properties in zip code instead of all info, street address, etc)
7. Without branding attached (powered by SUPERSCIPT, etc)
8. Purchase reports
a. Customers will buy reports based off of listings they have chosen from checkbox in search output. Need a wallet feature or shopping cart
9. Payment/non-payment access
a. Instant access for new memberships. Customer purchases monthly service with credit card and instantly gets added to the user database without admin interaction.
b. Customers 30 days of membership has ended, account goes into lock mode until the customer has paid which re-establishes hit account without admin interaction.
c. Normal code needed for interaction with the most popular credit services, gateways, etc.
10. Data input
a. Need to able to import a large amount of data in CVS or other format into mysql via script
b. Need admin specified fields for adding data manually through form
i. Easy add/delete/modify data of the listing
ii. Add pictures via form
iii. After adding street address to form, Auto populate link for yahoo maps that will be placed into the listing
11. Ticketing system
a. Ticket created when customer has purchased and requested a report
b. auto refresh feature for list of tickets(unless inside ticket)
c. Need basic features, make notes, reply, and close ticket which sends information to customers specified e-mail sourcing from personal settings
12. Listing Report form
a. Upload customer bought reports to database via form and the form would return url for retrieval from customer.
b. log street address of report and check against new customer request for reports to the same address as to keep from adding new urls for duplicate requests.
13. Need to be able interact with other existing scripts. No lockout of code
14. Figure out the Powerball numbers for tomorrows drawing and not have to worry about putting together any of this.
Linear Mode
