La Habra Heights 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":"La Habra Heights"}}},{"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":15,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":14,"relation":"eq"},"max_score":15.408767,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"344-365379438","_score":15.408767,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365379438","id_primarylistingofficename":"Century 21 Allstars","type_search":0,"type_propertytype":0,"bathrooms_total":5,"id_primarylistingagent":"YCIBRMAR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"605 Green View Rd","location_postalcode":"90631","bedrooms":4,"flag_internetadvertise":true,"price_list":2699000.0,"id_primarylistingoffice":"YCYA","squarefootage":5113,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.951856,"lat":33.964296},"id_listingid":"DW21078417","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365193538","_score":15.408767,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365193538","id_primarylistingofficename":"VIP Real Estate Firm","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"RMARTFAU","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"849 Picaacho Dr","location_postalcode":"90631","bedrooms":2,"flag_internetadvertise":true,"price_list":1649990.0,"id_primarylistingoffice":"RRMV","squarefootage":870,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.972882,"lat":33.959786},"id_listingid":"RS21031112","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365244605","_score":15.408767,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365244605","id_primarylistingofficename":"Bruce Jin, Broker","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"W71016","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1820 Sharpless Dr","location_postalcode":"90631","bedrooms":3,"flag_internetadvertise":true,"price_list":1350000.0,"id_primarylistingoffice":"21897","squarefootage":2851,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.934557,"lat":33.963651},"id_listingid":"WS21044958","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365415680","_score":15.408767,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365415680","id_primarylistingofficename":"Coldwell Banker Diamond","type_search":0,"type_propertytype":0,"bathrooms_total":5,"id_primarylistingagent":"pfiorjan","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"201 Reposado Dr","location_postalcode":"90631","bedrooms":5,"flag_internetadvertise":true,"price_list":1948000.0,"id_primarylistingoffice":"PB11644","squarefootage":5388,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.957004,"lat":33.961043},"id_listingid":"PW21089817","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365330521","_score":15.307862,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365330521","id_primarylistingofficename":"T.N.G. Real Estate Consultants","type_search":0,"type_propertytype":0,"bathrooms_total":5,"id_primarylistingagent":"PFERNRAY","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"2575 Casalero Dr","location_postalcode":"90631","bedrooms":6,"flag_internetadvertise":true,"price_list":2099888.0,"id_primarylistingoffice":"PB19138","squarefootage":5678,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.974712,"lat":33.969649},"id_listingid":"PW21067190","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365443687","_score":15.307862,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365443687","id_primarylistingofficename":"eXp Realty of California Inc","type_search":0,"type_propertytype":0,"bathrooms_total":5,"id_primarylistingagent":"PWTHORJAS","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1919 Skyline Vista Dr","location_postalcode":"90631","bedrooms":5,"flag_internetadvertise":true,"price_list":1300000.0,"id_primarylistingoffice":"PB16251","squarefootage":3222,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.932795,"lat":33.964666},"id_listingid":"PW21097658","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365512151","_score":15.307862,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365512151","id_primarylistingofficename":"America Realty Los Angeles","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"CLW-X15637","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"401 Skyline Dr","location_postalcode":"90631","bedrooms":3,"flag_internetadvertise":true,"price_list":1250000.0,"id_primarylistingoffice":"CLW-X72737","squarefootage":2742,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.969307,"lat":33.97129},"id_listingid":"21736158","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365507455","_score":15.307862,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365507455","id_primarylistingofficename":"Coldwell Banker Diamond","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"pfiorjan","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"2077 El Cajonita Dr","location_postalcode":"90631","bedrooms":3,"flag_internetadvertise":true,"price_list":1199000.0,"id_primarylistingoffice":"PB11644","squarefootage":2518,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.974003,"lat":33.96246},"id_listingid":"PW21111240","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-364687028","_score":15.307862,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"364687028","id_primarylistingofficename":"Keller Williams Realty","type_search":0,"type_propertytype":0,"bathrooms_total":6,"id_primarylistingagent":"A36039","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1782 Chota Rd","location_postalcode":"90631","bedrooms":5,"flag_internetadvertise":true,"price_list":5500000.0,"id_primarylistingoffice":"30262","squarefootage":7411,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.932719,"lat":33.953099},"id_listingid":"AR20175248","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365525666","_score":15.307862,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365525666","id_primarylistingofficename":"R C Realty Corp.","type_search":0,"type_propertytype":0,"bathrooms_total":4,"id_primarylistingagent":"H68709","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1226 La Cresta Dr","location_postalcode":"90631","bedrooms":4,"flag_internetadvertise":true,"price_list":1528000.0,"id_primarylistingoffice":"8023","squarefootage":3658,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.93188,"lat":33.947027},"id_listingid":"TR21115626","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365465870","_score":15.307862,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365465870","id_primarylistingofficename":"Redfin","type_search":0,"type_propertytype":0,"bathrooms_total":7,"id_primarylistingagent":"SRAINMAR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1152 Picaacho Dr","location_postalcode":"90631","bedrooms":5,"flag_internetadvertise":true,"price_list":1995000.0,"id_primarylistingoffice":"H05701","squarefootage":4751,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.974826,"lat":33.956238},"id_listingid":"OC21101129","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365497625","_score":15.072855,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365497625","id_primarylistingofficename":"Coldwell Banker Diamond","type_search":0,"type_propertytype":0,"bathrooms_total":6,"id_primarylistingagent":"pfiorjan","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"2185 Papaya Dr","location_postalcode":"90631","bedrooms":5,"flag_internetadvertise":true,"price_list":1950000.0,"id_primarylistingoffice":"PB11644","squarefootage":4815,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.942314,"lat":33.965096},"id_listingid":"PW21109423","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365481748","_score":15.072855,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365481748","id_primarylistingofficename":"Everhome Realty, Inc.","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"V159099676","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"365 Skyline Dr","location_postalcode":"90631","bedrooms":3,"flag_internetadvertise":true,"price_list":1594000.0,"id_primarylistingoffice":"V8877","squarefootage":1714,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.968809,"lat":33.971423},"id_listingid":"V1-5858","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-362515119","_score":15.072855,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"362515119","id_primarylistingofficename":"Coldwell Banker Diamond","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PFIORJAN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"2015 Kanola Rd","location_postalcode":"90631","bedrooms":3,"flag_internetadvertise":true,"price_list":899000.0,"id_primarylistingoffice":"PB11644","squarefootage":1828,"location_city":"La Habra Heights","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-117.926435,"lat":33.957448},"id_listingid":"PW19092753","type_transactiontype":0}}]}}