59-530 Hoalike Road
Haleiwa, HI 96712

Listing
Overview

Price: $3,299,000
Area: PUPUKEA
Status: Sold

Located on the hills of the beloved North Shore, Oahu. This paradise estate has beautiful views of the ocean and mountains! Zen and peace inspired custom designer home with magnificent architecture depicting special features as well as immaculate tropical landscaping. This exclusive retreat comprises a main house consisting of 3 Bedrooms, a big media room, an office room, 5 bathrooms, marvelous kitchen, lanai, etc. A separate recreation/guest room including a Wet bar. This property also provides a gorgeous pool next to a lovely cabana. It is less than a 5 minute drive to the most pristine beaches such as Waimea Bay and Pipeline. Favorable investment with a bonus of tranquility and prosperity.

  • Bedrooms: 4
  • Full Baths: 7
  • Land Area (sf): 45,651
  • Living (sf): 7,057
  • Year Built: 2002

  • Property Condition: Above Average,Excellent
  • Number of Parking Spaces: 3
  • Pool: In Ground,Spa/HotTub
  • Number of Stories: Three+
  • View: Garden,Mountain,Ocean,Other,Sunset
  • Listing Office: Compass

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(149) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(10) "1257700.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "946200.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "2203900.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(39) "Detach Single Family,Multiple Dwellings"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["exclusions"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(23) "Hardwood,Marble/Granite"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "7"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(3) "736"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "45651.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(25) "irmahawaiihomes@gmail.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(13) "Irma Klebanov"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-14"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "3299000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "7057"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(38) "59-530 Hoalike Road, Haleiwa, HI 96712"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202109191"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "PUPUKEA"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(6) "Three+"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(29) "3 Car+,Driveway,Garage,Street"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(20) "In Ground,Spa/HotTub"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(23) "Above Average,Excellent"
  }
  ["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) "7"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "7.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "3300000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "19"
  }
  ["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) "15849538"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(25) "irmahawaiihomes@gmail.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(13) "Irma Klebanov"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "44285"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9013420"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15465233"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "3299000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-14"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "45651.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-30T08:23:28.517"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15849538"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202109191"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "PUPUKEA"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-16T13:33:02.940"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "3299000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-5-9-025-020-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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) "22"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-25T10:40:43.840"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-25T10:22:14.600"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15849538"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(219) "Must see and show! Call/text/ 808-3436087 Irma or email at irmahawaiihomes@gmail.com, Irma.klebanov@compass.com
