Export SOLD data from Zillow into Excel Spreadsheet
$30-250 USD
Paid on delivery
Create Sold homes databases for entire states in an Excel CSV by exporting 'recently sold' Data from Zillow
On Zillow you can have a view of 1.4m sold properties in California --> task is how to get all the key data from these properties into an Excel (multiple excel files).
1. Create databases by state for all recently sold properties on Zillow
2. Create macro (or R script) to have this as an automated 'refresh' monthly for newly sold properities to be added to the database
e.g. searching california = 1.4m properties
[login to view URL],-109.456788,31.372399,-129.144288_rect/5_zm/
One home example:
[login to view URL]
Below is a list of what I'd like to have in the database, following all the entries that go into the sold homes listing. This is not an exhaustive list as just taken from one example for now - ie. im sure new variables may pop up with different types of home and we'd need to record them as well
Field Example; Format
Zillow Property URL; text
Street Address; Text
City; Text
State; Text
ZIP; Text
Sold: Number
Sold On: Date
Zestimate: Number
Rent Zestimate: Number
Beds: Number
Baths: Number
SqFt: Number
Lot: Text (number if possible)
Type: Text
Year Built: Number
Last Sold: Text
Parking: Text
Cooling: Text
Heating: Text
Fireplace Text
INTERIOR FEATURES
Beds: 3
Heating1: Text
Heating2: Text
Cooling: Text
Basement: Text
Attic: text
Appliances: text (this will need to be split out into seperate variables e.g. 'Dishwasher (Y/N)', 'Dryer (Y/N)' etc.
Floor Size: Number
Flooring: Text (May need seperate variables e.g. Laminate(Y/N), Tile (Y/N)
Other Interiro feautures: Seperate variables e.g. Fireplace (Y/N), Ceiling Fan (Y/N)
Building Size story: Number
Spaces: (Separate variables e.g. Jetted Pool (Y/N), Tub (Y/N)
Structure Type: Text e.g. Single Family Home
Materials Roof: text
Exterior material: text
Last remodel year: date
Built in: date
Stories: number
EXTERIOR FEATURES
Water: text
View: (Separate variables e.g. Mountain (Y/N), City (Y/N)
Parcel #: number
Neighborhood name: text
Community: text
Elementary school: text
Middle school: text
High school: text
School district: text
Parking: (Separate variables e.g. Carport (Y/N), Off Street (Y/N), Attached (Y/N)
Utilities: Text
Last sold date : date
Last sold Value: number
Last sale price/sqft: number
Bedrooms Total: number
Bedrooms: number
PRICE HISTORY: take max 3 only
Date 1: date
Sold 1: number
Date 2: date
Sold 2: number
Date 3: date
Sold 3: number
Project ID: #17174972
About the project
20 freelancers are bidding on average $184 for this job
Hello, I can help with you in your project Export SOLD data from Zillow into Excel Spreadsheet. I have more than 5 years of experience in Data Mining, Excel, R Programming Language, Web Scraping. We have worked on s More
Hello, I have working experience of more than 7 year on-Web Research, lead generation, data entry, data mining, lead collection, And all types of scrapping tools like - data toolbar, Visual Web ripper and email addres More
I have excellent command on MS Excel and have worked with Zillow before. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatic More
Hi I am a very experienced statistician and programmer I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done pr More
Hello I can achieve this project perfectly using php curl library or visual basic selenium library python 2.7 beautifulsoup library I can automate the scrapping process then save the data in csv , sql or txt files More
How are you, kanssproperty?. Do you need to have in the database, following all the entries that go into the sold homes listing ?.I have the ability to do it We have experience in thoses skills: R Pro More
Hi, I am a decision scientist with 3.5+ years of experience working with Mu Sigma, one of the largest data sciences firm in the world. While working there, I have gained experience in R, Python, Excel and Web Scrapp More
I have worked in business for 20+ years, and Excel, Access, and data analysis is a large part of my success. I am also a real estate investor and have an interest in the growth of this industry. Relevant Skills and E More
Hello , i would like to work with you . Have experience with US real estate data from last 3.6 yrs . We can work further if you like
Hi I have developed a software for scraping zillow, it is able to extract data from zillow beyond display limits. Please discuss. Thanks