41-887 Laumilo Street
Waimanalo, HI 96795

Listing
Overview

Price: $3,950,000
Area: WAIMANALO
Status: Sold

Hidden gem on the island, Waimanalo Beach Park, your backyard could be this very beach! Rarely available lot in this exclusive neighborhood. The house needs major repair so bring your contractor and remodel or rebuild and make it your dream home today! Public records show 5 bedrooms, property may not have permits for the studio that is built adjacent to the stone wall. It may not have 5 permitted bedrooms on the property. Buyer to do due their own due diligence. Seller purchased the property in its present condition and makes no representations on the accuracy of the number of bedrooms and whether permits were obtained.

  • Bedrooms: 5
  • Full Baths: 2
  • Half Baths: 1
  • Land Area (sf): 11,250
  • Living (sf): 2,055
  • Year Built: 1939

  • Property Condition: Needs Major Repair
  • Number of Parking Spaces: 1
  • Pool: None
  • Number of Stories: One
  • View: Coastline,Garden,Mountain,Ocean,Sunrise
  • Listing Office: Century 21 iProperties Hawaii

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(147) {
  ["address_is_formatted"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "196200.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(10) "2635000.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "2831200.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(13) "1031 Exchange"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(17) "Hardwood,Laminate"
  }
  ["formatted_address"]=>
  array(1) {
    [0]=>
    string(43) "41-887 Laumilo St, Waimanalo, HI 96795, USA"
  }
  ["formatted_address_simple"]=>
  array(1) {
    [0]=>
    string(32) "41-887 Laumilo St, Waimanalo, HI"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(17) "Ocean,Sandy Beach"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["google_place_id"]=>
  array(1) {
    [0]=>
    string(27) "ChIJu3WtQ5ETAHwR9NKZi3ZrYP4"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(3) "240"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "11250.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) "jun@ipropertieshawaii.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(17) "Junhyun K Johnson"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 791-1020"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-11-12"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(29) "Century 21 iProperties Hawaii"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "3950000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "2055"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(42) "41-887 Laumilo Street, Waimanalo, HI 96795"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202029110"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(9) "WAIMANALO"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "IPHI"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(22) "3 Car+,Driveway,Street"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(15) "45 Days or Less"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(18) "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(6) "Kailua"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "2.01"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(9) "Waimanalo"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "3950000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["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) "15554266"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 791-1020"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(25) "jun@ipropertieshawaii.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(17) "Junhyun K Johnson"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "46473"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "10284525"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "IPHI"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487616"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(29) "Century 21 iProperties Hawaii"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 791-1020"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "3950000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-11-12"
  }
  ["rets_lock_box_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "11250.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2020-12-18T17:03:50.960"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15554266"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202029110"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(9) "WAIMANALO"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-11-12T14:39:19.207"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "3950000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-4-1-005-055-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["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) "11"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-11-12T14:39:19.207"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96795"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15554266"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(111) "Contact Listor Jun Johnson (808) 777-9343. Listor must be present. Please use Brian Nakamoto at Title Guaranty."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(631) "Hidden gem on the island, Waimanalo Beach Park, your backyard could be this very beach! Rarely available lot in this exclusive neighborhood. The house needs major repair so bring your contractor and remodel or rebuild and make it your dream home today!  Public records show 5 bedrooms, property may not have permits for the studio that is built adjacent to the stone wall.  It may not have 5 permitted bedrooms on the property.  Buyer to do due their own due diligence.  Seller purchased the property in its present condition and makes no representations on the accuracy of the number of bedrooms and whether permits were obtained."
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(3) "240"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "1815"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "2055"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-12-18T17:03:50.960"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-18"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(7) "Laumilo"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "41-887"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(106) "1$21.336272$-157.697072$187.64$13.33$1.00$CAoSLEFGMVFpcE1WWGV1X0hYd2xwWXVlcnlVdEhGcGY2UW1YTW1ZUkowNjdlaFlH"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(7) "1977.30"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "2831200.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "196200.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(10) "2635000.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/15554266/a755f76ae718a3805cb1e18038a2999e"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "141"
  }
  ["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) "55"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1939"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(9) "Key,Video"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(3) "C&C"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-4-1-005-055-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(39) "Coastline,Garden,Mountain,Ocean,Sunrise"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15554266"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202029110"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628980780"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1939"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(31) "03 - R10 - Residential District"
  }
  ["latitude"]=>
  array(1) {
    [0]=>
    string(10) "21.3362057"
  }
  ["longitude"]=>
  array(1) {
    [0]=>
    string(12) "-157.6969936"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1229) "a:77:{i:0;i:17012400;i:1;i:17012401;i:2;i:17012402;i:3;i:17012403;i:4;i:17012404;i:5;i:17012405;i:6;i:17012406;i:7;i:17012407;i:8;i:17012408;i:9;i:17012409;i:10;i:17012410;i:11;i:17054172;i:12;i:17054173;i:13;i:17054174;i:14;i:17054175;i:15;i:17054176;i:16;i:17054177;i:17;i:17054178;i:18;i:17054179;i:19;i:17054180;i:20;i:17054181;i:21;i:17054182;i:22;i:17080619;i:23;i:17080620;i:24;i:17080621;i:25;i:17080622;i:26;i:17080623;i:27;i:17080624;i:28;i:17080625;i:29;i:17080626;i:30;i:17080627;i:31;i:17080628;i:32;i:17080629;i:33;i:17236772;i:34;i:17236773;i:35;i:17236774;i:36;i:17236775;i:37;i:17236776;i:38;i:17236777;i:39;i:17236778;i:40;i:17236779;i:41;i:17236780;i:42;i:17236781;i:43;i:17236782;i:44;i:17545386;i:45;i:17545387;i:46;i:17545388;i:47;i:17545389;i:48;i:17545390;i:49;i:17545391;i:50;i:17545392;i:51;i:17545393;i:52;i:17545394;i:53;i:17545395;i:54;i:17545396;i:55;i:20131426;i:56;i:20131427;i:57;i:20131428;i:58;i:20131429;i:59;i:20131430;i:60;i:20131431;i:61;i:20131432;i:62;i:20131433;i:63;i:20131434;i:64;i:20131435;i:65;i:20131436;i:66;i:20374675;i:67;i:20374676;i:68;i:20374677;i:69;i:20374678;i:70;i:20374679;i:71;i:20374680;i:72;i:20374681;i:73;i:20374682;i:74;i:20374683;i:75;i:20374684;i:76;i:20374685;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-11-16"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-18"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "3950000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-18"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 394-9223"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "Melanie@MelanieLong.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(12) "Melanie Long"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "24531"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3474902"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "PINT"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486939"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(28) "Pacific International Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 394-9223"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(9) "Waimanalo"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96795"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(7) "Laumilo"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "41-887"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20374675"
  }
}