I am interested in a list of realtors from the NJ (New Jersey) counties below: Bergen, Passaic, (excluding West Milford and Ringwood), Morris, Hudson, Essex, Union, and Middlesex. The towns with their zipcodes are shown on the attachment.
You may want to spider (use web crawler) to get this data. One good possible source of this data would be the State of New Jersey Department of Banking & Insurance's website.
The site is at https://www20.state.nj.us/DOBI_LicSearch/recSearch.jsp - you can click A through Z under name.
Select license status ACTIVELY LICENSED. Select license type BROKER OF RECORD, then BROKER SALESPERSON, then SALESPERSON under separate searches.
On the search results, the Licensee Name would appear in caps (e.g. ABADI,HOSSEIN A.). We want you to remove middle initial and want the Licensee Name in mixed upper/lower case format in separate fields as follows: First Name (Hossein) Last Name (Abadi).
Click on Actively Licensed and get the Address and Phone Number. We would like the address in separate fields (e.g. City, State, and Zipcode…again in mixed Upper Case/Lower Case if easy for you).
Dedupe all records by name to removing any dupes between BROKER OF RECORD, BROKER SALESPERSON, and SALESPERSON.
Please also find an email address of each of the brokers and salespersons from reliable sources such as company website.
Please provide final file in XLS or CSV format with separate fields for First Name, Last Name, Company, Address1, Address2 (if/when needed), City, State, Zipcode, Phone Number, and Email Address at Contact level (not generic such as firstname.lastname@example.org unless in a small number of cases this is the only listed email address).
I'd like to see 10 or 20 samples meeting my parameters.
Alternatively, I am interested in a list of NJ realtors in the same zipcodes/towns below that have listings on zillow.com, trulia.com, njmls.com, realtor.com, etc. with homes containing oil heat.
Perhaps this can be done with spidering as well. You'd need to identify oil heat among the keywords in the match (e.g. on zillow, you can search to Buy and under Towns below one by one, and under 'More' dropdown menu, search for oil heat.
I'd want all the same fields above plus a link to the listing which contains oil heat. I'd like to see 10 or 20 samples meeting these parameters if you can do this as well.
Budget shown is just a placeholder. Please let me know how much you would charge for this job and the amount of time needed to complete the job.