I’ll accommodate you at your convenience. Actual sq footage,bedrooms and baths do not match tax records."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(701) "Located on the hills of the beloved North Shore, Oahu. This paradise estate has beautiful views of the ocean and mountains! Zen and peace inspired custom designer home with magnificent architecture depicting special features as well as immaculate tropical landscaping. This exclusive retreat comprises a main house consisting of 3 Bedrooms, a big media room, an office room, 5 bathrooms, marvelous kitchen, lanai, etc. A separate recreation/guest room including a Wet bar. This property also provides a gorgeous pool next to a lovely cabana. It is less than a 5 minute drive to the most pristine beaches such as Waimea Bay and Pipeline. Favorable investment with a bonus of tranquility and prosperity."
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(3) "640"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(3) "736"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "4268"
  }
  ["rets_sqft_roofed_other"]=>
  array(1) {
    [0]=>
    string(4) "2053"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "7057"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-30T08:23:28.517"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-30"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(7) "Hoalike"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "59-530"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.643809$-158.044696$280.83$13.33$1.00$TLydnjXRWoNEBLS7wyj2-w"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "533.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "2203900.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(10) "1257700.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "946200.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/15849538/fa1fce80aa53344650fa53fa8fbd459c"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "159"
  }
  ["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) "20"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "25"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "2002"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(3) "Key"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(9) "Of Record"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(21) "A/S,Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-5-9-025-020-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(34) "Garden,Mountain,Ocean,Other,Sunset"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15849538"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202109191"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628918065"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "2002"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(21) "56 - Country District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2754) "a:168:{i:0;i:19868914;i:1;i:19868915;i:2;i:19868916;i:3;i:19868917;i:4;i:19868918;i:5;i:19868919;i:6;i:19868920;i:7;i:19868921;i:8;i:19868922;i:9;i:19868923;i:10;i:19868924;i:11;i:19868925;i:12;i:19868926;i:13;i:19868927;i:14;i:19868928;i:15;i:19868929;i:16;i:19868930;i:17;i:19868931;i:18;i:19868932;i:19;i:19868933;i:20;i:19868934;i:21;i:19868975;i:22;i:19868976;i:23;i:19868977;i:24;i:19868978;i:25;i:19868979;i:26;i:19868980;i:27;i:19868981;i:28;i:19868982;i:29;i:19868983;i:30;i:19868984;i:31;i:19868985;i:32;i:19868986;i:33;i:19868987;i:34;i:19868988;i:35;i:19868989;i:36;i:19868990;i:37;i:19868991;i:38;i:19868992;i:39;i:19868993;i:40;i:19868994;i:41;i:19868995;i:42;i:19869009;i:43;i:19869010;i:44;i:19869011;i:45;i:19869012;i:46;i:19869013;i:47;i:19869014;i:48;i:19869015;i:49;i:19869016;i:50;i:19869017;i:51;i:19869018;i:52;i:19869019;i:53;i:19869020;i:54;i:19869021;i:55;i:19869022;i:56;i:19869023;i:57;i:19869024;i:58;i:19869025;i:59;i:19869026;i:60;i:19869027;i:61;i:19869028;i:62;i:19869029;i:63;i:19877182;i:64;i:19877183;i:65;i:19877184;i:66;i:19877185;i:67;i:19877186;i:68;i:19877187;i:69;i:19877188;i:70;i:19877189;i:71;i:19877190;i:72;i:19877191;i:73;i:19877192;i:74;i:19877193;i:75;i:19877194;i:76;i:19877195;i:77;i:19877196;i:78;i:19877197;i:79;i:19877198;i:80;i:19877199;i:81;i:19877200;i:82;i:19877201;i:83;i:19877202;i:84;i:19877203;i:85;i:19877204;i:86;i:19877205;i:87;i:19877206;i:88;i:19877207;i:89;i:19877208;i:90;i:19877209;i:91;i:19877210;i:92;i:19877211;i:93;i:19877212;i:94;i:19877213;i:95;i:19877214;i:96;i:19877215;i:97;i:19877216;i:98;i:19877217;i:99;i:19877218;i:100;i:19877219;i:101;i:19877220;i:102;i:19877221;i:103;i:19877222;i:104;i:19877223;i:105;i:19881738;i:106;i:19881739;i:107;i:19881740;i:108;i:19881741;i:109;i:19881742;i:110;i:19881743;i:111;i:19881744;i:112;i:19881745;i:113;i:19881746;i:114;i:19881747;i:115;i:19881748;i:116;i:19881749;i:117;i:19881750;i:118;i:19881751;i:119;i:19881752;i:120;i:19881753;i:121;i:19881754;i:122;i:19881755;i:123;i:19881756;i:124;i:19881757;i:125;i:19881758;i:126;i:20046574;i:127;i:20046575;i:128;i:20046576;i:129;i:20046577;i:130;i:20046578;i:131;i:20046579;i:132;i:20046580;i:133;i:20046581;i:134;i:20046582;i:135;i:20046583;i:136;i:20046584;i:137;i:20046585;i:138;i:20046586;i:139;i:20046587;i:140;i:20046588;i:141;i:20046589;i:142;i:20046590;i:143;i:20046591;i:144;i:20046592;i:145;i:20046593;i:146;i:20046594;i:147;i:20294831;i:148;i:20294832;i:149;i:20294833;i:150;i:20294834;i:151;i:20294835;i:152;i:20294836;i:153;i:20294837;i:154;i:20294838;i:155;i:20294839;i:156;i:20294840;i:157;i:20294841;i:158;i:20294842;i:159;i:20294843;i:160;i:20294844;i:161;i:20294845;i:162;i:20294846;i:163;i:20294847;i:164;i:20294848;i:165;i:20294849;i:166;i:20294850;i:167;i:20294851;}"
  }
  ["rets_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_active_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_open_house_upcoming"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-02"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-30"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "3300000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-30"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 214-7187"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(27) "daniellecapozzihi@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(18) "Danielle S Capozzi"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "28833"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3477836"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "PCFC"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15413275"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(24) "Pacific Image Properties"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 214-7187"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(7) "Hoalike"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "59-530"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20294831"
  }
}