Country state city database in mysql php jobs

I'm looking for an experienced SEO specialist who can help me in enhancing the search engine rankings of my website. Key Project Details: - Current SEO State: The website has a moderate SEO foundation in place. - Primary Goal: The primary objective of this project is to improve search engine rankings. - Target Audience: The target audience for the website is primarily general consumers. Ideal Skills and Experience: - Proven Track Record: Demonstrated track record in improving search engine rankings for websites. - SEO Expertise: Comprehensive knowledge of SEO techniques and best practices. - Audience Understanding: Ability to tailor SEO strategies to reach and engage general consumers effectively. Please bid if you believe you have the skills and expe...

I am in need of a skilled PHP developer who can help me with implementing some design adjustments on my website. The job will involve: - Making layout adjustments - Updating the fonts - Adding new sections, specifically testimonials Your tasks will include modifying the layout of the website to accommodate the new sections and updating the fonts to align with the design changes. You will also be responsible for ensuring that the users' testimonials are seamlessly integrated into the design. Ideal Candidate: - Proficient in PHP - Strong understanding of front-end design - Experience in layout adjustments and font updates - Ability to add new website sections - Attention to detail, to implement the design changes accurately. Please note that you...

...geo-targeting report for a US-based business. The report will primarily focus on a specific city, state, and country, delving into neighborhood-level and county-level details. Key Requirements: - **Geo-Targeting:** The report should provide a detailed understanding of the demographics and market behavior of the specified locations. - **Competitor Analysis:** This will involve a thorough investigation of the market, outlining the competitive landscape and the strategies employed by competing businesses. - **Customer Behavior Data:** I would like the report to include detailed insights into customer behavior in the target locations. The ideal candidate for this project should have: - Proven experience in conducting geo-targeting reports. - Strong data ...

I have a backend code for a pre-existing fully function website and mobile app. The backend code is currently all written in php. I need someone to convert this existing php code into fully functional python code which I can deploy.

We have built a customized website in core php and need another experienced developer to join the team to fix some bugs, We are looking for a very experienced php developer for our project, you must have at least 12-15 years of experience with a good reference . Must have experience in multi-user programming, must know how to do quality coding, fix sql injections Conditions: You must be a independent freelancer. and share with some of your customized applications that u have worked on.

I need a PHP script to update an existing PDF file with data from a form. - The purpose is to update information in the PDF file, not generate new ones. - The edited PDF will be displayed once, not saved for future reference. - The data that I'll be entering into the form is a bit more complex than just text. It includes text, images, tables, etc. The ideal freelancer for this project should have: - Strong understanding of PHP. - Experience with PDF manipulation in PHP. - Ability to work with various data types in PDFs. - Attention to detail to ensure the PDF retains its original style, font, spacing, etc.

I have a website that's mainly about sharing information. The data stored a...page, with a particular focus on its data storage and transfer areas. Key Requirements: - An expert in web page security, especially in data storage and transfer - Experience in identifying and fixing vulnerabilities - Proficient in implementing advanced security measures - Capable of providing detailed reports and recommendations Your job will be to: - Perform a thorough security check on my web page - Focus on the areas of data storage and transfer - Identify any vulnerabilities - Implement advanced security measures - Provide me with a detailed report on the current state of security and recommendations for improvements. Please only apply if you have the necessary exp...

...freelancer to develop a custom web scraping script. The goal is to curate a comprehensive database of restoration and IICRC technicians in Australia. Specifically, I need the following information from their websites: - Business name - Phone number - Email address - Location (state, suburb, postcode) Websites without data available to scapers will require manual collection The ideal candidate should be well-versed in web scraping, particularly with experience in extracting data from websites into an organised and structured format. You should also possess strong problem-solving skills to handle any complications that may arise during the scraping process. This is a specialised type of cleaning so the database should be broken down into servi...

...necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface. Skills Required: - Proficiency in HTML, CSS, JavaScript, and responsive web design - Experience with web form development and validation PHP Integration

