Database needed for property rental service

Completed Posted Aug 21, 2008 Paid on delivery
Completed Paid on delivery

1. Properties Database

o Database to store Apartment Info – name, address, rates, specials, policy info, amenities,

location info, photos / floor plans, min bdrms, max bdrms, credit strictness, property

grade, pet info, utilities, preferred Employers, etc.

o Password Protected Administrative Manager – Add, Edit, Delete Each Apartment will

have their own page with photos, info, videos, etc.

o Cross-reference to Customer Database

2. Customer Database

o Database to store Customer Info - name, contact info, Occupant/Roommate Info, search

criteria, application info, leasing history, date of entry, apartments “shown”, apt rented,

lease start date, lease expiration date, admin notes, status, etc.

o Cross-reference to Apartments Database

o Password Protected Administrative Manager – Add, Edit, Delete Customers

3. User Accounts Database

o Database stores users’ name, user id, password, email address

o Password Protected Administrative Manager – Add, Edit, Delete User Accounts

o Secure Login – checks user id/password against Database –

o Password Reminder --

_ Enter their email address

_ If email address is found in database, then system will email them with their

username and password

_ If email address is not found in database, then message will be given to contact

system administrator

- Remember Me –

_ Sets cookie on user’s computer which allows automatic recognition and login

with each visit until cookie is deleted by user

- Permission Settings –

_ only allows access to areas permitted based on permission settings

4. Search Functions:

A. Customers Search

Search by name, status, city, zip code, employer, apt rented, lease start date, lease

exp date, entry date

Keyword Search

B. Apartments Search

Search by name, number of bedrooms/baths, number/types of pets allowed,

geographic area, city, zip code, schools, credit strictness, amenities, property grade

Keyword

C. Email Search Report to Customer

Saves search criteria to simple “reports” database – allows for real-time results when

customer retrieves report

Administrator can view/delete from list in manager program

Emails link for retrieval to customer - better chance of getting through spam filters if

email is in text format instead of HTML

View Report link – outputs in HTML layout to include photos and floorplan (similar to

[url removed, login to view])

D. Customer Lease Renewal Reminder

Display list of leases due for renewal in ‘X’ number of days – to be set by

Administrator

Administrator can customize email message to be sent

Queue for emails to be auto-sent – allows administrator to remove email from queue

Send Now link will send email right away and remove from queue

Re-queue archived email to be re-sent to customer

Enters email send date/time into Customer file in database

I have an excel sheet that has all the fields the database should need. I will send it to each bidder privately.

ASP PHP Website Design

Project ID: #303921

About the project

42 proposals Remote project Active Aug 27, 2008

Awarded to:

tonmay

Very simple, dis similar job. Waiting for your selection. Thanks, Tonmay

$900 USD in 21 days
(146 Reviews)
7.7

42 freelancers are bidding on average $1037 for this job

phpMaestro

Please check PMB.Thanks.

$1200 USD in 20 days
(421 Reviews)
10.0
qualifiedcoders

hi see pmb for details. thanks.

$1500 USD in 15 days
(66 Reviews)
8.0
vocsowebstudio

Hi, We have reviewed your project description of "Database needed for property rental service" We have extensive team specializes in webdesigns, Logo, Corporate identity, joomla, CMS, Oscommerce, word press all kinds o More

$1500 USD in 30 days
(17 Reviews)
7.1
netsolve

Glad to work. Thank you.

$1000 USD in 15 days
(299 Reviews)
7.4
webedeveloper

See pmb please

$750 USD in 15 days
(140 Reviews)
7.1
emadz

Plz. view your PM

$750 USD in 15 days
(56 Reviews)
6.4
skywalker65535

please see pmb

$1200 USD in 12 days
(28 Reviews)
6.3
virk

Please see PMB

$800 USD in 21 days
(11 Reviews)
5.9
naveedurrehman

I have read the details you provided and I am very clear with requirements. 500$ would be enough for this project. Check your pmb for some good suggestions. Thanks - Naveed

$750 USD in 15 days
(59 Reviews)
6.1
webRIA

Please check the PMB for more information.

$800 USD in 15 days
(13 Reviews)
5.8
ideacreativenet

please check your PMB for more discussion

$1499 USD in 0 days
(27 Reviews)
6.5
QualityService

We can do this project within time; please see PMB for more details.

$1500 USD in 30 days
(3 Reviews)
5.7
gparija

Please see PMB for details..

$800 USD in 21 days
(5 Reviews)
5.4
dsendra

We can code this project. We have 16+ years of programming experience and over 8 in ASP/PHP. Database experts also, bearing years of knowledge and experience in the field. Our price: $ 1250 to code this project. Please More

$750 USD in 20 days
(25 Reviews)
5.3
EspressoLogic

Please check PMB for details.

$800 USD in 20 days
(5 Reviews)
4.8
zhukaster

Hello, quality work is the best you can see from me. I can deliever this real estate database solution for you within 19 days or less and for $799

$799 USD in 19 days
(22 Reviews)
4.6
ThetaPi

Hello, I am well experienced with database design and with basic site layout (although I am NOT a designer). I can easily provide the functionality you need for this project. Please see profile for previous reviews, an More

$750 USD in 13 days
(13 Reviews)
4.7
rahmanali

I have more than 10 years Experience in WEB DESIGNING,WEB DEVELOPMENT and SEARCH ENGINE OPTIMIZATION(SEO).I will Provide you the solution.

$1500 USD in 25 days
(30 Reviews)
4.5
developlogic

Thanks for your consideration.

$800 USD in 31 days
(3 Reviews)
3.1
AshTechnology

Dear Sir, We would love very much to be given the opportunity to work with you on this project. We are expert. We can do this according your requirements. WE CAN MANAGE THE TIME FRAME AND BUDGET AFTER PROJECT D More

$750 USD in 15 days
(4 Reviews)
3.1