Previous
Next
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.
View: Mountain,Ocean
Listing Office: Nakamoto Realty LLC
Land Tenure: FS - Fee Simple
Elementary School: Haleiwa
Middle School: Waialua
High School: Waialua
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"
}
}