Zillow

About

The US Real Estate pipeline provides comprehensive information on properties across the United States. The pipeline includes details such as property addresses, square footage, number of bathrooms and bedrooms, latitude and longitude, price history, and agent information. This data is essential for real estate analysis, market research, and investment decisions.

Data Dictionary

Field Name
Data Type
Explanation

zpid

Integer

Unique Zillow property identifier

address

String

Full address of the property

city

String

City where the property is located

state

String

State where the property is located

zip

String

ZIP code of the property location

sqft

Integer

Total square footage of the property

is_complex

Boolean

Indicates if the property is part of a complex or building

baths

Float

Number of bathrooms in the property

beds

Integer

Number of bedrooms in the property

lat

Float

Latitude coordinates of the property location

lng

Float

Longitude coordinates of the property location

rent

Float

Monthly rent price (if the property is listed for rent)

zrent

Float

Estimated rent price as calculated by Zillow

home_status

String

Current status of the home (e.g., For Sale, For Rent, Sold)

home_type

String

Type of property (e.g., Single Family, Condo, Apartment)

reference_url

String

URL to the Zillow page or reference URL for the property listing

url

String

URL to the Zillow property listing

description

String

Description of the property as provided in the listing

great_schools_rating

Integer

Rating of nearby schools according to GreatSchools (if available)

price_history

String

History of price changes for the property (if available)

days_on_zillow

Integer

Number of days the property has been listed on Zillow

agent_name

String

Name of the listing agent

agent_business_name

String

Business name or agency associated with the listing agent

agent_type

String

Type of agent (e.g., Listing Agent, Buyer’s Agent)

agent_info

String

Additional information about the agent (e.g., contact details, specialties)

days_listed

Integer

Number of days the property has been actively listed

contacts

Integer

Number of contacts or inquiries received regarding the property listing

applications

Integer

Number of rental applications submitted for the property (if applicable)

owner

String

Name or identifier of the owner (if available and applicable)

CSV Example

Last updated