Completed

Find pool homes in Southern California sold <9 month

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.

Added 10/21/11
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.

Skills: Cartography & Maps, Data Mining, Excel

See more: trulia com, find in page, find code, cartography, cartography and maps, maps houses, excel find date, excel spread, spread excel, sold, spread sheet excel, maps square, pools, pool com, find com, Cartography maps, find date, southern specialty homes, 2500 month, california database sales tax zip code, find business zip code script, california sales tax rates zip code sql, street maps, zip code table california, find page flash enimation give describtion site

About the Employer:
( 1 review ) Apple Valley, United States

Project ID: #1256800

Awarded to:

meljackson72

October 20, 2011 galdoral: Thank you for the opportunity to submit my proposal for your project "Find Pool Homes in Southern California sold <9 months". I have thoroughly reviewed your job description and believe More

$100 USD in 2 days
(4 Reviews)
3.4

9 freelancers are bidding on average $88 for this job

sy3d

lets start .. check pm .. thx

$99 USD in 2 days
(147 Reviews)
6.5
deepali111

Hello galdarol please check P.M for further details

$60 USD in 1 day
(70 Reviews)
5.7
fredrick1973

Hi, I am interested. Please view PM for more details. Thanks

$100 USD in 2 days
(1 Review)
1.2
karimji

Hello sir I am willing to do this job for you. Please check private message.

$80 USD in 4 days
(1 Review)
1.0
tonykim100

Hello sir! Please check PMB.

$120 USD in 2 days
(1 Review)
1.8
AnMoP

I'm ready to help you with the construction of your file

$90 USD in 2 days
(0 Reviews)
0.0
alraji

Hello! I can do this for [url removed, login to view] 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!

$80 USD in 3 days
(0 Reviews)
0.0
mishad38

i can do this sir!!!

$60 USD in 6 days
(0 Reviews)
0.0