Norwalk 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":"Norwalk"}}},{"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":27,"relation":"eq"},"max_score":12.191187,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"344-363525694","_score":12.191187,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"363525694","id_primarylistingofficename":"Nationwide Real Estate Execs","type_search":0,"type_propertytype":1,"bathrooms_total":2,"id_primarylistingagent":"RSBEATMAT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"12920 Geronimo Ln","location_postalcode":"90650","bedrooms":5,"flag_internetadvertise":true,"price_list":399000.0,"id_primarylistingoffice":"RS20","squarefootage":1472,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.0625661,"lat":33.9137531},"id_listingid":"RS19234538","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365557962","_score":12.191187,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365557962","id_primarylistingofficename":"Compass","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"CLW-C104404","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"10925 Liggett St","location_postalcode":"90650","bedrooms":2,"flag_internetadvertise":true,"price_list":490000.0,"id_primarylistingoffice":"CLW-X7755905","squarefootage":924,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.101821,"lat":33.901179},"id_listingid":"21744724","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365520765","_score":12.191187,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365520765","id_primarylistingofficename":"Corcoran Global Living","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"SWGUZMJUA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"10921 Maza St","location_postalcode":"90650","bedrooms":4,"flag_internetadvertise":true,"price_list":670000.0,"id_primarylistingoffice":"SWIRE","squarefootage":1803,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.100175,"lat":33.912219},"id_listingid":"SW21113729","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365545575","_score":12.191187,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365545575","id_primarylistingofficename":"Prime Time Realty & Associates","type_search":0,"type_propertytype":1,"bathrooms_total":2,"id_primarylistingagent":"DWCABALE","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"12920 Mesquite Ln","location_postalcode":"90650","bedrooms":4,"flag_internetadvertise":true,"price_list":469999.0,"id_primarylistingoffice":"YPTA","squarefootage":1347,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.059003,"lat":33.91391},"id_listingid":"DW21116124","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365354994","_score":12.191187,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365354994","id_primarylistingofficename":"EXCELLENCE RE REAL ESTATE","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"M44788","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14705 Studebaker Rd","location_postalcode":"90650","bedrooms":2,"flag_internetadvertise":true,"price_list":525000.0,"id_primarylistingoffice":"9702","squarefootage":1129,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.100266,"lat":33.897029},"id_listingid":"MB21073738","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365606243","_score":12.191187,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365606243","id_primarylistingofficename":"Excellence RE Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"DWRUIGAB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"13731 Erwood Ave","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":630000.0,"id_primarylistingoffice":"DWEXL","squarefootage":1232,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.079369,"lat":33.906968},"id_listingid":"DW21129964","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-363517015","_score":12.178056,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"363517015","id_primarylistingofficename":"Century 21 On Target","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PKOHJAN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15119 Caulfield Ave","location_postalcode":"90650","bedrooms":4,"flag_internetadvertise":true,"price_list":535000.0,"id_primarylistingoffice":"PB5210","squarefootage":1510,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.0604368,"lat":33.8939833},"id_listingid":"PW19233159","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-364976475","_score":12.178056,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"364976475","id_primarylistingofficename":"Century 21 Peak","type_search":0,"type_propertytype":1,"bathrooms_total":3,"id_primarylistingagent":"DWROSTEV","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"12025 Orange St #A","location_postalcode":"90650","bedrooms":2,"flag_internetadvertise":true,"price_list":569000.0,"id_primarylistingoffice":"DWCYK","squarefootage":1350,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.077712,"lat":33.903362},"id_listingid":"DW20242727","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365514270","_score":12.178056,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365514270","id_primarylistingofficename":"EXCELLENCE RE REAL ESTATE","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"M44788","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"11507 Beaty Ave","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":680000.0,"id_primarylistingoffice":"9702","squarefootage":1826,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.087623,"lat":33.925531},"id_listingid":"MB21113206","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365184309","_score":12.178056,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365184309","id_primarylistingofficename":"Calidad Realty","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"RLIPIN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"12067 Barnwall St","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":495000.0,"id_primarylistingoffice":"RS39","squarefootage":964,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.07547,"lat":33.891418},"id_listingid":"RS21029138","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365571334","_score":12.178056,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365571334","id_primarylistingofficename":"CENTURY 21 KING","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"c23561","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"12124 Hayford St","location_postalcode":"90650","bedrooms":5,"flag_internetadvertise":true,"price_list":525000.0,"id_primarylistingoffice":"1363","squarefootage":817,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.074488,"lat":33.888157},"id_listingid":"CV21124780","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365593932","_score":12.178056,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365593932","id_primarylistingofficename":"Excellence RE Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"M440008","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"12150 Beaty Ave","location_postalcode":"90650","bedrooms":2,"flag_internetadvertise":true,"price_list":555888.0,"id_primarylistingoffice":"97982","squarefootage":768,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.073745,"lat":33.924206},"id_listingid":"MB21127996","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365422844","_score":12.178056,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365422844","id_primarylistingofficename":"C-21 Astro","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"RCLIVSHA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15514 Studebaker Rd","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":679800.0,"id_primarylistingoffice":"RCAS","squarefootage":1660,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.099603,"lat":33.889589},"id_listingid":"RS21091245","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365599507","_score":12.178056,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365599507","id_primarylistingofficename":"Pinnacle Real Estate Group","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"ws81768","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"11445 Hayford St","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":668000.0,"id_primarylistingoffice":"20652","squarefootage":1216,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.090496,"lat":33.887785},"id_listingid":"WS21128712","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365534368","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365534368","id_primarylistingofficename":"VAAC INTERNATIONAL, INC.","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"W73177","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"11913 Gem St","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":619800.0,"id_primarylistingoffice":"21323","squarefootage":1008,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.078546,"lat":33.922338},"id_listingid":"WS21117020","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365561906","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365561906","id_primarylistingofficename":"Realty Group Int'l of America","type_search":0,"type_propertytype":1,"bathrooms_total":1,"id_primarylistingagent":"PWCARAZU","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"10655 Lakefront Dr","location_postalcode":"90650","flag_internetadvertise":true,"price_list":267800.0,"id_primarylistingoffice":"PB20927","squarefootage":477,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.107471,"lat":33.902697},"id_listingid":"PW21122633","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365140976","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365140976","id_primarylistingofficename":"Your Home Team Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"RMULLALV","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"10876 Tonibar St","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":629900.0,"id_primarylistingoffice":"RCYH","squarefootage":1062,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.100769,"lat":33.906816},"id_listingid":"RS21018088","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365539684","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365539684","id_primarylistingofficename":"Opendoor Brokerage Inc.","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"CLW-C134974","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"15002 Flatbush Ave","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":750000.0,"id_primarylistingoffice":"CLW-X82364","squarefootage":1111,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.106301,"lat":33.894614},"id_listingid":"21742682","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365311030","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365311030","id_primarylistingofficename":"Impact Properties, Inc.","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"DWBOCALE","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"12327 Roseton Ave","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":670000.0,"id_primarylistingoffice":"DWIPT","squarefootage":1430,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.088172,"lat":33.919094},"id_listingid":"DW21062208","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365579161","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365579161","id_primarylistingofficename":"Think Boutiq Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"PWWAHLDUB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"10973 Liggett St","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":595000.0,"id_primarylistingoffice":"PB20978","squarefootage":1119,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.100266,"lat":33.901162},"id_listingid":"PW21122353","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365543870","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365543870","id_primarylistingofficename":"Keller Williams SELA","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"YROBLRAL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"12005 Pioneer Blvd","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":720000.0,"id_primarylistingoffice":"YKWI","squarefootage":1548,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.082136,"lat":33.922474},"id_listingid":"DW21118678","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365596848","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365596848","id_primarylistingofficename":"Manna Realty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"RSHONGJEN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"11947 Cedarvale St","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":565000.0,"id_primarylistingoffice":"RMAN","squarefootage":1134,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.078206,"lat":33.88171},"id_listingid":"RS21127911","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365620206","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365620206","id_primarylistingofficename":"Beacon Hillcrest","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"RHERNERI","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"11719 Arlee Ave","location_postalcode":"90650","bedrooms":4,"flag_internetadvertise":true,"price_list":675000.0,"id_primarylistingoffice":"RBHC","squarefootage":1652,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.081009,"lat":33.924535},"id_listingid":"RS21131863","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365588059","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365588059","id_primarylistingofficename":"Coldwell Banker Alliance","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PPAULECH","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"11516 Thomas Pl","location_postalcode":"90650","bedrooms":4,"flag_internetadvertise":true,"price_list":628800.0,"id_primarylistingoffice":"W133","squarefootage":1083,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.0876,"lat":33.926359},"id_listingid":"PW21126226","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365608012","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365608012","id_primarylistingofficename":"C-21 Astro","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"RFUKUBOO","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"11926 Lowemont St","location_postalcode":"90650","bedrooms":4,"flag_internetadvertise":true,"price_list":630999.0,"id_primarylistingoffice":"RCAS","squarefootage":1408,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.079095,"lat":33.889538},"id_listingid":"RS21130101","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365624311","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365624311","id_primarylistingofficename":"Lancelot","type_search":0,"type_propertytype":1,"bathrooms_total":1,"id_primarylistingagent":"SR207065806","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"14085 Bayside Dr","location_postalcode":"90650","flag_internetadvertise":true,"price_list":229000.0,"id_primarylistingoffice":"F8423001","squarefootage":477,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.10701,"lat":33.903248},"id_listingid":"SR21132449","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365618970","_score":12.034561,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365618970","id_primarylistingofficename":"First Team Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"DWREIJUD","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"11033 Belfair St","location_postalcode":"90650","bedrooms":3,"flag_internetadvertise":true,"price_list":599900.0,"id_primarylistingoffice":"DWFTM","squarefootage":958,"location_city":"Norwalk","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-118.098782,"lat":33.903642},"id_listingid":"DW21130119","type_transactiontype":0}}]}}