46-403 & 46-411 Haiku Plantations Drive
Kaneohe, HI 96744

Take a Virtual Tour

Listing
Overview

Price: $5,750,000
Area: HAIKU PLANTATION
Status: Active

Rare opportunity to build your own magnificent & secure getaway on two separate relatively level side by side one-acre lots. Offers on each individual lot also invited. This beautiful property is situated in the prestigious Haiku Plantation in Windward Oahu, a 24-hour privately guarded and gated community. This rare offering includes two adjacent parcels (027 & 028) totaling approximately 87,295 sf. of land, with two separate dwellings. All the land you will ever need to fulfill your every dream, whether a racquetball court or a basketball court or a bowling alley or a horse barn and ring or a dog kennel or all of the above, added to the existing regulation size night lighted tennis court and two swimming pools and existing convenient inside property parking for dozens of cars. Structures and facilities in disrepair, needs remodel.

  • Land Area (sf): 87,295
  • Living (sf): 16,986
  • Year Built: 1965

  • Property Condition: Fair
  • Number of Parking Spaces: 10
  • Number of Stories: One,Two
  • View: Garden,Mountain,Ocean
  • Listing Office: Hawaii Homes International

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(133) {
  ["address_is_formatted"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "807300.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(10) "2160400.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "2967700.00"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(8) "Drainage"
  }
  ["formatted_address"]=>
  array(1) {
    [0]=>
    string(56) "46-411 Haiku Plantations Dr #403, Kaneohe, HI 96744, USA"
  }
  ["formatted_address_simple"]=>
  array(1) {
    [0]=>
    string(45) "46-411 Haiku Plantations Dr #403, Kaneohe, HI"
  }
  ["google_place_id"]=>
  array(1) {
    [0]=>
    string(122) "Ejg0Ni00MTEgSGFpa3UgUGxhbnRhdGlvbnMgRHIgIzQwMywgS2FuZW9oZSwgSEkgOTY3NDQsIFVTQSIfGh0KFgoUChIJ8ShDjFFqAHwRgK04qX2QpKgSAzQwMw"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "87295.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(15) "bgwvrdr@aol.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(12) "Ralph S Gray"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 949-0020"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-15"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(26) "Hawaii Homes International"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "5750000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(5) "16986"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(58) "46-403 & 46-411 Haiku Plantations Drive, Kaneohe, HI 96744"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202029931"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(16) "HAIKU PLANTATION"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(7) "One,Two"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "REEW"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(7) "Covered"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(4) "Fair"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(11) "multifamily"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(11) "multifamily"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_compensation_method"]=>
  array(1) {
    [0]=>
    string(13) "Dual Variable"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "5750000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(3) "284"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "15575223"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_is_deleted"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 949-0020"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(15) "bgwvrdr@aol.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(12) "Ralph S Gray"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "24511"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3474891"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "REEW"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486350"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(26) "Hawaii Homes International"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 949-0020"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "5750000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-15"
  }
  ["rets_lock_box_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "87295.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(9) "Hawaiiana"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-593-9100"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-25T12:12:15.710"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15575223"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202029931"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(16) "HAIKU PLANTATION"
  }
  ["rets_net_operating_income"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_number_of_units_total"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-12-15T14:03:04.610"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "6000000.00"
  }
  ["rets_other_income"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-4-6-013-027-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["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) "17"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-12-17T21:12:41.423"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-05-09T16:55:24.443"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15575223"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(271) "Pre-Qualified buyer showings only with appointment. Please call Pauline at 808-429-4167 or email client's profile to Pauline: PShum429@hotmail.com for showing request. Contact Ralph Gray for all offers and questions. Virtual Tour: https://vtours.In1View.com/1755370?idx=1"
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(843) "Rare opportunity to build your own magnificent & secure getaway on two separate relatively level side by side one-acre lots. Offers on each individual lot also invited. This beautiful property is situated in the prestigious Haiku Plantation in Windward Oahu, a 24-hour privately guarded and gated community. This rare offering includes two adjacent parcels (027 & 028) totaling approximately 87,295 sf. of land, with two separate dwellings. All the land you will ever need to fulfill your every dream, whether a racquetball court or a basketball court or a bowling alley or a horse barn and ring or a dog kennel or all of the above, added to the existing regulation size night lighted tennis court and two swimming pools and existing convenient inside property parking for dozens of cars. Structures and facilities in disrepair, needs remodel."
  }
  ["rets_sqft_building"]=>
  array(1) {
    [0]=>
    string(5) "16986"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(5) "16986"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-12-15T14:03:04.610"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-15"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(17) "Haiku Plantations"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(15) "46-403 & 46-411"
  }
  ["rets_studio_units_number_of"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(2) "3%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "865.58"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "2967700.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "807300.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(10) "2160400.00"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/15575223/ad38740c18f0aae2431db21738b07d4b"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "146"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "27"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "13"
  }
  ["rets_total_actual_rent"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_total_annual_operating_expenses"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_total_income"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_unit_one_bed_number_of"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_unit_three_bed_number_of"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_unit_two_bed_number_of"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(40) "https://vtours.In1View.com/1755370?idx=1"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1965"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "1989"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(3) "C&C"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-4-6-013-027-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(21) "Garden,Mountain,Ocean"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(40) "https://vtours.In1View.com/1755370?idx=1"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15575223"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202029931"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(11) "01463079115"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1632607984"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1965"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "1989"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(21) "56 - Country District"
  }
  ["latitude"]=>
  array(1) {
    [0]=>
    string(10) "21.4201142"
  }
  ["longitude"]=>
  array(1) {
    [0]=>
    string(12) "-157.8194872"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(3927) "a:237:{i:0;i:17213978;i:1;i:17213979;i:2;i:17213980;i:3;i:17213981;i:4;i:17213982;i:5;i:17213983;i:6;i:17213984;i:7;i:17213985;i:8;i:17217577;i:9;i:17217578;i:10;i:17217579;i:11;i:17217580;i:12;i:17217581;i:13;i:17217582;i:14;i:17217583;i:15;i:17217584;i:16;i:17217585;i:17;i:17217586;i:18;i:17217587;i:19;i:17217589;i:20;i:17217590;i:21;i:17217592;i:22;i:17217594;i:23;i:17217596;i:24;i:17217598;i:25;i:17217600;i:26;i:17217602;i:27;i:17217604;i:28;i:17217605;i:29;i:17217607;i:30;i:17217609;i:31;i:17217611;i:32;i:17217613;i:33;i:17230913;i:34;i:17230914;i:35;i:17230915;i:36;i:17230916;i:37;i:17230917;i:38;i:17230918;i:39;i:17230919;i:40;i:17230920;i:41;i:17230921;i:42;i:17230922;i:43;i:17230923;i:44;i:17230924;i:45;i:17230925;i:46;i:17230926;i:47;i:17230927;i:48;i:17230928;i:49;i:17230929;i:50;i:17345470;i:51;i:17345471;i:52;i:17345472;i:53;i:17345473;i:54;i:17345474;i:55;i:17345475;i:56;i:17345476;i:57;i:17345477;i:58;i:17345478;i:59;i:17345479;i:60;i:17345480;i:61;i:17345481;i:62;i:17345482;i:63;i:17345483;i:64;i:17345484;i:65;i:17345485;i:66;i:17345486;i:67;i:17346051;i:68;i:17346052;i:69;i:17346053;i:70;i:17346054;i:71;i:17346055;i:72;i:17346056;i:73;i:17346057;i:74;i:17346058;i:75;i:17346059;i:76;i:17346060;i:77;i:17346061;i:78;i:17346062;i:79;i:17346063;i:80;i:17346064;i:81;i:17346065;i:82;i:17346066;i:83;i:17346067;i:84;i:17358893;i:85;i:17358894;i:86;i:17358895;i:87;i:17358896;i:88;i:17358897;i:89;i:17358898;i:90;i:17358899;i:91;i:17358900;i:92;i:17358901;i:93;i:17358902;i:94;i:17358903;i:95;i:17358904;i:96;i:17358905;i:97;i:17358906;i:98;i:17358907;i:99;i:17358908;i:100;i:17358909;i:101;i:17358970;i:102;i:17358971;i:103;i:17358972;i:104;i:17358973;i:105;i:17358974;i:106;i:17358975;i:107;i:17358976;i:108;i:17358977;i:109;i:17358978;i:110;i:17358979;i:111;i:17358980;i:112;i:17358981;i:113;i:17358982;i:114;i:17358983;i:115;i:17358984;i:116;i:17358985;i:117;i:17358986;i:118;i:17504399;i:119;i:17504400;i:120;i:17504401;i:121;i:17504402;i:122;i:17504403;i:123;i:17504404;i:124;i:17504405;i:125;i:17504406;i:126;i:17504407;i:127;i:17504408;i:128;i:17504409;i:129;i:17504410;i:130;i:17504411;i:131;i:17504412;i:132;i:17504413;i:133;i:17504414;i:134;i:17504415;i:135;i:17776925;i:136;i:17776926;i:137;i:17776927;i:138;i:17776928;i:139;i:17776929;i:140;i:17776930;i:141;i:17776931;i:142;i:17776932;i:143;i:17776933;i:144;i:17776934;i:145;i:17776935;i:146;i:17776936;i:147;i:17776937;i:148;i:17776938;i:149;i:17776939;i:150;i:17776940;i:151;i:17776941;i:152;i:19973915;i:153;i:19973916;i:154;i:19973917;i:155;i:19973918;i:156;i:19973919;i:157;i:19973920;i:158;i:19973921;i:159;i:19973922;i:160;i:19973923;i:161;i:19973924;i:162;i:19973925;i:163;i:19973926;i:164;i:19973927;i:165;i:19973928;i:166;i:19973929;i:167;i:19973930;i:168;i:19973931;i:169;i:20208173;i:170;i:20208174;i:171;i:20208175;i:172;i:20208176;i:173;i:20208177;i:174;i:20208178;i:175;i:20208179;i:176;i:20208180;i:177;i:20208181;i:178;i:20208182;i:179;i:20208183;i:180;i:20208184;i:181;i:20208185;i:182;i:20208186;i:183;i:20208187;i:184;i:20208188;i:185;i:20208189;i:186;i:20803727;i:187;i:20803728;i:188;i:20803729;i:189;i:20803730;i:190;i:20803731;i:191;i:20803732;i:192;i:20803733;i:193;i:20803734;i:194;i:20803735;i:195;i:20803736;i:196;i:20803737;i:197;i:20803738;i:198;i:20803739;i:199;i:20803740;i:200;i:20803741;i:201;i:20803742;i:202;i:20803743;i:203;i:20832326;i:204;i:20832327;i:205;i:20832328;i:206;i:20832329;i:207;i:20832330;i:208;i:20832331;i:209;i:20832332;i:210;i:20832333;i:211;i:20832334;i:212;i:20832335;i:213;i:20832336;i:214;i:20832337;i:215;i:20832338;i:216;i:20832339;i:217;i:20832340;i:218;i:20832341;i:219;i:20832342;i:220;i:20838520;i:221;i:20838521;i:222;i:20838522;i:223;i:20838523;i:224;i:20838524;i:225;i:20838525;i:226;i:20838526;i:227;i:20838527;i:228;i:20838528;i:229;i:20838529;i:230;i:20838530;i:231;i:20838531;i:232;i:20838532;i:233;i:20838533;i:234;i:20838534;i:235;i:20838535;i:236;i:20838536;}"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(17) "Haiku Plantations"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(15) "46-403 & 46-411"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(5) "Drive"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-12-31"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20838520"
  }
}