STATE
COUNTY
ZIP
PROPERTY TYPES
Compiled monthly · data as of July 2026 · CC0 · about 44,394 U.S. properties change every day · live data →
SAMPLE — 5 REPRESENTATIVE PROPERTIES · all 30 columns (scroll →)
| id | street | unit | city | state | zip | lat | lng | property_type | beds | baths | sqft | lot_sqft | year_built | status | list_price | last_sold_price | last_sold_date | heating_type | central_air | hoa_fee | pool | garage | waterfront | fireplace | basement | listing_type | parcel_apn | county_fips | source_count |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| stp_DkXM69Be1A | 2930 Highway D | Philadelphia | MO | 63463 | 39.841777 | -91.739852 | single_family | 2 | 1 | 936 | 55,757 | 2023 | off_market | 139,500 | 2025-04-22 | heat_pump | true | 0050112102002000 | 29127 | 2 | |||||||||
| stp_vzmMYE2Wzy | 1904 Highway 168 | Philadelphia | MO | 63463 | 39.843456 | -91.75534 | single_family | 2 | 1.5 | 1,200 | 4,965,840 | 2012 | off_market | 535,500 | gas | 0050111000001000 | 29127 | 1 | |||||||||||
| stp_vzm29pAMjy | 3199 County Road 197 | Philadelphia | MO | 63463 | 39.835552 | -91.784966 | single_family | 3 | 2 | 1,500 | 1,306,800 | 1975 | off_market | 408,400 | other | true | true | true | 0050210000005000 | 29127 | 1 | ||||||||
| stp_PjxZRavg1O | 545 Highway 168 | Philadelphia | MO | 63463 | 39.818535 | -91.83326 | single_family | 4 | 1 | 1,754 | 11,064,240 | 2023 | off_market | 377,400 | other | 0050417000007000 | 29127 | 1 | |||||||||||
| stp_dkWEyqXEz2 | 1177 Highway 168 | Philadelphia | MO | 63463 | 39.839466 | -91.81105 | single_family | 3 | 1 | 2,356 | 3,310,560 | 1978 | off_market | 515,200 | other | true | true | 0050516000001000 | 29127 | 1 |