I need an experienced HR freelancer in the city of Lucknow, who excels in recruitment and selection processes. My company is in the sales sector, and we are currently seeking to fill a position for a Sales Representative. Key tasks: - Identifying potential candidates - Conducting interviews - Facilitating the hiring process. The ideal candidate for this job would have ample experience in HR, particularly in the sales field. Their skill set would include an in-depth understanding of recruitment procedures, excellent people skills and the ability to recognize promising sales candidates.

I'm in need of a skilled PHP developer to create a custom admin dashboard. The primary goal of this project is to provide a user-friendly interface for my data, with the following features in mind: - **Data Visualization**: I want the dashboard to be able to display key data pertinent to my business. This may include sales data, user activity, and website traffic. - **User Management**: While not explicitly stated, I understand the importance of user management in an admin dashboard. Therefore, building a system that allows for user management is a crucial part of this project. - **Role-based Access Control**: I want the dashboard to have role-based access control. This means that users will have different levels of access based on their roles within the o...

...NodeJS and Electron. -Strong knowledge of Relational Database Servers such as MySQL or PostgreSQL. -Some experience with C#. -Experience with microservice based architecture. -Strong coding skills, ability to use BDD and TDD where needed. -Experience and confidence developing RESTful APIs and high-load apps. -Proficiency with fundamental front end languages such as HTML, CSS and JavaScript. -Ability to switch between languages and frameworks. -Knowledge of Agile and Scrum. -Fluent in English. -Nice to have: Google Cloud, CI/CD, Kubernetes, and Docker. -Nice to have: experience in building payment solutions. -Nice to have: experience in the medical business. ...

I require data entry services targeting both English and Malayalam languages for a medium volume of content sourced from digital files. As such, potential bidders sh...targeting both English and Malayalam languages for a medium volume of content sourced from digital files. As such, potential bidders should have the following: - Proficiency in written Malayalam and English to ensure accurate and efficient data entry. - Basic IT skills to navigate and extract data from digital files. - Attention to detail, ensuring data is properly entered without errors. - Experience in the field of data entry, especially if done in multiple languages. Your role will primarily involve transferring data from digital files into our designated format. Please state any relevant exp...

Hi there, We are a travel agency looking for an expert in API integration to answer the following questions: Is it possible to connect and our own booking system to check and update automatically accommodation availability, rating, pricing and meals within our internal booking system? It should take into consideration a radius of 5-10km from a certain city point. Our own booking engine works automatically as follows, it sends a booking request to the accommodations on a certain accommodation list (from the first to the last one on that list) following a rule: if the first accommodation on the list denies our booking request, automatically the request will be sent to the second on the list, and so on. What will the requirements?

...with a focus on improving rankings on Google. Key Requirements: - Audit: Review the current state of my website from an SEO standpoint. - Recommendations: Provide actionable suggestions to enhance my Google search engine rankings. - Keyword Optimization: Work with a list of specific keywords I aim to rank for. Ideal Skills and Experience: - Proven track record in SEO, particularly with enhancing Google search rankings. - Strong analytical skills to assess the current website's SEO performance. - Excellent understanding of keyword research and optimization techniques. - Ability to provide clear and strategic recommendations for improvements. - Good communication skills to explain complex SEO concepts in understandable terms. This project would suit someone ...

Please Sign Up or Login to see details.

I'm in need of an experienced PHP backend developer who can assist me with urgent server configuration and API integration tasks. Specifically, I would require the following: - Server Configuration: I need someone who is well-versed in server setup and configuration, ensuring a smooth and efficient back-end infrastructure. The ideal candidate should be able to ensure optimal performance and security. - API Integration: There is a need for the integration of an 'informative application' API. This task requires someone with prior experience in integrating custom APIs and a strong understanding of how to effectively connect APIs for seamless functionality. Ideal Skills and Experience: - Proficient in PHP for backend development. - St...

