I need someone to find one available office unit for rent in a building or complex in each city on the excel spreadsheet and put the full address of the unit , including street address, suite or unit#, city, state and zip code in column E in the spreadsheet, that is the column labeled "address" at the top. I repeat, IT MUST HAVE A SUITE OR UNIT # to be usable for this project.
I need this for each of the 2000 cities. If it is missing any part of the address it wont be usable so please make sure the full address is copied into the address space for that city.
I prefer you do the first 5 cities so I can double check and make sure you understand and used the site correctly to obtain the addresses. Thank you.
I am looking for someone that can obtain addresses for the cities/states provided on my spreadsheet using FIRST SOURCE: www.loopnet.com and yelp.com as the SECONDARY SOURCE if not found in FIRST.
Spreadsheet: State is shown in column C & City is shown in column B, you plug in the found address in column E. (Some of the city names are abbreviated or have no spaces for example row 19 on spreadsheet says NEWORLEANS but is found using in data base under New Orleans with a space the words. You have to have some knowledge in city names to be able to know this.
You will be logging in to www.loopnet.com using user name Login ID: (Please see attached word doc for log in details) Password: (Please see attached word doc for log in details)
1. When you log onto the website you will see the screen where you can place city and state. You can choose tabs (for rent or for lease) & options for office.
2. Once you hit the search box your results will populate. YOU WILL NEED TO CLICK INTO THE LISTING, for the address to populate if you don’t find addresses in office (for rent and for Lease) if you can’t find an address in for rent and for lease, click on office for sale. Click on the link for each address to see full address.
3. Once you click the link it will open the listing to the full address. You will then take the address and place it on the excel sheet attached. IT MUST also HAVE A SUITE OR UNIT #
4. Plug the address onto the spreadsheet; make sure the address includes city and state and zip code. Full address is needed!
SECOND SOURCE (if address is Not found in 1st source)
1. If you do not find an address using www.loopnet.com then the secondary source to look for an address is through yelp.com
2. You will type in find search bar type in “Business” and then city and state in the near portion of the search bar, click search and look for the business with the LEAST business reviews.
3. Plug the address onto the spreadsheet; make sure the address includes city and state and zip code.
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
42 freelancers están ofertando el promedio de $139 para este trabajo
Sir, I'm ready to help you. Could you please select me as your employeeee? If so, i will do your work perfectly. Waiting for your words through PM. Thanks
Sir, I am willing to do your project and ready to start work. I will provide you a good result with accuracy . My aim is to satisfy my client by my work . Please response . Thanks