Brea 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":"Brea"}}},{"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":10,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":27,"relation":"eq"},"max_score":12.460788,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"344-365356838","_score":12.460788,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365356838","id_primarylistingofficename":"DRS Brokers","type_search":0,"type_propertytype":0,"bathrooms_total":5,"id_primarylistingagent":"DWFLOSOC","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"507 Cable Canyon Pl","location_postalcode":"92821","bedrooms":5,"flag_internetadvertise":true,"price_list":1799000.0,"id_primarylistingoffice":"DWDRS","squarefootage":4065,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.867561,"lat":33.926878},"id_listingid":"DW21074214","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365333498","_score":12.460788,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365333498","id_primarylistingofficename":"NEW STAR REALTY & INVESTMENT","type_search":0,"type_propertytype":0,"bathrooms_total":4,"id_primarylistingagent":"C19937","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"390 Marina Dr","location_postalcode":"92821","bedrooms":4,"flag_internetadvertise":true,"price_list":988000.0,"id_primarylistingoffice":"1061","squarefootage":1953,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.901855,"lat":33.933637},"id_listingid":"CV21068264","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365529065","_score":12.460788,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365529065","id_primarylistingofficename":"eXp Realty of California Inc","type_search":0,"type_propertytype":0,"bathrooms_total":4,"id_primarylistingagent":"SAGUIGAB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"449 Brea Hills Ave","location_postalcode":"92823","bedrooms":4,"flag_internetadvertise":true,"price_list":1650000.0,"id_primarylistingoffice":"OC03224","squarefootage":4267,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.83357,"lat":33.925032},"id_listingid":"OC21116170","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365585690","_score":12.460788,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365585690","id_primarylistingofficename":"Berkshire Hathaway Homeservice","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PZUNIFRA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"406 Brea Blvd","location_postalcode":"92821","bedrooms":3,"flag_internetadvertise":true,"price_list":769800.0,"id_primarylistingoffice":"W213","squarefootage":1317,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.901168,"lat":33.914527},"id_listingid":"PW21126770","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365622003","_score":12.460788,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365622003","id_primarylistingofficename":"T.N.G. Real Estate Consultants","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"NBUONSHE","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"354 Puente St","location_postalcode":"92821","bedrooms":3,"flag_internetadvertise":true,"price_list":750000.0,"id_primarylistingoffice":"PB18025","squarefootage":1486,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.915365,"lat":33.915288},"id_listingid":"PW21129710","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-362181137","_score":12.307308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"362181137","id_primarylistingofficename":"RE/MAX Select One","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"SHEAPBRE","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"927 Tracie Dr","location_postalcode":"92821","bedrooms":3,"flag_internetadvertise":true,"price_list":720000.0,"id_primarylistingoffice":"J02098","squarefootage":1693,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.9126568,"lat":33.9333565},"id_listingid":"OC19042253","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-363733524","_score":12.307308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"363733524","id_primarylistingofficename":"ReMax Tiffany Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"BKIMYAN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"3374 Greenleaf Dr","location_postalcode":"92823","bedrooms":4,"flag_internetadvertise":true,"price_list":699000.0,"id_primarylistingoffice":"B229","squarefootage":2183,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.8512214,"lat":33.9065507},"id_listingid":"PW19265511","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-363725311","_score":12.307308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"363725311","id_primarylistingofficename":"Douglas Elliman Of California,","type_search":0,"type_propertytype":0,"bathrooms_total":4,"id_primarylistingagent":"U41032","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"680 Driftwood Ave","location_postalcode":"92821","bedrooms":6,"flag_internetadvertise":true,"price_list":799000.0,"id_primarylistingoffice":"U6587","squarefootage":3129,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.8894035,"lat":33.9303843},"id_listingid":"NP19262115","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365483594","_score":12.307308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365483594","id_primarylistingofficename":"Realty Executives-Premier","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"NKERRBAR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"626 Desert Canyon Rd","location_postalcode":"92821","bedrooms":4,"flag_internetadvertise":true,"price_list":1295000.0,"id_primarylistingoffice":"N220","squarefootage":2768,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.885986,"lat":33.930437},"id_listingid":"PW21106356","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365476702","_score":12.307308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365476702","id_primarylistingofficename":"RE/MAX INNOVATIONS","type_search":0,"type_propertytype":1,"bathrooms_total":2,"id_primarylistingagent":"CV33252","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"632 Birch St #B","location_postalcode":"92821","bedrooms":2,"flag_internetadvertise":true,"price_list":459999.0,"id_primarylistingoffice":"50463","squarefootage":1104,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.891776,"lat":33.917442},"id_listingid":"CV21105027","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365520734","_score":12.307308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365520734","id_primarylistingofficename":"Keller Williams Realty","type_search":0,"type_propertytype":1,"bathrooms_total":2,"id_primarylistingagent":"NSTEPSCO","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"419 Mallorca Ln","location_postalcode":"92823","bedrooms":2,"flag_internetadvertise":true,"price_list":640000.0,"id_primarylistingoffice":"PB18969","squarefootage":1046,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.850401,"lat":33.911755},"id_listingid":"PW21114646","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365592162","_score":12.307308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365592162","id_primarylistingofficename":"Goldenwest Properties","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PRODRJOE","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"301 Guava Pl","location_postalcode":"92821","bedrooms":3,"flag_internetadvertise":true,"price_list":725000.0,"id_primarylistingoffice":"B037","squarefootage":1223,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.882518,"lat":33.922486},"id_listingid":"PW21127810","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365358460","_score":12.307308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365358460","id_primarylistingofficename":"Anne Ku, Broker","type_search":0,"type_propertytype":0,"bathrooms_total":4,"id_primarylistingagent":"HKUANNE","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"3659 Glorietta Pl","location_postalcode":"92823","bedrooms":3,"flag_internetadvertise":true,"price_list":1398000.0,"id_primarylistingoffice":"PB3111","squarefootage":3359,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.845641,"lat":33.910492},"id_listingid":"TR21031676","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365604056","_score":12.307308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365604056","id_primarylistingofficename":"Keller Williams Realty","type_search":0,"type_propertytype":1,"bathrooms_total":3,"id_primarylistingagent":"PNANCKIM","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"403 Sevilla Dr","location_postalcode":"92823","bedrooms":2,"flag_internetadvertise":true,"price_list":750000.0,"id_primarylistingoffice":"PB17230","squarefootage":1534,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.850048,"lat":33.911477},"id_listingid":"PW21127923","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365582682","_score":12.307308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365582682","id_primarylistingofficename":"ERA North Orange County","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"NJONEDAR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"361 Amberwick Ln","location_postalcode":"92821","bedrooms":4,"flag_internetadvertise":true,"price_list":899000.0,"id_primarylistingoffice":"N174","squarefootage":2252,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.874251,"lat":33.914615},"id_listingid":"PW21125061","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365416685","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365416685","id_primarylistingofficename":"RE/MAX Dynasty","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"DWGUTPAT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"902 Buttonwood Dr","location_postalcode":"92821","bedrooms":3,"flag_internetadvertise":true,"price_list":1199000.0,"id_primarylistingoffice":"YRMD","squarefootage":1900,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.882338,"lat":33.926952},"id_listingid":"DW21090208","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365332960","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365332960","id_primarylistingofficename":"IRN Realty","type_search":0,"type_propertytype":0,"bathrooms_total":7,"id_primarylistingagent":"HSANGJIN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"340 Olinda Dr","location_postalcode":"92823","bedrooms":5,"flag_internetadvertise":true,"price_list":2180000.0,"id_primarylistingoffice":"PB4909","squarefootage":8010,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.800964,"lat":33.929624},"id_listingid":"TR21067596","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365565007","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365565007","id_primarylistingofficename":"Windsor Inv., Inc.","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"EWILLTHO","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"3601 La Fiesta Dr","location_postalcode":"92823","bedrooms":4,"flag_internetadvertise":true,"price_list":1195000.0,"id_primarylistingoffice":"PWE189","squarefootage":2463,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.847009,"lat":33.908666},"id_listingid":"PW21122943","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365602546","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365602546","id_primarylistingofficename":"RE/MAX 2000 REALTY","type_search":0,"type_propertytype":1,"bathrooms_total":3,"id_primarylistingagent":"WS78921","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"122 Orange Ave","location_postalcode":"92821","bedrooms":4,"flag_internetadvertise":true,"price_list":799000.0,"id_primarylistingoffice":"21026","squarefootage":2004,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.897795,"lat":33.918647},"id_listingid":"WS21128864","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365553158","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365553158","id_primarylistingofficename":"ERA North Orange County","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"NJONEDAR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"550 Linden Wy","location_postalcode":"92821","bedrooms":3,"flag_internetadvertise":true,"price_list":775000.0,"id_primarylistingoffice":"N174","squarefootage":1377,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.913618,"lat":33.912639},"id_listingid":"PW21120682","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365387428","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365387428","id_primarylistingofficename":"ERA North Orange County","type_search":0,"type_propertytype":0,"bathrooms_total":4,"id_primarylistingagent":"NJONEDAR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"324 Copa De Oro Dr","location_postalcode":"92823","bedrooms":4,"flag_internetadvertise":true,"price_list":2999999.0,"id_primarylistingoffice":"N174","squarefootage":5803,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.809757,"lat":33.929485},"id_listingid":"PW21080449","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365585131","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365585131","id_primarylistingofficename":"Jason Kliewer, Broker","type_search":0,"type_propertytype":1,"bathrooms_total":4,"id_primarylistingagent":"SKOZMCAR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"755 Site Drive St","location_postalcode":"92821","bedrooms":4,"flag_internetadvertise":true,"price_list":1018000.0,"id_primarylistingoffice":"J00749","squarefootage":2200,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.90362,"lat":33.931823},"id_listingid":"OC21126855","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365457388","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365457388","id_primarylistingofficename":"Realty One Group Diamond","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PHENGRET","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"475 Ash St","location_postalcode":"92821","bedrooms":3,"flag_internetadvertise":true,"price_list":829000.0,"id_primarylistingoffice":"PB19146","squarefootage":1733,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.894444,"lat":33.919296},"id_listingid":"PW21098003","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365489486","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365489486","id_primarylistingofficename":"T.N.G. Real Estate Consultants","type_search":0,"type_propertytype":1,"bathrooms_total":4,"id_primarylistingagent":"PSHIMJUL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"382 Broadway Dr","location_postalcode":"92821","bedrooms":3,"flag_internetadvertise":true,"price_list":749800.0,"id_primarylistingoffice":"PB18025","squarefootage":1813,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.901359,"lat":33.930224},"id_listingid":"PW21107870","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365607770","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365607770","id_primarylistingofficename":"Opendoor Brokerage Inc.","type_search":0,"type_propertytype":1,"bathrooms_total":4,"id_primarylistingagent":"CLW-C134974","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"710 Brooklyn Dr","location_postalcode":"92821","bedrooms":3,"flag_internetadvertise":true,"price_list":875000.0,"id_primarylistingoffice":"CLW-X82364","squarefootage":2012,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.900758,"lat":33.930348},"id_listingid":"21749128","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365577074","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365577074","id_primarylistingofficename":"Menconi & Associates Inc.","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"KMENMARK","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1908 Skywood St","location_postalcode":"92821","bedrooms":3,"flag_internetadvertise":true,"price_list":775000.0,"id_primarylistingoffice":"KMAI01","squarefootage":1511,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.926777,"lat":33.929992},"id_listingid":"IG21123975","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365593891","_score":12.106308,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365593891","id_primarylistingofficename":"T.N.G. Real Estate Consultants","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"NPOCOROB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"826 Buttonwood Dr","location_postalcode":"92821","bedrooms":2,"flag_internetadvertise":true,"price_list":625000.0,"id_primarylistingoffice":"PB18025","squarefootage":1043,"location_city":"Brea","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.883773,"lat":33.927065},"id_listingid":"PW21099756","type_transactiontype":0}}]}}