Westminster CA Real Estate

POST /listings/_search?typed_keys=true
{"query":{"bool":{"filter":[{"terms":{"systemid":[344]}},{"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":"Westminster"}}},{"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":18,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":19,"relation":"eq"},"max_score":9.674392,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"344-365344278","_score":9.674392,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365344278","id_primarylistingofficename":"HPT Realty","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"OCNGUYEPH","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"8831 Rathburn Ave","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":889900.0,"id_primarylistingoffice":"OC02888","squarefootage":2282,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.974941,"lat":33.739352},"id_listingid":"OC21070569","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365538760","_score":9.674392,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365538760","id_primarylistingofficename":"Chapman Realty","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PCHACUR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14321 Baker St","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":712000.0,"id_primarylistingoffice":"PB19973","squarefootage":1547,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.040146,"lat":33.754819},"id_listingid":"PW21116974","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365511213","_score":9.674392,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365511213","id_primarylistingofficename":"Keller Williams Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PROSELAU","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"5352 Yale Ave","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":925000.0,"id_primarylistingoffice":"PB17079","squarefootage":2020,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.036517,"lat":33.760293},"id_listingid":"PW21112486","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365540466","_score":9.674392,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365540466","id_primarylistingofficename":"Regius Realtors","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"SREGIFRE","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15892 Caltech Cir","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":878888.0,"id_primarylistingoffice":"H02979","squarefootage":2587,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.981228,"lat":33.731935},"id_listingid":"OC21118488","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365617479","_score":9.674392,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365617479","id_primarylistingofficename":"Douglas Elliman of California","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"HRACZKRO","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"6131 Apache Rd","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":850000.0,"id_primarylistingoffice":"J01435","squarefootage":2363,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.022566,"lat":33.771765},"id_listingid":"OC21131330","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365617690","_score":9.674392,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365617690","id_primarylistingofficename":"First Team Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"SCAMPLIL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"16460 Venus Dr","location_postalcode":"92683","bedrooms":3,"flag_internetadvertise":true,"price_list":759000.0,"id_primarylistingoffice":"H07700","squarefootage":1058,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.974758,"lat":33.723709},"id_listingid":"OC21124409","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-363754098","_score":9.670601,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"363754098","id_primarylistingofficename":"Seven Gables Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"SLAPPARC","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"8812 Monterey Cir","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":798888.0,"id_primarylistingoffice":"H45560","squarefootage":1932,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.9753753,"lat":33.7368928},"id_listingid":"OC19269196","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-362233520","_score":9.670601,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"362233520","id_primarylistingofficename":"First Team Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"SCAMPLIL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15232 Coronado St","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":699900.0,"id_primarylistingoffice":"H07700","squarefootage":1386,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.9790128,"lat":33.7414101},"id_listingid":"OC19050735","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365306634","_score":9.670601,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365306634","id_primarylistingofficename":"West To East Realty Services","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"KLOMBBON","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"9341 Mirage Ave","location_postalcode":"92683","bedrooms":3,"flag_internetadvertise":true,"price_list":950000.0,"id_primarylistingoffice":"KWES01","squarefootage":1130,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.966293,"lat":33.758205},"id_listingid":"IG21061102","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365480306","_score":9.670601,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365480306","id_primarylistingofficename":"Alliance West Realty","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"PWNGUWIN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"7415 Hazard Ave","location_postalcode":"92683","bedrooms":1,"flag_internetadvertise":true,"price_list":550000.0,"id_primarylistingoffice":"PB16803","squarefootage":480,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.999643,"lat":33.752595},"id_listingid":"PW21105997","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365508580","_score":9.670601,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365508580","id_primarylistingofficename":"T.N.G. Real Estate Consultants","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PNGUJUL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"9821 Cheshire Ave","location_postalcode":"92683","bedrooms":5,"flag_internetadvertise":true,"price_list":1100000.0,"id_primarylistingoffice":"PB16187","squarefootage":2328,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.957804,"lat":33.750534},"id_listingid":"PW21111321","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365470932","_score":9.670601,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365470932","id_primarylistingofficename":"Realty One Group Synergy","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PWARUANA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"7741 Duquesne Pl","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":1125000.0,"id_primarylistingoffice":"PB15175","squarefootage":3062,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.994065,"lat":33.742783},"id_listingid":"PW21103947","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365602703","_score":9.670601,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365602703","id_primarylistingofficename":"Keller Williams Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"HVOTOM","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14841 Bowen St","location_postalcode":"92683","bedrooms":3,"flag_internetadvertise":true,"price_list":839000.0,"id_primarylistingoffice":"OC03193","squarefootage":1204,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.948038,"lat":33.747795},"id_listingid":"OC21129423","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365617664","_score":9.670601,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365617664","id_primarylistingofficename":"Shinn Real Estate Group","type_search":0,"type_propertytype":0,"bathrooms_total":4,"id_primarylistingagent":"OCSHINMAT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14796 Blossom Ln","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":1449000.0,"id_primarylistingoffice":"OC06858","squarefootage":2669,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.956274,"lat":33.748031},"id_listingid":"OC21131344","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365620876","_score":9.670601,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365620876","id_primarylistingofficename":"BHHS CA Properties","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"SWMUESJEF","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"6082 Camphor Ave","location_postalcode":"92683","bedrooms":3,"flag_internetadvertise":true,"price_list":799000.0,"id_primarylistingoffice":"TARB10","squarefootage":1538,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.023069,"lat":33.75552},"id_listingid":"SW21131743","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-363698833","_score":9.616754,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"363698833","id_primarylistingofficename":"Superior Real Estate Group","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PWHOTAMM","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"9921 Margo Ln","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":889000.0,"id_primarylistingoffice":"G275","squarefootage":2286,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.9560884,"lat":33.7347234},"id_listingid":"PW19260380","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365426030","_score":9.616754,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365426030","id_primarylistingofficename":"Tri-Star Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"SWUESCAR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"6681 Sequoia Dr","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":848000.0,"id_primarylistingoffice":"D702","squarefootage":1683,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.012914,"lat":33.77056},"id_listingid":"OC21092751","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365558535","_score":9.616754,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365558535","id_primarylistingofficename":"Saigon Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PHUYNTRI","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"6642 Trask Ave","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":849500.0,"id_primarylistingoffice":"PB6130","squarefootage":1177,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.013417,"lat":33.766095},"id_listingid":"PW21121769","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365595907","_score":9.616754,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365595907","id_primarylistingofficename":"KW Vision","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"W76727","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"6451 Apache Rd","location_postalcode":"92683","bedrooms":4,"flag_internetadvertise":true,"price_list":799000.0,"id_primarylistingoffice":"21113","squarefootage":1817,"location_city":"Westminster","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.016893,"lat":33.773039},"id_listingid":"WS21128266","type_transactiontype":0}}]}}