Andover KS 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_city":{"operator":"and","query":"Andover"}}},{"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":11,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":26,"relation":"eq"},"max_score":14.01205,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"326-595435","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"595435","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"ODONNAPR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"103 S Shay","flag_internetadvertise":true,"price_list":286450.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1346464,"lat":37.6806193},"id_primarylistingofficename":"PB Realty","type_propertytype":0,"location_postalcode":"67002","bedrooms":2,"id_primarylistingoffice":"811000523","squarefootage":1816,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/595435/0/0/0/1de2fc660449608eea8b69a801c26c81/1/d1e523eafa7b40b48f8e51e1c560634e/595435.JPG","id_listingid":"595435","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597815","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597815","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"HOLDERHO","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2340 S Mckenzie Ct","flag_internetadvertise":true,"price_list":385000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1415956,"lat":37.6507254},"id_primarylistingofficename":"Better Homes and Gardens Real Estate Alliance","type_propertytype":0,"location_postalcode":"67002","bedrooms":5,"id_primarylistingoffice":"715","squarefootage":3329,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597815/0/0/0/a69329f4a4ed9084f5e28aed6e983b5c/1/c4fec2faec40711074766ffa6013338f/597815.JPG","id_listingid":"597815","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-594978","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"594978","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"GUTHRKEL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2403 N Bluestone St","flag_internetadvertise":true,"price_list":479900.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1464716,"lat":37.7329825},"id_primarylistingofficename":"RITCHIE ASSOCIATES","type_propertytype":0,"location_postalcode":"67002","bedrooms":5,"id_primarylistingoffice":"214","squarefootage":3194,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/594978/0/0/0/ebf5447229c0bd96c96dc73741514496/1/3aa2ab5136d4877af37940b141853783/594978.JPG","id_listingid":"594978","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-595840","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"595840","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"BELLTINA","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1304 Lavern St","flag_internetadvertise":true,"price_list":124000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1330983,"lat":37.7088774},"id_primarylistingofficename":"Keller Williams Signature Partners","type_propertytype":0,"location_postalcode":"67002","bedrooms":2,"id_primarylistingoffice":"636","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-13T21:00:00","date_startdatetime":"2021-06-13T19:00:00"}],"squarefootage":768,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/595840/0/0/0/0fdabfc5fc167f0f1f9698301170a93a/1/284fbeee3984d54efba8e472a8214914/595840.JPG","id_listingid":"595840","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597447","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597447","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"KRETCKIM","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"712 18th Fairway","flag_internetadvertise":true,"price_list":549900.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1508514,"lat":37.6979639},"id_primarylistingofficename":"Platinum Realty","type_propertytype":0,"location_postalcode":"67002","bedrooms":6,"id_primarylistingoffice":"17729","squarefootage":4546,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597447/0/0/0/5767cf01fe95732b336319f1ee255469/1/29318a4262a97eca27b25f9f53416070/597447.JPG","id_listingid":"597447","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597548","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597548","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"NUGENLIN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"7302 SW Overland Trail Rd","flag_internetadvertise":true,"price_list":225000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.069563,"lat":37.719078},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67002","bedrooms":2,"id_primarylistingoffice":"86","squarefootage":1624,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597548/0/0/0/59d75b2cd9a91b64dd11042e7dce0e49/1/9cc878d733c70dfbf86645ddb6fca1d2/597548.JPG","id_listingid":"597548","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597724","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597724","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"ANDERNAT","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1723 N Riverbirch Ct","flag_internetadvertise":true,"price_list":210000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1496312,"lat":37.7166776},"id_primarylistingofficename":"ERA Great American Realty","type_propertytype":0,"location_postalcode":"67002","bedrooms":4,"id_primarylistingoffice":"169","squarefootage":1886,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597724/0/0/0/e42737682c174f7d59a8a18bb65ab001/1/fff8bd2f7dc60696611b228930cd0744/597724.JPG","id_listingid":"597724","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597893","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597893","id_primarylistingofficename":"Reece Nichols South Central Kansas","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"KEMNIKEL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"3220 E 13th St","location_postalcode":"67002","bedrooms":3,"flag_internetadvertise":true,"price_list":465000.0,"id_primarylistingoffice":"2920","squarefootage":2252,"location_city":"Andover","primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597893/0/0/0/d24331afb3dffbd76dc91ba60fc4817d/1/d2d6c73151fec0a5ff9f47316da1c7ac/597893.JPG","detailtablename":"MLS_KSSC_RE_11","id_listingid":"597893","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597341","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597341","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"KARIMMAH","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1809 N Columbine","flag_internetadvertise":true,"price_list":278000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1419399,"lat":37.718465},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67002","bedrooms":5,"id_primarylistingoffice":"86","squarefootage":2620,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597341/0/0/0/445f355300b4bf8034cdefa65a65c889/1/2dd522f017372e01a456bf9dce07bf96/597341.JPG","id_listingid":"597341","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597432","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597432","id_primarylistingofficename":"McCurdy Auction, LLC","type_search":0,"type_propertytype":0,"bathrooms_total":1,"id_primarylistingagent":"PATTOTY","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"7920 SW Elm Rd","location_postalcode":"67002","bedrooms":1,"flag_internetadvertise":true,"id_primarylistingoffice":"167","squarefootage":800,"location_city":"Andover","primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597432/0/0/0/c361f9ccb5b73a6fdb5d8dbf3443c05d/1/94e4f356c657fd2afe76ea8435738a7d/597432.JPG","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.0649543,"lat":37.7098674},"id_listingid":"597432","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-573257","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"573257","id_primarylistingofficename":"RITCHIE ASSOCIATES","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"GUTHRKEL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2502 N Quartz St","location_postalcode":"67002","bedrooms":3,"flag_internetadvertise":true,"price_list":362985.0,"id_primarylistingoffice":"214","squarefootage":1488,"location_city":"Andover","primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/573257/0/0/0/f7c005565363dbf74643d9002ba0dd99/1/bcff7fe35b968ae2af9dc8f5afa4e58c/573257.JPG","detailtablename":"MLS_KSSC_RE_11","id_listingid":"573257","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-596834","_score":14.01205,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"596834","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"ALCORCHR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"9365 SW Robin Rd","flag_internetadvertise":true,"price_list":345000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.0719875,"lat":37.688772},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67002","bedrooms":3,"id_primarylistingoffice":"86","squarefootage":2432,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/596834/0/0/0/aaa8ac0175c9805a338064894bb9ced8/1/b477ad5c5a1a623fe64c6602f5d2e5c9/596834.JPG","id_listingid":"596834","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-573304","_score":13.888994,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"573304","id_primarylistingofficename":"RITCHIE ASSOCIATES","type_search":0,"type_propertytype":0,"bathrooms_total":2,"id_primarylistingagent":"GUTHRKEL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2510 N Quartz St","location_postalcode":"67002","bedrooms":3,"flag_internetadvertise":true,"price_list":312790.0,"id_primarylistingoffice":"214","squarefootage":1514,"location_city":"Andover","primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/573304/0/0/0/0cf1f88a8328c885537bd797a22fff1d/1/a4d11ebe97d562690fa93a98fbce1395/573304.JPG","detailtablename":"MLS_KSSC_RE_11","id_listingid":"573304","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597523","_score":13.888994,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597523","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"STROBKEV","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"9088 SW Windy Knoll Rd","flag_internetadvertise":true,"price_list":165000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.0725128,"lat":37.6926474},"id_primarylistingofficename":"Realty Pros of Kansas","type_propertytype":0,"location_postalcode":"67002","bedrooms":3,"id_primarylistingoffice":"2768","squarefootage":1600,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597523/0/0/0/2dd92e761e78769a0ff909c15a20d9c8/1/5e098fd0b7fdfafb71517b6dad917931/597523.JPG","id_listingid":"597523","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-596095","_score":13.888994,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"596095","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"ODONNAPR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"119 S Shay","flag_internetadvertise":true,"price_list":349440.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1303481,"lat":37.6860256},"id_primarylistingofficename":"PB Realty","type_propertytype":0,"location_postalcode":"67002","bedrooms":3,"id_primarylistingoffice":"811000523","squarefootage":2590,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/596095/0/0/0/1e0576f65c83ee7279ea51420f707f97/1/007d65376b6a904a07783846bfde4633/596095.JPG","id_listingid":"596095","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-587880","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"587880","type_search":0,"bathrooms_total":8,"id_primarylistingagent":"CARNACYN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1904 E Central Ave","flag_internetadvertise":true,"price_list":3000000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1145811,"lat":37.6976064},"id_primarylistingofficename":"Reece Nichols South Central Kansas","type_propertytype":0,"location_postalcode":"67002","bedrooms":4,"id_primarylistingoffice":"2920","squarefootage":7538,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/587880/0/0/0/1953476ce20799424a8dab79a8177011/1/cadfbbffd7c7f3145a840a5e96907076/587880.JPG","id_listingid":"587880","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-591815","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"591815","id_primarylistingofficename":"PB Realty","type_search":0,"type_propertytype":0,"bathrooms_total":3,"id_primarylistingagent":"ODONNAPR","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"111 S Shay","location_postalcode":"67002","bedrooms":3,"flag_internetadvertise":true,"price_list":314480.0,"id_primarylistingoffice":"811000523","squarefootage":2461,"location_city":"Andover","primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/591815/0/0/0/afa6e7c31baa500a35be771d8fd7176e/1/3cacca73372743cbde89f3d9094ac1ea/591815.JPG","detailtablename":"MLS_KSSC_RE_11","id_listingid":"591815","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-593875","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"593875","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"GUTHRKEL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1322 W Ledgestone","flag_internetadvertise":true,"price_list":460701.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1497874,"lat":37.7282309},"id_primarylistingofficename":"RITCHIE ASSOCIATES","type_propertytype":0,"location_postalcode":"67002","bedrooms":5,"id_primarylistingoffice":"214","squarefootage":3006,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/593875/0/0/0/2b8196c416397d4204dd85376b3d6472/1/b96600609814f72d9baeae27c658632b/593875.JPG","id_listingid":"593875","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-594642","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"594642","type_search":0,"bathrooms_total":5,"id_primarylistingagent":"GUTHRKEL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2419 N Bluestone St","flag_internetadvertise":true,"price_list":501000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1464686,"lat":37.7329819},"id_primarylistingofficename":"RITCHIE ASSOCIATES","type_propertytype":0,"location_postalcode":"67002","bedrooms":5,"id_primarylistingoffice":"214","squarefootage":3351,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/594642/0/0/0/8684d873749b11ae62bf7e6f435dc5d8/1/70a83019bca03a45ad2b369be32b20bc/594642.JPG","id_listingid":"594642","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-596559","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"596559","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"CHENJUL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"419 W Mike St","flag_internetadvertise":true,"price_list":128000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1394922,"lat":37.7039849},"id_primarylistingofficename":"OnPoint","type_propertytype":0,"location_postalcode":"67002","bedrooms":3,"id_primarylistingoffice":"3223","squarefootage":1163,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/596559/0/0/0/1e2e1a5a1f5febf0dc23a87bca8b51a4/1/b77b88f32aea810333099ec5569108e6/596559.JPG","id_listingid":"596559","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-596828","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"596828","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"MAVISCIN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"715 N Deerfield Ct","flag_internetadvertise":true,"price_list":545000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1223521,"lat":37.6980576},"id_primarylistingofficename":"Berkshire Hathaway PenFed Realty","type_propertytype":0,"location_postalcode":"67002","bedrooms":5,"id_primarylistingoffice":"86","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-13T21:00:00","date_startdatetime":"2021-06-13T19:00:00"}],"squarefootage":3847,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/596828/0/0/0/bf19eea5967c0d2042e22ec54cbc8876/1/4f9e6fa1eb80023c7934632005349b01/596828.JPG","id_listingid":"596828","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597400","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597400","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"nguyenvu","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"240 Bent Tree Ct","flag_internetadvertise":true,"price_list":299900.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1401864,"lat":37.6899505},"id_primarylistingofficename":"Keller Williams Hometown Partners","type_propertytype":0,"location_postalcode":"67002","bedrooms":5,"id_primarylistingoffice":"517","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-19T21:00:00","date_startdatetime":"2021-06-19T19:00:00"}],"squarefootage":3276,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597400/0/0/0/4e8c8deb413a658f9e415b8905b08106/1/81597ad32fe906b97f1d3db73fab53bc/597400.JPG","id_listingid":"597400","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597466","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597466","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"SCOTTJAN","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"1438 N Shadow Rock Dr","flag_internetadvertise":true,"price_list":630000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1429023,"lat":37.7119292},"id_primarylistingofficename":"Reece Nichols South Central Kansas","type_propertytype":0,"location_postalcode":"67002","bedrooms":5,"id_primarylistingoffice":"2920","squarefootage":3718,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597466/0/0/0/5fb8106e8a5b66004fedc3d03feeb31f/1/33c46a0baa5ada97d1199b3dcfd7991d/597466.JPG","id_listingid":"597466","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-597750","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"597750","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"LANEBOB","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"350 S Pitchers Ct","flag_internetadvertise":true,"price_list":279900.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1413853,"lat":37.6822915},"id_primarylistingofficename":"Keller Williams Hometown Partners","type_propertytype":0,"location_postalcode":"67002","bedrooms":4,"id_primarylistingoffice":"517","squarefootage":2560,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/597750/0/0/0/66f3cfb96394d25f89a1c14733ceb1f5/1/3a9b64320a5dacf6e6f3f935404c35bb/597750.JPG","id_listingid":"597750","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-593468","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"593468","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"ANAYADAW","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"818 Mccloud Cir","flag_internetadvertise":true,"price_list":325000.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1525506,"lat":37.6990063},"id_primarylistingofficename":"Coldwell Banker Plaza Real Estate","type_propertytype":0,"location_postalcode":"67002","bedrooms":3,"id_primarylistingoffice":"193","squarefootage":1950,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/593468/0/0/0/aa7a3394f2588562cca0bd9a7ff120cd/1/7abcd8c94b5bbb1b66a7ad3915078c4f/593468.JPG","id_listingid":"593468","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"326-594780","_score":13.742691,"_source":{"status_display":"Active","systemid":326,"id_listinguid":"594780","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"GUTHRKEL","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"KS","location_streetaddress":"2409 N Bluestone St","flag_internetadvertise":true,"price_list":499384.0,"location_city":"Andover","detailtablename":"MLS_KSSC_RE_11","geo_coordinates":{"lon":-97.1464686,"lat":37.7329819},"id_primarylistingofficename":"RITCHIE ASSOCIATES","type_propertytype":0,"location_postalcode":"67002","bedrooms":5,"id_primarylistingoffice":"214","squarefootage":3071,"primaryimage":"https://cdnparap120.paragonrels.com/ParagonImages/Property/p12/SCKMLS/594780/0/0/0/6f16ef6de3ddc82f7463fce59f3093d9/1/b713c413c779ed5bacb315cc28b7090a/594780.JPG","id_listingid":"594780","type_transactiontype":0}}]}}