67204 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":"67204"}}}]}},"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":14,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":19,"relation":"eq"},"max_score":9.294735,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"326-590860","_score":9.294735,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"590860","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"FLOREBER","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2819 N Coolidge Ave","flag_internetadvertise":true,"price_list":95900.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3610881,"lat":37.7352526},"id_primarylistingofficename":"Fiesta Real Estate","type_propertytype":0,"location_postalcode":"67204","bedrooms":3,"id_primarylistingoffice":"719","squarefootage":1664,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/590860/0/0/0/4ae2e28d03a9f9968dc45e252f51fb56/1/ca61229f20cd566820f27cf87650cd79/590860.JPG","id_listingid":"590860","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-589834","_score":9.294735,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"589834","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"MALEYBAR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"5002 N Delaware Ct","flag_internetadvertise":true,"price_list":359000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3633379,"lat":37.7777732},"id_primarylistingofficename":"Keller Williams Hometown Partners","type_propertytype":0,"location_postalcode":"67204","bedrooms":4,"id_primarylistingoffice":"517","obj_openhouses":[{"remarks_marketingremarks":"OPEN SUNDAY 2-4 This four bedroom three bath home has everything  you could want. With open floor plan,granite,LVP flooring, main floor laundry with drop zone,walk in tile shower, composite covered deck, huge basement wet bar, sod sprinkler and well to complete package built by R","type_openhousetype":0,"date_enddatetime":"2021-06-06T21:00:00","date_startdatetime":"2021-06-06T19:00:00"}],"squarefootage":2950,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/589834/0/0/0/f07bdf04a6b31c28f7e7785672e25d2c/1/e51e26817bc820a9a20d8fa0aaca0944/589834.JPG","id_listingid":"589834","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-594235","_score":9.294735,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"594235","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"HOYERDAN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"619 W 36th St N","flag_internetadvertise":true,"price_list":90000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3440708,"lat":37.7501602},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67204","bedrooms":3,"id_primarylistingoffice":"86","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-05-02T21:00:00","date_startdatetime":"2021-05-02T19:00:00"}],"squarefootage":2184,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/594235/0/0/0/ac1c1b051795bed98db2d0c12403f9b6/1/5e2c3af3726e89ad7eb2f9e219c28e94/594235.JPG","id_listingid":"594235","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-596970","_score":9.294735,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"596970","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"CLYNECIN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"411 W 53rd St N","flag_internetadvertise":true,"price_list":180000.0,"location_city":"Park City","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3426085,"lat":37.780916},"id_primarylistingofficename":"Better Homes and Gardens Real Estate Alliance","type_propertytype":0,"location_postalcode":"67204","bedrooms":3,"id_primarylistingoffice":"715","squarefootage":1260,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/596970/0/0/0/d6cdeaad4ccec1a0da3c2ae962bf53ef/1/4f3f3eb69c9e4f641a9200e1cd746ca3/596970.JPG","id_listingid":"596970","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597596","_score":9.294735,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597596","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"HENRYJIL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2929 N Shelton Ave","flag_internetadvertise":true,"price_list":95000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3462439,"lat":37.7362934},"id_primarylistingofficename":"ERA Great American Realty","type_propertytype":0,"location_postalcode":"67204","bedrooms":3,"id_primarylistingoffice":"169","squarefootage":1248,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597596/0/0/0/b48f4035f2be14ae6c18b31a1e0db9a5/1/b2a1b5eb1e901ec79e6eb35c63374aae/597596.JPG","id_listingid":"597596","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597648","_score":9.294735,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597648","id_primarylistingofficename":"Dreiling Realty & Auction, LLC","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"DREILINGPAT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"5938 N Seneca St","location_postalcode":"67204","bedrooms":2,"flag_internetadvertise":true,"id_primarylistingoffice":"2904","squarefootage":900,"location_city":"Wichita","primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597648/0/0/0/741fad80a635dab01f1da215c1b9286a/1/1c766fbcc0fe8928e3ddce85c5c6ce27/597648.JPG","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3539164,"lat":37.7914572},"id_listingid":"597648","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597735","_score":9.294735,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597735","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"armstbob","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"5013 N Athenian","flag_internetadvertise":true,"price_list":359000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3675431,"lat":37.7508116},"id_primarylistingofficename":"New Door Real Estate","type_propertytype":0,"location_postalcode":"67204","bedrooms":4,"id_primarylistingoffice":"811000718","squarefootage":2950,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597735/0/0/0/e8cb519155a6f2960111c7aa30651e46/1/bb6e5116d761aab60ca600e2f8942831/597735.JPG","id_listingid":"597735","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597747","_score":9.294735,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597747","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"BARTETOM","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"5540 N Porter Ave","flag_internetadvertise":true,"price_list":340000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.359632,"lat":37.7846596},"id_primarylistingofficename":"Top Dog Realty","type_propertytype":0,"location_postalcode":"67204","bedrooms":4,"id_primarylistingoffice":"811000555","squarefootage":3821,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597747/0/0/0/2cc92f26816ae80557ebaa6dc8221a38/1/e2d55ad2a88335d321e0092bc3fccc66/597747.JPG","id_listingid":"597747","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-596311","_score":9.294735,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"596311","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"PURVISCHR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"5130 N Athenian Ct","flag_internetadvertise":true,"price_list":339500.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3665959,"lat":37.7516724},"id_primarylistingofficename":"GLC REAL ESTATE SERVICES, INC.","type_propertytype":0,"location_postalcode":"67204","bedrooms":5,"id_primarylistingoffice":"54","squarefootage":2478,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/596311/0/0/0/ca998df26c5c7eae221eb1745b637b3e/1/efc2c5f92da59bfe0427b691b49e9948/596311.JPG","id_listingid":"596311","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597142","_score":9.1920805,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597142","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"WOODILIS","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"4826 N Portwest St","flag_internetadvertise":true,"price_list":415000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3812442,"lat":37.7719142},"id_primarylistingofficename":"Hybrid Realty","type_propertytype":0,"location_postalcode":"67204","bedrooms":4,"id_primarylistingoffice":"811000524","squarefootage":3072,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597142/0/0/0/5b3fc1b22590a04de4ac8362af330104/1/ce8f7d3162a0b75a2e165a869ce6317c/597142.JPG","id_listingid":"597142","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597783","_score":9.1920805,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597783","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"LEIVIDAN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2805 N Richmond St","flag_internetadvertise":true,"price_list":192000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3735973,"lat":37.7342905},"id_primarylistingofficename":"Anita Cochran Realty","type_propertytype":0,"location_postalcode":"67204","bedrooms":3,"id_primarylistingoffice":"2638","squarefootage":2178,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597783/0/0/0/3f26df0161041cac23f75b30deb74251/1/5e8687debaf562d67118dc0b0f1ca14d/597783.JPG","id_listingid":"597783","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597209","_score":9.1920805,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597209","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"WIRTHMAD","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"521 W Longlane Rd","flag_internetadvertise":true,"price_list":175000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3434063,"lat":37.762284},"id_primarylistingofficename":"ERA Great American Realty","type_propertytype":0,"location_postalcode":"67204","bedrooms":3,"id_primarylistingoffice":"169","squarefootage":1452,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597209/0/0/0/0d1a4098aaefb626014bf3f0726ce283/1/8dc7a04bcd6cc9e5c67b75ea453d484b/597209.JPG","id_listingid":"597209","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597055","_score":9.1920805,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597055","type_search":0,"bathrooms_total":7,"id_primarylistingagent":"THEOBVIC","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2901 W Crystal Beach St","flag_internetadvertise":true,"price_list":1250000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3772125,"lat":37.776563},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67204","bedrooms":4,"id_primarylistingoffice":"85","squarefootage":5641,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597055/0/0/0/9607ac7f37059e26300c05f47a43a7eb/1/52bebb0d8852bd9a06d64b65738bc6e6/597055.JPG","id_listingid":"597055","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597071","_score":9.068878,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597071","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"HAUSEELI","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"6205 N Edwards St","flag_internetadvertise":true,"price_list":289900.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3751651,"lat":37.7964798},"id_primarylistingofficename":"J.P. Weigand & Sons","type_propertytype":0,"location_postalcode":"67204","bedrooms":3,"id_primarylistingoffice":"247","squarefootage":1588,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597071/0/0/0/ae69a2121453c1b988639905ea325dc3/1/30160594a5a51b0df4afd8706f013099/597071.JPG","id_listingid":"597071","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597697","_score":9.068878,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597697","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"CORBYKIT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"5828 N Seneca St","flag_internetadvertise":true,"price_list":115000.0,"location_city":"Valley Center","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3539768,"lat":37.7893877},"id_primarylistingofficename":"Keller Williams Hometown Partners","type_propertytype":0,"location_postalcode":"67204","bedrooms":3,"id_primarylistingoffice":"517","squarefootage":1504,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597697/0/0/0/741ce2fdc3ba66fbe586584cb9b30998/1/429963cb6b67bafaf9701838c7cfc11f/597697.JPG","id_listingid":"597697","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597631","_score":9.068878,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597631","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"WEDMASEA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2557 N Burns Ave","flag_internetadvertise":true,"price_list":145000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3507907,"lat":37.7293289},"id_primarylistingofficename":"Keller Williams Signature Partners","type_propertytype":0,"location_postalcode":"67204","bedrooms":3,"id_primarylistingoffice":"636","squarefootage":1423,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597631/0/0/0/d7eabb1008dc1dc03aaeb6c78803f87c/1/c519d039be55e797b53a5096baa2448d/597631.JPG","id_listingid":"597631","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-594470","_score":9.068878,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"594470","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"WANJAJEM","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2201 N Shelton Ave","flag_internetadvertise":true,"price_list":90000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.346222,"lat":37.72271},"id_primarylistingofficename":"Jemmima International Realty, LLC","type_propertytype":0,"location_postalcode":"67204","bedrooms":4,"id_primarylistingoffice":"811000634","squarefootage":1746,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/594470/0/0/0/4c07329c1b01296b0a6192cdc080f31b/1/1157b167754e17c11af18cda19461acf/594470.JPG","id_listingid":"594470","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597343","_score":9.068878,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597343","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"HOLMEDEB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"6750 N Sheridan St","flag_internetadvertise":true,"price_list":1100000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.378923,"lat":37.8067954},"id_primarylistingofficename":"J.P. Weigand & Sons","type_propertytype":0,"location_postalcode":"67204","bedrooms":5,"id_primarylistingoffice":"247","squarefootage":5674,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597343/0/0/0/a0ff676b353ee5d1db00d6dfef2caa31/1/a001e6b9b3409d719ae3875446056407/597343.JPG","id_listingid":"597343","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597688","_score":9.068878,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597688","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"malletyr","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"4815 N Bison St","flag_internetadvertise":true,"price_list":575000.0,"location_city":"Wichita","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.3578594,"lat":37.7709845},"id_primarylistingofficename":"Keller Williams Signature Partners","type_propertytype":0,"location_postalcode":"67204","bedrooms":5,"id_primarylistingoffice":"636","squarefootage":3504,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597688/0/0/0/a54e98629f4b5b94a552e194d74760dc/1/cd1647df933f4139ea9656472153f88c/597688.JPG","id_listingid":"597688","type_transactiontype":0}}]}}