Listing
Overview

Price: $435,000
Area: AHUIMANU AREA
Status: Sold

This is an AMAZING and UNIQUE Opportunity to buy the only Vacant Lot on Hui Iwa St. Located in a fantastic family neighborhood, right before you turn up into Ahuimanu Hills, below the gorgeous Koolau Mountains. Property is part of a 3 unit CPR. Seller’s plans to build changed. Seller currently has sewer approval and building plans that have not been approved for permit yet. Click on Supplements for Plans, Condo Map and CPR Docs. Buyer to do their own due diligence on the build-ability of the lot. Seller Please do not walk on property without making an appointment. Line in photos are for illustrative purposes only and should not be construed as actual property line. Vacant lot renderings are conceptual for representational purposes only and subject to variances.

  • Land Area (sf): 6,231

  • View: Garden
  • Listing Office: BHGRE Advantage Realty

  • Land Tenure: FS - Fee Simple

  • Elementary School: Ahuimanu
  • Middle School: King
  • High School: Castle

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

array(139) {
  ["address_is_formatted"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(7) "3400.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(8) "59400.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(8) "62800.00"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(8) "Ahuimanu"
  }
  ["formatted_address"]=>
  array(1) {
    [0]=>
    string(41) "47-508 Hui Iwa St, Kaneohe, HI 96744, USA"
  }
  ["formatted_address_simple"]=>
  array(1) {
    [0]=>
    string(30) "47-508 Hui Iwa St, Kaneohe, HI"
  }
  ["google_place_id"]=>
  array(1) {
    [0]=>
    string(27) "ChIJby_amUBqAHwR1HlDdO29zA0"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(6) "Castle"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "6231.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(10) "Land Court"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(24) "RachelB@BetterHawaii.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(15) "Rachel Barnette"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 261-1800"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-01-19"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "435000.00"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202101240"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(13) "AHUIMANU AREA"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(6) "ADVG02"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(16) "lots_acres_farms"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(16) "Lots Acres Farms"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_additional_parcels_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "415000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(3) "148"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(8) "Ahuimanu"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_high_school"]=>
  array(1) {
    [0]=>
    string(6) "Castle"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "15666468"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 261-1800"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(24) "RachelB@BetterHawaii.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "Rachel Barnette"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "38096"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3481522"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "ADVG02"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10139093"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 261-1800"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "435000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-01-19"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "6231.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-05T14:57:11.293"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15666468"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202101240"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "AHUIMANU AREA"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-01-20T14:47:46.100"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "500000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-060-041-0003"
  }
  ["rets_permit_address_internet_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_permit_internet_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_photo_count"]=>
  array(1) {
    [0]=>
    string(2) "12"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-05-20T06:43:08.440"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-05-17T15:34:28.850"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15666468"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(206) "Please call Rachel Barnette for showings and information, 808-224-5886.  Do not walk on property without an appointment. Please make sure your Buyer does their due diligence on the build-ability of the lot."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(773) "This is an AMAZING and UNIQUE Opportunity to buy the only Vacant Lot on Hui Iwa St. Located in a fantastic family neighborhood, right before you turn up into Ahuimanu Hills, below the gorgeous Koolau Mountains.  Property is part of a 3 unit CPR. Seller's plans to build changed. Seller currently has sewer approval and building plans that have not been approved for permit yet. Click on Supplements for Plans, Condo Map and CPR Docs. Buyer to do their own due diligence on the build-ability of the lot. Seller Please do not walk on property without making an appointment. Line in photos are for illustrative purposes only and should not be construed as actual property line.  Vacant lot renderings are conceptual for representational purposes only and subject to variances."
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-05T14:57:11.293"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-05"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(7) "Hui Iwa"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(7) "47-508C"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.435137$-157.832381$121.37$13.33$1.00$V6XN1MIxWcRnMGW_2EXdYw"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_supplement_count"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_supplement_modification_timestam"]=>
  array(1) {
    [0]=>
    string(23) "2021-01-19T15:59:58.447"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(5) "25.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(8) "62800.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(7) "3400.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(8) "59400.00"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/15666468/ab9012bd4e0ccc37ef1db04a9ce87218"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "147"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "41"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "7"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "60"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(13) "C&C,Of Record"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_address"]=>
  array(1) {
    [0]=>
    string(41) "47-508C Hui Iwa Street, Kaneohe, HI 96744"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-060-041-0003"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15666468"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202101240"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463079227"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1633481865"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["latitude"]=>
  array(1) {
    [0]=>
    string(10) "21.4343626"
  }
  ["longitude"]=>
  array(1) {
    [0]=>
    string(11) "-157.832484"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1469) "a:92:{i:0;i:17395065;i:1;i:17395066;i:2;i:17395067;i:3;i:17395068;i:4;i:17395069;i:5;i:17395070;i:6;i:17395071;i:7;i:17395072;i:8;i:17395073;i:9;i:17395074;i:10;i:17395075;i:11;i:17398659;i:12;i:17398660;i:13;i:17398661;i:14;i:17398662;i:15;i:17398663;i:16;i:17398664;i:17;i:17398665;i:18;i:17398666;i:19;i:17398667;i:20;i:17398668;i:21;i:17398669;i:22;i:17507489;i:23;i:17507490;i:24;i:17507491;i:25;i:17507492;i:26;i:17507493;i:27;i:17507494;i:28;i:17507495;i:29;i:17507496;i:30;i:17507497;i:31;i:17507498;i:32;i:17507499;i:33;i:19845540;i:34;i:19845541;i:35;i:19845542;i:36;i:19845543;i:37;i:19845544;i:38;i:19845545;i:39;i:19845546;i:40;i:19845547;i:41;i:19845548;i:42;i:19845549;i:43;i:19845550;i:44;i:19922305;i:45;i:19922306;i:46;i:19922307;i:47;i:19922308;i:48;i:19922309;i:49;i:19922310;i:50;i:19922311;i:51;i:19922312;i:52;i:19922313;i:53;i:19922314;i:54;i:19922315;i:55;i:19922316;i:56;i:20210058;i:57;i:20210059;i:58;i:20210060;i:59;i:20210061;i:60;i:20210062;i:61;i:20210063;i:62;i:20210064;i:63;i:20210065;i:64;i:20210066;i:65;i:20210067;i:66;i:20210068;i:67;i:20210069;i:68;i:20804265;i:69;i:20804266;i:70;i:20804267;i:71;i:20804268;i:72;i:20804269;i:73;i:20804270;i:74;i:20804271;i:75;i:20804272;i:76;i:20804273;i:77;i:20804274;i:78;i:20804275;i:79;i:20804276;i:80;i:20904695;i:81;i:20904696;i:82;i:20904697;i:83;i:20904698;i:84;i:20904699;i:85;i:20904700;i:86;i:20904701;i:87;i:20904702;i:88;i:20904703;i:89;i:20904704;i:90;i:20904705;i:91;i:20904706;}"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(69) "https://app.immoviewer.com/landing/unbranded/6009347a7f9ffe6379f0d34c"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(69) "https://app.immoviewer.com/landing/unbranded/6009347a7f9ffe6379f0d34c"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_internet_automated_valuation_dis"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_internet_consumer_comment_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-27"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(7) "Hui Iwa"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(7) "47-508C"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-01-29"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-05"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "415000.00"
  }
  ["rets_co_selling_agent_direct_work_pho"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_co_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "chengj33@gmail.com"
  }
  ["rets_co_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Jeremy A Cheng"
  }
  ["rets_co_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "50861"
  }
  ["rets_co_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "15544406"
  }
  ["rets_co_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "EXPI"
  }
  ["rets_co_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10013908"
  }
  ["rets_co_selling_office_name"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["rets_co_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-05"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "tony@alohatony.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Tony Kawaguchi"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "30802"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3478693"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "EXPI"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10013908"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20904695"
  }
}