...nonfunctional PHP or HTML form based on a concept I have. The form should be beautifully designed and should be able to toggle between light and dark modes. I only need the design. This form does not require a database. - The form should be designed to be versatile and multiple types of utility forms - The form should include various fields, including but not limited to Name, Email, Phone number, Address, and Message. - The form should be equipped to handle and incorporate different types of utility forms such as Contact form, Feedback form, Registration form, and Survey form. I will provide you with a mockup of the form; you will be tasked with transforming this concept into a functional form. Most have side admin panel Ideal Skills and Experience: - Proficient ...

...unique code. Task Management for Reports Task States: Each report should go through various states (e.g., Received, Under Review, Under Investigation, Concluded). Assignment of Responsibilities: Ability to assign responsible parties for each state or stage of the report. Notifications: Automatic notifications to the reporter about the progress and state changes of their report. Task History: Complete log of all actions and state changes for each report. Business Intelligence (BI) Panel General Statistics: Total number of reports received, in process, and resolved. Category Analysis: Statistics by type of report, department, severity, etc. Temporal Trends: Graphs of monthly, quarterly, and yearly trends. Customizable Dashboard: Customizable widge...

We need an expert to help us set up a GitHub Codespace for our Prestashop Website. We've already created the appropriate Codespace account and repository. We also user Docker. We don't manage to run php 7.0 on the codespace server. There's probably something we're doing wrong (we're not github/codespace experts). We need you to finish the set up for us. Please apply to this job ONLY if you're very experienced with Github-Codespace-Dockers + php.

I am in need of a PHP developer who is capable of handling front-end tasks. While I do not require someone with extensive experience in PHP, a beginner level developer with a good grasp of front-end development will suffice. The role is part-time, requiring only 10 hours of work per month. My budget for this project is up to 5000 INR. For the website redesign project, our primary focus will be on improving the user experience. The specific details of the website's redesign will be discussed as we progress. Ideal skills and experience for the job: - Proficiency in front-end development - Basic understanding of PHP - Prior experience in website redesign projects - Familiarity with enhancing user experience The ideal candidate for this...

Hi Zubair Ali S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

A global tour agency is looking to hire experienced and knowledgeable guides for private tours in Jeonju, Gangneung, Jeju City, and Seogwipo, South Korea. Ideal candidates should: - Be well-versed in the local history, culture, and outdoor attractions of the mentioned cities. - Have a friendly, engaging, and professional demeanor. - Have excellent communication skills in English. Korean language proficiency is a plus. The agency is seeking to hire 8 guides, with varying skill sets and tour guiding experiences to cater to the different types of tours being offered. If you have a passion for sharing your knowledge of South Korea and its unique offerings with international visitors, please get in touch.

...necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface. Skills Required: - Proficiency in HTML, CSS, JavaScript, and responsive web design - Experience with web form development and validation PHP Integration

I have an issue with overlapping content in my website's navigation bar and footer. I need a skilled developer to fix the problem. Key Requirements: - Fixing overlapping content in the navigation bar and footer - Ensuring the elements are well-aligned I'm aiming for a responsive design that works seamlessly across different devices - desktop, mobile, and tablet. The final output should be fully functional on Chrome and Safari. Ideal Skills and Experience: - Proficient in PHP, CSS, and HTML - Experience in responsive web design - Knowledge of cross-browser compatibility issues - Prior work with navigation and footer elements - Ability to troubleshoot and resolve design issues efficiently

I need a market survey conducted on Sharjah's real estate market focusing specifically on demand and supply ...on Sharjah's real estate market focusing specifically on demand and supply trends for (residential villas). The focus of the survey should be on Sharjah city and needs to project these trends for the next 5 years. Key responsibilities will include: - Close monitoring and research of property market trends for the given period - Analysis and compilation of data in an easily digestible format - Forecasting of real estate demand and supply trends Ideal freelancers for this job should have: - Strong knowledge of Sharjah's real estate market - Experience in market research and data analysis - Ability to forecast market trends - Background in...

...upload documents. • Secure storage of documents. • API for admins to update the status of submissions. 4. WhatsApp Integration: • Integrate a WhatsApp Business API. • Implement APIs to handle user inquiries and provide automated responses. 5. Database: • Design a schema for storing user data, submission details, payment transactions, and status tracking. • Tables: Users, Submissions, Payments, Statuses, Chat Logs • Ensure data integrity and security. Main Integrations 1. User Registration and Authentication: • Enable users to create accounts and securely log in. 2. Payment Gateway Integration: • Allow users to make payments online using a secure payment gateway. • Track payment statuses and link them to user accounts. 3. Da...

...accuracy in data collection and entry. Additionally, demonstrating respect for privacy laws and guidelines, including GDPR, is essential. Experience with spreadsheets and CRM systems would be advantageous. Gyms must be privately owned only, non franchise. Offer Personal Training. Boutique Exclude: Category - Fitness Equipment Category - Community Health Centres & Services Category - Community Health Centres Category - Fitness Instructor Courses Mentions of - Gov Mentions of - Council Mentions of - Leisure Centre Mentions of - Aquatic Centre Mentions of - University Mentions of - College Mentions of - RSL Mentions of - Pool Mention of - Workers Club / Worker's Club Mentions of - Gymnastics Mentions of - Tai Chi Mentions of - Personal Trainer Mentions of - If only has Pe...

...innovative company in need of a Jr. Flutter Developer with 1-2 years of experience, we are seeking a capable individual to join our team on a monthly basis. The successful candidate will work on mobile application projects. Key Responsibilities: - Development of mobile applications utilizing Flutter - Incorporation of high-quality UI/UX Design and seamless User Experience - Efficient integration of third-party APIs - Proper State Management to ensure the application runs smoothly Extra: - Previous experience with Audio Video Call projects will be a plus The ideal candidate must have: - 1-2 years of experience in Flutter development - Strong understanding of UI/UX design principles - Proven experience in API integration - Solid grasp of state manage...

I'm in need of a talented designer to create a modern and minimalist logo for my brand. Additionally, I require a comprehensive brand manual to ensure consistency across all brand assets. Key Responsibilities: - Develop a modern and minimalist logo that aligns with my brand identity. - Create a detailed brand manual outlining the appropriate use of the logo, color palette, typography, and imagery. Ideal Skills and Experience: - Proficiency in graphic design and branding. - Strong understanding of modern design principles. - Previous experience in creating brand manuals. - Ability to work collaboratively and incorporate feedback. Please note, my target audience is the general public, especially kids, young adults and parents. The successful candidate will be abl...

...larger multimedia project, so a flair for creative versatility and respectful alignment with other elements is vital. Ideal skills would include a strong understanding of the cyberpunk genre, experience in short film project curation, experience with after effects and an outstanding ability to convey tone effectively through visual media. Your portfolio showcasing similar previous work will be highly valued. Scene 1: A Futuristic Cyberpunk city. Actor buys food from a street vendor then walks home down a dark alley. Footage can be via greenscreen or raw on set. (1 min) Scene 2: Actor sits in a dingey room, futuristic screens appear and she interacts with the computer AI. Footage can be green screen or raw on set. (3 min) If you have relevant experience, please s...

I need an individual from Mexico City who can conduct a comprehensive market research focusing on the black beans industry. The research will cover aspects like consumer preferences, competition analysis, and pricing trends. Key Tasks: - Gather and analyze data on consumer preferences regarding black beans in Mexico City. - Conduct a thorough competition analysis of the black beans market in the city. - Identify and document the pricing trends of black beans in the local market. - Complete the questionnaire we provided Target Audience: - Consumers: Understand their preferences, purchasing habits, and expectations. - Retailers: Identify key players, their pricing strategies, and market positioning. - Distributors: Explore current distri...

I'm in need of a skilled Laravel developer to create a QR scanner-enabled webpage. This webpage should be capable of updating a database based on the scanned QR code information. I'm not entirely sure whether an existing database can be used for this project, so your experience in setting up databases would be a plus. Key requirements and decisions to be made: - Setting up a Laravel project with QR scanner functionality - Integration of the scanner with a database to update it according to scanned QR codes - The system should handle multiple scans of the same QR code by the same user by ignoring subsequent scans - The primary action the system should take is a check-in/check-out registration process, triggered by the QR scan Ideal s...

Hello, I'm in need of a skilled UI developer with solid PHP experience to assist with a project. Strong UI Experience + PHP Experience - Have to fix few pages design & layout change for 1 page. Its 4 - 5 hrs work for experience , i will share FTP detail & task detail document in DM Max Budget 1000 INR Regard

...handle large data processing in a timely manner - Implementing efficient resource utilization strategies - Validating the performance of the cluster with real-world workloads The ideal candidate for this role should have: - Proven experience in configuring Cyclecloud HPC clusters - A strong understanding of machine learning and simulation requirements - The ability to optimize resource utilization and improve scalability - Excellent communication and problem-solving skills read the specs: What I would like to do is to set up a Cyclecloud cluster with four partitions to begin with; these will come in pairs. One partition will be high priority (aimed at running uninterruptible workloads) and the second will be low priority (spot), both using the same VM SKU. ...

I'm in need of a logo design for my BBQ cook off team. The logo should feature two bulls back to back with flames behind them. Additionally, I'd like to incorporate the outline of the state of Texas. Key Requirements: - Incorporate the elements of two bulls, flames, and the Texas state outline into the design. - The logo should primarily be colored in blue, gray, black, and red. - Use a bold style font for any text that is included in the logo. Design Preferences: - The style of the logo should be more on the realistic side as opposed to cartoonish. Ideal Candidate: - Prior experience in creating logo designs, particularly those with an illustrative or graphic art focus. - Proficiency in using design software such as Adobe Illus...

...the structure can remain or not. Both it and the RV are currently located in the mapped floodplain. Certainly for procedural questions, the *********** is a good choice. Thank you, THE EXISTING BUILDING IS NOT PERMITTED AND I NEED A STRUCTURAL ENGINEER TO DO CALCS AND DRAWING FOR THE CITY TO GET IT PERMITTED. Conduct comprehensive load calculations: This will involve determining forces, stresses and strains that the structural design will be expected to withstand. - Provide detailed structural drafts: You will focus on delivering accurate structural drafts of the existing building, detailing the current status and structure. - Identify structural integrity code deficiencies: I require someone proficient in interpreting and applying regulations related t...

I'm looking for a skilled Python developer to help me with a scraping project. I need to extract specific product data from a website's table. Skillset: - Proficiency in Python and Scrapy - Experience in web scraping - Familiarity with handling web popups The website () contains a table with important product information. For each product, I need the following details scrapped: Certificate Type Certificate Number Product Type Organization Name Country Issue Date Expiry Date in addition to Product Details Brand Model Description Barcode The data should be saved in a CSV file. There are no specific rules or requirements to be followed during the scraping process.

I'm looking for a skilled PHP Laravel developer to work on a project basis. The ideal candidate should have expertise in the following areas: - Frontend Development - Backend Development - Database Management

I'm seeking a freelancer to collate verified contact details of travel agencies from the UK, USA, Europe, and Latin America. Key project details: - Data to be collect...collected: Only contact information (phone, email, address,webiste link )of decision makers is needed from each agency. - Data segmentation: The collected data should be segmented by country. The purpose of this data collection project is to generate leads for my business. Ideal Candidate: - Experience in web research and data collection. - Familiarity with the travel industry would be a plus. - Attention to detail to ensure accurate data gathering. - Ability to organize data by country for efficient lead generation. Please bid if you are confident in your ability to deliver accurate...

I want a skilled PHP developer with experience in form handling to create a script for me that will block a form's submit button until certain conditions are met. Key Requirements: - The button should only become active if the user types in any text. This means if the form is left blank or a field is left empty, the button should stay inactive. - After clicking the button, if the conditions are not met, I want an error message to be shown to the user. This is to ensure that they understand what is expected before the form is submitted. The form is working inside an wordpress website but was made with php

I'm seeking a sourcing specialist with experience in the prepaid mobile top-up industry. This project involves identifying and onboarding local suppliers for prepaid mobile top-up products in various countries around the world. Key Requirements: - Global Reach: I'm looking for suppliers from all countries. - API Integration: We need a supplier that offers intermediate API integration support. This includes documentation and support team assistance. - Commission Structure: The ideal supplier should offer a percentage-based commission per top-up transaction. The success of this project will be measured by the quality of the sourced suppliers. For each country where a suitable supplier is sourced, a fee of up to $100 will be offered as a reward. Supplier Req...

I'm currently in need of a talented Java backend developer who has a strong understanding of databases, particularly MySQL and PostgreSQL. Key Responsibilities: - API Development: The primary focus of the project is on developing APIs that are efficient, secure, and capable of handling high traffic. - Code Modification: The project requires some modification of existing code to ensure seamless integration of the APIs. - Reporting: The backend developer should be able to generate insightful reports based on the data stored in the databases. Ideal Skills: - Proficiency in Java: Excellent understanding of Java is a must. - Strong Database Skills: Prior experience with MySQL and PostgreSQL is necessary. - API Development: A proven track record ...

...experiencing database retrieval issues. Your task would be to resolve these errors and make the application functional again. - Database Update: You'll need to shift from the current WebSQL database to MySQL and ensure smooth data storage and retrieval. New Features to Add: - User Authentication System: Incorporate a new authentication system to enhance user privacy and security. - Game Timer: Implement a game timer to bring an additional level of challenge and excitement to the gameplay. - Animations & Interactivity: Enhance user experience with engaging animations and interactive elements. Ideal skills for this project: - Proficiency in React Native development - Experience with database management and migration - Strong knowledge o...

I'm in need of an experienced PHP developer to assist in enhancing my project with specific focus on design modifications and functionality enhancements. Key Tasks: - Design Modifications: The project requires a design overhaul to improve aesthetics and user experience. This includes updating the layout, color scheme, typography, and overall visual elements. Your ability to create appealing, modern designs that align with our brand is crucial. - Functionality Enhancements: There are certain functionalities within the project that need to be revisited and improved. Your role will involve identifying areas for enhancement, suggesting necessary changes, and implementing these updates effectively. You should be well-versed in PHP development and capabl...

I'm seeking a professional who can compile a precise B2B mail/email list for local small businesses in my city. Looking for someone to create me a mailing & email list of businesses within specific postcodes of Australia (there will be 20 postcodes) I'm not interested in an outdated existing list.. i want someone to do the work of collating a current list. List headers will include..... Business Name Business Principal contact (if obtainable) Business Email Business Phone number Business registered mailing address Business industry Business registration date

...improvements to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven exper...

...interested in having car, background, and other animations added. These should be creative and interactive to enhance the player experience. - Incorporate sound effects: Sound is an important aspect of any game and I'd like to include sound effects that enhance the overall experience. - Perform necessary bug fixes and improve the game's performance, rendering, scaling, and responsiveness: Ensuring the game runs smoothly on ANY browser (desktop or mobile) and without any issues is crucial. - Enhance the website's completeness and social media integration: The game should be fully integrated into the website and connected well with social media. - Improve the architecture to allow for future features: The game should be in a state that it can be easily ...

I have a website, built on Custom PHP, that I've recently migrated from a test environment to a new domain. However, although subpages are accessible via the new domain, the main page isn't redirecting properly. Key requirements: - Troubleshoot and fix the issue with the main page so that the website is fully functional on the new domain. You should have: - Strong experience with Custom PHP. - Proficiency in React and PHP Laravel. - Good understanding of website migration processes. I have access to the admin panel and can provide you with the necessary logins.

I'm in need of a skilled SEO professional to massively enhance our search engine ranking and subsequently, boost our lead generation. Our current Wordpress site performance is subpar and we are looking to improve this particularly on Google and Bing. We prefer to work with someone within a nearby time zone. Key deliverables include: - Improving our ranking for 10 keywords in 5 city areas where we operate. The company is targeting the areas around 5 specific cities in Wisconsin, USA. - I can provide direction - such as water testing, water softener, water filter, reverse osmosis filter, legionella testing, etc. Open to suggestions. - Increasing leads through better search engine optimization. As far as type of lead, all homes and businesses use water,...