MySQL database building/maintenance of records/automated mail generation

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 <[url removed, login to view]>

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

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

[[url removed, login to view]][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)

Skills: Engineering, MySQL, PHP, Project Management, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: www docs google com, we need sales agent, website development process flowchart, vice com, types of it solutions, translate online get paid, translate get paid, translate from home, translate english to dutch online, translate english to dutch google, translate dutch to english website, translate dutch to english online free, translate dutch english online free, the value of project management, starting an online sales company, small houses design, sales generation online, sales free agents, sales agent of houses, sales agent for short, real estate sales agent, programm for create website for free, php programm, php mail help, need to buy translate

About the Employer:
( 0 reviews ) Netherlands

Project ID: #2715779

9 freelancers are bidding on average $497 for this job


See private message.

$1000 USD in 14 days
(153 Reviews)

See private message.

$420.75 USD in 14 days
(31 Reviews)

See private message.

$500.65 USD in 14 days
(23 Reviews)

See private message.

$400.35 USD in 14 days
(16 Reviews)

See private message.

$425 USD in 14 days
(10 Reviews)

See private message.

$400.35 USD in 14 days
(3 Reviews)

See private message.

$500.65 USD in 14 days
(1 Review)

See private message.

$400.35 USD in 14 days
(0 Reviews)

See private message.

$420.75 USD in 14 days
(0 Reviews)