MySQL database building/maintenance of records/automated mail generation

Cancelled Posted Feb 26, 2012 Paid on delivery
Cancelled Paid on delivery

We are building a new company to help realestate agents sell houses. For this purpose we need a database with houses and realestate agents.

In this database realestate agents should be able to register in which houses home owners are interested in. THe system should be able to automatically mail agents and home owners

We are looking for a coder who can:7

- create a mysql database including recordstructure

- create php maintenance pages for the database

- programm a matching function

- implement users maintenance (login, create, forgot password etc)

- create automatic generated mails from the database

## Deliverables

**The Dutch housing market is in a bad shape. People who own a house put it to the market and wait for their house to sell before they buy a new house. In essence everyone is waiting for every one and hardly any sales are recorded. Purpose of the site is to get the market rolling again by finding out who is interested in which house.

In Holland when a house is put up for sale, ONE real estate agent gets the listing, and gets paid when the house is sold. So the agents are a key figure in the process which must not be overlooked.

We would like the sellers to start selecting the house they want and tell their estate agent about their preferred new home. The realestate agent should put this information in a database. This database and the management around it is to be built.

On a regularly basis the website should inform the agents which houses their clients are interested in and which houses they can sell tot other agents customers. If owner of house A is interested in house B and B is interested in C and C is interested in D we call this a train (with traincarts). Still nothing happens until A is sold

The website offers 3 types of solutions for this problem

1 We ask all owners if they are prepared to buy a cheaper house if they can sell their house. For example if the value of house D is 1 million and house A is worth only 100K it could be that D will buy A, not to live, in but as an investment. He will have sold his house and will have his hands free to buy a new house. We call this a "koekkoek"

2 We check if the train is very short and A proves to be interested in B and vice versa. We call this a "siamees" (siamese)

3 We check if D (the big expesive house) maybe is interested in house A (a small appartment) to really live in. We call this a "Slang" (snake)

When a realestate agent adds a traincart the agent has to fill a form with questions an example <[login to view URL]>

We devided the project in different fases to reduce the complexity.

[[login to view URL]][1] is online with explanation of the matching proces. It is in Dutch, but google translate should help to put it into english.

[[login to view URL]][2] is the main housing site

**

We added aditional files

- Database design ( to be used as a starting point for development)

- ODB (example with maintainance screens and database starting point)

- matching function (flowchart for matching function)

Engineering MySQL PHP Project Management Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #2715779

About the project

8 proposals Remote project Active Mar 21, 2012

8 freelancers are bidding on average $496 for this job

newgroup4u

See private message.

$1000 USD in 14 days
(169 Reviews)
7.8
Eliteprog

See private message.

$420.75 USD in 14 days
(31 Reviews)
6.2
alexwww

See private message.

$500.65 USD in 14 days
(23 Reviews)
5.1
SunilVyas01

See private message.

$400.35 USD in 14 days
(16 Reviews)
4.6
khersunil

See private message.

$425 USD in 14 days
(10 Reviews)
4.2
shaikhaezaz80

See private message.

$400.35 USD in 14 days
(3 Reviews)
1.0
matifmunaf1

See private message.

$400.35 USD in 14 days
(0 Reviews)
0.0
deepdevelopervw

See private message.

$420.75 USD in 14 days
(0 Reviews)
0.0