Wichita KS Real Estate

POST /listings/_search?typed_keys=true
{"query":{"bool":{"filter":[{"terms":{"systemid":[326]}},{"bool":{"must_not":[{"term":{"flag_publicsearch":{"value":false}}}]}},{"terms":{"type_search":[0]}},{"terms":{"type_propertytype":[0,2,3]}},{"terms":{"type_transactiontype":[0,2]}}],"must":[{"match":{"location_city":{"operator":"and","query":"Wichita"}}},{"multi_match":{"fields":["location_*","id_listingid"],"operator":"and","query":"KS","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":47,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":336,"relation":"eq"},"max_score":11.99401,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"326-577880","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"577880","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"JONESGRI","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2033 S Wheatland St","flag_internetadvertise":true,"price_list":248800.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.4887547,"lat":37.6556282},"id_primarylistingofficename":"West Edge Real Estate","type_propertytype":0,"location_postalcode":"67235","bedrooms":3,"id_primarylistingoffice":"3086","squarefootage":1357,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/577880/0/0/0/1e53cc7affcc84c84839ac0b42de6fc7/1/b0b31025a67a8321bb0607ccd531d0aa/577880.JPG","id_listingid":"577880","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-589269","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"589269","type_search":0,"bathrooms_total":7,"id_primarylistingagent":"moorechr","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"800 S Lakewood Dr","flag_internetadvertise":true,"price_list":2850000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1576259,"lat":37.675697},"id_primarylistingofficename":"Keller Williams Signature Partners","type_propertytype":0,"location_postalcode":"67230","bedrooms":6,"id_primarylistingoffice":"636","squarefootage":7918,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/589269/0/0/0/94253b7c0ffa65a557f257d668e3629a/1/f443c844e502e1906cb714bc374f520c/589269.JPG","id_listingid":"589269","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-595735","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"595735","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"BARNACAT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1051 S Roosevelt St","flag_internetadvertise":true,"price_list":69900.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2922225,"lat":37.6686486},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67218","bedrooms":2,"id_primarylistingoffice":"85","squarefootage":860,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/595735/0/0/0/45bf1d054adaae9528ae97f9e817c92f/1/6f7fe84b1b21ddca7ba2ab01914adf3c/595735.JPG","id_listingid":"595735","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-595892","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"595892","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"BLACKTAM","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"6614 W Palmetto St","flag_internetadvertise":true,"price_list":341000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.4358142,"lat":37.7548565},"id_primarylistingofficename":"PB Realty","type_propertytype":0,"location_postalcode":"67205","bedrooms":2,"id_primarylistingoffice":"811000523","squarefootage":1776,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/595892/0/0/0/caf75fd4cf4f617a07dc6990596bfbab/1/12526de42b1829ad984661f630471ac5/595892.JPG","id_listingid":"595892","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-595893","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"595893","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"BLACKTAM","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"6614 W Palmetto St","flag_internetadvertise":true,"price_list":350000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.4358142,"lat":37.7548565},"id_primarylistingofficename":"PB Realty","type_propertytype":0,"location_postalcode":"67205","bedrooms":2,"id_primarylistingoffice":"811000523","squarefootage":1776,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/595893/0/0/0/9f0db9920ea96b1a6de03c6a8570bdc1/1/4aea0152d3f7d6ee6f15363d51e6c41d/595893.JPG","id_listingid":"595893","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-594498","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"594498","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"GRAYDEN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"4620 S Flora Ct","flag_internetadvertise":true,"price_list":220500.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.4057257,"lat":37.6108023},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67215","bedrooms":2,"id_primarylistingoffice":"85","squarefootage":1208,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/594498/0/0/0/222eb7efe4e1445f4731999bee1e11c2/1/4f48d7890689c8b6dac8056dc9894377/594498.JPG","id_listingid":"594498","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-595290","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"595290","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"nevarjon","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"702 S Clear Creek St","flag_internetadvertise":true,"price_list":404959.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1783014,"lat":37.6781228},"id_primarylistingofficename":"Jeff Blubaugh Real Estate","type_propertytype":0,"location_postalcode":"67230","bedrooms":3,"id_primarylistingoffice":"2816","squarefootage":2303,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/595290/0/0/0/af6c7e4d58cf85bb660ad38ad25da087/1/a128a294e8db37c197da03c3648cfc65/595290.JPG","id_listingid":"595290","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-595482","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"595482","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"DARRESCO","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2601 S Lark Ln","flag_internetadvertise":true,"price_list":356677.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.4688426,"lat":37.6463158},"id_primarylistingofficename":"Jeff Blubaugh Real Estate","type_propertytype":0,"location_postalcode":"67215","bedrooms":3,"id_primarylistingoffice":"2816","squarefootage":1660,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/595482/0/0/0/ab916a0c4f6ec4f19155fd4924e31fa4/1/b738aa44e87859ce2e8197a5532cb2bf/595482.JPG","id_listingid":"595482","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597882","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597882","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"MILLEDON","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"243 N Dellrose Ave","flag_internetadvertise":true,"price_list":350000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2819988,"lat":37.6896401},"id_primarylistingofficename":"Reece Nichols South Central Kansas","type_propertytype":0,"location_postalcode":"67208","bedrooms":3,"id_primarylistingoffice":"2920","squarefootage":3199,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597882/0/0/0/8ca0f818c92178855358ea200da56f17/1/27e0811fe95b92a42aae46971912d31e/597882.JPG","id_listingid":"597882","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597334","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597334","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"KNOWLKER","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"225 N Estelle Ave","flag_internetadvertise":true,"price_list":119900.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3049213,"lat":37.6889694},"id_primarylistingofficename":"Select Homes","type_propertytype":0,"location_postalcode":"67214","bedrooms":4,"id_primarylistingoffice":"734","squarefootage":1458,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597334/0/0/0/ab7fc83b9bc970d49858e9894922969c/1/9f9cfb3278fb67741a7caf2c2b3015af/597334.JPG","id_listingid":"597334","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597170","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597170","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"WILSOMARQ","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"347 S Erie St","flag_internetadvertise":true,"price_list":120000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3026164,"lat":37.6812129},"id_primarylistingofficename":"Knowlton Group","type_propertytype":0,"location_postalcode":"67211","bedrooms":4,"id_primarylistingoffice":"3074","squarefootage":1601,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597170/0/0/0/b68df34c86aea53ef3a41b9ac35204b6/1/9c67eb122274c9fd136f0b70b72b7c17/597170.JPG","id_listingid":"597170","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-586636","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"586636","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"KETZNCHR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"741 N Firefly Ct","flag_internetadvertise":true,"price_list":372043.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.4893577,"lat":37.6950815},"id_primarylistingofficename":"New Door Real Estate","type_propertytype":0,"location_postalcode":"67235","bedrooms":2,"id_primarylistingoffice":"811000718","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-03-03T23:00:00","date_startdatetime":"2021-03-03T19:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-04T23:00:00","date_startdatetime":"2021-03-04T19:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-05T23:00:00","date_startdatetime":"2021-03-05T19:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-06T23:00:00","date_startdatetime":"2021-03-06T19:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-07T23:00:00","date_startdatetime":"2021-03-07T19:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-09T23:00:00","date_startdatetime":"2021-03-09T19:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-10T23:00:00","date_startdatetime":"2021-03-10T19:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-11T23:00:00","date_startdatetime":"2021-03-11T19:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-12T23:00:00","date_startdatetime":"2021-03-12T19:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-13T23:00:00","date_startdatetime":"2021-03-13T19:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-14T22:00:00","date_startdatetime":"2021-03-14T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-16T22:00:00","date_startdatetime":"2021-03-16T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-17T22:00:00","date_startdatetime":"2021-03-17T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-18T22:00:00","date_startdatetime":"2021-03-18T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-19T22:00:00","date_startdatetime":"2021-03-19T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-20T22:00:00","date_startdatetime":"2021-03-20T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-21T22:00:00","date_startdatetime":"2021-03-21T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-23T22:00:00","date_startdatetime":"2021-03-23T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-24T22:00:00","date_startdatetime":"2021-03-24T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-25T22:00:00","date_startdatetime":"2021-03-25T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-26T22:00:00","date_startdatetime":"2021-03-26T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-27T22:00:00","date_startdatetime":"2021-03-27T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-28T22:00:00","date_startdatetime":"2021-03-28T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-30T22:00:00","date_startdatetime":"2021-03-30T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-03-31T22:00:00","date_startdatetime":"2021-03-31T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-01T22:00:00","date_startdatetime":"2021-04-01T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-02T22:00:00","date_startdatetime":"2021-04-02T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-03T22:00:00","date_startdatetime":"2021-04-03T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-04T22:00:00","date_startdatetime":"2021-04-04T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-06T22:00:00","date_startdatetime":"2021-04-06T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-07T22:00:00","date_startdatetime":"2021-04-07T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-08T22:00:00","date_startdatetime":"2021-04-08T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-09T22:00:00","date_startdatetime":"2021-04-09T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-10T22:00:00","date_startdatetime":"2021-04-10T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-11T22:00:00","date_startdatetime":"2021-04-11T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-13T22:00:00","date_startdatetime":"2021-04-13T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-14T22:00:00","date_startdatetime":"2021-04-14T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-15T22:00:00","date_startdatetime":"2021-04-15T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-16T22:00:00","date_startdatetime":"2021-04-16T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-17T22:00:00","date_startdatetime":"2021-04-17T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-18T22:00:00","date_startdatetime":"2021-04-18T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-20T22:00:00","date_startdatetime":"2021-04-20T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-21T22:00:00","date_startdatetime":"2021-04-21T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-22T22:00:00","date_startdatetime":"2021-04-22T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-23T22:00:00","date_startdatetime":"2021-04-23T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-24T22:00:00","date_startdatetime":"2021-04-24T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-25T22:00:00","date_startdatetime":"2021-04-25T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-27T22:00:00","date_startdatetime":"2021-04-27T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-28T22:00:00","date_startdatetime":"2021-04-28T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-29T22:00:00","date_startdatetime":"2021-04-29T18:00:00"},{"type_openhousetype":0,"date_enddatetime":"2021-04-30T22:00:00","date_startdatetime":"2021-04-30T18:00:00"}],"squarefootage":1803,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/586636/0/0/0/51bcc7bee841fc1071d6cc9dcd9c0a4c/1/af069b4b195b65918cf9bbe7c9da5272/586636.JPG","id_listingid":"586636","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-594063","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"594063","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"HENDEJAC","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"208 N Richmond Ave","flag_internetadvertise":true,"price_list":83000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3722418,"lat":37.6861857},"id_primarylistingofficename":"At Home Wichita Real Estate","type_propertytype":0,"location_postalcode":"67203","bedrooms":3,"id_primarylistingoffice":"2784","squarefootage":1008,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/594063/0/0/0/0df76488d0f3dbc1e6b1bc7cd9e75e4c/1/58e9db7d2c038b79af9d96e446a50c47/594063.JPG","id_listingid":"594063","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-594631","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"594631","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"JOHNSZUR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"207 N Edgemoor St","flag_internetadvertise":true,"price_list":134900.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2717555,"lat":37.688661},"id_primarylistingofficename":"Keller Williams Signature Partners","type_propertytype":0,"location_postalcode":"67208","bedrooms":2,"id_primarylistingoffice":"636","squarefootage":1494,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/594631/0/0/0/b75f27daf1b75582818a77c597915e3f/1/65fed4e751d4b9e51b3685bd1e9735f3/594631.JPG","id_listingid":"594631","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-595067","_score":11.99401,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"595067","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"ALONZTER","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2314 W 2