Oceanfront home! Legal Nightly Rental! Lovingly named “Hale Moana” or “House of the Sea.” This beautiful oceanfront home along Kamehameha Highway in Haleiwa carries with it one of the rare Non-Conforming Use or NUC, legal nightly vacation rental licenses. Fully booked year round and located perfectly between historic Haleiwa town and beautiful Waimea Bay. Wonderful panoramic ocean views with easy access to world class surf spots straight out front! Enjoy watching whales, dolphins and turtles as you sip your morning coffee or favorite evening drink as you watch the sun set over the ocean.
Listing by: Corcoran Pacific Properties (808) 589-2040
array(171) {
["agency"]=>
array(1) {
[0]=>
string(27) "Corcoran Pacific Properties"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "534600.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(10) "1948300.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "2482900.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "3"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["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(4) "None"
}
["floor_covering"]=>
array(1) {
[0]=>
string(23) "Ceramic Tile,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "3"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "249"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "7110.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(29) "bill.ward@corcoranpacific.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(14) "William G Ward"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 589-2040"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-06-15"
}
["list_office_name"]=>
array(1) {
[0]=>
string(27) "Corcoran Pacific Properties"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "3988000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1977"
}
["location"]=>
array(1) {
[0]=>
string(44) "61-393 Kamehameha Highway, Haleiwa, HI 96712"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202210975"
}
["neighborhood"]=>
array(1) {
[0]=>
string(20) "KAWAILOA-NORTH SHORE"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "2"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "ELIT"
}
["parking_features"]=>
array(1) {
[0]=>
string(28) "1 Car,Driveway,Garage,Street"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(15) "45 Days or Less"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96712"
}
["property_condition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["property_type"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["property_type_label"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["region"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "3.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 589-2040"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(31) "jeffrey.fox@corcoranpacific.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Jeffrey M Fox"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "15935"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3473238"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "ELIT"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3486767"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(27) "Corcoran Pacific Properties"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 589-2040"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "4200000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "11"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_foreclosure_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16693199"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 589-2040"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(29) "bill.ward@corcoranpacific.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(14) "William G Ward"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "44675"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "9217144"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "ELIT"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3486767"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(27) "Corcoran Pacific Properties"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 589-2040"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "3988000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-06-15"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "7110.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-08-26T10:11:57.067"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16693199"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202210975"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(20) "KAWAILOA-NORTH SHORE"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-15T16:51:37.050"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "3988000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-6-1-008-001-0000"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["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) "23"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-17T07:41:54.950"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96712"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-15T16:51:37.050"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16693199"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(481) "Listing agent must be present for all showings. Please schedule all showings with Bill Ward at 372-6986 and call/email Bill or Jeff Fox directly with any questions. Seller requests Nara Shibao at First American Title. Please see STR Disclosure for use with all submitted offers and NUC included in Supplements on this listing. Seller has loved this home for many decades and respectfully requests any offers set aside two weeks a year for the family to rent at market rental rates."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(594) "Oceanfront home! Legal Nightly Rental! Lovingly named "Hale Moana" or "House of the Sea." This beautiful oceanfront home along Kamehameha Highway in Haleiwa carries with it one of the rare Non-Conforming Use or NUC, legal nightly vacation rental licenses. Fully booked year round and located perfectly between historic Haleiwa town and beautiful Waimea Bay. Wonderful panoramic ocean views with easy access to world class surf spots straight out front! Enjoy watching whales, dolphins and turtles as you sip your morning coffee or favorite evening drink as you watch the sun set over the ocean."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "364"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "249"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1728"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1977"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-08-26T10:11:57.067"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-08-26"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "61-393"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.625524$-158.076324$349.23$13.33$1.00$AfBNzjt7v5fN1fB56dX1Eg"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-06-09T10:20:44.863"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(7) "1288.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(8) "15456.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "2482900.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "534600.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(10) "1948300.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2022"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16693199/091d5d92b1d86afb4186e5170ee4d9ff"
}
["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) "1"
}
["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) "8"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(42) "https://tours.1ViewMedia.com/2003440?idx=1"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1952"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "1991"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["setbacks"]=>
array(1) {
[0]=>
string(13) "C&C,Of Record"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "61-393"
}
["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-008-001-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(12) "Garden,Ocean"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(42) "https://tours.1ViewMedia.com/2003440?idx=1"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16693199"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202210975"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1661544746"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1952"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "1991"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1683) "a:105:{i:0;i:22449836;i:1;i:22449837;i:2;i:22449838;i:3;i:22449839;i:4;i:22449840;i:5;i:22449841;i:6;i:22449842;i:7;i:22449843;i:8;i:22449844;i:9;i:22449845;i:10;i:22449846;i:11;i:22449847;i:12;i:22449848;i:13;i:22449849;i:14;i:22449850;i:15;i:22449851;i:16;i:22449852;i:17;i:22449853;i:18;i:22449854;i:19;i:22449855;i:20;i:22449856;i:21;i:22450939;i:22;i:22450940;i:23;i:22450941;i:24;i:22450942;i:25;i:22450943;i:26;i:22450944;i:27;i:22450945;i:28;i:22450946;i:29;i:22450947;i:30;i:22450948;i:31;i:22450949;i:32;i:22450950;i:33;i:22450951;i:34;i:22450952;i:35;i:22450953;i:36;i:22450954;i:37;i:22450955;i:38;i:22450956;i:39;i:22450957;i:40;i:22450958;i:41;i:22450959;i:42;i:22462709;i:43;i:22462710;i:44;i:22462711;i:45;i:22462712;i:46;i:22462713;i:47;i:22462714;i:48;i:22462715;i:49;i:22462716;i:50;i:22462717;i:51;i:22462718;i:52;i:22462719;i:53;i:22462720;i:54;i:22462721;i:55;i:22462722;i:56;i:22462723;i:57;i:22462724;i:58;i:22462725;i:59;i:22462726;i:60;i:22462727;i:61;i:22462728;i:62;i:22462729;i:63;i:22545230;i:64;i:22545231;i:65;i:22545232;i:66;i:22545233;i:67;i:22545234;i:68;i:22545235;i:69;i:22545236;i:70;i:22545237;i:71;i:22545238;i:72;i:22545239;i:73;i:22545240;i:74;i:22545241;i:75;i:22545242;i:76;i:22545243;i:77;i:22545244;i:78;i:22545245;i:79;i:22545246;i:80;i:22545247;i:81;i:22545248;i:82;i:22545249;i:83;i:22545250;i:84;i:23165879;i:85;i:23165880;i:86;i:23165881;i:87;i:23165882;i:88;i:23165883;i:89;i:23165884;i:90;i:23165885;i:91;i:23165886;i:92;i:23165887;i:93;i:23165888;i:94;i:23165889;i:95;i:23165890;i:96;i:23165891;i:97;i:23165892;i:98;i:23165893;i:99;i:23165894;i:100;i:23165895;i:101;i:23165896;i:102;i:23165897;i:103;i:23165898;i:104;i:23165899;}"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-06-25"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-08-26"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "4200000.00"
}
["rets_co_selling_agent_direct_work_pho"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["rets_co_selling_agent_email"]=>
array(1) {
[0]=>
string(21) "julie.chu@compass.com"
}
["rets_co_selling_agent_full_name"]=>
array(1) {
[0]=>
string(12) "Julianne Chu"
}
["rets_co_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "52042"
}
["rets_co_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "16407257"
}
["rets_co_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["rets_co_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "15465233"
}
["rets_co_selling_office_name"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["rets_co_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-06-15"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-08-26"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(14) "ben@fieman.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(10) "Ben Fieman"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "46073"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "10012520"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "15465233"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "23165879"
}
}
Array
(
[agency] => Array
(
[0] => Corcoran Pacific Properties
)
[assd_val_imprv] => Array
(
[0] => 534600.00
)
[assd_val_land] => Array
(
[0] => 1948300.00
)
[assd_val_total] => Array
(
[0] => 2482900.00
)
[bedrooms] => Array
(
[0] => 3
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Haleiwa
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[floor_covering] => Array
(
[0] => Ceramic Tile,W/W Carpet
)
[frontage] => Array
(
[0] => Ocean,Sandy Beach
)
[full_baths] => Array
(
[0] => 3
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 0
)
[lanai_sf] => Array
(
[0] => 249
)
[land_area_sf] => Array
(
[0] => 7110.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => bill.ward@corcoranpacific.com
)
[list_agent_name] => Array
(
[0] => William G Ward
)
[list_agent_phone_number] => Array
(
[0] => (808) 589-2040
)
[list_date] => Array
(
[0] => 2022-06-15
)
[list_office_name] => Array
(
[0] => Corcoran Pacific Properties
)
[list_price] => Array
(
[0] => 3988000.00
)
[living_sf] => Array
(
[0] => 1977
)
[location] => Array
(
[0] => 61-393 Kamehameha Highway, Haleiwa, HI 96712
)
[mls_] => Array
(
[0] => 202210975
)
[neighborhood] => Array
(
[0] => KAWAILOA-NORTH SHORE
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => ELIT
)
[parking_features] => Array
(
[0] => 1 Car,Driveway,Garage,Street
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => 45 Days or Less
)
[postal_code] => Array
(
[0] => 96712
)
[property_condition] => Array
(
[0] => Above Average
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => North Shore
)
[rets_baths_full] => Array
(
[0] => 3
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 3.00
)
[rets_beds_total] => Array
(
[0] => 3
)
[rets_city] => Array
(
[0] => Haleiwa
)
[rets_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 589-2040
)
[rets_co_list_agent_email] => Array
(
[0] => jeffrey.fox@corcoranpacific.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => Jeffrey M Fox
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 15935
)
[rets_co_list_agent_mui] => Array
(
[0] => 3473238
)
[rets_co_list_office_mlsid] => Array
(
[0] => ELIT
)
[rets_co_list_office_mui] => Array
(
[0] => 3486767
)
[rets_co_list_office_name] => Array
(
[0] => Corcoran Pacific Properties
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 589-2040
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 4200000.00
)
[rets_dom] => Array
(
[0] => 11
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16693199
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 0
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 589-2040
)
[rets_list_agent_email] => Array
(
[0] => bill.ward@corcoranpacific.com
)
[rets_list_agent_full_name] => Array
(
[0] => William G Ward
)
[rets_list_agent_mlsid] => Array
(
[0] => 44675
)
[rets_list_agent_mui] => Array
(
[0] => 9217144
)
[rets_list_office_mlsid] => Array
(
[0] => ELIT
)
[rets_list_office_mui] => Array
(
[0] => 3486767
)
[rets_list_office_name] => Array
(
[0] => Corcoran Pacific Properties
)
[rets_list_office_phone] => Array
(
[0] => (808) 589-2040
)
[rets_list_price] => Array
(
[0] => 3988000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-06-15
)
[rets_lot_size_area] => Array
(
[0] => 7110.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-08-26T10:11:57.067
)
[rets_matrix_unique_id] => Array
(
[0] => 16693199
)
[rets_mls_number] => Array
(
[0] => 202210975
)
[rets_neighbourhood] => Array
(
[0] => KAWAILOA-NORTH SHORE
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-06-15T16:51:37.050
)
[rets_original_list_price] => Array
(
[0] => 3988000.00
)
[rets_parcel_number] => Array
(
[0] => 1-6-1-008-001-0000
)
[rets_parking_total] => Array
(
[0] => 2
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 23
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-06-17T07:41:54.950
)
[rets_postal_code] => Array
(
[0] => 96712
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-06-15T16:51:37.050
)
[rets_primary_key] => Array
(
[0] => 16693199
)
[rets_private_remarks] => Array
(
[0] => Listing agent must be present for all showings. Please schedule all showings with Bill Ward at 372-6986 and call/email Bill or Jeff Fox directly with any questions. Seller requests Nara Shibao at First American Title. Please see STR Disclosure for use with all submitted offers and NUC included in Supplements on this listing. Seller has loved this home for many decades and respectfully requests any offers set aside two weeks a year for the family to rent at market rental rates.
)
[rets_public_remarks] => Array
(
[0] => Oceanfront home! Legal Nightly Rental! Lovingly named "Hale Moana" or "House of the Sea." This beautiful oceanfront home along Kamehameha Highway in Haleiwa carries with it one of the rare Non-Conforming Use or NUC, legal nightly vacation rental licenses. Fully booked year round and located perfectly between historic Haleiwa town and beautiful Waimea Bay. Wonderful panoramic ocean views with easy access to world class surf spots straight out front! Enjoy watching whales, dolphins and turtles as you sip your morning coffee or favorite evening drink as you watch the sun set over the ocean.
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_garage_carport] => Array
(
[0] => 364
)
[rets_sqft_lanai_open] => Array
(
[0] => 249
)
[rets_sqft_roofed_living] => Array
(
[0] => 1728
)
[rets_sqft_total] => Array
(
[0] => 1977
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-08-26T10:11:57.067
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-08-26
)
[rets_street_name] => Array
(
[0] => Kamehameha
)
[rets_street_number] => Array
(
[0] => 61-393
)
[rets_street_view_param] => Array
(
[0] => 1$21.625524$-158.076324$349.23$13.33$1.00$AfBNzjt7v5fN1fB56dX1Eg
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_supplement_count] => Array
(
[0] => 2
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-06-09T10:20:44.863
)
[rets_tax_amount] => Array
(
[0] => 1288.00
)
[rets_tax_annual_amount] => Array
(
[0] => 15456.00
)
[rets_tax_assessed_value] => Array
(
[0] => 2482900.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 534600.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 1948300.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2022
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16693199/091d5d92b1d86afb4186e5170ee4d9ff
)
[rets_tmk_area] => Array
(
[0] => 161
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 1
)
[rets_tmk_section] => Array
(
[0] => 1
)
[rets_tmk_zone] => Array
(
[0] => 6
)
[rets_tmkplat] => Array
(
[0] => 8
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://tours.1ViewMedia.com/2003440?idx=1
)
[rets_year_built] => Array
(
[0] => 1952
)
[rets_year_remodeled] => Array
(
[0] => 1991
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => C&C,Of Record
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Kamehameha
)
[street_number] => Array
(
[0] => 61-393
)
[street_suffix] => Array
(
[0] => Highway
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-6-1-008-001-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Garden,Ocean
)
[virtual_tour] => Array
(
[0] => https://tours.1ViewMedia.com/2003440?idx=1
)
[wpp::rets_pk] => Array
(
[0] => 16693199
)
[wpp_gpid] => Array
(
[0] => 202210975
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1661544746
)
[year_built] => Array
(
[0] => 1952
)
[year_remodeled_] => Array
(
[0] => 1991
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:105:{i:0;i:22449836;i:1;i:22449837;i:2;i:22449838;i:3;i:22449839;i:4;i:22449840;i:5;i:22449841;i:6;i:22449842;i:7;i:22449843;i:8;i:22449844;i:9;i:22449845;i:10;i:22449846;i:11;i:22449847;i:12;i:22449848;i:13;i:22449849;i:14;i:22449850;i:15;i:22449851;i:16;i:22449852;i:17;i:22449853;i:18;i:22449854;i:19;i:22449855;i:20;i:22449856;i:21;i:22450939;i:22;i:22450940;i:23;i:22450941;i:24;i:22450942;i:25;i:22450943;i:26;i:22450944;i:27;i:22450945;i:28;i:22450946;i:29;i:22450947;i:30;i:22450948;i:31;i:22450949;i:32;i:22450950;i:33;i:22450951;i:34;i:22450952;i:35;i:22450953;i:36;i:22450954;i:37;i:22450955;i:38;i:22450956;i:39;i:22450957;i:40;i:22450958;i:41;i:22450959;i:42;i:22462709;i:43;i:22462710;i:44;i:22462711;i:45;i:22462712;i:46;i:22462713;i:47;i:22462714;i:48;i:22462715;i:49;i:22462716;i:50;i:22462717;i:51;i:22462718;i:52;i:22462719;i:53;i:22462720;i:54;i:22462721;i:55;i:22462722;i:56;i:22462723;i:57;i:22462724;i:58;i:22462725;i:59;i:22462726;i:60;i:22462727;i:61;i:22462728;i:62;i:22462729;i:63;i:22545230;i:64;i:22545231;i:65;i:22545232;i:66;i:22545233;i:67;i:22545234;i:68;i:22545235;i:69;i:22545236;i:70;i:22545237;i:71;i:22545238;i:72;i:22545239;i:73;i:22545240;i:74;i:22545241;i:75;i:22545242;i:76;i:22545243;i:77;i:22545244;i:78;i:22545245;i:79;i:22545246;i:80;i:22545247;i:81;i:22545248;i:82;i:22545249;i:83;i:22545250;i:84;i:23165879;i:85;i:23165880;i:86;i:23165881;i:87;i:23165882;i:88;i:23165883;i:89;i:23165884;i:90;i:23165885;i:91;i:23165886;i:92;i:23165887;i:93;i:23165888;i:94;i:23165889;i:95;i:23165890;i:96;i:23165891;i:97;i:23165892;i:98;i:23165893;i:99;i:23165894;i:100;i:23165895;i:101;i:23165896;i:102;i:23165897;i:103;i:23165898;i:104;i:23165899;}
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-06-25
)
[rets_close_date] => Array
(
[0] => 2022-08-26
)
[rets_close_price] => Array
(
[0] => 4200000.00
)
[rets_co_selling_agent_direct_work_pho] => Array
(
[0] => (808) 825-4277
)
[rets_co_selling_agent_email] => Array
(
[0] => julie.chu@compass.com
)
[rets_co_selling_agent_full_name] => Array
(
[0] => Julianne Chu
)
[rets_co_selling_agent_mlsid] => Array
(
[0] => 52042
)
[rets_co_selling_agent_mui] => Array
(
[0] => 16407257
)
[rets_co_selling_office_mlsid] => Array
(
[0] => COHI
)
[rets_co_selling_office_mui] => Array
(
[0] => 15465233
)
[rets_co_selling_office_name] => Array
(
[0] => Compass
)
[rets_co_selling_office_phone] => Array
(
[0] => (808) 825-4277
)
[rets_expiration_date] => Array
(
[0] => 2023-06-15
)
[rets_off_market_date] => Array
(
[0] => 2022-08-26
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 825-4277
)
[rets_selling_agent_email] => Array
(
[0] => ben@fieman.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Ben Fieman
)
[rets_selling_agent_mlsid] => Array
(
[0] => 46073
)
[rets_selling_agent_mui] => Array
(
[0] => 10012520
)
[rets_selling_office_mlsid] => Array
(
[0] => COHI
)
[rets_selling_office_mui] => Array
(
[0] => 15465233
)
[rets_selling_office_name] => Array
(
[0] => Compass
)
[rets_selling_office_phone] => Array
(
[0] => (808) 825-4277
)
[_thumbnail_id] => Array
(
[0] => 23165879
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446