I am looking for homes with pools in Rancho Cucamonga, California.
These houses should be 2500 square feet or larger.
I am looking for homes that have sold within the last year (primarily) and all homes with pools secondarily.
[url removed, login to view] has listings as far back as 9 months.
I would like them put in an Excel spread sheet, (each page should be a neighborhood or subdivision) with the following:
0. Last date sold
1. Street Number
2. Street Name
3. Zip code
Many people have responded to let me know they can extract the homes sold that have pools.
I also need the ones that have pools in the neighborhood that HAVEN'T sold within a year as a secondary attribute. I don't know if this can be done, but I do know that if you click on homes that are NOT for sale, Trulia will give you information about the house--including pool.
I am not saying Trulia has to be the site used. I just know they have the data available.
If you could show me that you can get the information from 1 neighborhood or street, to show that you can do it that would be good.
I apologize for the lack of clarification earlier. But this is to be used for primary and secondary marketing.
For those who have offered me the code, that is a big plus, as I might adapt it for use at a later date.
I will make a decision by Saturday night Pacific Daylight Savings Time.
I hope this helps clarify further:
Specifically, I don't care about homes that are for sale, because I would have to talk to new owners for my product, and I can track that without any outside help. With the US housing market (CA especially) anything beyond 3 years is probably worthless due to financial situation of my target market.
I'm sorry for any earlier confusion on my part. I just realized that Redfin is probably a better source for the data mining (than Trulia) as they already have information set up (for sales up to 3 years), but I also want a list of secondary homes for marketing purposes that have not sold (beyond 3 years). If there are homes for sale on the secondary list, then that is OK, but they should probably be identified as such, i.e. (FOR SALE), and I can follow up on them later.
So, if any of you freelancers would prefer to use Redfin, use sales up to 3 years old, and put that date in the 0 column, that would be more helpful, and you could use FOR SALE for homes listed for sale, that could suffice.
If you have an idea for how you would implement this that doesn't meet these categories but you feel would produce a better spreadsheet (more usable) I'm open to suggestions. Perhaps column 0 "Last Date Sold" could be given a numerical value such as:
0= For Sale
1=Sold within 180 days
2=Sold 181-365 days
3=Sold 366-730 days
4=Sold 731-1095 days
5=Sold 1096-1461 days
6=Sold >1462 days
I apologize for the revision, but with the examples I've been given and the discovery of the information on Redfin.com I think it might be easier to get the information I need.
If this complicates things to the point where you need to revise your bid, feel free to do so. It's important that I get the information I need, moreso, than the source where you draw the information.
If you can provide a small example, that has the information, I can check it for accuracy.
9 freelancers are bidding on average $88 for this job
Hello! I can do this for [login to view URL] fact, I really want to do it. I'll make sure you'll love the work. I can do this really fast. Waiting to hear from you soon. Thank You!