Hawaii Kai Real Estate

POST /listings/_search?typed_keys=true
{"query":{"bool":{"filter":[{"terms":{"systemid":[268]}},{"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_areas":{"operator":"and","query":"Hawaii Kai"}}}]}},"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":21,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":75,"relation":"eq"},"max_score":19.991236,"hits":[{"_index":"listings_v1","_type":"_doc","_id":"268-15720661","_score":19.991236,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15720661","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"05463","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"105 Poipu Dr","flag_internetadvertise":true,"price_list":3420000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7093364,"lat":21.2637671},"id_primarylistingofficename":"Tomoko Realty","type_propertytype":0,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"TOMO","squarefootage":4515,"primaryimage":"https://lm.salecore.com/photos/268/2021/2/19/Ph_15720661_0_1850.jpg","id_listingid":"202104011","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15841736","_score":19.991236,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15841736","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"24284","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"201 Poipu Dr","flag_internetadvertise":true,"price_list":2995000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7074529,"lat":21.266459},"id_primarylistingofficename":"Hawaii Life","type_propertytype":0,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"HLRE","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-04-19T03:00:00","date_startdatetime":"2021-04-19T00:00:00"}],"squarefootage":3420,"primaryimage":"https://lm.salecore.com/photos/268/2021/4/11/Ph_15841736_0_1521.jpg","id_listingid":"202108898","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15788225","_score":19.991236,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15788225","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"24284","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"63 Poipu Dr","flag_internetadvertise":true,"price_list":2995000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7090049,"lat":21.2624048},"id_primarylistingofficename":"Hawaii Life","type_propertytype":0,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"HLRE","obj_openhouses":[{"remarks_marketingremarks":"Mandatory: registration of all attendees, masks worn properly, maintain social distancing & 10 person limit in the home","type_openhousetype":0,"date_enddatetime":"2021-05-24T03:00:00","date_startdatetime":"2021-05-24T00:00:00"}],"squarefootage":4347,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/29/Ph_15788225_0_1244.jpg","id_listingid":"202107316","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15935768","_score":19.819351,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15935768","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"24341","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"42 Hanapepe Loop","flag_internetadvertise":true,"price_list":2880000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7098817,"lat":21.2614711},"id_primarylistingofficename":"Edgar P. Miner Realty","type_propertytype":0,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"MINE","squarefootage":3656,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/14/Ph_15935768_0_0055.jpg","id_listingid":"202113187","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-14893488","_score":19.819351,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"14893488","type_search":0,"bathrooms_total":6,"id_primarylistingagent":"00564","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"150 Hanapepe Loop","flag_internetadvertise":true,"price_list":1.28E7,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.710681,"lat":21.264905},"id_primarylistingofficename":"Coldwell Banker Realty","type_propertytype":0,"location_postalcode":"96825","bedrooms":6,"id_primarylistingoffice":"CBPP","obj_openhouses":[{"remarks_marketingremarks":"Joint Broker's Open!! Stunning views of ocean to Diamond Head!","type_openhousetype":0,"date_enddatetime":"2021-04-16T04:30:00","date_startdatetime":"2021-04-16T02:30:00"}],"squarefootage":8829,"primaryimage":"https://lm.salecore.com/photos/268/2019/12/16/Ph_14893488_0_1720.jpg","id_listingid":"201935276","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15560733","_score":19.75998,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15560733","type_search":0,"bathrooms_total":6,"id_primarylistingagent":"21474","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"60 Hanapepe Loop","flag_internetadvertise":true,"price_list":1.45E7,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.71089,"lat":21.262008},"id_primarylistingofficename":"Compass","type_propertytype":0,"location_postalcode":"96825","bedrooms":6,"id_primarylistingoffice":"COHI","squarefootage":7682,"primaryimage":"https://lm.salecore.com/photos/268/2020/11/17/Ph_15560733_0_1940.jpg","id_listingid":"202029356","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15939534","_score":19.75998,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15939534","type_search":0,"bathrooms_total":6,"id_primarylistingagent":"30733","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"139 Hanapepe Loop","flag_internetadvertise":true,"price_list":4650000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.71,"lat":21.2646074},"id_primarylistingofficename":"Compass","type_propertytype":0,"location_postalcode":"96825","bedrooms":5,"id_primarylistingoffice":"COHI","squarefootage":5529,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/1/Ph_15939534_0_2305.jpg","id_listingid":"202113329","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15870563","_score":19.672531,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15870563","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"43821","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"6770 Hawaii Kai Dr #904","flag_internetadvertise":true,"price_list":505000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.707315,"lat":21.2914644},"id_primarylistingofficename":"Terraco Hawaii Real Estate LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"TRCO","squarefootage":1119,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/4/27/Ph_15870563_0_1619.jpg","id_listingid":"202110028","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15613544","_score":19.672531,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15613544","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"44158","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"6770 Hawaii Kai Dr #12","flag_internetadvertise":true,"price_list":688000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.707315,"lat":21.2914644},"id_primarylistingofficename":"Keller Williams Honolulu","type_propertytype":2,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"KWPP","obj_openhouses":[{"remarks_marketingremarks":"many requests yet so little time, don't wait on your offers because others will send in theirs.  Don't miss this open","type_openhousetype":0,"date_enddatetime":"2021-06-07T03:00:00","date_startdatetime":"2021-06-07T00:00:00"}],"squarefootage":1690,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/22/Ph_15613544_0_1456.jpg","id_listingid":"202032018","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15984078","_score":19.672531,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15984078","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"24745","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"6770 Hawaii Kai Dr #1107","flag_internetadvertise":true,"price_list":550000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.707315,"lat":21.2914644},"id_primarylistingofficename":"Pacific Realty Ventures LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"STOP","obj_openhouses":[{"remarks_marketingremarks":"Plenty of parking on the top floor parking structure.","type_openhousetype":0,"date_enddatetime":"2021-06-21T03:00:00","date_startdatetime":"2021-06-21T00:00:00"}],"squarefootage":1119,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/15/Ph_15984078_0_1918.jpg","id_listingid":"202115678","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15964436","_score":19.672531,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15964436","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"07237","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"6770 Hawaii Kai Dr #1401","flag_internetadvertise":true,"price_list":615000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.707315,"lat":21.2914644},"id_primarylistingofficename":"Hawaii Life","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"HLRE","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-14T03:00:00","date_startdatetime":"2021-06-14T00:00:00"}],"squarefootage":1561,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/9/Ph_15964436_0_1651.jpg","id_listingid":"202114918","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15675022","_score":18.71508,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15675022","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"25110","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"423 Portlock Rd","flag_internetadvertise":true,"price_list":1900000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.708126,"lat":21.2720759},"id_primarylistingofficename":"Hawaii Homes International","type_propertytype":0,"location_postalcode":"96825","bedrooms":5,"id_primarylistingoffice":"REEW","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-03-22T03:00:00","date_startdatetime":"2021-03-22T01:00:00"}],"squarefootage":3110,"primaryimage":"https://lm.salecore.com/photos/268/2021/1/24/Ph_15675022_0_2138.jpg","id_listingid":"202101599","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15968049","_score":18.71508,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15968049","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"26575","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"342 Kuanalu Pl","flag_internetadvertise":true,"price_list":1495000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6699449,"lat":21.2911519},"id_primarylistingofficename":"Hawaii Life","type_propertytype":0,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"HLRE","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-21T03:00:00","date_startdatetime":"2021-06-21T00:00:00"}],"squarefootage":1954,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/9/Ph_15968049_0_1148.jpg","id_listingid":"202115081","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15743801","_score":18.526878,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15743801","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"34835","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"266 Portlock Rd","flag_internetadvertise":true,"price_list":4300000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.707904,"lat":21.277379},"id_primarylistingofficename":"Tropical Hawaii Realty","type_propertytype":0,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"THRH","squarefootage":5241,"primaryimage":"https://lm.salecore.com/photos/268/2021/3/1/Ph_15743801_0_0220.jpg","id_listingid":"202104953","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15486292","_score":18.526878,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15486292","type_search":0,"bathrooms_total":8,"id_primarylistingagent":"21601","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"445 Portlock Rd","flag_internetadvertise":true,"price_list":8737000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.707718,"lat":21.270995},"id_primarylistingofficename":"Hawaii Life","type_propertytype":0,"location_postalcode":"96825","bedrooms":6,"id_primarylistingoffice":"HLRE","squarefootage":9429,"primaryimage":"https://lm.salecore.com/photos/268/2020/10/26/Ph_15486292_0_0310.jpg","id_listingid":"202026878","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15626757","_score":18.526878,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15626757","type_search":0,"bathrooms_total":6,"id_primarylistingagent":"32193","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"569 Portlock Rd","flag_internetadvertise":true,"price_list":1.22E7,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7096721,"lat":21.2667909},"id_primarylistingofficename":"Keller Williams Honolulu","type_propertytype":0,"location_postalcode":"96825","bedrooms":5,"id_primarylistingoffice":"KWPP","squarefootage":8444,"primaryimage":"https://lm.salecore.com/photos/268/2020/12/22/Ph_15626757_0_1406.jpg","id_listingid":"202032528","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15557551","_score":18.526878,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15557551","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"40099","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"434 Portlock Rd","flag_internetadvertise":true,"price_list":3988000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7075299,"lat":21.2716888},"id_primarylistingofficename":"Hawaii Realty International","type_propertytype":0,"location_postalcode":"96825","bedrooms":5,"id_primarylistingoffice":"HREI","obj_openhouses":[{"remarks_marketingremarks":"Will be hosted Jessica E Mok, Hawaii Realty International, (808) 492-0148","type_openhousetype":0,"date_enddatetime":"2021-04-26T03:00:00","date_startdatetime":"2021-04-26T00:00:00"}],"squarefootage":5589,"primaryimage":"https://lm.salecore.com/photos/268/2021/4/12/Ph_15557551_0_1012.jpg","id_listingid":"202029234","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15862942","_score":18.526878,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15862942","type_search":0,"bathrooms_total":5,"id_primarylistingagent":"46180","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"500 Portlock Rd","flag_internetadvertise":true,"price_list":3400000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7070642,"lat":21.269247},"id_primarylistingofficename":"Hawaii Life","type_propertytype":0,"location_postalcode":"96825","bedrooms":6,"id_primarylistingoffice":"HLRE","squarefootage":4651,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/3/Ph_15862942_0_0859.jpg","id_listingid":"202109715","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15908058","_score":18.526878,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15908058","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"15458","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7152 Makaa St","flag_internetadvertise":true,"price_list":1700000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6992638,"lat":21.2915632},"id_primarylistingofficename":"Island Pacific Real Estate LLC","type_propertytype":0,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"DTHH","squarefootage":2801,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/13/Ph_15908058_0_1400.jpg","id_listingid":"202112108","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15862998","_score":18.48936,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15862998","type_search":0,"bathrooms_total":6,"id_primarylistingagent":"46180","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"280 Poipu Dr","flag_internetadvertise":true,"price_list":1.35E7,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7065054,"lat":21.2691696},"id_primarylistingofficename":"Hawaii Life","type_propertytype":0,"location_postalcode":"96825","bedrooms":6,"id_primarylistingoffice":"HLRE","squarefootage":8039,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/3/Ph_15862998_0_0914.jpg","id_listingid":"202109718","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15839253","_score":18.48936,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15839253","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"15713","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"306 Kipukai Pl","flag_internetadvertise":true,"price_list":1350000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6683579,"lat":21.2913102},"id_primarylistingofficename":"Hawaii Life","type_propertytype":0,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"HLRE","squarefootage":2323,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/4/30/Ph_15839253_0_1900.jpg","id_listingid":"202108798","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15981215","_score":18.150427,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15981215","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"29449","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"6710 Hawaii Kai Dr #502","flag_internetadvertise":true,"price_list":575000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7070224,"lat":21.2929833},"id_primarylistingofficename":"Coldwell Banker Realty","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"CBPP02","obj_openhouses":[{"remarks_marketingremarks":"FIRST OPEN!","type_openhousetype":0,"date_enddatetime":"2021-06-21T03:00:00","date_startdatetime":"2021-06-21T00:00:00"}],"squarefootage":1040,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/18/Ph_15981215_0_2000.jpg","id_listingid":"202115579","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15936338","_score":16.853924,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15936338","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"04578","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"580 Lunalilo Home Rd #B-341","flag_internetadvertise":true,"price_list":1100000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6961902,"lat":21.2891997},"id_primarylistingofficename":"Windward Isle Properties Inc","type_propertytype":2,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"WIPR","squarefootage":2022,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/28/Ph_15936338_0_1449.jpg","id_listingid":"202113217","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15970028","_score":16.853924,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15970028","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"26021","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7080 Hawaii Kai Dr #4","flag_internetadvertise":true,"price_list":685000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7008543,"lat":21.2900276},"id_primarylistingofficename":"Engel & Volkers-Honolulu","type_propertytype":2,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"PPRO","squarefootage":947,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/9/Ph_15970028_0_2240.jpg","id_listingid":"202115177","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15932885","_score":16.83685,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15932885","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"44476","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7196 Hawaii Kai Dr #247","flag_internetadvertise":true,"price_list":735000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6985039,"lat":21.2940959},"id_primarylistingofficename":"Coldwell Banker Realty","type_propertytype":2,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"CBPP","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-05-31T03:00:00","date_startdatetime":"2021-05-31T00:00:00"}],"squarefootage":1308,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/27/Ph_15932885_0_1707.jpg","id_listingid":"202113063","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15925858","_score":16.805025,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15925858","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"27729","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7012 Hawaii Kai Dr #208","flag_internetadvertise":true,"price_list":925000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7039419,"lat":21.2884052},"id_primarylistingofficename":"OahuRE.com","type_propertytype":3,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"GIVE","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-05-31T03:00:00","date_startdatetime":"2021-05-31T01:00:00"}],"squarefootage":1910,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/22/Ph_15925858_0_0337.jpg","id_listingid":"202112799","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15850607","_score":16.742912,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15850607","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"45890","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"1482 Honokahua St","flag_internetadvertise":true,"price_list":860000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.67254,"lat":21.3116817},"id_primarylistingofficename":"Coldwell Banker Realty","type_propertytype":0,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"CBPP02","obj_openhouses":[{"remarks_marketingremarks":"Please follow COVID-19 CDC guidelines by social distancing, wearing masks, and sanitizing upon entry and exit. Mahalo","type_openhousetype":0,"date_enddatetime":"2021-04-26T03:00:00","date_startdatetime":"2021-04-26T00:00:00"}],"squarefootage":1032,"primaryimage":"https://lm.salecore.com/photos/268/2021/4/21/Ph_15850607_0_1343.jpg","id_listingid":"202109237","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15968339","_score":16.742912,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15968339","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"30969","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"1345 Kaeleku St","flag_internetadvertise":true,"price_list":1175000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6707635,"lat":21.3060924},"id_primarylistingofficename":"BHGRE Advantage Realty","type_propertytype":0,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"ADVG","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-14T03:00:00","date_startdatetime":"2021-06-14T00:00:00"}],"squarefootage":2098,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/8/Ph_15968339_0_1809.jpg","id_listingid":"202115091","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15918925","_score":16.642977,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15918925","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"42885","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7012 Hawaii Kai Dr #907","flag_internetadvertise":true,"price_list":875000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7039419,"lat":21.2884052},"id_primarylistingofficename":"List Sotheby's Int'l Realty","type_propertytype":2,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"LIST","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-17T22:00:00","date_startdatetime":"2021-06-17T22:00:00"}],"squarefootage":1690,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/11/Ph_15918925_0_1515.jpg","id_listingid":"202112520","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15828737","_score":16.615463,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15828737","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"11370","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"1 Keahole Pl #1006","flag_internetadvertise":true,"price_list":1850000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7056495,"lat":21.2855611},"id_primarylistingofficename":"Kato & Associates, Inc.","type_propertytype":2,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"KATO","squarefootage":2559,"primaryimage":"https://lm.salecore.com/photos/268/2021/4/6/Ph_15828737_0_1752.jpg","id_listingid":"202108517","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15875063","_score":16.615463,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15875063","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"36654","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7018 Hawaii Kai Dr #506","flag_internetadvertise":true,"price_list":785000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7066367,"lat":21.2917494},"id_primarylistingofficename":"Locations LLC","type_propertytype":2,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"LOCA","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-05-09T01:00:00","date_startdatetime":"2021-05-08T23:00:00"}],"squarefootage":1477,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/4/29/Ph_15875063_0_1313.jpg","id_listingid":"202110219","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15744662","_score":16.549921,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15744662","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"22751","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"1492 Honokahua St","flag_internetadvertise":true,"price_list":6000000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.673325,"lat":21.312698},"id_primarylistingofficename":"Coldwell Banker Realty","type_propertytype":0,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"CBPP02","squarefootage":1426,"primaryimage":"https://lm.salecore.com/photos/268/2021/3/1/Ph_15744662_0_1527.jpg","id_listingid":"202104998","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15989778","_score":16.549921,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15989778","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"13550","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7549 Nakalele St","flag_internetadvertise":true,"price_list":968000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6726216,"lat":21.3040594},"id_primarylistingofficename":"Locations LLC","type_propertytype":0,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"LOCA","squarefootage":1588,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/18/Ph_15989778_0_1714.jpg","id_listingid":"202115900","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15721437","_score":16.5396,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15721437","type_search":0,"bathrooms_total":4,"id_primarylistingagent":"17683","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"1063 Kamookoa Pl","flag_internetadvertise":true,"price_list":1790000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7023141,"lat":21.3015173},"id_primarylistingofficename":"Pacific Home Prop. Mgmt., Inc.","type_propertytype":0,"location_postalcode":"96825","bedrooms":5,"id_primarylistingoffice":"NOH","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-03-01T03:00:00","date_startdatetime":"2021-03-01T00:00:00"}],"squarefootage":3680,"primaryimage":"https://lm.salecore.com/photos/268/2021/2/15/Ph_15721437_0_1423.jpg","id_listingid":"202104043","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15863169","_score":16.5396,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15863169","type_search":0,"bathrooms_total":5,"id_primarylistingagent":"24511","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"1008 Hoa St","flag_internetadvertise":true,"price_list":3195000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6794358,"lat":21.3016125},"id_primarylistingofficename":"Hawaii Homes International","type_propertytype":0,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"REEW","squarefootage":7458,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/4/30/Ph_15863169_0_2217.jpg","id_listingid":"202109726","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15898050","_score":16.5396,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15898050","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"50452","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7248 Kuahono St","flag_internetadvertise":true,"price_list":1544888.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.684992,"lat":21.2979781},"id_primarylistingofficename":"eXp Realty","type_propertytype":0,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"EXPI","obj_openhouses":[{"remarks_marketingremarks":"Open House 2-5pm.","type_openhousetype":0,"date_enddatetime":"2021-05-10T03:00:00","date_startdatetime":"2021-05-10T00:00:00"}],"squarefootage":2309,"id_listingid":"202111703","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15938989","_score":16.5396,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15938989","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"26021","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"1441 Honokahua St","flag_internetadvertise":true,"price_list":970000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.671501,"lat":21.309993},"id_primarylistingofficename":"Engel & Volkers-Honolulu","type_propertytype":0,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"PPRO","squarefootage":1679,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/4/Ph_15938989_0_1451.jpg","id_listingid":"202113310","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15944077","_score":16.5396,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15944077","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"31069","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"1127 Kaumoku St","flag_internetadvertise":true,"price_list":1650000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7035314,"lat":21.3035795},"id_primarylistingofficename":"Graham Properties, Inc.","type_propertytype":0,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"GRAH","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-21T03:00:00","date_startdatetime":"2021-06-21T00:00:00"}],"squarefootage":2512,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/7/Ph_15944077_0_1811.jpg","id_listingid":"202113520","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15976536","_score":16.5396,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15976536","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"49945","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7212 Kipu Pl","flag_internetadvertise":true,"price_list":1200000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6872094,"lat":21.2977386},"id_primarylistingofficename":"Royal Realty LLC","type_propertytype":0,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"RRLC","squarefootage":1964,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/11/Ph_15976536_0_2350.jpg","id_listingid":"202115422","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15880604","_score":16.5396,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15880604","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"50419","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"1279 Kaeleku St","flag_internetadvertise":true,"price_list":1100000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6705772,"lat":21.3036456},"id_primarylistingofficename":"eXp Realty","type_propertytype":0,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"EXPI","obj_openhouses":[{"remarks_marketingremarks":"Happy Father's Day","type_openhousetype":0,"date_enddatetime":"2021-06-21T03:00:00","date_startdatetime":"2021-06-21T00:00:00"}],"squarefootage":1767,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/2/Ph_15880604_0_0541.jpg","id_listingid":"202110399","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15969962","_score":16.5396,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15969962","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"43152","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"1168 Kaluanui Rd","flag_internetadvertise":true,"price_list":1750000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7019778,"lat":21.3045164},"id_primarylistingofficename":"Inspired Life Realty, LLC","type_propertytype":0,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"ILRL","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-14T01:00:00","date_startdatetime":"2021-06-13T22:00:00"}],"squarefootage":2890,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/10/Ph_15969962_0_1936.jpg","id_listingid":"202115175","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15942663","_score":15.146765,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15942663","type_search":0,"bathrooms_total":7,"id_primarylistingagent":"20082","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"406 Kekupua St","flag_internetadvertise":true,"price_list":1780000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6972148,"lat":21.2808898},"id_primarylistingofficename":"Pan Pacific Realty, LLC.","type_propertytype":0,"location_postalcode":"96825","bedrooms":7,"id_primarylistingoffice":"PPRL","obj_openhouses":[{"remarks_marketingremarks":"multi living corner lot w/ cool breeze. 4/4 upstairs hard wood floor, 9' ceiling & split ACs, Downstairs 3/3, 8' ceiling","type_openhousetype":0,"date_enddatetime":"2021-06-21T02:00:00","date_startdatetime":"2021-06-20T23:00:00"}],"squarefootage":3648,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/1/Ph_15942663_0_1042.jpg","id_listingid":"202113461","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15962969","_score":15.146765,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15962969","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"00846","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"765 Aipo St","flag_internetadvertise":true,"price_list":990000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6905969,"lat":21.2938728},"id_primarylistingofficename":"Vernco Properties, Inc.","type_propertytype":0,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"VERN","obj_openhouses":[{"remarks_marketingremarks":"SPECIAL HOURS:  (9-11AM) Single level home with large covered patio, completely fenced  in for privacy on a corner lot!","type_openhousetype":0,"date_enddatetime":"2021-06-17T21:00:00","date_startdatetime":"2021-06-17T22:00:00"},{"remarks_marketingremarks":"Nice single level home with a large covered patio and completely fenced in for privacy on a corner lot too! A must see!","type_openhousetype":0,"date_enddatetime":"2021-06-21T03:00:00","date_startdatetime":"2021-06-21T00:00:00"}],"squarefootage":1822,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/15/Ph_15962969_0_2049.jpg","id_listingid":"202114859","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15868770","_score":13.639128,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15868770","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"47260","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"500 Lunalilo Home Rd #24L","flag_internetadvertise":true,"price_list":775000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6988214,"lat":21.2854048},"id_primarylistingofficename":"Locations LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"LOCA","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-05-03T03:00:00","date_startdatetime":"2021-05-03T00:00:00"}],"squarefootage":1202,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/4/27/Ph_15868770_0_1016.jpg","id_listingid":"202109946","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15918334","_score":12.653072,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15918334","id_primarylistingofficename":"Homequest LLC","type_search":0,"type_propertytype":3,"bathrooms_total":2,"id_primarylistingagent":"05118","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7007 Hawaii Kai Dr #C16","location_postalcode":"96825","bedrooms":3,"flag_internetadvertise":true,"price_list":940000.0,"id_primarylistingoffice":"HOMQ","squarefootage":1436,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7025764,"lat":21.2871663},"id_listingid":"202112492","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15620696","_score":11.632759,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15620696","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"05514","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"250 Kawaihae St #7C","flag_internetadvertise":true,"price_list":898000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7194053,"lat":21.2876428},"id_primarylistingofficename":"eHAWAIIproperty.com","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"EHPC","squarefootage":1661,"primaryimage":"https://lm.salecore.com/photos/268/2020/12/31/Ph_15620696_0_1349.jpg","id_listingid":"202032317","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15932477","_score":11.632759,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15932477","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"46290","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"6750 Hawaii Kai Dr #104","flag_internetadvertise":true,"price_list":705000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.707358,"lat":21.2922369},"id_primarylistingofficename":"Century 21 iProperties Hawaii","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"IPHI","squarefootage":1238,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/1/Ph_15932477_0_0238.jpg","id_listingid":"202113043","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15916075","_score":11.632759,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15916075","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"43418","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"250 Kawaihae St #17D","flag_internetadvertise":true,"price_list":948000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7194053,"lat":21.2876428},"id_primarylistingofficename":"Hawaii Life","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"HLRE","squarefootage":1621,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/17/Ph_15916075_0_1605.jpg","id_listingid":"202112416","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15979987","_score":11.632759,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15979987","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"13056","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"521 Hahaione St #2/9L","flag_internetadvertise":true,"price_list":648000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7078028,"lat":21.294372},"id_primarylistingofficename":"Namiko Sherman","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"NAMI","squarefootage":1302,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/14/Ph_15979987_0_1719.jpg","id_listingid":"202115530","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15941944","_score":11.632759,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15941944","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"05630","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"350 Opihikao Pl #552","flag_internetadvertise":true,"price_list":925000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7122554,"lat":21.2870964},"id_primarylistingofficename":"Key Properties Hawaii, LLC","type_propertytype":2,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"KEYP","squarefootage":1918,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/14/Ph_15941944_0_2152.jpg","id_listingid":"202113432","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15989845","_score":11.632759,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15989845","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"11146","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"250 Kawaihae St #4B","flag_internetadvertise":true,"price_list":960000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7194053,"lat":21.2876428},"id_primarylistingofficename":"Coldwell Banker Realty","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"CBPP02","squarefootage":1644,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/19/Ph_15989845_0_2026.jpg","id_listingid":"202115904","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15906903","_score":11.599085,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15906903","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"43695","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"250 Kawaihae St #2C","flag_internetadvertise":true,"price_list":848000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7194053,"lat":21.2876428},"id_primarylistingofficename":"Coldwell Banker Realty","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"CBPP04","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-05-20T21:30:00","date_startdatetime":"2021-05-20T22:00:00"}],"squarefootage":1661,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/19/Ph_15906903_0_1145.jpg","id_listingid":"202112065","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15855559","_score":11.599085,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15855559","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"31563","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"521 Hahaione St #210H","flag_internetadvertise":true,"price_list":630000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.707175,"lat":21.2941032},"id_primarylistingofficename":"Berkshire Hathaway HmSvc HI RE","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"BHHR","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-06T03:00:00","date_startdatetime":"2021-06-06T00:00:00"}],"squarefootage":1211,"id_listingid":"202109431","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15970683","_score":11.599085,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15970683","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"25968","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"444 Lunalilo Home Rd #503","flag_internetadvertise":true,"price_list":779000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6994994,"lat":21.2836033},"id_primarylistingofficename":"RE/MAX Honolulu","type_propertytype":2,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"RMXH","obj_openhouses":[{"remarks_marketingremarks":"NO LATER THAN 2 PM SHOWINGS, OWNER LIVES IN THE PROPERTY.\r\nCALL FLORENCIA 808-384-9039","type_openhousetype":0,"date_enddatetime":"2021-06-20T00:00:00","date_startdatetime":"2021-06-19T21:00:00"}],"squarefootage":1626,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/15/Ph_15970683_0_1430.jpg","id_listingid":"202115211","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15976160","_score":11.599085,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15976160","type_search":0,"bathrooms_total":3,"id_primarylistingagent":"29644","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"145 Opihikao Wy #1152","flag_internetadvertise":true,"price_list":1050000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.713124,"lat":21.2865665},"id_primarylistingofficename":"Coldwell Banker Realty","type_propertytype":2,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"CBPP04","obj_openhouses":[{"remarks_marketingremarks":"FIRST OPEN HOUSE","type_openhousetype":0,"date_enddatetime":"2021-06-20T03:00:00","date_startdatetime":"2021-06-20T00:00:00"}],"squarefootage":1937,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/16/Ph_15976160_0_1126.jpg","id_listingid":"202115403","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15569816","_score":10.257427,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15569816","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #2702","flag_internetadvertise":true,"price_list":740000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"AVAL","squarefootage":1145,"primaryimage":"https://lm.salecore.com/photos/268/2020/11/20/Ph_15569816_0_1551.jpg","id_listingid":"202029725","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15769137","_score":10.257427,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15769137","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #3611","flag_internetadvertise":true,"price_list":657500.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"AVAL","obj_openhouses":[{"remarks_marketingremarks":"Please park in visitor stalls located in the parking structure. Check in at sales/leasing office.","type_openhousetype":0,"date_enddatetime":"2021-05-03T03:00:00","date_startdatetime":"2021-05-02T20:30:00"}],"squarefootage":1023,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/2/Ph_15769137_0_2009.jpg","id_listingid":"202106583","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15914982","_score":10.257427,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15914982","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #3517","flag_internetadvertise":true,"price_list":746000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"AVAL","squarefootage":1098,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/15/Ph_15914982_0_2000.jpg","id_listingid":"202112375","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15876064","_score":10.257427,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15876064","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #3911","flag_internetadvertise":true,"price_list":675000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"AVAL","obj_openhouses":[{"remarks_marketingremarks":"Please park in visitor stalls located in the parking structure. Check in at sales/leasing office.","type_openhousetype":0,"date_enddatetime":"2021-05-31T03:00:00","date_startdatetime":"2021-05-31T00:00:00"}],"squarefootage":1023,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/4/29/Ph_15876064_0_2104.jpg","id_listingid":"202110250","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15875987","_score":10.257427,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15875987","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #2909","flag_internetadvertise":true,"price_list":772000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"AVAL","squarefootage":1145,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/9/Ph_15875987_0_1852.jpg","id_listingid":"202110247","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15976964","_score":10.257427,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15976964","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #3315","flag_internetadvertise":true,"price_list":667900.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7039714,"lat":21.2870461},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"AVAL","squarefootage":1024,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/12/Ph_15976964_0_1410.jpg","id_listingid":"202115434","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15980026","_score":10.257427,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15980026","id_primarylistingofficename":"Avalon Realty LLC","type_search":0,"type_propertytype":3,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #s508","location_postalcode":"96825","flag_internetadvertise":true,"price_list":30000.0,"id_primarylistingoffice":"AVAL","squarefootage":46,"location_city":"Honolulu","primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/14/Ph_15980026_0_1417.jpg","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7039714,"lat":21.2870461},"id_listingid":"202115531","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15607987","_score":10.1301,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15607987","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #3102","flag_internetadvertise":true,"price_list":690000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":1,"id_primarylistingoffice":"AVAL","obj_openhouses":[{"remarks_marketingremarks":"Please park in our guest stall located in the parking garage check into our sales office","type_openhousetype":0,"date_enddatetime":"2021-05-31T03:00:00","date_startdatetime":"2021-05-31T00:00:00"}],"squarefootage":719,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/21/Ph_15607987_0_1601.jpg","id_listingid":"202031811","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15765083","_score":10.1301,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15765083","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #2209","flag_internetadvertise":true,"price_list":749000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"AVAL","squarefootage":1145,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/20/Ph_15765083_0_2006.jpg","id_listingid":"202106411","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15886531","_score":10.1301,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15886531","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #PH301","flag_internetadvertise":true,"price_list":775000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"AVAL","squarefootage":1154,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/5/Ph_15886531_0_1727.jpg","id_listingid":"202110647","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15871630","_score":10.1301,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15871630","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #2316","flag_internetadvertise":true,"price_list":819400.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"AVAL","squarefootage":1113,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/4/27/Ph_15871630_0_1921.jpg","id_listingid":"202110095","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15969322","_score":10.1301,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15969322","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #3401","flag_internetadvertise":true,"price_list":775000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7039714,"lat":21.2870461},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":4,"id_primarylistingoffice":"AVAL","squarefootage":1154,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/9/Ph_15969322_0_1405.jpg","id_listingid":"202115151","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15940264","_score":10.1301,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15940264","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #2608","flag_internetadvertise":true,"price_list":845000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7039714,"lat":21.2870461},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"AVAL","squarefootage":1145,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/9/Ph_15940264_0_1852.jpg","id_listingid":"202113361","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15914981","_score":10.1301,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15914981","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #2403","flag_internetadvertise":true,"price_list":750000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"AVAL","squarefootage":1145,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/15/Ph_15914981_0_2000.jpg","id_listingid":"202112374","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15900608","_score":10.1301,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15900608","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #3915","flag_internetadvertise":true,"price_list":680000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":3,"id_primarylistingoffice":"AVAL","squarefootage":1024,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/9/Ph_15900608_0_1908.jpg","id_listingid":"202111810","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15716634","_score":10.089909,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15716634","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #2503","flag_internetadvertise":true,"price_list":804000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"AVAL","squarefootage":1145,"primaryimage":"https://lm.salecore.com/photos/268/2021/2/11/Ph_15716634_0_1743.jpg","id_listingid":"202103861","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15875398","_score":10.089909,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15875398","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #3902","flag_internetadvertise":true,"price_list":675000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7058245,"lat":21.2875485},"id_primarylistingofficename":"Avalon Realty LLC","type_propertytype":3,"location_postalcode":"96825","bedrooms":1,"id_primarylistingoffice":"AVAL","squarefootage":719,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/9/Ph_15875398_0_1908.jpg","id_listingid":"202110227","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15936276","_score":10.089909,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15936276","id_primarylistingofficename":"Avalon Realty LLC","type_search":0,"type_propertytype":3,"id_primarylistingagent":"40648","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"7000 Hawaii Kai Dr #s503","location_postalcode":"96825","flag_internetadvertise":true,"price_list":30000.0,"id_primarylistingoffice":"AVAL","squarefootage":59,"location_city":"Honolulu","primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/5/27/Ph_15936276_0_1707.jpg","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.7039714,"lat":21.2870461},"id_listingid":"202113214","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15972892","_score":8.971241,"_source":{"status_display":"Active","systemid":268,"id_listinguid":"15972892","type_search":0,"bathrooms_total":2,"id_primarylistingagent":"23560","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"520 Lunalilo Home Rd #7419","flag_internetadvertise":true,"price_list":725000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6973045,"lat":21.2871055},"id_primarylistingofficename":"Coldwell Banker Realty","type_propertytype":3,"location_postalcode":"96825","bedrooms":2,"id_primarylistingoffice":"CBPP02","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-14T03:00:00","date_startdatetime":"2021-06-14T00:00:00"}],"squarefootage":1378,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/12/Ph_15972892_0_1310.jpg","id_listingid":"202115298","type_transactiontype":0}},{"_index":"listings_v1","_type":"_doc","_id":"268-15968245","_score":8.928242,"_source":{"status_display":"In Escrow Showing","systemid":268,"id_listinguid":"15968245","type_search":0,"bathrooms_total":1,"id_primarylistingagent":"26001","type_status":0,"flag_showstreetaddress":true,"flag_publicsearch":true,"location_state":"HI","location_streetaddress":"520 Lunalilo Home Rd #6101","flag_internetadvertise":true,"price_list":560000.0,"location_city":"Honolulu","detailtablename":"MLS_HIHB_RESI","geo_coordinates":{"lon":-157.6973045,"lat":21.2871055},"id_primarylistingofficename":"BHGRE Advantage Realty","type_propertytype":3,"location_postalcode":"96825","bedrooms":1,"id_primarylistingoffice":"ADVG","obj_openhouses":[{"type_openhousetype":0,"date_enddatetime":"2021-06-14T03:00:00","date_startdatetime":"2021-06-14T00:00:00"}],"squarefootage":1029,"primaryimage":"https://lm.salecore.com/photos/268/RESI/2021/6/8/Ph_15968245_0_1639.jpg","id_listingid":"202115087","type_transactiontype":0}}]}}