This is a most complete homes and real estates database for sale from 49 popular cities of the United States. It contains 275,904 real estates and homes by 6 types (Single Family Home, Condo/Townhome/Row Home/Co-Op, Multi-Family Home, Land, Mfd/Mobile Home & Farms/Ranches) in the data set. Each real estate home consists of photo count, price, street address, address locality, address region, postal code, bedroom, bathroom, squar foot, city id, latitude, longitude, etc. It also has 17,701 neighborhood records related with these real estates. The whole America real estates & homes database consists of 7 tables.
| Name | n3a2_realtor_com |
|---|---|
| Data | 264.34M (+ 0B) |
| Tables | 7 (+ 0) |
| Columns | 43 (+ 0) |
| Table Rows | 928,239 (+ 0) |
| Media | 10.39G (+ 0B) |
| Files | 103,269 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 49 | title |
100%
|
| neighborhood | 17,701 | title |
100%
|
| real_estate_home | 275,904 | photo_count |
100%
|
| label_new |
18.66%
|
||
| price |
90.76%
|
||
| street_address |
98.69%
|
||
| address_locality |
100%
|
||
| address_region |
100%
|
||
| postal_code |
100%
|
||
| bedrooms |
82.01%
|
||
| bathrooms |
90.56%
|
||
| sq_ft |
87.43%
|
||
| sq_ft_lot |
43.22%
|
||
| acres_lot |
25.15%
|
||
| garage |
63.84%
|
||
| broker |
26.41%
|
||
| latitude |
96.3%
|
||
| longitude |
96.3%
|
||
| city_id |
100%
|
||
| listing_photo |
0%
|
||
| real_estate_home_x_neighborhood | 358,481 | real_estate_home_id |
100%
|
| neighborhood_id |
100%
|
||
| real_estate_home_x_type | 276,098 | real_estate_home_id |
100%
|
| type_id |
100%
|
||
| type | 6 | title |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
REAL_ESTATE_HOME_IMAGE
| Size (Bytes) | Files |
|---|---|
| 10.39G | 103,269 |
