Loudoun VA 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_county":{"operator":"and","query":"Loudoun"}}},{"multi_match":{"fields":["location_*","id_listingid"],"operator":"and","query":"VA","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":34,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":378,"relation":"eq"},"max_score":7.5232186,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"373-304628605070","_score":7.5232186,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"304628605070","type_search":0,"bathrooms_total":5,"id_primarylistingagent":"65021","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"VA","location_streetaddress":"25808 Success Dr","flag_internetadvertise":true,"price_list":884990.0,"location_city":"Aldie","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-77.55489,"lat":38.90526},"id_primarylistingofficename":"RE/MAX Real Estate Connections","type_propertytype":0,"location_postalcode":"20105","bedrooms":5,"id_primarylistingoffice":"RAES2","obj_openhouses":[{"remarks_marketingremarks":"JUST COME AND SHIOW","type_openhousetype":0,"date_enddatetime":"2021-06-13T20:00:00","date_startdatetime":"2021-06-13T17:00:00"}],"squarefootage":3187,"id_listingid":"VALO439994","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"373-800769430862","_score":7.5232186,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"800769430862","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"3093212","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"VA","location_streetaddress":"42159 Warwick Farm Pl","flag_internetadvertise":true,"price_list":880000.0,"location_city":"Aldie","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-77.5460602,"lat":38.895261},"id_primarylistingofficename":"RE/MAX Gateway, LLC","type_propertytype":0,"location_postalcode":"20105","bedrooms":4,"id_primarylistingoffice":"RMAX110","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-19T19:00:00","date_startdatetime":"2021-06-19T16:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-06-20T18:00:00","date_startdatetime":"2021-06-20T16:00:00"}],"squarefootage":2894,"id_listingid":"VALO2000514","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"373-304625646056","_score":7.4987745,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"304625646056","id_primarylistingofficename":"Pearson Smith Realty, LLC","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"3321269","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"VA","location_streetaddress":"122 W Virginia Ave","location_postalcode":"20158","bedrooms":3,"flag_internetadvertise":true,"price_list":415000.0,"id_primarylistingoffice":"PSTH1","squarefootage":1422,"location_city":"Hamilton","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-77.66488,"lat":39.13745},"id_listingid":"VALO439778","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"373-304529796748","_score":7.2397094,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"304529796748","id_primarylistingofficename":"Toll Brothers Real Estate Inc.","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"151913","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"VA","location_streetaddress":"43543 Charitable St","location_postalcode":"20148","bedrooms":3,"flag_internetadvertise":true,"price_list":689950.0,"id_primarylistingoffice":"TOLL1","squarefootage":2400,"location_city":"Ashburn","detailtablename":"MLS_MDBM_RESI","geo_coordinates":{"lon":-77.49786376,"lat":39.00350333},"id_listingid":"VALO434062","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"373-301752470577","_score":7.2397094,"_source":{"status_display":"Active","systemid":373,"id_listinguid":"301752470577","type_search":0,"bathrooms_total&qu