Benicia CA Real Estate

POST /listings/_search?typed_keys=true
{"query":{"bool":{"filter":[{"terms":{"systemid":[390,222]}},{"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":"Benicia"}}},{"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":9,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":12,"relation":"eq"},"max_score":12.388908,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"390-90261183","_score":12.388908,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90261183","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"D321810","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"448 H St","flag_internetadvertise":true,"price_list":779000.0,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.15084,"lat":38.0472708},"id_primarylistingofficename":"Estey Real Estate","type_propertytype":0,"location_postalcode":"94510","bedrooms":4,"id_primarylistingoffice":"DESTEY","squarefootage":1900,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/03/7afc6bc5-d87d-4321-bd7c-79643a9550f1.jpg","id_listingid":"321048822","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90239229","_score":12.388908,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90239229","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"A334824","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1360 7th St","flag_internetadvertise":true,"price_list":549000.0,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.141632,"lat":38.0496399},"id_primarylistingofficename":"RE/MAX Gold","type_propertytype":2,"location_postalcode":"94510","bedrooms":2,"id_primarylistingoffice":"7CREGO13","squarefootage":1143,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/05/06/2baa2561-65bc-485a-b4ba-8731fbd03b66.jpg","id_listingid":"321034130","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90269062","_score":12.270921,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90269062","id_primarylistingofficename":"Coldwell Banker Kappel Gateway Realty","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"C319975","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"20 Hillcrest Ave","location_postalcode":"94510","bedrooms":2,"flag_internetadvertise":true,"price_list":535000.0,"id_primarylistingoffice":"7C604","squarefootage":1092,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1474392,"lat":38.059946},"id_listingid":"321053132","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90266509","_score":12.270921,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90266509","id_primarylistingofficename":"Hamann Real Estate","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"D0124","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"526 Sandy","location_postalcode":"94510","bedrooms":3,"flag_internetadvertise":true,"price_list":795000.0,"id_primarylistingoffice":"DHAMAN","squarefootage":1579,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1619432,"lat":38.0612034},"id_listingid":"321051684","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90259642","_score":12.270921,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90259642","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"D0785","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"545 I St","flag_internetadvertise":true,"price_list":949000.0,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1481785,"lat":38.0473342},"id_primarylistingofficename":"Kennon Realty","type_propertytype":0,"location_postalcode":"94510","bedrooms":4,"id_primarylistingoffice":"DKENN","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-19T12:00:00","date_startdatetime":"2021-06-19T10:00:00"}],"squarefootage":2014,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/12/e270d346-82b5-46a9-a824-1c8ca498e26b.jpg","id_listingid":"321047750","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90272165","_score":12.270921,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90272165","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"D0227","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"378 Piercy Dr","flag_internetadvertise":true,"price_list":1098000.0,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1479714,"lat":38.0822538},"id_primarylistingofficename":"Olson Realty, Inc","type_propertytype":0,"location_postalcode":"94510","bedrooms":4,"id_primarylistingoffice":"DOLSON","squarefootage":3162,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/19/f6352e3d-b3d6-45fc-8881-98153fc8bc4f.jpg","id_listingid":"321053927","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90261512","_score":12.270921,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90261512","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"D312675","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"767 J St","flag_internetadvertise":true,"price_list":1179000.0,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1704141,"lat":38.0585803},"id_primarylistingofficename":"Birnbaum Realty","type_propertytype":0,"location_postalcode":"94510","bedrooms":4,"id_primarylistingoffice":"DBIRNBA","obj_openhouses":[{"remarks_marketingremarks":"Hosted by Julie Martinez. Come take a look at this gorgeous home!","type_openhousetype":0,"date_enddatetime":"2021-06-27T16:00:00","date_startdatetime":"2021-06-27T13:00:00"}],"squarefootage":2258,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/05/26/09e9ae3b-5411-4da1-bc72-25f8ca0397f3.jpg","id_listingid":"321045408","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90222611","_score":12.270921,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90222611","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"D337876","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"511 Lansing Cir","flag_internetadvertise":true,"price_list":1100000.0,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1432251,"lat":38.0852245},"id_primarylistingofficename":"RE/MAX Gold","type_propertytype":0,"location_postalcode":"94510","bedrooms":4,"id_primarylistingoffice":"7CREGO13","squarefootage":3824,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/04/28/d6dde428-dd9e-4e38-af65-4f2e75908973.jpg","id_listingid":"321024376","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90258079","_score":12.085626,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90258079","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"E317974","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"900 Cambridge Dr #42","flag_internetadvertise":true,"price_list":305000.0,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1898008,"lat":38.0788997},"id_primarylistingofficename":"Sunshine Property Management","type_propertytype":3,"location_postalcode":"94510","bedrooms":1,"id_primarylistingoffice":"ESUNSHN","squarefootage":687,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/05/28/dfabdad8-6c0d-4128-8165-11e7e5ca5a31.jpg","id_listingid":"321046809","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90242919","_score":12.085626,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90242919","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"D313564","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"465 Myrtle Ct","flag_internetadvertise":true,"price_list":650000.0,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1696602,"lat":38.080238},"id_primarylistingofficename":"Realty World-Silverado","type_propertytype":0,"location_postalcode":"94510","bedrooms":3,"id_primarylistingoffice":"DRWSILVR","obj_openhouses":[{"remarks_marketingremarks":"Just reduced. Remodeled Kitchen and living room. Added Sun Room for dining. Off street Parking and 2 car garage > Very large Master Bedroom.","type_openhousetype":0,"date_enddatetime":"2021-06-26T16:00:00","date_startdatetime":"2021-06-26T10:00:00"}],"squarefootage":1602,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/05/30/172aa15e-2108-414c-9f29-4b1981c86c92.jpg","id_listingid":"321035928","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90272472","_score":12.085626,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90272472","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"D317311","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"207 Panorama Dr","flag_internetadvertise":true,"price_list":779000.0,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1602578,"lat":38.0754963},"id_primarylistingofficename":"Coldwell Banker Solano Pacific","type_propertytype":0,"location_postalcode":"94510","bedrooms":4,"id_primarylistingoffice":"DCOLD","squarefootage":1735,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/14/f62444e1-6b74-48df-a4cb-6a358cf5f1d3.jpg","id_listingid":"321053341","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90273008","_score":12.085626,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90273008","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"C327234","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"818 Rose Dr","flag_internetadvertise":true,"price_list":798000.0,"location_city":"Benicia","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1795495,"lat":38.0901003},"id_primarylistingofficename":"Home 4 All Realty, Inc.","type_propertytype":0,"location_postalcode":"94510","bedrooms":4,"id_primarylistingoffice":"CH4ALL","squarefootage":2437,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/18/7e0ba6ef-4a20-4ae3-93e8-db296bad1c29.jpg","id_listingid":"321054575","type_transactiontype":0}}]}}