54-132 Kawaipuna Street
Hauula, HI 96717

Take a Virtual Tour

Listing
Overview

Price: $980,000
Area: HAUULA
Status: Sold

“Wow!” Is what I kept saying to myself walking through this house. Completely remodeled in 2020, this home got a head to toe makeover and a huge addition to living square footage. While offering amazing rental potential while living comfortably in the spacious main upstairs area, your monthly payments could also be a lot less than you’d imagine. However you live in it, you’ll love the natural wood open beam ceilings upstairs and downstairs, light and refreshing color scheme throughout and spaciousness of every corner of this house. Located a minutes walk away you’ll find grocery and drug stores, restaurants and medical offices. You’re also just minutes away from a number of great family friendly beaches whether heading north or south. Don’t wait, call your agent now to schedule a showing.

  • Bedrooms: 5
  • Full Baths: 4
  • Land Area (sf): 5,025
  • Living (sf): 3,264
  • Year Built: 1965

  • Property Condition: Excellent
  • Number of Parking Spaces: 3
  • Pool: None
  • Number of Stories: Two
  • View: Mountain,Ocean
  • Listing Office: Staples Realty, Inc.

  • Land Tenure: FS - Fee Simple

  • Elementary School: Hauula
  • Middle School: Kahuku
  • High School: Kahuku

CONTACT US

Marcus Realty

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

