Project Details:
Web Application For Real Estate Brokerage & Contractor
A family owned real estate brokerage and residential contractor’s office located in North Carolina was in need of a web based system that will help them to centralize and facilitate the flow of communication within the company from start to finish.
Technologies Used:
Utilized ASP/MS-SQL
Have a new project in mind?
We would love to hear from you. Click here to connect with an expert!
BACKGROUND
A family owned real estate brokerage and residential contractor’s office located in North Carolina was in need of a web based system that will help them to centralize and facilitate the flow of communication within the company from start to finish.
SCOPE
- The web application needed to address five unique types of users:
- Administrator – will have full rights to the software
- Coordinator – will have some but not full admin rights to the software
- Customers – Those who have purchased a company will be able to track the status of their home and communicate with their salesperson
- Salespeople – employees who will use the application to manage customers and current information regarding the company’s current inventory of available homes
- Vendors – independent contractors hired by the company to complete work on the homes (plumbers, electricians, carpenters, etc.) will use the application to communicate to the company on their current jobs and schedule their work.
- In addition, the web application needs to be able to track the current inventory of homes available and current projects that are under construction and have users be able to locate all data regarding the homes and projects in one easily accessible location.
SOLUTION
- A web application was built from the ground up and goes through the entire construction and sales process. The entire process entails of six basic parts:
- Home Specifications – lists general information about the home
- Job Completion Checklist – the ability to track the construction progress of the home and works as a rudimentary scheduling module
- Associated Documents – the facility to upload all documents (contracts, price sheets, pictures, etc) that are related to a specific job
- Home Options – items that are different for many homes (color, style, etc)
- Closing Information – information relating to when the home will be transferred from the builder to the buyer
- Building Notes – facility to post specific notes and change orders for each job that are made between the company, the contractor, and the vendors who actually perform the work (electricians, plumbers, carpenters, etc).
- An easy to use administrative backend was built which allows the site admin to setup new projects when new construction begins. The site admin also had the facility to enter specific job name with all the home specifications details (size, price, address, status, etc.) as well as the list of vendors that will be working on the new construction.
- In the vendor section of the application, the assigned vendors will see the status of jobs and his upcoming work. The vendor can view a list of both sold and unsold jobs and warranty jobs; when he selects a job, he can see the job completion checklist, the builder notes, the home options, and the home specifications all of which he can add modifications and additional notes.
- When the work load is passed off to the coordinator, the coordinator has been provided with the facilities to update the job completion check list for the home(s) and be able to attach any related document(s) during the construction period as well as be able to make notes and change orders for the vendors, buyers and salesperson.
- Once the home is ready to be sold, the salesperson is provided with access to the completed inventory. The salesperson can attach the details of the customer (contact information, financial information, home information) that he has entered into the customer database. The salesperson will also attach his details as the salesperson for the job.
- An easy to use communication system was installed to provide an easy way for the salesperson and buyer to communicate through the entire building and home purchase process. The salesperson and the buyer can communicate via private message board concerning the job. The coordinator is also provided with the facility to post information to the message board as is necessary.
- As the home nears completion an alert is sent to the salesperson to enter all the closing information and when the job closes, the system categorizes the home and puts it under warranty. After one year, the system will archive the home from the warranty section and the home will no longer be visible to any users. The system will remove the project from all lists and the customer’s username and password will be void.
TECHNOLOGY
- Utilized ASP/MS-SQL
- MVC framework designed to provide better separation of different layers.
- Well documented and simple architecture/code
