?
? This is a three part screen scraping program that will download to a .csv file public records.
?
?
## Deliverables
?
**PART 1**
**I want the program to open up a box and let me input a date range that I want to search for Deeds of Trust**
**Once I enter the date range the program should go out and search the following website for any deeds of trust that have been recorded.**
**<[login to view URL]>**
**? **
**In the document type drop down list box select D-T**
**Your program will need to search in 3 day increments to prevent it coming back with over 6000 records.**
**Once search button is selected**
**The program should traverse all the deeds of trust and record the following information in there own column.**
**1.? ? ? ? ? **The book and page number****
**2.? ? ? ? ? **First Full name under grantor ie John Doe****
**3.? ? ? ? ? **Second Full name under grantor if there is one ie Jane Doe****
**4.? ? ? ? ? **Grantee****
**5.? ? ? ? ? **Date Deed of Trust was recorded.****
**? **
**The program should download all the information into an excel type sheet.**
**? **
**? **
**? **
**Part 2**
**Then go back to the webpage**
**<[login to view URL]>**
**? **
**Go through the excel sheet and enter the first name under grantor and check the number of deed of trust from the date the deed of trust was recorded and todays current date and return that in a column.**
**? **
**? **
**? **
**Part 3**
Open the following website
<[login to view URL]>
The program should go through the excel spreadsheet and input the first grantor into the search by owner box.
If the property comes up select the link, if it comes back with no records select the second person under grantor and search again.
?
If no property records show for either go to the next record, if more than one shows up for either, go to the next user.
If just one record comes up select that record and return the following information:
Owners Mailing Property address
Owners Mailing City, State
Owners Mailing Zip Code
Property Location Address
Property Location City, State
Property Location Zip Code
?
Check whether the owners mailing property address and property location address match and return a yes or no
Return the pkg sale date
Return the pkg sales price
Return the total value assessed
?
?
?