Ahwahnee CA Real Estate

POST /listings/_search?typed_keys=true
{"query":{"bool":{"filter":[{"terms":{"systemid":[344,61]}},{"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":"Ahwahnee"}}},{"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":14,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":10,"relation":"eq"},"max_score":13.967228,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"344-365379218","_score":13.967228,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365379218","id_primarylistingofficename":"Century 21 Ditton Realty Oak","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"YGbuller1","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1707 Shany Crk","location_postalcode":"93601","bedrooms":3,"flag_internetadvertise":true,"price_list":823000.0,"id_primarylistingoffice":"YGC21DO","squarefootage":1828,"location_city":"Ahwahnee","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-119.722705,"lat":37.425381},"id_listingid":"FR21079203","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365500524","_score":13.967228,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365500524","id_primarylistingofficename":"Concierge Real Estate Services, Inc.","type_search":0,"type_propertytype":0,"bathrooms_total":8,"id_primarylistingagent":"MPsmitht","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"5657 Worman Rd","location_postalcode":"95338","bedrooms":8,"flag_internetadvertise":true,"price_list":5350000.0,"id_primarylistingoffice":"mpcres","squarefootage":3500,"location_city":"Ahwahnee","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-119.70155,"lat":37.454198},"id_listingid":"MP21109518","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"61-398566","_score":13.967228,"_source":{"status_display":"Active","systemid":61,"id_listinguid":"398566","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"17854","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"46408 Opah Dr","flag_internetadvertise":true,"price_list":685000.0,"location_city":"Ahwahnee","detailtablename":"MLS_FAR_RESI","geo_coordinates":{"lon":-119.7011102,"lat":37.3675201},"id_primarylistingofficename":"Century 21 Ditton Realty","type_propertytype":0,"location_postalcode":"93601","bedrooms":4,"id_primarylistingoffice":"1542","squarefootage":2813,"primaryimage":"https://mediall.rapmls.com/fresnomls/listingpics/bigphoto/2021/06/23/386678f5-842e-4dc8-8995-ffd698adcb9e.jpg","id_listingid":"560444","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365323495","_score":13.799061,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365323495","id_primarylistingofficename":"BOLD Realty Group","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"SWFREEWYL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"41829 Rd 600","location_postalcode":"93601","bedrooms":2,"flag_internetadvertise":true,"price_list":289000.0,"id_primarylistingoffice":"SWBRG","squarefootage":1188,"location_city":"Ahwahnee","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-119.730003,"lat":37.352915},"id_listingid":"SW21065367","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"61-396051","_score":13.799061,"_source":{"status_display":"Active","systemid":61,"id_listinguid":"396051","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"17854","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1707 Shany Creek Rd","flag_internetadvertise":true,"price_list":823000.0,"location_city":"Ahwahnee","detailtablename":"MLS_FAR_RESI","geo_coordinates":{"lon":-119.722705,"lat":37.425381},"id_primarylistingofficename":"Century 21 Ditton Realty","type_propertytype":0,"location_postalcode":"93601","bedrooms":3,"id_primarylistingoffice":"1542","squarefootage":1828,"primaryimage":"https://mediall.rapmls.com/fresnomls/listingpics/bigphoto/2021/04/16/de42af07-bc7e-48e7-ab1b-8b1acf40066c.jpg","id_listingid":"557763","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365359517","_score":13.799061,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365359517","id_primarylistingofficename":"Century 21 Ditton Realty Oak","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"YGhohweiler","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"44985 Hwy 49","location_postalcode":"93601","bedrooms":3,"flag_internetadvertise":true,"price_list":400000.0,"id_primarylistingoffice":"YGC21DO","squarefootage":1248,"location_city":"Ahwahnee","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-119.732515,"lat":37.402541},"id_listingid":"FR21074872","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365540475","_score":13.799061,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365540475","id_primarylistingofficename":"Century 21 Ditton Realty Oak","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"YGbuller1","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"46408 Opah Dr","location_postalcode":"93601","bedrooms":4,"flag_internetadvertise":true,"price_list":685000.0,"id_primarylistingoffice":"YGC21DO","squarefootage":2813,"location_city":"Ahwahnee","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-119.70111,"lat":37.36752},"id_listingid":"FR21118479","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"61-398050","_score":13.697474,"_source":{"status_display":"Active","systemid":61,"id_listinguid":"398050","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"13601","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"42787 Primrose Ln","flag_internetadvertise":true,"price_list":469000.0,"location_city":"Ahwahnee","detailtablename":"MLS_FAR_RESI","geo_coordinates":{"lon":-119.7354119,"lat":37.3707143},"id_primarylistingofficename":"Ed Bailey Realty","type_propertytype":0,"location_postalcode":"93644","bedrooms":3,"id_primarylistingoffice":"81637","squarefootage":1838,"primaryimage":"https://mediall.rapmls.com/fresnomls/listingpics/bigphoto/2021/05/30/f6055937-6584-496c-93b8-d405ae1a9824.jpg","id_listingid":"559855","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"61-395740","_score":13.697474,"_source":{"status_display":"Active","systemid":61,"id_listinguid":"395740","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"13236","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"44985 Hwy 49","flag_internetadvertise":true,"price_list":400000.0,"location_city":"Ahwahnee","detailtablename":"MLS_FAR_RESI","geo_coordinates":{"lon":-119.7325145,"lat":37.4025413},"id_primarylistingofficename":"Century 21 Ditton Realty","type_propertytype":0,"location_postalcode":"93601","bedrooms":3,"id_primarylistingoffice":"1542","squarefootage":1248,"primaryimage":"https://mediall.rapmls.com/fresnomls/listingpics/bigphoto/2021/04/28/3b7fe209-3c89-4065-802c-1b8fc08caa6b.jpg","id_listingid":"557422","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365383746","_score":13.697474,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365383746","id_primarylistingofficename":"Century 21 Golden Chain Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"YGjines","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"45368 Dillon Dr","location_postalcode":"93601","bedrooms":3,"flag_internetadvertise":true,"price_list":365000.0,"id_primarylistingoffice":"YGc21gc","squarefootage":1782,"location_city":"Ahwahnee","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-119.719325,"lat":37.355931},"id_listingid":"FR21081143","type_transactiontype":0}}]}}