59-495 Hoalike Road
Haleiwa, HI 96712

Listing
Overview

Price: $2,490,000
Area: PUPUKEA
Status: Sold

Come and enjoy the peace and beauty of the North Shore at this gorgeous home in Pupukea! You’ll fall in love with the open concept layout, newly renovated kitchen with all newer appliances, quartz counter tops and just installed luxury plank flooring throughout the 4 bedroom, 3 bath main house. Wonderful for entertaining, you and your guests can soak in the ocean views and sea breezes on your HUGE 840 sqft lanai! This home also boasts a mother-in-law suite with its own separate entrance, a recreation room with a wet-bar and separate entrance and another work room or home office where you can live, work, and play all on your 1.192 acre fenced in lot. DON’T MISS IT – There is so much this home has to offer!

  • Bedrooms: 6
  • Full Baths: 5
  • Land Area (sf): 51,924
  • Living (sf): 5,566
  • Year Built: 2000

  • Property Condition: Excellent
  • Number of Parking Spaces: 4
  • Pool: None
  • Number of Stories: One
  • View: Mountain,Ocean
  • Listing Office: BHGRE Advantage Realty

  • Land Tenure: FS - Fee Simple

  • Elementary School: Sunset Beach
  • Middle School: Waialua
  • High School: Waialua

CONTACT US

Marcus Realty

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

array(152) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "894200.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "727300.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "1621500.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "Detach Single Family"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(29) "None,Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(12) "Sunset Beach"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(19) "Laminate,W/W Carpet"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(7) "Partial"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(3) "840"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "51924.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(27) "margaritam@betterhawaii.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(22) "Margarita Margo Munden"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 261-1800"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-21"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "2490000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "5566"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(38) "59-495 Hoalike Road, Haleiwa, HI 96712"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202109282"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "PUPUKEA"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(6) "ADVG02"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(11) "3 Car+,Boat"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(15) "45 Days or Less"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(9) "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) "5"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "5.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["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) "2525000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(12) "Sunset Beach"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_fractional_ownership_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_high_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "15851894"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 261-1800"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(27) "margaritam@betterhawaii.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(22) "Margarita Margo Munden"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "31202"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3478859"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "ADVG02"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10139093"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 261-1800"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "2490000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-21"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "51924.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-05-26T13:08:42.727"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15851894"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202109282"
  }
  ["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-21T08:15:01.410"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "2490000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-5-9-024-019-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["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) "25"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-21T08:15:01.410"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-21T08:15:01.410"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15851894"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(245) "Showings to pre-approved buyers only, send over proof of cash funds or pre-approval before confirming an appointment. Listor must be present. The number of bedrooms and bathrooms differ from the tax records. Monthly tax based on 2020 tax values."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(719) "Come and enjoy the peace and beauty of the North Shore at this gorgeous home in Pupukea!  You’ll fall in love with the open concept layout, newly renovated kitchen with all newer appliances, quartz counter tops and just installed luxury plank flooring throughout the 4 bedroom, 3 bath main house. Wonderful for entertaining, you and your guests can soak in the ocean views and sea breezes on your HUGE 840 sqft lanai! This home also boasts a mother-in-law suite with its own separate entrance, a recreation room with a wet-bar and separate entrance and another work room or home office where you can live, work, and play all on your 1.192 acre fenced in lot. DON’T MISS IT - There is so much this home has to offer!"
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(3) "600"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(3) "840"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "4194"
  }
  ["rets_sqft_roofed_other"]=>
  array(1) {
    [0]=>
    string(3) "532"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "5566"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-05-26T13:08:42.727"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-26"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(7) "Hoalike"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "59-495"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.641398$-158.044545$101.77$13.33$1.00$dQdI8XpwL4F9NMXPbb9Dhw"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "500.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "1621500.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "894200.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "727300.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/15851894/baf6ce86d5e9707bcbd46967b9601fbb"
  }
  ["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) "19"
  }
  ["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) "24"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "2000"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["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(24) "Cash,Conventional,FHA,VA"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-5-9-024-019-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Ocean"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15851894"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202109282"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628916104"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "2000"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(21) "56 - Country District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1341) "a:84:{i:0;i:19840941;i:1;i:19840942;i:2;i:19840943;i:3;i:19840944;i:4;i:19840945;i:5;i:19840946;i:6;i:19840947;i:7;i:19840948;i:8;i:19840949;i:9;i:19840950;i:10;i:19840951;i:11;i:19840952;i:12;i:19840953;i:13;i:19840954;i:14;i:19840955;i:15;i:19840956;i:16;i:19840957;i:17;i:19840958;i:18;i:19840959;i:19;i:19840960;i:20;i:19840961;i:21;i:19877826;i:22;i:19877827;i:23;i:19877828;i:24;i:19877829;i:25;i:19877830;i:26;i:19877831;i:27;i:19877832;i:28;i:19877833;i:29;i:19877834;i:30;i:19877835;i:31;i:19877836;i:32;i:19877837;i:33;i:19877838;i:34;i:19877839;i:35;i:19877840;i:36;i:19877841;i:37;i:19877842;i:38;i:19877843;i:39;i:19877844;i:40;i:19877845;i:41;i:19877846;i:42;i:20043707;i:43;i:20043708;i:44;i:20043709;i:45;i:20043710;i:46;i:20043711;i:47;i:20043712;i:48;i:20043713;i:49;i:20043714;i:50;i:20043715;i:51;i:20043716;i:52;i:20043717;i:53;i:20043718;i:54;i:20043719;i:55;i:20043720;i:56;i:20043721;i:57;i:20043722;i:58;i:20043723;i:59;i:20043724;i:60;i:20043725;i:61;i:20043726;i:62;i:20043727;i:63;i:20291814;i:64;i:20291815;i:65;i:20291816;i:66;i:20291817;i:67;i:20291818;i:68;i:20291819;i:69;i:20291820;i:70;i:20291821;i:71;i:20291822;i:72;i:20291823;i:73;i:20291824;i:74;i:20291825;i:75;i:20291826;i:76;i:20291827;i:77;i:20291828;i:78;i:20291829;i:79;i:20291830;i:80;i:20291831;i:81;i:20291832;i:82;i:20291833;i:83;i:20291834;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-24"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-26"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "2525000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-26"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-24"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 550-0818"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(28) "kathi.white@evrealestate.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "Kathryn C White"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "25767"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3475586"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "PPRO"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486494"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(24) "Engel & Volkers-Honolulu"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 550-0818"
  }
  ["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-495"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20291814"
  }
}