La Mirada 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,2,3,21]}},{"terms":{"type_transactiontype":[0,2]}}],"must":[{"match":{"location_city":{"operator":"and","query":"La Mirada"}}},{"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":47,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":19,"relation":"eq"},"max_score":14.5956745,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"344-365543288","_score":14.5956745,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365543288","id_primarylistingofficename":"Re/Max Olympic","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PKURZBOB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"12930 Burgess Ave","location_postalcode":"90638","bedrooms":3,"flag_internetadvertise":true,"price_list":767000.0,"id_primarylistingoffice":"PB6201","squarefootage":1592,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.023206,"lat":33.913319},"id_listingid":"PW21118939","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365610862","_score":14.5956745,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365610862","id_primarylistingofficename":"Century 21 Westworld Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"WBAXTDIA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14713 Excelsior Dr","location_postalcode":"90638","bedrooms":3,"flag_internetadvertise":true,"price_list":775000.0,"id_primarylistingoffice":"M046","squarefootage":1757,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.017616,"lat":33.894926},"id_listingid":"PW21130132","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365549361","_score":14.5956745,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365549361","id_primarylistingofficename":"Re/Max Discover","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PCHAMICL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14704 Ragan Dr","location_postalcode":"90638","bedrooms":4,"flag_internetadvertise":true,"price_list":820000.0,"id_primarylistingoffice":"PB17801","squarefootage":1729,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.01822,"lat":33.911818},"id_listingid":"PW21120390","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365563432","_score":14.5956745,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365563432","id_primarylistingofficename":"Berkshire Hathaway Home Srvcs","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"TRPERESUL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"12902 Duffield Ave","location_postalcode":"90638","bedrooms":5,"flag_internetadvertise":true,"price_list":765000.0,"id_primarylistingoffice":"8559","squarefootage":1767,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.036334,"lat":33.914458},"id_listingid":"TR21118568","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365662906","_score":14.5956745,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365662906","id_primarylistingofficename":"Ed Moore Realty, Inc.","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PWMOORROD","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14379 Ramo Dr","location_postalcode":"90638","bedrooms":3,"flag_internetadvertise":true,"price_list":690000.0,"id_primarylistingoffice":"M024","squarefootage":1506,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.025377,"lat":33.904597},"id_listingid":"PW21135586","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365545772","_score":14.5956745,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365545772","id_primarylistingofficename":"Century 21 Westworld Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"MGUSIPAU","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15304 Talbot Dr","location_postalcode":"90638","bedrooms":4,"flag_internetadvertise":true,"price_list":825000.0,"id_primarylistingoffice":"M046","squarefootage":1688,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.998961,"lat":33.891951},"id_listingid":"PW21119403","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365543314","_score":14.440214,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365543314","id_primarylistingofficename":"All California Brokerage Inc","type_search":0,"type_propertytype":1,"bathrooms_total":1,"id_primarylistingagent":"RSERGFRA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15920 Alta Vista Dr #H","location_postalcode":"90638","bedrooms":1,"flag_internetadvertise":true,"price_list":399000.0,"id_primarylistingoffice":"RFRA","squarefootage":830,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.990777,"lat":33.907891},"id_listingid":"RS21116560","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365510848","_score":14.440214,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365510848","id_primarylistingofficename":"Re/Max Dynasty","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"MROJAPAT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15229 Imperial","location_postalcode":"90638","bedrooms":3,"flag_internetadvertise":true,"price_list":1375000.0,"id_primarylistingoffice":"PB20012","squarefootage":2965,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.005388,"lat":33.916765},"id_listingid":"PW21112353","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365389329","_score":14.440214,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365389329","id_primarylistingofficename":"All Pro Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"NCHAVJUA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"8162 Andora Dr","location_postalcode":"90638","bedrooms":3,"flag_internetadvertise":true,"price_list":780000.0,"id_primarylistingoffice":"N597","squarefootage":1944,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.991402,"lat":33.894707},"id_listingid":"PW21082056","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365654692","_score":14.440214,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365654692","id_primarylistingofficename":"Century 21 Cornerstone","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PCAMPMER","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15917 Golva Dr","location_postalcode":"90638","bedrooms":3,"flag_internetadvertise":true,"price_list":715000.0,"id_primarylistingoffice":"W578","squarefootage":1080,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.991275,"lat":33.896291},"id_listingid":"PW21136124","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365548544","_score":14.440214,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365548544","id_primarylistingofficename":"Helen Yi, Broker","type_search":0,"type_propertytype":1,"bathrooms_total":2,"id_primarylistingagent":"PYIHELEN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"13405 Avenida Santa Tecla #G","location_postalcode":"90638","bedrooms":2,"flag_internetadvertise":true,"price_list":452000.0,"id_primarylistingoffice":"PB17037","squarefootage":1060,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.992308,"lat":33.90849},"id_listingid":"PW21120245","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365627417","_score":14.440214,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365627417","id_primarylistingofficename":"Century 21 Westworld Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"WBAXTDIA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"16027 Jalon Rd","location_postalcode":"90638","bedrooms":3,"flag_internetadvertise":true,"price_list":670000.0,"id_primarylistingoffice":"M046","squarefootage":1176,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.007216,"lat":33.88632},"id_listingid":"PW21132786","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-364746574","_score":14.427902,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"364746574","id_primarylistingofficename":"Albert Garcia, Broker","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PGARALBE","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15209 Borda Rd","location_postalcode":"90963","bedrooms":4,"flag_internetadvertise":true,"price_list":775000.0,"id_primarylistingoffice":"PB13627","squarefootage":1840,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.01782,"lat":33.894225},"id_listingid":"PW20192517","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365402584","_score":14.427902,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365402584","id_primarylistingofficename":"Eva Raleigh, Broker","type_search":0,"type_propertytype":21,"bathrooms_total":2,"id_primarylistingagent":"OCRALEEVA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14030 Lake View Dr #146","location_postalcode":"90638","bedrooms":2,"flag_internetadvertise":true,"price_list":260000.0,"id_primarylistingoffice":"OC07461","squarefootage":1632,"location_city":"La Mirada","detailtablename":"MLS_CACR_Park","geo_coordinates":{"lon":-118.032935,"lat":33.914229},"id_listingid":"OC21086439","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365624184","_score":14.427902,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365624184","id_primarylistingofficename":"Keller Williams Realty","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PWBAIKKWA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14741 Sabine Dr","location_postalcode":"90638","bedrooms":4,"flag_internetadvertise":true,"price_list":929000.0,"id_primarylistingoffice":"PB18969","squarefootage":2531,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.016942,"lat":33.914579},"id_listingid":"PW21131138","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365622522","_score":14.427902,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365622522","id_primarylistingofficename":"Global PNC Real Estate","type_search":0,"type_propertytype":1,"bathrooms_total":1,"id_primarylistingagent":"YCARRJAI","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"13610 La Jolla Cir #A","location_postalcode":"90638","bedrooms":1,"flag_internetadvertise":true,"price_list":395000.0,"id_primarylistingoffice":"YGPN","squarefootage":864,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.99325,"lat":33.906955},"id_listingid":"DW21131349","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365597026","_score":14.427902,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365597026","id_primarylistingofficename":"Keller Williams Pacific Estates La Mirada","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PWKAESAND","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"13128 Los Alisos St","location_postalcode":"90638","bedrooms":4,"flag_internetadvertise":true,"price_list":1095000.0,"id_primarylistingoffice":"PB19240","squarefootage":2505,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.989216,"lat":33.911694},"id_listingid":"PW21126708","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365610666","_score":14.427902,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365610666","id_primarylistingofficename":"Keller Williams Newport Estate","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PGUANJO","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15811 Rosalita Dr","location_postalcode":"90638","bedrooms":3,"flag_internetadvertise":true,"price_list":700000.0,"id_primarylistingoffice":"PB15812","squarefootage":1264,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.993333,"lat":33.901768},"id_listingid":"PW21129615","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365420597","_score":14.427902,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365420597","id_primarylistingofficename":"Reliance Real Estate Services","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PFISCBET","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14832 San Ardo Dr","location_postalcode":"90638","bedrooms":4,"flag_internetadvertise":true,"price_list":905000.0,"id_primarylistingoffice":"PB18008","squarefootage":1700,"location_city":"La Mirada","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.014995,"lat":33.890232},"id_listingid":"PW21090402","type_transactiontype":0}}]}}