Rio Vista CA Real Estate

POST /listings/_search?typed_keys=true
{"query":{"bool":{"filter":[{"terms":{"systemid":[390,222]}},{"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":"Rio Vista"}}},{"multi_match":{"fields":["location_*","id_listingid"],"operator":"and","query":"CA","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":19,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":10,"relation":"eq"},"max_score":13.77047,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"390-90258428","_score":13.77047,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90258428","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"C326181","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"670 Cypress Dr","flag_internetadvertise":true,"price_list":425000.0,"location_city":"Rio Vista","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.7113074,"lat":38.1808039},"id_primarylistingofficename":"Century 21 MM","type_propertytype":0,"location_postalcode":"94571","bedrooms":2,"id_primarylistingoffice":"7MMNA21","squarefootage":1451,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/05/29/99207a90-80ba-41a1-b15e-50c562e96aea.jpg","id_listingid":"321046477","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90251187","_score":13.77047,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90251187","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"C337826","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1002 Olympic Dr","flag_internetadvertise":true,"price_list":339000.0,"location_city":"Rio Vista","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.7138681,"lat":38.1818017},"id_primarylistingofficename":"Wood Real Estate","type_propertytype":0,"location_postalcode":"94571","bedrooms":2,"id_primarylistingoffice":"7C489","squarefootage":950,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/19/8ec4481b-a1e3-4a20-9d99-3466a093b1c9.jpg","id_listingid":"321042709","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90265686","_score":13.77047,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90265686","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"C323078","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"700 Rolling Green Dr","flag_internetadvertise":true,"price_list":479800.0,"location_city":"Rio Vista","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.689684,"lat":38.1644695},"id_primarylistingofficename":"McGahey Real Estate Team Judy Davis Broker","type_propertytype":0,"location_postalcode":"94571","bedrooms":4,"id_primarylistingoffice":"CWALDIE","squarefootage":1866,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/10/5ff53263-3fba-40eb-986f-6cace4d891af.jpg","id_listingid":"321051029","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90256963","_score":13.77047,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90256963","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"B405049","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"2155 Reunion Ln","flag_internetadvertise":true,"price_list":489900.0,"location_city":"Rio Vista","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.717468,"lat":38.200688},"id_primarylistingofficename":"LGI Realty - California, LLC","type_propertytype":0,"location_postalcode":"94571","bedrooms":2,"id_primarylistingoffice":"7B1735","squarefootage":1686,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/09/ba40a69f-4b79-489e-9981-f94069022775.jpg","id_listingid":"321046176","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90234633","_score":13.753839,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90234633","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"B405049","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"2266 Park Pl","flag_internetadvertise":true,"price_list":470900.0,"location_city":"Rio Vista","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.717824,"lat":38.202411},"id_primarylistingofficename":"LGI Realty - California, LLC","type_propertytype":0,"location_postalcode":"94571","bedrooms":2,"id_primarylistingoffice":"7B1735","squarefootage":1686,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/09/86be7b7b-3aac-4168-8f13-090c1d367348.jpg","id_listingid":"321031439","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90256966","_score":13.753839,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90256966","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"B405049","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"2179 Reunion Ln","flag_internetadvertise":true,"price_list":489900.0,"location_city":"Rio Vista","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.7174672,"lat":38.200979},"id_primarylistingofficename":"LGI Realty - California, LLC","type_propertytype":0,"location_postalcode":"94571","bedrooms":2,"id_primarylistingoffice":"7B1735","squarefootage":1686,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/05/27/908432ee-3974-40e0-9387-bc5ad83f70e1.jpg","id_listingid":"321046182","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90270079","_score":13.753839,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90270079","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"C337826","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"670 Cypress Dr","flag_internetadvertise":true,"price_list":435000.0,"location_city":"Rio Vista","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.7113074,"lat":38.1808039},"id_primarylistingofficename":"Wood Real Estate","type_propertytype":0,"location_postalcode":"94571","bedrooms":2,"id_primarylistingoffice":"7C489","squarefootage":1451,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/16/4bf25414-4fe2-4551-aff8-bf42d1f382d6.jpg","id_listingid":"321054122","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90221807","_score":13.753839,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90221807","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"B405049","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"2211 Reunion Ln","flag_internetadvertise":true,"price_list":470900.0,"location_city":"Rio Vista","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.7174723,"lat":38.2014439},"id_primarylistingofficename":"LGI Realty - California, LLC","type_propertytype":0,"location_postalcode":"94571","bedrooms":2,"id_primarylistingoffice":"7B1735","squarefootage":1686,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/04/09/b38a36c1-fe53-41da-a86b-895f05fe6d08.jpg","id_listingid":"321023922","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90273886","_score":13.753839,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90273886","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"C319988","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"511 Edgewood Dr","flag_internetadvertise":true,"price_list":425000.0,"location_city":"Rio Vista","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.7079228,"lat":38.1810017},"id_primarylistingofficename":"Shafer Real Estate, Inc.","type_propertytype":0,"location_postalcode":"94571","bedrooms":2,"id_primarylistingoffice":"7CSHAFER","squarefootage":1451,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/21/92be698c-03f7-4c86-ad57-02944ef1d44c.jpg","id_listingid":"321056343","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90274881","_score":13.740707,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90274881","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"C336706","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"150 Alpine","flag_internetadvertise":true,"price_list":474900.0,"location_city":"Rio Vista","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.7197908,"lat":38.1798372},"id_primarylistingofficename":"Shafer Real Estate, Inc.","type_propertytype":0,"location_postalcode":"94571","bedrooms":2,"id_primarylistingoffice":"7CSHAFER","squarefootage":1837,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/23/a1ef303f-7835-41da-a112-bd12daf394fd.jpg","id_listingid":"321057014","type_transactiontype":0}}]}}