Export SOLD data from Zillow into Excel Spreadsheet
$30-250 USD
货到付款
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
项目ID: #17174972
关于项目
有20名威客正在参与此工作的竞标,均价$184/小时
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 更多
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 更多
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 更多
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 更多
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 更多
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 更多
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 更多
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 更多
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