Automate Calculation of Home Equity from Property Website Data

Automate Calculation of Home Equity from Property Website Data is project number 262388 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Cancelled by Service Buyer)

Status:	Closed
Budget:	$30-250
Created:	05/15/2008 at 8:40 EDT
Bidding Ends:	05/18/2008 at 8:40 EDT
Project Creator:	chadp   Buyer Rating: (No Feedback Yet)
Description:	You are welcome to suggest the best format for providing this solution. It could be a script running on our local PC. It could be hosted on a server somewhere. It doesn't matter, as long as it works and could be operated by someone with little technical skills. The idea is to have the program input several hundred homes in an area (perhaps by subdivision name or by zip code) and to determine the qualifying homes for our direct mail marketing. This project will use property and personal information that is freely available on public internet sites such as our County Property Appraisers website, County Comptroller website, and Zillow. You would have a great amount of flexibility in designing the solution, however it is important to do the following: STEP 1: COMPILE A LIST OF QUALIFYING PROPERTIES. 1.) Determine the current value of each property. 2.) Determine the amount of all mortgages owed against the property from the County Comptroller website. 3.) Determine the resulting amount of equity (using 1 & 2) 4.) For Homes that meet certain criteria (ie: At least 60% equity and no sales in last 5 years or homes where the owner address is different than the property address), summarize the home information in one location (such as an excel spreadsheet or other database) and provide a csv or similar file for mailing. Here are links to sources of data available: http://www.zillow.com http://officialrecords.occompt.com/wb_or1/or_sch_1.asp http://www.ocpafl.org/rec_srch.html#1 STEP 2: MANAGE MAILING INFORMATION. For each qualifying home (determined from Phase 1) we have multiple pieces of mail that we will mail out to those homeowners. They would receive a postcard to start, then they would receive a letter 4 weeks later. Then, a different postcard after another 4 weeks, etc, etc. Since new qualifying homes will be added to the list each week, we need to keep track of when and what we have mailed to each homeowner. This may as easy as having a simple field within a database, but there may be more creative and helpful solutions.
Job Type:	C/C++ Linux PHP Script Installation XML
Database:	(I don't know)
Operating system:	(I don't know)
Bid count:	2
Average bid:	N/A