Listing
Overview

Price: $4,000,000
Area: KAWAILOA-NORTH SHORE
Status: Active

Laniakea’s meaning of “Immense Heaven” or “Wide Horizons” can be seen and felt from this precious 2 acre land. It is across from the North of Oahu’s gathering place for our Treasured Green Sea Turtles. Are you ready to build your special home on this property with AMAZING Views? The property is zoned AG-1 and has many possibilities with additional structures once you’ve created the vision with your architect.

  • Land Area (sf): 88,340

  • View: Mountain,Ocean
  • Listing Office: Nakamoto Realty LLC

  • Land Tenure: FS - Fee Simple

  • Elementary School: Haleiwa
  • Middle School: Waialua
  • High School: Waialua

CONTACT US

Marcus Realty

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

array(110) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "511100.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "511100.00"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["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(7) "Haleiwa"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "88340.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(14) "Regular System"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(22) "alohabelinda@gmail.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(17) "Belinda M Miranda"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 688-9878"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-21"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(19) "Nakamoto Realty LLC"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "4000000.00"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202116359"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(20) "KAWAILOA-NORTH SHORE"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "NREA"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["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(11) "North Shore"
  }
  ["rets_additional_parcels_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "4000000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(3) "275"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_high_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16001506"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_internet_automated_valuation_dis"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_internet_consumer_comment_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 688-9878"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(22) "alohabelinda@gmail.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(17) "Belinda M Miranda"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "38101"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3481525"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "NREA"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486452"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(19) "Nakamoto Realty LLC"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 688-9878"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "4000000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-21"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "88340.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2022-05-12T01:33:42.380"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16001506"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202116359"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(20) "KAWAILOA-NORTH SHORE"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-24T17:38:02.807"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "3300000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-6-1-009-004-0000"
  }
  ["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) "10"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-24T17:38:02.807"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16001506"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(245) "Please call or text Belinda Miranda at (808) 561-4342.

APPOINTMENTS ONLY ~ PLEASE DO NO ENTER THE PROPERTY

Flood Zoning shows as: D, AE AND VE on Hawaii Information and should be verified.
Aerial Outline View of Map is for reference only."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(415) "Laniakea's meaning of "Immense Heaven" or "Wide Horizons" can be seen and felt from this precious 2 acre land.  It is across from the North of Oahu's gathering place for our Treasured Green Sea Turtles.  Are you ready to build your special home on this property with AMAZING Views?  The property is zoned AG-1 and has many possibilities with additional structures once you've created the vision with your architect."
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2022-05-04T01:16:51.467"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-21"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(10) "Kamehameha"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "61-560"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.620047$-158.083497$213.97$13.33$1.00$cPzyOHXwpt4KQtxZ9smLLw"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "242.77"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "511100.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "511100.00"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16001506/08fcd4ddca5799ab8216c1671842b637"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "161"
  }
  ["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(1) "4"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(39) "http://player.vimeo.com/video/563570859"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(9) "Of Record"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["street_address"]=>
  array(1) {
    [0]=>
    string(44) "61-560 Kamehameha Highway, Haleiwa, HI 96712"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(10) "Kamehameha"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "61-560"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(7) "Highway"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-6-1-009-004-0000"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Ocean"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(39) "http://player.vimeo.com/video/563570859"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16001506"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202116359"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463079227"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1652355273"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(31) "51 - AG-1 Restricted Agricultur"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1117) "a:70:{i:0;i:19925992;i:1;i:19925993;i:2;i:19925994;i:3;i:19925995;i:4;i:19925996;i:5;i:19925997;i:6;i:19925998;i:7;i:19925999;i:8;i:19926000;i:9;i:19926001;i:10;i:20215216;i:11;i:20215217;i:12;i:20215218;i:13;i:20215219;i:14;i:20215220;i:15;i:20215221;i:16;i:20215222;i:17;i:20215223;i:18;i:20215224;i:19;i:20215225;i:20;i:20808396;i:21;i:20808397;i:22;i:20808398;i:23;i:20808399;i:24;i:20808400;i:25;i:20808401;i:26;i:20808402;i:27;i:20808403;i:28;i:20808404;i:29;i:20808405;i:30;i:21453509;i:31;i:21453510;i:32;i:21453511;i:33;i:21453512;i:34;i:21453513;i:35;i:21453514;i:36;i:21453515;i:37;i:21453516;i:38;i:21453517;i:39;i:21453518;i:40;i:21828156;i:41;i:21828157;i:42;i:21828158;i:43;i:21828159;i:44;i:21828160;i:45;i:21828161;i:46;i:21828162;i:47;i:21828163;i:48;i:21828164;i:49;i:21828165;i:50;i:22150397;i:51;i:22150398;i:52;i:22150399;i:53;i:22150400;i:54;i:22150401;i:55;i:22150402;i:56;i:22150403;i:57;i:22150404;i:58;i:22150405;i:59;i:22150406;i:60;i:22204553;i:61;i:22204554;i:62;i:22204555;i:63;i:22204556;i:64;i:22204557;i:65;i:22204558;i:66;i:22204559;i:67;i:22204560;i:68;i:22204561;i:69;i:22204562;}"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2022-05-12T01:33:42.380"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "2913.24"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "22204553"
  }
}