54-274 Kaipapau Loop
Hauula, HI 96717

Take a Virtual Tour

Listing
Overview

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

Paradise found! Hawaii country living at its finest…huge back yard to plant fruit trees or landscape. Beach side of Kamehameha Hwy, 1 minute walk to beach access- fishing, surfing, or shell hunting. Ten-minute walk to best Koolau hiking on Oahu. Perfect, small, comfortable home in a quiet, safe neighborhood. 15 minute drive to Turtle Bay, 45 minute drive to town. 6,600 sf lot which is slightly elevated about the street. Newer roof and new electrical panel. Convenient location very close to grocery, post office, restaurants, beaches, parks, schools, and much more. Hurry and don’t miss this opportunity. Tenant is vacating the property by 5/22. First showing Sunday 5/23. Please submit offers by 5/25, reviewed 5/26.

  • Bedrooms: 3
  • Full Baths: 1
  • Land Area (sf): 6,600
  • Living (sf): 988
  • Year Built: 1957

  • Property Condition: Fair,Needs Major Repair
  • Number of Parking Spaces: 2
  • Pool: None
  • Number of Stories: One
  • View: Mountain
  • Listing Office: Island, REALTORS

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(145) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "157100.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "438600.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "595700.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(14) "Hardwood,Vinyl"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "6600.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(27) "scott.fujiwara@irhawaii.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(16) "Scott T Fujiwara"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 687-8000"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-07"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(16) "Island, REALTORS"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "650000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "988"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(38) "54-274 Kaipapau Loop, Hauula, HI 96717"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202108551"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "STFP"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(35) "1 Car,2 Car,Carport,Driveway,Street"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(23) "Fair,Needs Major Repair"
  }
  ["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) "1"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "1.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "670000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "26"
  }
  ["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) "15829695"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 687-8000"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(27) "scott.fujiwara@irhawaii.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Scott T Fujiwara"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "21741"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3474102"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "STFP"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487863"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(16) "Island, REALTORS"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 687-8000"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "650000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-07"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "6600.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-28T21:55:32.240"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15829695"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202108551"
  }
  ["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) "2021-04-07T00:18:34.710"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "625000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-5-4-012-061-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) "24"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-07T00:18:34.710"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96717"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15829695"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(392) "For fastest response, please email scott.fujiwara@irhawaii.com for any showing requests or inquiries. Please do not text. Please consider using Old Republic Title and Escrow, Main Branch, Jo Ayson. NOTE: Interior pictures were taken prior to the tenant occupying the property.  Tenant is vacating the property by 5/22.  First showing Sunday 5/23.  Please submit offers by 5/25, reviewed 5/26."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(726) "Paradise found! Hawaii country living at its finest…huge back yard to plant fruit trees or landscape. Beach side of Kamehameha Hwy, 1 minute walk to beach access- fishing, surfing, or shell hunting. Ten-minute walk to best Koolau hiking on Oahu. Perfect, small, comfortable home in a quiet, safe neighborhood. 15 minute drive to Turtle Bay, 45 minute drive to town.  6,600 sf lot which is slightly elevated about the street. Newer roof and new electrical panel. Convenient location very close to grocery, post office, restaurants, beaches, parks, schools, and much more. Hurry and don't miss this opportunity. Tenant is vacating the property by 5/22.  First showing Sunday 5/23.  Please submit offers by 5/25, reviewed 5/26."
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(3) "372"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "988"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "988"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-28T21:55:32.240"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-28"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(8) "Kaipapau"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "54-274"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.619204$-157.913564$189.69$13.33$1.00$CKdbJZv6Pt4OS3jVyIuMvA"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "3.0%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "174.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "595700.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "157100.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "438600.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/15829695/36ab5439b904252ae9748e1bc9ce009b"
  }
  ["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) "61"
  }
  ["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) "12"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1957"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "1977"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(3) "C&C"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(32) "Cash,Conventional,USDA Financing"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-5-4-012-061-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15829695"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202108551"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628923097"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1957"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "1977"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(3468) "a:210:{i:0;i:19744907;i:1;i:19744908;i:2;i:19744909;i:3;i:19744910;i:4;i:19744911;i:5;i:19744912;i:6;i:19744913;i:7;i:19744914;i:8;i:19744915;i:9;i:19744916;i:10;i:19744917;i:11;i:19744918;i:12;i:19744919;i:13;i:19744920;i:14;i:19744921;i:15;i:19744922;i:16;i:19744923;i:17;i:19744924;i:18;i:19744925;i:19;i:19744926;i:20;i:19744927;i:21;i:19750231;i:22;i:19750232;i:23;i:19750233;i:24;i:19750234;i:25;i:19750235;i:26;i:19750236;i:27;i:19750237;i:28;i:19750238;i:29;i:19750239;i:30;i:19750240;i:31;i:19750241;i:32;i:19750242;i:33;i:19750243;i:34;i:19750244;i:35;i:19750245;i:36;i:19750246;i:37;i:19750247;i:38;i:19750248;i:39;i:19750249;i:40;i:19750250;i:41;i:19750251;i:42;i:19753509;i:43;i:19753510;i:44;i:19753511;i:45;i:19753512;i:46;i:19753513;i:47;i:19753514;i:48;i:19753515;i:49;i:19753516;i:50;i:19753517;i:51;i:19753518;i:52;i:19753519;i:53;i:19753520;i:54;i:19753521;i:55;i:19753522;i:56;i:19753523;i:57;i:19753524;i:58;i:19753525;i:59;i:19753526;i:60;i:19753527;i:61;i:19753528;i:62;i:19753529;i:63;i:19753763;i:64;i:19753764;i:65;i:19753765;i:66;i:19753766;i:67;i:19753767;i:68;i:19753768;i:69;i:19753769;i:70;i:19753770;i:71;i:19753771;i:72;i:19753772;i:73;i:19753773;i:74;i:19753774;i:75;i:19753775;i:76;i:19753776;i:77;i:19753777;i:78;i:19753778;i:79;i:19753779;i:80;i:19753780;i:81;i:19753781;i:82;i:19753782;i:83;i:19753783;i:84;i:19761551;i:85;i:19761552;i:86;i:19761553;i:87;i:19761554;i:88;i:19761555;i:89;i:19761556;i:90;i:19761557;i:91;i:19761558;i:92;i:19761559;i:93;i:19761560;i:94;i:19761561;i:95;i:19761562;i:96;i:19761563;i:97;i:19761564;i:98;i:19761565;i:99;i:19761566;i:100;i:19761567;i:101;i:19761568;i:102;i:19761569;i:103;i:19761570;i:104;i:19761571;i:105;i:19773602;i:106;i:19773603;i:107;i:19773604;i:108;i:19773605;i:109;i:19773606;i:110;i:19773607;i:111;i:19773608;i:112;i:19773609;i:113;i:19773610;i:114;i:19773611;i:115;i:19773612;i:116;i:19773613;i:117;i:19773614;i:118;i:19773615;i:119;i:19773616;i:120;i:19773617;i:121;i:19773618;i:122;i:19773619;i:123;i:19773620;i:124;i:19773621;i:125;i:19773622;i:126;i:19813635;i:127;i:19813636;i:128;i:19813637;i:129;i:19813638;i:130;i:19813639;i:131;i:19813640;i:132;i:19813641;i:133;i:19813642;i:134;i:19813643;i:135;i:19813644;i:136;i:19813645;i:137;i:19813646;i:138;i:19813647;i:139;i:19813648;i:140;i:19813649;i:141;i:19813650;i:142;i:19813651;i:143;i:19813652;i:144;i:19813653;i:145;i:19813654;i:146;i:19813655;i:147;i:20053151;i:148;i:20053152;i:149;i:20053153;i:150;i:20053154;i:151;i:20053155;i:152;i:20053156;i:153;i:20053157;i:154;i:20053158;i:155;i:20053159;i:156;i:20053160;i:157;i:20053161;i:158;i:20053162;i:159;i:20053163;i:160;i:20053164;i:161;i:20053165;i:162;i:20053166;i:163;i:20053167;i:164;i:20053168;i:165;i:20053169;i:166;i:20053170;i:167;i:20053171;i:168;i:20206261;i:169;i:20206262;i:170;i:20206263;i:171;i:20206264;i:172;i:20206265;i:173;i:20206266;i:174;i:20206267;i:175;i:20206268;i:176;i:20206269;i:177;i:20206270;i:178;i:20206271;i:179;i:20206272;i:180;i:20206273;i:181;i:20206274;i:182;i:20206275;i:183;i:20206276;i:184;i:20206277;i:185;i:20206278;i:186;i:20206279;i:187;i:20206280;i:188;i:20206281;i:189;i:20301387;i:190;i:20301388;i:191;i:20301389;i:192;i:20301390;i:193;i:20301391;i:194;i:20301392;i:195;i:20301393;i:196;i:20301394;i:197;i:20301395;i:198;i:20301396;i:199;i:20301397;i:200;i:20301398;i:201;i:20301399;i:202;i:20301400;i:203;i:20301401;i:204;i:20301402;i:205;i:20301403;i:206;i:20301404;i:207;i:20301405;i:208;i:20301406;i:209;i:20301407;}"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(70) "http://cdn-mls.s3.amazonaws.com/hicentral/HICENTRAL_202108551/clip.mp4"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(70) "http://cdn-mls.s3.amazonaws.com/hicentral/HICENTRAL_202108551/clip.mp4"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96717"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-26"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-05-10T17:29:16.020"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(8) "Kaipapau"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "54-274"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Loop"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-28"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "670000.00"
  }
  ["rets_concessions"]=>
  array(1) {
    [0]=>
    string(4) "8000"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-28"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 292-6019"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(25) "jacquieInHawaii@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(17) "Jacqueline Lambka"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "50662"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "15377920"
  }
  ["rets_selling_agent_remarks"]=>
  array(1) {
    [0]=>
    string(78) "$8,000 credit to buyer for closing costs in lieu of painting exterior of home."
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "RBTS"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487717"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(17) "Realty By The Sea"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 292-6019"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20301387"
  }
}