Quarryville PA Real Estate

POST /listings/_search?typed_keys=true
{"query":{"bool":{"filter":[{"terms":{"systemid":[373]}},{"bool":{"must_not":[{"term":{"flag_publicsearch":{"value":false}}}]}},{"terms":{"type_search":[0]}},{"terms":{"type_propertytype":[0,1,3,2,4]}},{"terms":{"type_transactiontype":[0,2]}}],"must":[{"match":{"location_city":{"operator":"and","query":"Quarryville"}}},{"multi_match":{"fields":["location_*","id_listingid"],"operator":"and","query":"PA","type":"cross_fields"}}]}},"size":500,"_source":{"includes":["systemid","detailtablename","id_listinguid","id_listingid","id_primarylistingoffice","id_primarylistingofficename","id_primarylistingagent","status_display","location_streetaddress","location_city","location_state","location_postalcode","bedrooms","bathrooms_total","price_list","primaryimage","squarefootage","geo_coordinates","type_search","type_transactiontype","type_propertytype","type_status","obj_openhouses","price_closed","date_closed","flag_*"]}}

{"took":11,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":7,"relation":"eq"},"max_score":12.937933,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"373-304640512299","_score":12.937933,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"304640512299","id_primarylistingofficename":"Iron Valley Real Estate of Lancaster","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"3234584","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"PA","location_streetaddress":"16 S Hess St","location_postalcode":"17566","bedrooms":4,"flag_internetadvertise":true,"price_list":345000.0,"id_primarylistingoffice":"108058B","squarefootage":3000,"location_city":"Quarryville","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-76.16150665,"lat":39.89660645},"id_listingid":"PALA183520","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"373-304592973330","_score":12.937933,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"304592973330","id_primarylistingofficename":"Magnolia Lane Properties","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"3235144","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"PA","location_streetaddress":"273 Eden Rd","location_postalcode":"17566","bedrooms":5,"flag_internetadvertise":true,"price_list":425000.0,"id_primarylistingoffice":"107945","squarefootage":2850,"location_city":"Quarryville","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-76.14459,"lat":39.91414},"id_listingid":"PALA181708","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"373-304411488748","_score":12.937933,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"304411488748","id_primarylistingofficename":"U.S. Commercial Realty","type_search":0,"type_propertytype":0,"id_primarylistingagent":"3234300","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"PA","location_streetaddress":"672 Scotland Rd","location_postalcode":"17566","flag_internetadvertise":true,"price_list":75000.0,"id_primarylistingoffice":"1317","date_closed":"2021-12-31T00:00:00","location_city":"Quarryville","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-76.20729801,"lat":39.85794307},"id_listingid":"PALA174428","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"373-800782702754","_score":12.937933,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"800782702754","id_primarylistingofficename":"Kingsway Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"3234374","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"PA","location_streetaddress":"4 Hartwicke Dr","location_postalcode":"17566","bedrooms":3,"flag_internetadvertise":true,"price_list":277900.0,"id_primarylistingoffice":"1152","squarefootage":1680,"location_city":"Quarryville","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-76.16363,"lat":39.85391},"id_listingid":"PALA2000608","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"373-304638862111","_score":12.73254,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"304638862111","id_primarylistingofficename":"Kingsway Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"3234374","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"PA","location_streetaddress":"4 Hartwicke Dr","location_postalcode":"17566","bedrooms":3,"flag_internetadvertise":true,"price_list":292900.0,"id_primarylistingoffice":"1152","squarefootage":1680,"location_city":"Quarryville","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-76.16364288,"lat":39.85391235},"id_listingid":"PALA183476","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"373-304544475236","_score":12.73254,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"304544475236","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"3234716","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"PA","location_streetaddress":"162 S Lime St","flag_internetadvertise":true,"price_list":295000.0,"date_closed":"2021-06-30T00:00:00","location_city":"Quarryville","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-76.15398407,"lat":39.89489746},"id_primarylistingofficename":"Realty Professional Group LLC","type_propertytype":0,"location_postalcode":"17566","bedrooms":3,"id_primarylistingoffice":"1451","squarefootage":1040,"id_listingid":"PALA179810","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"373-800769438988","_score":12.73254,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"800769438988","id_primarylistingofficename":"Berkshire Hathaway HomeServices Homesale Realty","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"3235490","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"PA","location_streetaddress":"45 Hartwicke Dr","location_postalcode":"17566","bedrooms":3,"flag_internetadvertise":true,"price_list":324900.0,"id_primarylistingoffice":"HOMESALE007","squarefootage":1248,"location_city":"Quarryville","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-76.16054535,"lat":39.85565186},"id_listingid":"PALA2000402","type_transactiontype":0}}]}}