Skip to content

Instantly share code, notes, and snippets.

@mustafa-qamaruddin

mustafa-qamaruddin/realtor-propstream-merge.json

Created July 10, 2021 22:28
Show Gist options
  • Save mustafa-qamaruddin/16a4a2dd8bfca6272358e2ae62f3edcf to your computer and use it in GitHub Desktop.
Save mustafa-qamaruddin/16a4a2dd8bfca6272358e2ae62f3edcf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
realtor-propstream-merge.json
{
"took": 3,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 5486,
"relation": "eq"
},
"max_score": 2.0,
"hits": [
{
"_index": "realestate",
"_type": "_doc",
"_id": "nc_salisbury_28147_3008_raymond_ave",
"_score": 2.0,
"_source": {
"owner1Company_propstream": "",
"lastSaleDate_propstream": null,
"longitude_propstream": -80.5096649586788,
"lastSaleAmount_propstream": null,
"yearBuilt_propstream": 1960,
"owner2FirstName_propstream": "",
"zip_propstream": "28147",
"propertyType_propstream": "Single Family (SFR)",
"countyName_propstream": "Rowan",
"bathrooms_propstream": 1,
"estimatedEquity_propstream": 100645.0,
"imageUrl_propstream": "https://images.listing.propstream.com/no_photo.jpg",
"type_propstream": "O",
"lotSquareFeet_propstream": 10019,
"stateCode_propstream": "NC",
"apn_propstream": "461A163",
"squareFeet_propstream": 950,
"owner1LastName_propstream": "FACEMYER",
"landUse_propstream": "Single Family Residential",
"owner1FirstName_propstream": "BRENDA",
"owner2LastName_propstream": "",
"bedrooms_propstream": null,
"propstream_id_propstream": "1802454632",
"estimatedValue_propstream": 100645.0,
"status_propstream": "",
"latitude_propstream": 35.6429457165923,
"streetAddress_propstream": "3008 Raymond Ave",
"pricePerSquareFoot_propstream": null,
"cityName_propstream": "Salisbury",
"bed_realtor": null,
"address_realtor": "3008 Raymond Ave",
"lot_realtor": 10019,
"sqft_realtor": 950,
"state_realtor": "NC",
"bath_realtor": 1,
"url_realtor": "https://www.realtor.com/realestateandhomesdetail/3008RaymondAve_Salisbury_NC_28147_M5602015624",
"city_realtor": "Salisbury",
"zip_realtor": "28147",
"estimate_value_realtor": 109400.0
}
},
{
"_index": "realestate",
"_type": "_doc",
"_id": "nc_salisbury_28147_3110_raymond_ave",
"_score": 2.0,
"_source": {
"owner1Company_propstream": "",
"lastSaleDate_propstream": "2016-10-07",
"longitude_propstream": -80.5113023171744,
"lastSaleAmount_propstream": 72000.0,
"yearBuilt_propstream": 1925,
"owner2FirstName_propstream": "LINDA",
"zip_propstream": "28147",
"propertyType_propstream": "Single Family (SFR)",
"countyName_propstream": "Rowan",
"bathrooms_propstream": 1,
"estimatedEquity_propstream": 21813.0,
"imageUrl_propstream": "https://images.listing.propstream.com/20160428/403835646.png",
"type_propstream": "O",
"lotSquareFeet_propstream": 16988,
"stateCode_propstream": "NC",
"apn_propstream": "470014",
"squareFeet_propstream": 1072,
"owner1LastName_propstream": "REMSBERG",
"landUse_propstream": "Single Family Residential",
"owner1FirstName_propstream": "JUDITH",
"owner2LastName_propstream": "PERDUE",
"bedrooms_propstream": null,
"propstream_id_propstream": "1802473881",
"estimatedValue_propstream": 85307.0,
"status_propstream": "",
"latitude_propstream": 35.6414917267536,
"streetAddress_propstream": "3110 Raymond Ave",
"pricePerSquareFoot_propstream": 67.16,
"cityName_propstream": "Salisbury",
"bed_realtor": 3,
"address_realtor": "3110 Raymond Ave",
"lot_realtor": 16988,
"sqft_realtor": 1112,
"state_realtor": "NC",
"bath_realtor": 1,
"url_realtor": "https://www.realtor.com/realestateandhomesdetail/3110RaymondAve_Salisbury_NC_28147_M5330656403",
"city_realtor": "Salisbury",
"zip_realtor": "28147",
"estimate_value_realtor": 116000.0
}
},
{
"_index": "realestate",
"_type": "_doc",
"_id": "ga_atlanta_30311_526_harlan_rd_sw",
"_score": 2.0,
"_source": {
"owner1Company_propstream": "",
"lastSaleDate_propstream": "2021-06-02",
"longitude_propstream": -84.4791743083778,
"lastSaleAmount_propstream": 250000.0,
"yearBuilt_propstream": 1958,
"owner2FirstName_propstream": "BRIGGETTE",
"zip_propstream": "30311",
"propertyType_propstream": "Single Family (SFR)",
"countyName_propstream": "Fulton",
"bathrooms_propstream": null,
"estimatedEquity_propstream": 269929.0,
"imageUrl_propstream": "https://dexjpy0wclpxj.cloudfront.net/175421651/f6148c2e3e4f00fe5c84b329b0c98535.jpeg?Expires=1712307131&Signature=i3N7tCRZVZwc04I~apGWgJMor79etbcOgB8-sV1Iy091RzksUPS~vxz~~mtm2mpnJDY1QthUl44b5utpKbO1PjA4AmKngo1CAIJyN7sYdSE-RpyDt1F5QQRmB95BbjKoeNkUUGY0hf6xL5m1QAE-UEU5HlAuyT5l-E~bZyrp2ALx5azHmr6MCMxGllA4lqTinpnSjTEy3QdOXLow3ioNS4kHh3jJMRrAxgCpTV8iUK8uyJ0cqUUEc3kkNedNwOoi7x4BLrTKRyUErAe6QJ-ATIXxgIAY4zucDMYRzbsrh-6ZsPo41KbHZyT6wwRZ7lCFcuru2~wRO5dpOpCf7e937g__&Key-Pair-Id=APKAIRLUSEP6QUB5PEZQ",
"type_propstream": "O",
"lotSquareFeet_propstream": 21736,
"stateCode_propstream": "GA",
"apn_propstream": "14-0213-0003-018-3",
"squareFeet_propstream": 1640,
"owner1LastName_propstream": "DERRICO",
"landUse_propstream": "Single Family Residential",
"owner1FirstName_propstream": "JOSEPHINE",
"owner2LastName_propstream": "LAWRENCE",
"bedrooms_propstream": 3,
"propstream_id_propstream": "1741419628",
"estimatedValue_propstream": 269929.0,
"status_propstream": "CONTINGENT",
"latitude_propstream": 33.7447437545641,
"streetAddress_propstream": "526 Harlan Rd SW",
"pricePerSquareFoot_propstream": 152.44,
"cityName_propstream": "Atlanta",
"bed_realtor": 3,
"address_realtor": "526 Harlan Rd SW",
"lot_realtor": 21780,
"sqft_realtor": null,
"state_realtor": "GA",
"bath_realtor": 3,
"url_realtor": "https://www.realtor.com/realestateandhomesdetail/526HarlanRdSW_Atlanta_GA_30311_M6701597729",
"city_realtor": "Atlanta",
"zip_realtor": "30311",
"estimate_value_realtor": 275000.0
}
},
{
"_index": "realestate",
"_type": "_doc",
"_id": "tx_rio_hondo_78583_32439_fm_2925",
"_score": 2.0,
"_source": {
"owner1Company_propstream": "",
"lastSaleDate_propstream": "2020-08-19",
"longitude_propstream": -97.5018698742445,
"lastSaleAmount_propstream": 182500.0,
"yearBuilt_propstream": 1986,
"owner2FirstName_propstream": "AIDA",
"zip_propstream": "78583",
"propertyType_propstream": "Single Family (SFR)",
"countyName_propstream": "Cameron",
"bathrooms_propstream": null,
"estimatedEquity_propstream": 62990.0,
"imageUrl_propstream": "https://images.listing.propstream.com/no_photo.jpg",
"type_propstream": "O",
"lotSquareFeet_propstream": 25783,
"stateCode_propstream": "TX",
"apn_propstream": "73-1650-0000-0115-00",
"squareFeet_propstream": 1554,
"owner1LastName_propstream": "TREVINO",
"landUse_propstream": "Single Family Residential",
"owner1FirstName_propstream": "CHARLES",
"owner2LastName_propstream": "GONZALEZ",
"bedrooms_propstream": null,
"propstream_id_propstream": "1829845302",
"estimatedValue_propstream": 202485.0,
"status_propstream": "",
"latitude_propstream": 26.3236455785781,
"streetAddress_propstream": "32439 Fm 2925",
"pricePerSquareFoot_propstream": 117.44,
"cityName_propstream": "Rio Hondo",
"bed_realtor": 2,
"address_realtor": "32439 Fm 2925",
"lot_realtor": 50393,
"sqft_realtor": 1554,
"state_realtor": "TX",
"bath_realtor": 2,
"url_realtor": "https://www.realtor.com/realestateandhomesdetail/32439Fm2925_RioHondo_TX_78583_M7948344077",
"city_realtor": "Rio Hondo",
"zip_realtor": "78583",
"estimate_value_realtor": 153200.0
}
},
{
"_index": "realestate",
"_type": "_doc",
"_id": "ga_hoschton_30548_522_durham_dr",
"_score": 2.0,
"_source": {
"owner1Company_propstream": "",
"lastSaleDate_propstream": "2006-10-20",
"longitude_propstream": -83.7089278381245,
"lastSaleAmount_propstream": 289900.0,
"yearBuilt_propstream": 2006,
"owner2FirstName_propstream": "MELISSA",
"zip_propstream": "30548",
"propertyType_propstream": "Single Family (SFR)",
"countyName_propstream": "Jackson",
"bathrooms_propstream": null,
"estimatedEquity_propstream": 211653.0,
"imageUrl_propstream": "https://images.listing.propstream.com/no_photo.jpg",
"type_propstream": "O",
"lotSquareFeet_propstream": 39204,
"stateCode_propstream": "GA",
"apn_propstream": "107B019",
"squareFeet_propstream": 2336,
"owner1LastName_propstream": "POTTER",
"landUse_propstream": "Single Family Residential",
"owner1FirstName_propstream": "JEFFREY",
"owner2LastName_propstream": "POTTER",
"bedrooms_propstream": null,
"propstream_id_propstream": "1742388384",
"estimatedValue_propstream": 390738.0,
"status_propstream": "",
"latitude_propstream": 34.0498848237049,
"streetAddress_propstream": "522 Durham Dr",
"pricePerSquareFoot_propstream": 124.1,
"cityName_propstream": "Hoschton",
"bed_realtor": null,
"address_realtor": "522 Durham Dr",
"lot_realtor": 39204,
"sqft_realtor": 2336,
"state_realtor": "GA",
"bath_realtor": 4,
"url_realtor": "https://www.realtor.com/realestateandhomesdetail/522DurhamDr_Hoschton_GA_30548_M5072238979",
"city_realtor": "Hoschton",
"zip_realtor": "30548",
"estimate_value_realtor": 402600.0
}
},
{
"_index": "realestate",
"_type": "_doc",
"_id": "pa_hatboro_19040_42_flamingo_rd",
"_score": 2.0,
"_source": {
"owner1Company_propstream": "",
"lastSaleDate_propstream": "2004-03-31",
"longitude_propstream": -75.1115569554716,
"lastSaleAmount_propstream": 249100.0,
"yearBuilt_propstream": 1956,
"owner2FirstName_propstream": "DARYL",
"zip_propstream": "19040",
"propertyType_propstream": "Single Family (SFR)",
"countyName_propstream": "Montgomery",
"bathrooms_propstream": null,
"estimatedEquity_propstream": 198927.0,
"imageUrl_propstream": "https://images.listing.propstream.com/no_photo.jpg",
"type_propstream": "O",
"lotSquareFeet_propstream": 9100,
"stateCode_propstream": "PA",
"apn_propstream": "59-00-07798-009",
"squareFeet_propstream": 1516,
"owner1LastName_propstream": "FENSTAD",
"landUse_propstream": "Single Family Residential",
"owner1FirstName_propstream": "ELLEN",
"owner2LastName_propstream": "FENSTAD",
"bedrooms_propstream": 3,
"propstream_id_propstream": "1818842355",
"estimatedValue_propstream": 356954.0,
"status_propstream": "",
"latitude_propstream": 40.1828946368964,
"streetAddress_propstream": "42 Flamingo Rd",
"pricePerSquareFoot_propstream": 164.31,
"cityName_propstream": "Hatboro",
"bed_realtor": 4,
"address_realtor": "42 Flamingo Rd",
"lot_realtor": 9148,
"sqft_realtor": 1516,
"state_realtor": "PA",
"bath_realtor": 2,
"url_realtor": "https://www.realtor.com/realestateandhomesdetail/42FlamingoRd_Hatboro_PA_19040_M4452517061",
"city_realtor": "Hatboro",
"zip_realtor": "19040",
"estimate_value_realtor": 318600.0
}
},
{
"_index": "realestate",
"_type": "_doc",
"_id": "va_mc_lean_22101_1403_homeric_ct",
"_score": 2.0,
"_source": {
"owner1Company_propstream": "",
"lastSaleDate_propstream": "2007-04-05",
"longitude_propstream": -77.1877308135333,
"lastSaleAmount_propstream": 669000.0,
"yearBuilt_propstream": 1958,
"owner2FirstName_propstream": "PRISCILLA",
"zip_propstream": "22101",
"propertyType_propstream": "Single Family (SFR)",
"countyName_propstream": "Fairfax",
"bathrooms_propstream": 3,
"estimatedEquity_propstream": 94898.0,
"imageUrl_propstream": "https://images.listing.propstream.com/no_photo.jpg",
"type_propstream": "O",
"lotSquareFeet_propstream": 10751,
"stateCode_propstream": "VA",
"apn_propstream": "030-1-12-0205",
"squareFeet_propstream": 1334,
"owner1LastName_propstream": "MURRELL",
"landUse_propstream": "Single Family Residential",
"owner1FirstName_propstream": "DAVID",
"owner2LastName_propstream": "MURRELL",
"bedrooms_propstream": 4,
"propstream_id_propstream": "1843253258",
"estimatedValue_propstream": 893214.0,
"status_propstream": "",
"latitude_propstream": 38.9348301443511,
"streetAddress_propstream": "1403 Homeric Ct",
"pricePerSquareFoot_propstream": 501.5,
"cityName_propstream": "Mc Lean",
"bed_realtor": 4,
"address_realtor": "1403 Homeric Ct",
"lot_realtor": 10751,
"sqft_realtor": 1334,
"state_realtor": "VA",
"bath_realtor": 3,
"url_realtor": "https://www.realtor.com/realestateandhomesdetail/1403HomericCt_MCLean_VA_22101_M6348658103",
"city_realtor": "Mc Lean",
"zip_realtor": "22101",
"estimate_value_realtor": 940900.0
}
},
{
"_index": "realestate",
"_type": "_doc",
"_id": "wv_morgantown_26501_106_kay_st",
"_score": 2.0,
"_source": {
"owner1Company_propstream": "",
"lastSaleDate_propstream": "2016-06-06",
"longitude_propstream": -79.99606745,
"lastSaleAmount_propstream": 236000.0,
"yearBuilt_propstream": 1972,
"owner2FirstName_propstream": "",
"zip_propstream": "26501",
"propertyType_propstream": "Single Family (SFR)",
"countyName_propstream": "Monongalia",
"bathrooms_propstream": null,
"estimatedEquity_propstream": 44750.0,
"imageUrl_propstream": "https://images.listing.propstream.com/20150903/186694145.png",
"type_propstream": "O",
"lotSquareFeet_propstream": 8999,
"stateCode_propstream": "WV",
"apn_propstream": "31-07-5A-0013.0000",
"squareFeet_propstream": 1956,
"owner1LastName_propstream": "FULLER",
"landUse_propstream": "Single Family Residential",
"owner1FirstName_propstream": "MARJORIE",
"owner2LastName_propstream": "",
"bedrooms_propstream": 3,
"propstream_id_propstream": "1850452533",
"estimatedValue_propstream": 254592.0,
"status_propstream": "",
"latitude_propstream": 39.63116815,
"streetAddress_propstream": "106 Kay St",
"pricePerSquareFoot_propstream": 120.65,
"cityName_propstream": "Morgantown",
"bed_realtor": 3,
"address_realtor": "106 Kay St",
"lot_realtor": 8712,
"sqft_realtor": 2408,
"state_realtor": "WV",
"bath_realtor": 3,
"url_realtor": "https://www.realtor.com/realestateandhomesdetail/106KaySt_Morgantown_WV_26501_M4098467528",
"city_realtor": "Morgantown",
"zip_realtor": "26501",
"estimate_value_realtor": 228700.0
}
},
{
"_index": "realestate",
"_type": "_doc",
"_id": "wa_leavenworth_98826_16410_chumstick_hwy",
"_score": 2.0,
"_source": {
"owner1Company_propstream": "",
"lastSaleDate_propstream": "2020-02-06",
"longitude_propstream": -120.634388753684,
"lastSaleAmount_propstream": 326500.0,
"yearBuilt_propstream": 1988,
"owner2FirstName_propstream": "",
"zip_propstream": "98826",
"propertyType_propstream": "Other",
"countyName_propstream": "Chelan",
"bathrooms_propstream": 2,
"estimatedEquity_propstream": 216796.0,
"imageUrl_propstream": "https://export.propstream.com/resource/public/lhimg?path=NYSMLS/10680924/1?LM=20191227T005956",
"type_propstream": "O",
"lotSquareFeet_propstream": 5,
"stateCode_propstream": "WA",
"apn_propstream": "261830440150",
"squareFeet_propstream": 1728,
"owner1LastName_propstream": "MELNYK",
"landUse_propstream": "Mobile home",
"owner1FirstName_propstream": "JOSEPH",
"owner2LastName_propstream": "",
"bedrooms_propstream": 3,
"propstream_id_propstream": "1846436637",
"estimatedValue_propstream": 541958.0,
"status_propstream": "REMOVED",
"latitude_propstream": 47.7181786615473,
"streetAddress_propstream": "16410 Chumstick Hwy",
"pricePerSquareFoot_propstream": 188.95,
"cityName_propstream": "Leavenworth",
"bed_realtor": 2,
"address_realtor": "16410 Chumstick Hwy",
"lot_realtor": 217800,
"sqft_realtor": 1344,
"state_realtor": "WA",
"bath_realtor": 1,
"url_realtor": "https://www.realtor.com/realestateandhomesdetail/16410ChumstickHwy_Leavenworth_WA_98826_M2832231029",
"city_realtor": "Leavenworth",
"zip_realtor": "98826",
"estimate_value_realtor": 311600.0
}
},
{
"_index": "realestate",
"_type": "_doc",
"_id": "pa_duncansville_16635_1000_short_st",
"_score": 2.0,
"_source": {
"owner1Company_propstream": "",
"lastSaleDate_propstream": null,
"longitude_propstream": -78.4365005869561,
"lastSaleAmount_propstream": null,
"yearBuilt_propstream": 1975,
"owner2FirstName_propstream": "LOIS",
"zip_propstream": "16635",
"propertyType_propstream": "Single Family (SFR)",
"countyName_propstream": "Blair",
"bathrooms_propstream": 1,
"estimatedEquity_propstream": 222919.0,
"imageUrl_propstream": "https://export.propstream.com/resource/public/lhimg?path=AHARPA/60140/1?LM=20210323T142216",
"type_propstream": "O",
"lotSquareFeet_propstream": 2,
"stateCode_propstream": "PA",
"apn_propstream": "02.00-13..-016.00-000",
"squareFeet_propstream": 1685,
"owner1LastName_propstream": "WILT",
"landUse_propstream": "Single Family Residential",
"owner1FirstName_propstream": "NEIL",
"owner2LastName_propstream": "WILT",
"bedrooms_propstream": 3,
"propstream_id_propstream": "1815665307",
"estimatedValue_propstream": 222919.0,
"status_propstream": "REMOVED",
"latitude_propstream": 40.4327688710813,
"streetAddress_propstream": "1000 Short St",
"pricePerSquareFoot_propstream": null,
"cityName_propstream": "Duncansville",
"bed_realtor": 3,
"address_realtor": "1000 Short St",
"lot_realtor": 77101,
"sqft_realtor": null,
"state_realtor": "PA",
"bath_realtor": 1,
"url_realtor": "https://www.realtor.com/realestateandhomesdetail/1000ShortSt_Duncansville_PA_16635_M4183405596",
"city_realtor": "Duncansville",
"zip_realtor": "16635",
"estimate_value_realtor": 225000.0
}
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment