American Canyon CA Real Estate

POST /listings/_search?typed_keys=true
{"query":{"bool":{"filter":[{"terms":{"systemid":[390]}},{"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":"American Canyon"}}},{"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":6,"relation":"eq"},"max_score":16.575583,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"390-830076","_score":16.575583,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"830076","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"E317828","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"305 Napa Junction Rd","flag_internetadvertise":true,"price_list":1396000.0,"location_city":"American Canyon","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.2572577,"lat":38.1846985},"id_primarylistingofficename":"RE/MAX Gold - American Canyon","type_propertytype":0,"location_postalcode":"94503","bedrooms":5,"id_primarylistingoffice":"7E1908","squarefootage":3300,"primaryimage":"http://mediall.rapmls.com/norcalmls/listingpics/bigphoto/2020/09/22/ad6f3dc5-b7c0-4a97-816a-2294c32b1c05.jpg","id_listingid":"22020931","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90271706","_score":16.567814,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90271706","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"E316241","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"220 Golden Brook Ln","flag_internetadvertise":true,"price_list":649999.0,"location_city":"American Canyon","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.2506774,"lat":38.1735159},"id_primarylistingofficename":"CORE Vision Realty, Inc","type_propertytype":0,"location_postalcode":"94503","bedrooms":3,"id_primarylistingoffice":"7DCORE","obj_openhouses":[{"remarks_marketingremarks":"Agents must accompany their Buyers. Please text Cristina at 707-342-7899 for your scheduled showing time.","type_openhousetype":0,"date_enddatetime":"2021-06-18T20:00:00","date_startdatetime":"2021-06-18T09:00:00"},{"remarks_marketingremarks":"Agents must accompany their Buyers. Please text Cristina at 707-342-7899 for your scheduled showing time.","type_openhousetype":0,"date_enddatetime":"2021-06-19T20:00:00","date_startdatetime":"2021-06-19T09:00:00"},{"remarks_marketingremarks":"Agents must accompany their Buyers. Please text Cristina at 707-342-7899 for your scheduled showing time.","type_openhousetype":0,"date_enddatetime":"2021-06-20T20:00:00","date_startdatetime":"2021-06-20T09:00:00"}],"squarefootage":1682,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/17/6a24d370-5823-47af-8f99-17ad1730a360.jpg","id_listingid":"321054452","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90273023","_score":16.567814,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90273023","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"D321562","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"504 Wetlands Edge Rd","flag_internetadvertise":true,"price_list":849000.0,"location_city":"American Canyon","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.2710823,"lat":38.1777159},"id_primarylistingofficename":"RE/MAX Gold - American Canyon","type_propertytype":0,"location_postalcode":"94503","bedrooms":4,"id_primarylistingoffice":"7E1908","squarefootage":2877,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/06/17/e0ac93c6-aa94-4b6e-8c7d-698da3311f5d.jpg","id_listingid":"321034490","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90222975","_score":16.567814,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90222975","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"C400281","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"3755 Spurs Trl","flag_internetadvertise":true,"price_list":1799995.0,"location_city":"American Canyon","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.1890402,"lat":38.2199604},"id_primarylistingofficename":"Level Up Realty - Solari Group","type_propertytype":0,"location_postalcode":"94503","bedrooms":3,"id_primarylistingoffice":"7C1484","obj_openhouses":[{"remarks_marketingremarks":"Hosted My Level Up Realtor","type_openhousetype":0,"date_enddatetime":"2021-06-19T16:00:00","date_startdatetime":"2021-06-19T13:00:00"},{"remarks_marketingremarks":"Hosted by Level Up Realtor","type_openhousetype":0,"date_enddatetime":"2021-06-20T16:00:00","date_startdatetime":"2021-06-20T13:00:00"}],"squarefootage":4503,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/04/12/f077c548-b092-4702-85e1-bcde6b788f57.jpg","id_listingid":"321024228","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-837798","_score":16.335106,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"837798","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"C402960","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"68 Donaldson Wy","flag_internetadvertise":true,"price_list":800000.0,"location_city":"American Canyon","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.2552625,"lat":38.1707163},"id_primarylistingofficename":"Coldwell Banker Kappel Gateway Realty","type_propertytype":0,"location_postalcode":"94503","bedrooms":2,"id_primarylistingoffice":"7C600","squarefootage":1440,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/02/01/e4c513ce-3b4a-485c-9fc3-6419e301924f.jpg","id_listingid":"22029451","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"390-90244060","_score":16.335106,"_source":{"status_display":"Active","systemid":390,"id_listinguid":"90244060","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"D332541","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"CA","location_streetaddress":"114 Via Pescara","flag_internetadvertise":true,"price_list":915000.0,"location_city":"American Canyon","detailtablename":"MLS_CABA_RESI","geo_coordinates":{"lon":-122.2356774,"lat":38.1639142},"id_primarylistingofficename":"Cornerstone Real Estate Investment Group","type_propertytype":0,"location_postalcode":"94503","bedrooms":4,"id_primarylistingoffice":"DCORNER","squarefootage":3455,"primaryimage":"http://barimedia.rapmls.com/norcalmls/listingpics/bigphoto/2021/05/13/df1ac492-4104-4b12-b24a-2b898dc4f60e.jpg","id_listingid":"321035279","type_transactiontype":0}}]}}