Placentia 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":"Placentia"}}},{"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":16,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":27,"relation":"eq"},"max_score":12.464355,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"344-365469985","_score":12.464355,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365469985","id_primarylistingofficename":"UNITED EMPIRE REALTY","type_search":0,"type_propertytype":1,"bathrooms_total":2,"id_primarylistingagent":"IVFRANORL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"212 Kraemer Blvd #2508","location_postalcode":"92870","bedrooms":2,"flag_internetadvertise":true,"price_list":380000.0,"id_primarylistingoffice":"IVLAWKIR","squarefootage":929,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.861953,"lat":33.870798},"id_listingid":"IV21100282","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365471801","_score":12.464355,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365471801","id_primarylistingofficename":"Berkshire Hathway HomeServices CA Properties","type_search":0,"type_propertytype":1,"bathrooms_total":3,"id_primarylistingagent":"IGCARMROB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"2017 Orchard Dr #10","location_postalcode":"92870","bedrooms":3,"flag_internetadvertise":true,"price_list":589500.0,"id_primarylistingoffice":"IGTRAH01","squarefootage":1745,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.819265,"lat":33.869846},"id_listingid":"IG21103023","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365550895","_score":12.464355,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365550895","id_primarylistingofficename":"THE brokeredge","type_search":0,"type_propertytype":1,"bathrooms_total":1,"id_primarylistingagent":"PWTHAIANT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"166 Kauai Ln","location_postalcode":"92870","bedrooms":1,"flag_internetadvertise":true,"price_list":399000.0,"id_primarylistingoffice":"PB17577","squarefootage":916,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.865671,"lat":33.870151},"id_listingid":"PW21120465","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365535363","_score":12.464355,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365535363","id_primarylistingofficename":"Main St. Real Estate Partners","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"OCSTEWKEN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"805 Berkenstock Cir","location_postalcode":"92870","bedrooms":4,"flag_internetadvertise":true,"price_list":899000.0,"id_primarylistingoffice":"OC08567","squarefootage":2327,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.850535,"lat":33.897074},"id_listingid":"OC21117191","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365618484","_score":12.464355,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365618484","id_primarylistingofficename":"Century 21 Discovery","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"NBERGCIN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"526 Gardenia Ave","location_postalcode":"92870","bedrooms":3,"flag_internetadvertise":true,"price_list":729000.0,"id_primarylistingoffice":"N508","squarefootage":1384,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.858822,"lat":33.8766},"id_listingid":"PW21127880","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-364592401","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"364592401","id_primarylistingofficename":"Coldwell Banker Realty","type_search":0,"type_propertytype":0,"bathrooms_total":8,"id_primarylistingagent":"PWDELFRA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"410 Angelina Dr","location_postalcode":"92870","bedrooms":5,"flag_internetadvertise":true,"price_list":2800000.0,"id_primarylistingoffice":"E026","squarefootage":8012,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.864852,"lat":33.873872},"id_listingid":"PW20133365","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365312952","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365312952","id_primarylistingofficename":"EMPIRE REALTY GROUP","type_search":0,"type_propertytype":1,"bathrooms_total":2,"id_primarylistingagent":"ICHAVROD","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"113 Doverfield Dr #65","location_postalcode":"92870","bedrooms":2,"flag_internetadvertise":true,"price_list":465000.0,"id_primarylistingoffice":"IVCHAVEZ","squarefootage":892,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.866425,"lat":33.884719},"id_listingid":"IV21062970","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365421117","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365421117","id_primarylistingofficename":"BHHS CA Properties","type_search":0,"type_propertytype":0,"bathrooms_total":8,"id_primarylistingagent":"PWMANUBOB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"322 Baker St","location_postalcode":"92870","bedrooms":8,"flag_internetadvertise":true,"price_list":1200000.0,"id_primarylistingoffice":"PB18053","squarefootage":1760,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.874709,"lat":33.868653},"id_listingid":"PW21090176","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365526097","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365526097","id_primarylistingofficename":"Reliance Real Estate Services","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PFREIADA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1268 Antigua Cir","location_postalcode":"92870","bedrooms":3,"flag_internetadvertise":true,"price_list":649000.0,"id_primarylistingoffice":"PB18008","squarefootage":1350,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.840965,"lat":33.878514},"id_listingid":"PW21114525","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365449498","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365449498","id_primarylistingofficename":"First Team Real Estate","type_search":0,"type_propertytype":1,"bathrooms_total":4,"id_primarylistingagent":"PNOLARS","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1077 Bradford Ave","location_postalcode":"92870","bedrooms":4,"flag_internetadvertise":true,"price_list":798800.0,"id_primarylistingoffice":"E776","squarefootage":2549,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.867795,"lat":33.882242},"id_listingid":"PW21096510","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365507100","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365507100","id_primarylistingofficename":"Keller Williams Corona Market Center","type_search":0,"type_propertytype":1,"bathrooms_total":4,"id_primarylistingagent":"OCALIRAGH","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1546 Spruce","location_postalcode":"92870","bedrooms":3,"flag_internetadvertise":true,"price_list":748000.0,"id_primarylistingoffice":"OC06580","squarefootage":2024,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.832238,"lat":33.869965},"id_listingid":"OC21111335","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365578473","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365578473","id_primarylistingofficename":"eXp Realty of California Inc","type_search":0,"type_propertytype":1,"bathrooms_total":1,"id_primarylistingagent":"PMARIFEL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"150 Southampton Wy #17","location_postalcode":"92870","bedrooms":2,"flag_internetadvertise":true,"price_list":419999.0,"id_primarylistingoffice":"PB16251","squarefootage":794,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.865369,"lat":33.885006},"id_listingid":"PW21125681","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365603655","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365603655","id_primarylistingofficename":"Redfin","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"SGEORDAV","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"412 Cline Ct","location_postalcode":"92870","bedrooms":5,"flag_internetadvertise":true,"price_list":999600.0,"id_primarylistingoffice":"H05701","squarefootage":2389,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.848062,"lat":33.872639},"id_listingid":"OC21128895","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365528841","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365528841","id_primarylistingofficename":"T.N.G. Real Estate Consultants","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PNORCSUS","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"16341 Skymeadow Dr","location_postalcode":"92870","bedrooms":3,"flag_internetadvertise":true,"price_list":899000.0,"id_primarylistingoffice":"PB18025","squarefootage":1675,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.848612,"lat":33.888221},"id_listingid":"PW21114498","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365453948","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365453948","id_primarylistingofficename":"Martin Investment Properties","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"OCSTOUALY","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"127 Santa Rosa Wy","location_postalcode":"92870","bedrooms":5,"flag_internetadvertise":true,"price_list":850000.0,"id_primarylistingoffice":"H07272","squarefootage":2425,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.864957,"lat":33.899975},"id_listingid":"OC21099509","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365599434","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365599434","id_primarylistingofficename":"Seven Gables Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PWHITERI","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"600 Valley Forge Dr","location_postalcode":"92870","bedrooms":4,"flag_internetadvertise":true,"price_list":769900.0,"id_primarylistingoffice":"E532","squarefootage":2048,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.864041,"lat":33.875886},"id_listingid":"PW21128927","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365623128","_score":12.3832245,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365623128","id_primarylistingofficename":"Century 21 Discovery","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"BKIMYOU","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1212 Eckenrode Wy","location_postalcode":"92870","bedrooms":3,"flag_internetadvertise":true,"price_list":759000.0,"id_primarylistingoffice":"N508","squarefootage":1664,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.848108,"lat":33.88131},"id_listingid":"PW21132299","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-364973801","_score":12.231007,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"364973801","id_primarylistingofficename":"STEVEN F. VALVERDE JR., BROKER","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"CV42787","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"919 Gonzales St","location_postalcode":"92870","bedrooms":2,"flag_internetadvertise":true,"price_list":459000.0,"id_primarylistingoffice":"52192","squarefootage":1071,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.875919,"lat":33.859297},"id_listingid":"CV20241825","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365581387","_score":12.231007,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365581387","id_primarylistingofficename":"Realty One Group Diamond","type_search":0,"type_propertytype":1,"bathrooms_total":3,"id_primarylistingagent":"PWHANDJEN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1570 Hastings Wy","location_postalcode":"92870","bedrooms":3,"flag_internetadvertise":true,"price_list":710000.0,"id_primarylistingoffice":"PB19146","squarefootage":1366,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.833462,"lat":33.873108},"id_listingid":"PW21125485","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365571890","_score":12.231007,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365571890","id_primarylistingofficename":"Seven Gables Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"SVANDROB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"406 Massachusetts Ln","location_postalcode":"92870","bedrooms":4,"flag_internetadvertise":true,"price_list":780000.0,"id_primarylistingoffice":"H45560","squarefootage":2048,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.862485,"lat":33.874297},"id_listingid":"OC21125133","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365240978","_score":12.231007,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365240978","id_primarylistingofficename":"Real Estate Legends USA","type_search":0,"type_propertytype":0,"bathrooms_total":4,"id_primarylistingagent":"OCGREGPAT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"525 Angelina Dr","location_postalcode":"92870","bedrooms":5,"flag_internetadvertise":true,"price_list":1198000.0,"id_primarylistingoffice":"J02040","squarefootage":3678,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.865232,"lat":33.875474},"id_listingid":"OC21043895","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365340450","_score":12.231007,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365340450","id_primarylistingofficename":"Ana Real Estate","type_search":0,"type_propertytype":1,"bathrooms_total":3,"id_primarylistingagent":"GNGUYAN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"503 Milano St","location_postalcode":"92870","bedrooms":4,"flag_internetadvertise":true,"price_list":830000.0,"id_primarylistingoffice":"G208","squarefootage":2211,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.856578,"lat":33.886835},"id_listingid":"PW21053171","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365569405","_score":12.231007,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365569405","id_primarylistingofficename":"First Team Real Estate","type_search":0,"type_propertytype":1,"bathrooms_total":1,"id_primarylistingagent":"PWDELOJOS","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1470 Avenida Alvarado","location_postalcode":"92870","bedrooms":2,"flag_internetadvertise":true,"price_list":530000.0,"id_primarylistingoffice":"E776","squarefootage":950,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.855184,"lat":33.88848},"id_listingid":"PW21124522","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365511579","_score":12.231007,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365511579","id_primarylistingofficename":"RE/MAX Diamond","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PLEEJOS","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"163 Saddle Dr","location_postalcode":"92870","bedrooms":3,"flag_internetadvertise":true,"price_list":899900.0,"id_primarylistingoffice":"PB11832","squarefootage":2306,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.82361,"lat":33.870775},"id_listingid":"PW21112562","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365479004","_score":12.231007,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365479004","id_primarylistingofficename":"Freedom First Properties","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PJOHMEL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"950 Ott Ave","location_postalcode":"92870","bedrooms":5,"flag_internetadvertise":true,"price_list":849000.0,"id_primarylistingoffice":"PB12989","squarefootage":2012,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.846505,"lat":33.895568},"id_listingid":"PW21105392","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365436340","_score":12.231007,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365436340","id_primarylistingofficename":"Century 21 Sunny Hills","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"PJUNKAY","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1026 Azalea Ave","location_postalcode":"92870","bedrooms":4,"flag_internetadvertise":true,"price_list":879000.0,"id_primarylistingoffice":"N066","squarefootage":2190,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.85699,"lat":33.879259},"id_listingid":"PW21080415","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365569821","_score":12.231007,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365569821","id_primarylistingofficename":"Berkshire Hathaway HomeServices California Properties","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"CDAR-d29929","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"364 Molokai Dr","location_postalcode":"92870","bedrooms":2,"flag_internetadvertise":true,"price_list":529000.0,"id_primarylistingoffice":"CDAR-oD23061","squarefootage":1300,"location_city":"Placentia","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.863995,"lat":33.869112},"id_listingid":"219063288DA","type_transactiontype":0}}]}}