67207 Real Estate

POST /listings/_search?typed_keys=true
{"query":{"bool":{"filter":[{"terms":{"systemid":[326,338]}},{"bool":{"must_not":[{"term":{"flag_publicsearch":{"value":false}}}]}},{"terms":{"type_search":[0]}},{"terms":{"type_propertytype":[0,3]}},{"terms":{"type_transactiontype":[0,2]}}],"must":[{"match":{"location_postalcode":{"operator":"and","query":"67207"}}}]}},"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":8,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":18,"relation":"eq"},"max_score":8.563864,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"326-577598","_score":8.563864,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"577598","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"MCNEIGEN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1818 S Stephanie St","flag_internetadvertise":true,"price_list":198450.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2373274,"lat":37.6518815},"id_primarylistingofficename":"Golden Inc, REALTORS","type_propertytype":0,"location_postalcode":"67207","bedrooms":2,"id_primarylistingoffice":"134","squarefootage":1125,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/577598/0/0/0/bc9d99a9bb6c1d1c63e3eff6d20ff9d9/1/191306f38ce080018fcc3afe08c694c5/577598.JPG","id_listingid":"577598","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597776","_score":8.563864,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597776","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"HESSEPAM","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1009 S Rue St","flag_internetadvertise":true,"price_list":298900.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2005385,"lat":37.6695742},"id_primarylistingofficename":"J.P. Weigand & Sons","type_propertytype":0,"location_postalcode":"67207","bedrooms":4,"id_primarylistingoffice":"246","squarefootage":2717,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597776/0/0/0/95670422b7ba7d039531cf7b3e29dcbb/1/b8f29aca461d92f38116cd6b7e27f7eb/597776.JPG","id_listingid":"597776","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-590622","_score":8.563864,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"590622","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"BIASJUD","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2326 S Chateau St","flag_internetadvertise":true,"price_list":256900.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2136171,"lat":37.6575661},"id_primarylistingofficename":"Keller Williams Signature Partners","type_propertytype":0,"location_postalcode":"67207","bedrooms":4,"id_primarylistingoffice":"636","squarefootage":2258,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/590622/0/0/0/a73cac7b05537150a0c1204f1cef8a35/1/e8683d5cde727b8532f123574b1efbaf/590622.JPG","id_listingid":"590622","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597195","_score":8.563864,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597195","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"MCCURBRA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2 E Lynwood Blvd","flag_internetadvertise":true,"location_city":"Eastborough","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.261695,"lat":37.6841968},"id_primarylistingofficename":"McCurdy Auction, LLC","type_propertytype":0,"location_postalcode":"67207","bedrooms":4,"id_primarylistingoffice":"167","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-08T22:30:00","date_startdatetime":"2021-06-08T20:30:00"},{"type_openhousetype":0,"date_enddatetime":"2021-06-17T22:30:00","date_startdatetime":"2021-06-17T20:30:00"}],"squarefootage":4172,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597195/0/0/0/ce37cec1c4a91e2ca3fc1c9064501326/1/65920e71d35cbaba9f5f569fa6554e0a/597195.JPG","id_listingid":"597195","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597851","_score":8.563864,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597851","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"WEATHNIC","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"8049 E Orme St","flag_internetadvertise":true,"price_list":163000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2423412,"lat":37.6771209},"id_primarylistingofficename":"Reece Nichols South Central Kansas","type_propertytype":0,"location_postalcode":"67207","bedrooms":4,"id_primarylistingoffice":"2920","squarefootage":1809,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597851/0/0/0/4b22cc8a7f496f680796dec9e8e35637/1/a39460148c1d1113b69a47712e95b1da/597851.JPG","id_listingid":"597851","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597819","_score":8.563864,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597819","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"WELLSTIF","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"7914 E Clay St","flag_internetadvertise":true,"price_list":100000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2450377,"lat":37.6740198},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67207","bedrooms":3,"id_primarylistingoffice":"22907","squarefootage":1325,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597819/0/0/0/5587983f70c908761d5dd2fbc068b663/1/77e99701e1c338ff28d129f7e3b05b88/597819.JPG","id_listingid":"597819","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-595425","_score":8.547483,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"595425","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"KENNENIC","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"68 S Stratford Rd","flag_internetadvertise":true,"price_list":350000.0,"location_city":"Eastborough","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2540338,"lat":37.6843181},"id_primarylistingofficename":"Reece Nichols South Central Kansas","type_propertytype":0,"location_postalcode":"67207","bedrooms":3,"id_primarylistingoffice":"3075","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-05-02T21:00:00","date_startdatetime":"2021-05-02T19:00:00"}],"squarefootage":3024,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/595425/0/0/0/24a407354444e86561df0b83c15848b4/1/e2d260dd8b2b810f527b3c922e39f8c5/595425.JPG","id_listingid":"595425","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-593843","_score":8.547483,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"593843","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"SCHNEJEF","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2151 S Cooper Ct","flag_internetadvertise":true,"price_list":230000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2311141,"lat":37.6552961},"id_primarylistingofficename":"Keller Williams Signature Partners","type_propertytype":0,"location_postalcode":"67207","bedrooms":3,"id_primarylistingoffice":"636","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-04-18T21:00:00","date_startdatetime":"2021-04-18T19:00:00"}],"squarefootage":1606,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/593843/0/0/0/8cea522a0414508b5d39131728ee51ef/1/d47cb427f934c9da395aa0457c197849/593843.JPG","id_listingid":"593843","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597765","_score":8.547483,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597765","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"BEANTYS","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"10921 E Mount Vernon Ct","flag_internetadvertise":true,"price_list":209900.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2104551,"lat":37.6575753},"id_primarylistingofficename":"Pinnacle Realty Group","type_propertytype":0,"location_postalcode":"67207","bedrooms":4,"id_primarylistingoffice":"3128","squarefootage":2176,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597765/0/0/0/fb138b27fda819d49a177da9c4a0ed88/1/239369c55f0afdc9d73d13510ada55e6/597765.JPG","id_listingid":"597765","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597813","_score":8.547483,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597813","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"KUBIKTIM","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1940 S Lori Ln","flag_internetadvertise":true,"price_list":209000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2398766,"lat":37.6582318},"id_primarylistingofficename":"Realty4Less","type_propertytype":0,"location_postalcode":"67207","bedrooms":3,"id_primarylistingoffice":"515","squarefootage":2448,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597813/0/0/0/7afca5854ff307691b436f75c6bec144/1/949ee7ddbd534e2d24abcddcec9c3c6e/597813.JPG","id_listingid":"597813","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597371","_score":8.503824,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597371","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"MIXKAT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2301 S Stoneybrook St","flag_internetadvertise":true,"price_list":275000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2201836,"lat":37.6520995},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67207","bedrooms":5,"id_primarylistingoffice":"86","squarefootage":3219,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597371/0/0/0/bb000c4d850370c23700bcef4d29e5fc/1/43864e749f2d4c6b29e892260bc4e55f/597371.JPG","id_listingid":"597371","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597673","_score":8.503824,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597673","id_primarylistingofficename":"McCurdy Auction, LLC","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"PATTOTY","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"7001 E Zimmerly St","location_postalcode":"67207","bedrooms":3,"flag_internetadvertise":true,"id_primarylistingoffice":"167","squarefootage":2060,"location_city":"Wichita","primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597673/0/0/0/ce6a32103a1be5ff09f0f94c82dc0987/1/91baba6ca507fe6374fd20159c0ef552/597673.JPG","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2550451,"lat":37.6690421},"id_listingid":"597673","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-577600","_score":8.503824,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"577600","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"MCNEIGEN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1822 S Stephanie St","flag_internetadvertise":true,"price_list":232880.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3328531,"lat":37.6057778},"id_primarylistingofficename":"Golden Inc, REALTORS","type_propertytype":0,"location_postalcode":"67207","bedrooms":3,"id_primarylistingoffice":"134","squarefootage":1261,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/577600/0/0/0/d5919446dabb7cb1f856411548285fc0/1/1992b96260ef9b37bd0f6f5fc1c17ec1/577600.JPG","id_listingid":"577600","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-590621","_score":8.503824,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"590621","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"BIASJUD","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2319 S Chateau St","flag_internetadvertise":true,"price_list":256900.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2136171,"lat":37.65757},"id_primarylistingofficename":"Keller Williams Signature Partners","type_propertytype":0,"location_postalcode":"67207","bedrooms":4,"id_primarylistingoffice":"636","squarefootage":2258,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/590621/0/0/0/18d96d17efa176554c2a66199f15cf20/1/399fca45941f8dda25120a9e24843f9e/590621.JPG","id_listingid":"590621","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-593353","_score":8.503824,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"593353","type_search":0,"bathrooms_total":5,"id_primarylistingagent":"ORTHSTE","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"50 S Mission Rd","flag_internetadvertise":true,"price_list":749900.0,"location_city":"Eastborough","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2573418,"lat":37.684383},"id_primarylistingofficename":"Carl Chuzy Company","type_propertytype":0,"location_postalcode":"67207","bedrooms":6,"id_primarylistingoffice":"578","squarefootage":4262,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/593353/0/0/0/99e35e3259d58b5d9f5231b044a8d930/1/0aeff17193d2a0b4257b0753ce03a670/593353.JPG","id_listingid":"593353","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-596327","_score":8.503824,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"596327","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"BIASJUD","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2322 S Chateau St","flag_internetadvertise":true,"price_list":269500.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2136171,"lat":37.6575661},"id_primarylistingofficename":"Keller Williams Signature Partners","type_propertytype":0,"location_postalcode":"67207","bedrooms":3,"id_primarylistingoffice":"636","squarefootage":2202,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/596327/0/0/0/f8e717371d11568655152cf97f82a070/1/d88caa71339706f2b13512b9a538e9e1/596327.JPG","id_listingid":"596327","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597696","_score":8.503824,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597696","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"RUCKEENI","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2016 S Rosalie St","flag_internetadvertise":true,"price_list":174900.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2378754,"lat":37.6565145},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67207","bedrooms":3,"id_primarylistingoffice":"86","squarefootage":2184,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597696/0/0/0/d2dee507592b7a74526075ea9968ce7d/1/7201c87570cd7f1a5453dc96b10fffb8/597696.JPG","id_listingid":"597696","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597848","_score":8.503824,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597848","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"MILLEMON","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1806 S White Oak Cir","flag_internetadvertise":true,"price_list":160000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.2411194,"lat":37.6603678},"id_primarylistingofficename":"Coldwell Banker Plaza Real Estate","type_propertytype":0,"location_postalcode":"67207","bedrooms":4,"id_primarylistingoffice":"193","squarefootage":1852,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597848/0/0/0/f9d3dd0938e70fa3d4064ece69c2a1b1/1/94d18c2cd244eddfd80416c2738f8172/597848.JPG","id_listingid":"597848","type_transactiontype":0}}]}}