Suisun City CA Real Estate

POST /listings/_search?typed_keys=true
{"query":{"bool":{"filter":[{"terms":{"systemid":[390,344,61,382,314]}},{"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":"Suisun City"}}},{"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":53,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":13,"relation":"eq"},"max_score":12.991048,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"390-90195353","_score":12.991048,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90195353","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"E01378","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"439 Railroad Ave","flag_internetadvertise":true,"price_list":380000.0,"location_city":"Suisun City","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.0159266,"lat":38.258684},"id_primarylistingofficename":"Golden Gate Sotheby's International Realty","type_propertytype":0,"location_postalcode":"94585","bedrooms":2,"id_primarylistingoffice":"7E1323","squarefootage":940,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/03/04/0da837cf-c703-406d-8c85-3f7fa89fe5ef.jpg","id_listingid":"321008233","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90273359","_score":12.991048,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90273359","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"D332582","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"807 Osprey Wy","flag_internetadvertise":true,"price_list":540000.0,"location_city":"Suisun City","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.9938961,"lat":38.249582},"id_primarylistingofficename":"RE/MAX Gold","type_propertytype":0,"location_postalcode":"94585","bedrooms":4,"id_primarylistingoffice":"CREGO2","squarefootage":1766,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/19/da50e60a-dfd2-45c7-8424-e15e7c81e720.jpg","id_listingid":"321053556","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90271991","_score":12.991048,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90271991","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"C401745","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"276 Tamarisk Cir","flag_internetadvertise":true,"price_list":508800.0,"location_city":"Suisun City","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.0242313,"lat":38.2464075},"id_primarylistingofficename":"Keller Williams Napa Valley","type_propertytype":0,"location_postalcode":"94585","bedrooms":3,"id_primarylistingoffice":"7E1185","squarefootage":1599,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/17/452ff53c-9222-4872-b68d-363e596d97ea.jpg","id_listingid":"321055237","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90269075","_score":12.991048,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90269075","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"C040378","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1320 Phillip Wy","flag_internetadvertise":true,"price_list":584900.0,"location_city":"Suisun City","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.0085099,"lat":38.2593814},"id_primarylistingofficename":"GD REALTY","type_propertytype":0,"location_postalcode":"94585","bedrooms":3,"id_primarylistingoffice":"7C1008","squarefootage":2150,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/14/c184d423-c098-42e5-a3fd-b33b40fcc65a.jpg","id_listingid":"321053220","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90269190","_score":12.991048,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90269190","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"D400023","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1003 Whistler Dr","flag_internetadvertise":true,"price_list":450000.0,"location_city":"Suisun City","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.0050007,"lat":38.2450959},"id_primarylistingofficename":"Coldwell Banker Solano Pacific","type_propertytype":0,"location_postalcode":"94585","bedrooms":3,"id_primarylistingoffice":"DCOLD","squarefootage":1088,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/14/6d01fbfe-a0a6-4aaf-9dec-9291e26c61cd.jpg","id_listingid":"321053180","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365519446","_score":12.952667,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365519446","id_primarylistingofficename":"KW Peninsula Estates","type_search":0,"type_propertytype":0,"id_primarylistingagent":"MLSL3-01433498","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"200 Yarrow Ct","location_postalcode":"94585","bedrooms":3,"flag_internetadvertise":true,"price_list":499000.0,"id_primarylistingoffice":"MLSL-86691","squarefootage":1599,"location_city":"Suisun City","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-122.023565,"lat":38.245386},"id_listingid":"ML81846093","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90271462","_score":12.952667,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90271462","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"D404240","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1077 Mayfield Wy","flag_internetadvertise":true,"price_list":549000.0,"location_city":"Suisun City","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.0022691,"lat":38.240678},"id_primarylistingofficename":"Redfin","type_propertytype":0,"location_postalcode":"94585","bedrooms":4,"id_primarylistingoffice":"AAPPLIA","squarefootage":1760,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/17/a7f3ef04-397c-4c76-bec6-f89353f162e6.jpg","id_listingid":"321054911","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90207295","_score":12.952667,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90207295","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"C405616","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"500 Line St","flag_internetadvertise":true,"price_list":579888.0,"location_city":"Suisun City","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.0404391,"lat":38.2366943},"id_primarylistingofficename":"Century 21 MM","type_propertytype":0,"location_postalcode":"94585","bedrooms":4,"id_primarylistingoffice":"7MMNA19","obj_openhouses":[{"remarks_marketingremarks":"Make an appointment if you would like to stop by. Must fill out PEAD form and have an appointment with list agent (707)290-9333","type_openhousetype":1,"date_enddatetime":"2021-04-17T13:00:00","uri_marketinguri":"https://www.facebook.com/seidiwoods","date_startdatetime":"2021-04-17T11:00:00"}],"squarefootage":3084,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/16/92daf5c5-6e90-4aba-8586-b1fed3f7c31a.jpg","id_listingid":"321014838","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"382-560173644","_score":12.952667,"_source":{"status_display":"Active","systemid":382,"id_listinguid":"560173644","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"DCAMPILB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1431 Pelican Wy","flag_internetadvertise":true,"price_list":460000.0,"location_city":"Suisun City","detailtablename":"MLS_CAMM_RESI","geo_coordinates":{"lon":-121.98867,"lat":38.243896},"id_primarylistingofficename":"eXp Realty of California Inc.","type_propertytype":0,"location_postalcode":"94585","bedrooms":4,"id_primarylistingoffice":"01EXPY","squarefootage":1536,"primaryimage":"https://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/15/ef6f796f-d966-499f-82fb-029fb5c2ac8a.jpg","id_listingid":"321053747","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90271362","_score":12.952667,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90271362","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"C333713","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"1772 Andrews Cir","flag_internetadvertise":true,"price_list":569999.0,"location_city":"Suisun City","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-121.9869663,"lat":38.2543567},"id_primarylistingofficename":"Coldwell Banker Kappel Gateway Realty","type_propertytype":0,"location_postalcode":"94585","bedrooms":3,"id_primarylistingoffice":"7C601","squarefootage":1839,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/22/020c45df-f6b9-46fc-8d1c-b7750209e7f2.jpg","id_listingid":"321054816","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"344-365529088","_score":12.895485,"_source":{"status_display":"Active","systemid":344,"id_listinguid":"365529088","id_primarylistingofficename":"Maxreal","type_search":0,"type_propertytype":0,"id_primarylistingagent":"MLSL-01400820","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"404 Honker Ln","location_postalcode":"94585","bedrooms":4,"flag_internetadvertise":true,"price_list":540000.0,"id_primarylistingoffice":"MLSL-29496","squarefootage":1904,"location_city":"Suisun City","detailtablename":"MLS_CACR_tial2","geo_coordinates":{"lon":-122.014239,"lat":38.244291},"id_listingid":"ML81846500","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"314-81846500","_score":12.895485,"_source":{"status_display":"Active","systemid":314,"id_listinguid":"81846500","id_primarylistingofficename":"Maxreal","type_search":0,"type_propertytype":0,"id_primarylistingagent":"481822","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"404 Honker Ln","location_postalcode":"94585","bedrooms":4,"flag_internetadvertise":true,"price_list":540000.0,"id_primarylistingoffice":"29496","squarefootage":1904,"location_city":"Suisun City","primaryimage":"https://mlslmedia.azureedge.net/property/MLSL/81846500/c504d3be82ea4f80bf434eccf11e73a5/2/1","detailtablename":"MLS_CAML_RES","geo_coordinates":{"lon":-122.0142389,"lat":38.244291},"id_listingid":"ML81846500","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90265505","_score":12.895485,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90265505","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"C335683","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"175 Sunshine St","flag_internetadvertise":true,"price_list":489999.0,"location_city":"Suisun City","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.0226326,"lat":38.2547542},"id_primarylistingofficename":"RE/MAX Gold","type_propertytype":0,"location_postalcode":"94585","bedrooms":4,"id_primarylistingoffice":"CREGO5","obj_openhouses":[{"remarks_marketingremarks":"Maggie Padilla.   Lovely home.  Bring your buyers!","type_openhousetype":0,"date_enddatetime":"2021-06-19T15:00:00","date_startdatetime":"2021-06-19T12:00:00"}],"squarefootage":1898,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/17/e127fd8f-6539-4a84-91a5-dd5407b65373.jpg","id_listingid":"321051244","type_transactiontype":0}}]}}