array(157) {
  ["address_is_formatted"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "148700.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "425200.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "573900.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "Detach Single Family"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(5) "Vinyl"
  }
  ["formatted_address"]=>
  array(1) {
    [0]=>
    string(42) "54-132 Kawaipuna St, Hauula, HI 96717, USA"
  }
  ["formatted_address_simple"]=>
  array(1) {
    [0]=>
    string(31) "54-132 Kawaipuna St, Hauula, HI"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["google_place_id"]=>
  array(1) {
    [0]=>
    string(27) "ChIJCcV3NgVFAHwRtHe_wj7JNCA"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "5025.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(10) "Land Court"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(24) "jeremy@stapleshawaii.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(15) "Jeremy J Moncur"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 293-1114"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-28"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(20) "Staples Realty, Inc."
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "980000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "3264"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(41) "54-132 Kawaipuna Street, Hauula, HI 96717"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202032735"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "STAP"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(18) "3 Car+,Boat,Street"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["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(7) "Kaneohe"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "4.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["rets_compensation_method"]=>
  array(1) {
    [0]=>
    string(8) "Flat Fee"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "960000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "42"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["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(6) "Kahuku"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "15631797"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 293-1114"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(24) "jeremy@stapleshawaii.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "Jeremy J Moncur"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "44149"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8909796"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "STAP"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486428"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(20) "Staples Realty, Inc."
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 293-1114"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "980000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-28"
  }
  ["rets_lock_box_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "5025.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-03-30T22:29:19.017"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15631797"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202032735"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-12-28T20:15:25.190"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "980000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-5-4-018-037-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) "25"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-12-28T20:15:25.190"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96717"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15631797"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(97) "Sold As-Is. Seller prefers Athena Zamora with Old Republic Kailua. Schedule through Showing Time."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(799) ""Wow!" Is what I kept saying to myself walking through this house. Completely remodeled in 2020, this home got a head to toe makeover and a huge addition to living square footage. While offering amazing rental potential while living comfortably in the spacious main upstairs area, your monthly payments could also be a lot less than you'd imagine. However you live in it, you'll love the natural wood open beam ceilings upstairs and downstairs, light and refreshing color scheme throughout and spaciousness of every corner of this house. Located a minutes walk away you'll find grocery and drug stores, restaurants and medical offices. You're also just minutes away from a number of great family friendly beaches whether heading north or south. Don't wait, call your agent now to schedule a showing."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "3264"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "3264"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-03-30T22:29:19.017"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-03-30"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(9) "Kawaipuna"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "54-132"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.617663$-157.916211$215.75$13.33$1.00$nY-_gZ1PaXDqcNCvMU3oAw"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(5) "15000"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "168.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "573900.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "148700.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "425200.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) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/15631797/a578472e90955beeb5058ec831aac05c"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "154"
  }
  ["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) "37"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "18"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(130) "https://mls.immoviewer.com/portal/tour/2122656?psm.showBottomLine=false&accessKey=5f3c&psm.showPoweredBy=false&psm.showShare=false"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1965"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(3) "C&C"
  }
  ["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-4-018-037-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Ocean"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(130) "https://mls.immoviewer.com/portal/tour/2122656?psm.showBottomLine=false&accessKey=5f3c&psm.showPoweredBy=false&psm.showShare=false"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15631797"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202032735"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628966465"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1965"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["latitude"]=>
  array(1) {
    [0]=>
    string(10) "21.6176693"
  }
  ["longitude"]=>
  array(1) {
    [0]=>
    string(12) "-157.9161975"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2754) "a:168:{i:0;i:17272958;i:1;i:17272959;i:2;i:17272960;i:3;i:17272961;i:4;i:17272962;i:5;i:17272963;i:6;i:17272964;i:7;i:17272965;i:8;i:17272966;i:9;i:17272967;i:10;i:17272968;i:11;i:17272969;i:12;i:17272970;i:13;i:17272971;i:14;i:17272972;i:15;i:17272973;i:16;i:17272974;i:17;i:17272975;i:18;i:17272976;i:19;i:17272977;i:20;i:17272978;i:21;i:17272979;i:22;i:17272980;i:23;i:17272981;i:24;i:17272982;i:25;i:17272983;i:26;i:17272984;i:27;i:17272985;i:28;i:17272986;i:29;i:17272987;i:30;i:17272988;i:31;i:17272989;i:32;i:17272990;i:33;i:17272991;i:34;i:17272992;i:35;i:17272993;i:36;i:17272994;i:37;i:17272995;i:38;i:17272996;i:39;i:17272997;i:40;i:17272998;i:41;i:17272999;i:42;i:17283426;i:43;i:17283427;i:44;i:17283428;i:45;i:17283429;i:46;i:17283430;i:47;i:17283431;i:48;i:17283432;i:49;i:17283433;i:50;i:17283434;i:51;i:17283435;i:52;i:17283436;i:53;i:17283437;i:54;i:17283438;i:55;i:17283439;i:56;i:17283440;i:57;i:17283441;i:58;i:17283442;i:59;i:17283443;i:60;i:17283444;i:61;i:17283445;i:62;i:17283446;i:63;i:17525577;i:64;i:17525578;i:65;i:17525579;i:66;i:17525580;i:67;i:17525581;i:68;i:17525582;i:69;i:17525583;i:70;i:17525584;i:71;i:17525585;i:72;i:17525586;i:73;i:17525587;i:74;i:17525588;i:75;i:17525589;i:76;i:17525590;i:77;i:17525591;i:78;i:17525592;i:79;i:17525593;i:80;i:17525594;i:81;i:17525595;i:82;i:17525596;i:83;i:17525597;i:84;i:17778731;i:85;i:17778732;i:86;i:17778733;i:87;i:17778734;i:88;i:17778735;i:89;i:17778736;i:90;i:17778737;i:91;i:17778738;i:92;i:17778739;i:93;i:17778740;i:94;i:17778741;i:95;i:17778742;i:96;i:17778743;i:97;i:17778744;i:98;i:17778745;i:99;i:17778746;i:100;i:17778747;i:101;i:17778748;i:102;i:17778749;i:103;i:17778750;i:104;i:17778751;i:105;i:19699033;i:106;i:19699034;i:107;i:19699035;i:108;i:19699036;i:109;i:19699037;i:110;i:19699038;i:111;i:19699039;i:112;i:19699040;i:113;i:19699041;i:114;i:19699042;i:115;i:19699043;i:116;i:19699044;i:117;i:19699045;i:118;i:19699046;i:119;i:19699047;i:120;i:19699048;i:121;i:19699049;i:122;i:19699050;i:123;i:19699051;i:124;i:19699052;i:125;i:19699053;i:126;i:20110681;i:127;i:20110682;i:128;i:20110683;i:129;i:20110684;i:130;i:20110685;i:131;i:20110686;i:132;i:20110687;i:133;i:20110688;i:134;i:20110689;i:135;i:20110690;i:136;i:20110691;i:137;i:20110692;i:138;i:20110693;i:139;i:20110694;i:140;i:20110695;i:141;i:20110696;i:142;i:20110697;i:143;i:20110698;i:144;i:20110699;i:145;i:20110700;i:146;i:20110701;i:147;i:20355533;i:148;i:20355534;i:149;i:20355535;i:150;i:20355536;i:151;i:20355537;i:152;i:20355538;i:153;i:20355539;i:154;i:20355540;i:155;i:20355541;i:156;i:20355542;i:157;i:20355543;i:158;i:20355544;i:159;i:20355545;i:160;i:20355546;i:161;i:20355547;i:162;i:20355548;i:163;i:20355549;i:164;i:20355550;i:165;i:20355551;i:166;i:20355552;i:167;i:20355553;}"
  }
  ["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) ""
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-02-07"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-03-30"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "960000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-03-30"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 371-3509"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(28) "david@hawaiihomelistings.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(12) "David E Buck"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "24981"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3475118"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "HRCT"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "12644575"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(28) "Harcourts Island Real Estate"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 371-3509"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96717"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(9) "Kawaipuna"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "54-132"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20355533"
  }
}