94-542 Lumiauau Street Unit H102
Waipahu, HI 96797

Listing
Overview

Price: $599,999
Area: WAIKELE
Status: Sold

Rarely available unit in the peaceful community of Highlands at Waikele! This charming and highly desired 2 bedroom, 2 bathroom ground floor unit offers ample natural light and mountain views. This lovingly cared for home has vinyl plank flooring, in-unit laundry, bar seating in the living room, window-ac and abundant storage space. The primary bedroom is quite spacious with an en-suite bathroom and linen closet. Enjoy your very own private yard with a covered lanai, perfect for indoor/outdoor entertaining. 2 assigned parking stalls (one covered, one uncovered) and plenty of guest parking available. The sale also includes outdoor storage container. Dog park is about 250 feet from your doorstep. Just minutes from Waikele Premium Outlets and Waikele Center with restaurants, shopping, and Waikele golf course! Easy access to H1 and Kunia Road make this location ideal for commuters.

Listing by: Seaside Realty LLC

array(179) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "156300.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "326800.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "483100.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(20) "Highlands at Waikele"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(26) "Low-Rise 6 or Less Stories"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(21) "Pets Allowed (Verify)"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Waikele"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(18) "Ceramic Tile,Vinyl"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(7) "100,000"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(3) "150"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "424057.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(12) "Dual Systems"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "ericainhawaii@gmail.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(16) "Erica J Lehmkuhl"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 723-0953"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-06-21"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(18) "Seaside Realty LLC"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "599999.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "941"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(51) "94-542 Lumiauau Street Unit H102, Waipahu, HI 96797"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "494.00"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202211119"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["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) "SSRE"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(33) "Covered - 1,Guest,Open - 1,Street"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "Negotiable"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(15) "condo_townhouse"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(15) "Condo Townhouse"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "494"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "2.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_building_name"]=>
  array(1) {
    [0]=>
    string(20) "Highlands at Waikele"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_compensation_method"]=>
  array(1) {
    [0]=>
    string(2) "4%"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(7) "70, 100"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "605000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Waikele"
  }
  ["rets_floor_number"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["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) "Waipahu"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16697212"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_internet_automated_valuation_dis"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_internet_consumer_comment_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 723-0953"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "ericainhawaii@gmail.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Erica J Lehmkuhl"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "47564"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "11074635"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "SSRE"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "16118386"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(18) "Seaside Realty LLC"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 723-0953"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "599999.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-06-21"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "424057.00"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "494.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(9) "Hawaiiana"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 593-9100"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2022-07-29T12:28:39.650"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16697212"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202211119"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2022-06-21T08:36:21.657"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "599999.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "68"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-007-074-0050"
  }
  ["rets_parking_additional"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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) "2022-06-21T08:38:49.590"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2022-06-21T08:36:21.657"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16697212"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(330) "PLEASE SEND OFFERS TO SeasideOffers@gmail.com; Vacant and easy to show! Please ShowingTime for showing requests. Please consider Kalia Goulette at Fidelity National Title, 808-724-0466, kalia.goulette@fnf.com for escrow. Please include "as-is" addendum and STR disclosure. This unit is NOT zoned or approved for short term rental."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(890) "Rarely available unit in the peaceful community of Highlands at Waikele! This charming and highly desired 2 bedroom, 2 bathroom ground floor unit offers ample natural light and mountain views. This lovingly cared for home has vinyl plank flooring, in-unit laundry, bar seating in the living room, window-ac and abundant storage space. The primary bedroom is quite spacious with an en-suite bathroom and linen closet. Enjoy your very own private yard with a covered lanai, perfect for indoor/outdoor entertaining. 2 assigned parking stalls (one covered, one uncovered) and plenty of guest parking available. The sale also includes outdoor storage container. Dog park is about 250 feet from your doorstep. Just minutes from Waikele Premium Outlets and Waikele Center with restaurants, shopping, and Waikele golf course! Easy access to H1 and Kunia Road make this location ideal for commuters."
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(3) "150"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "791"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "941"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2022-07-29T12:28:39.650"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-07-29"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(8) "Lumiauau"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "94-542"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.407413$-158.009409$241.81$13.33$1.00$_r-MAzbjloSuBLSkGqvclA"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "104.00"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "1248.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "483100.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "156300.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "326800.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(7) "100,000"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16697212/0660c7a19b4caeaa849680ab3680e646"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "194"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(2) "50"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "74"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(1) "7"
  }
  ["rets_unit_number"]=>
  array(1) {
    [0]=>
    string(4) "H102"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1994"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(3) "Key"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(8) "Lumiauau"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "94-542"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(33) "Cash,Conventional,Exchange,FHA,VA"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-007-074-0050"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(90) "Bedroom on 1st Level,Even# Unit,Full Bath on 1st Floor,Ground Floor Unit,Single Level,Yard"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(4) "H102"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16697212"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202211119"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1659133777"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1994"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(3468) "a:210:{i:0;i:22495487;i:1;i:22495488;i:2;i:22495489;i:3;i:22495490;i:4;i:22495491;i:5;i:22495492;i:6;i:22495493;i:7;i:22495494;i:8;i:22495495;i:9;i:22495496;i:10;i:22495497;i:11;i:22495498;i:12;i:22495499;i:13;i:22495500;i:14;i:22495501;i:15;i:22495502;i:16;i:22495503;i:17;i:22495504;i:18;i:22495505;i:19;i:22495506;i:20;i:22495507;i:21;i:22495529;i:22;i:22495530;i:23;i:22495531;i:24;i:22495532;i:25;i:22495533;i:26;i:22495534;i:27;i:22495535;i:28;i:22495536;i:29;i:22495537;i:30;i:22495538;i:31;i:22495539;i:32;i:22495540;i:33;i:22495541;i:34;i:22495542;i:35;i:22495543;i:36;i:22495544;i:37;i:22495545;i:38;i:22495546;i:39;i:22495547;i:40;i:22495548;i:41;i:22495549;i:42;i:22516895;i:43;i:22516896;i:44;i:22516897;i:45;i:22516898;i:46;i:22516899;i:47;i:22516900;i:48;i:22516901;i:49;i:22516902;i:50;i:22516903;i:51;i:22516904;i:52;i:22516905;i:53;i:22516906;i:54;i:22516907;i:55;i:22516908;i:56;i:22516909;i:57;i:22516910;i:58;i:22516911;i:59;i:22516912;i:60;i:22516913;i:61;i:22516914;i:62;i:22516915;i:63;i:22516978;i:64;i:22516979;i:65;i:22516980;i:66;i:22516981;i:67;i:22516982;i:68;i:22516983;i:69;i:22516984;i:70;i:22516985;i:71;i:22516986;i:72;i:22516987;i:73;i:22516988;i:74;i:22516989;i:75;i:22516990;i:76;i:22516991;i:77;i:22516992;i:78;i:22516993;i:79;i:22516994;i:80;i:22516995;i:81;i:22516996;i:82;i:22516997;i:83;i:22516998;i:84;i:22539735;i:85;i:22539736;i:86;i:22539737;i:87;i:22539738;i:88;i:22539739;i:89;i:22539740;i:90;i:22539741;i:91;i:22539742;i:92;i:22539743;i:93;i:22539744;i:94;i:22539745;i:95;i:22539746;i:96;i:22539747;i:97;i:22539748;i:98;i:22539749;i:99;i:22539750;i:100;i:22539751;i:101;i:22539752;i:102;i:22539753;i:103;i:22539754;i:104;i:22539755;i:105;i:22539781;i:106;i:22539782;i:107;i:22539783;i:108;i:22539784;i:109;i:22539785;i:110;i:22539786;i:111;i:22539787;i:112;i:22539788;i:113;i:22539789;i:114;i:22539790;i:115;i:22539791;i:116;i:22539792;i:117;i:22539793;i:118;i:22539794;i:119;i:22539795;i:120;i:22539796;i:121;i:22539797;i:122;i:22539798;i:123;i:22539799;i:124;i:22539800;i:125;i:22539801;i:126;i:22541784;i:127;i:22541785;i:128;i:22541786;i:129;i:22541787;i:130;i:22541788;i:131;i:22541789;i:132;i:22541790;i:133;i:22541791;i:134;i:22541792;i:135;i:22541793;i:136;i:22541794;i:137;i:22541795;i:138;i:22541796;i:139;i:22541797;i:140;i:22541798;i:141;i:22541799;i:142;i:22541800;i:143;i:22541801;i:144;i:22541802;i:145;i:22541803;i:146;i:22541804;i:147;i:22544144;i:148;i:22544145;i:149;i:22544146;i:150;i:22544147;i:151;i:22544148;i:152;i:22544149;i:153;i:22544150;i:154;i:22544151;i:155;i:22544152;i:156;i:22544153;i:157;i:22544154;i:158;i:22544155;i:159;i:22544156;i:160;i:22544157;i:161;i:22544158;i:162;i:22544159;i:163;i:22544160;i:164;i:22544161;i:165;i:22544162;i:166;i:22544163;i:167;i:22544164;i:168;i:22573937;i:169;i:22573938;i:170;i:22573939;i:171;i:22573940;i:172;i:22573941;i:173;i:22573942;i:174;i:22573943;i:175;i:22573944;i:176;i:22573945;i:177;i:22573946;i:178;i:22573947;i:179;i:22573948;i:180;i:22573949;i:181;i:22573950;i:182;i:22573951;i:183;i:22573952;i:184;i:22573953;i:185;i:22573954;i:186;i:22573955;i:187;i:22573956;i:188;i:22573957;i:189;i:22885813;i:190;i:22885814;i:191;i:22885815;i:192;i:22885816;i:193;i:22885817;i:194;i:22885818;i:195;i:22885819;i:196;i:22885820;i:197;i:22885821;i:198;i:22885822;i:199;i:22885823;i:200;i:22885824;i:201;i:22885825;i:202;i:22885826;i:203;i:22885827;i:204;i:22885828;i:205;i:22885829;i:206;i:22885830;i:207;i:22885831;i:208;i:22885832;i:209;i:22885833;}"
  }
  ["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_supplement_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_supplement_modification_timestam"]=>
  array(1) {
    [0]=>
    string(23) "2022-06-25T12:13:22.710"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-06-27"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-07-29"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "605000.00"
  }
  ["rets_co_selling_agent_direct_work_pho"]=>
  array(1) {
    [0]=>
    string(14) "(808) 382-6871"
  }
  ["rets_co_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(20) "nmanzano77@gmail.com"
  }
  ["rets_co_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(17) "Noradel B Manzano"
  }
  ["rets_co_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "52292"
  }
  ["rets_co_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "16612338"
  }
  ["rets_co_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "FIVE"
  }
  ["rets_co_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486552"
  }
  ["rets_co_selling_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Five Star Realty, Inc."
  }
  ["rets_co_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 382-6871"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-11-30"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-07-29"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 382-6871"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(19) "ruthiem87@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(19) "Ruth Manzano Javier"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "43542"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3483670"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "FIVE"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486552"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Five Star Realty, Inc."
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 382-6871"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "22885813"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 156300.00
        )

    [assd_val_land] => Array
        (
            [0] => 326800.00
        )

    [assd_val_total] => Array
        (
            [0] => 483100.00
        )

    [bedrooms] => Array
        (
            [0] => 2
        )

    [building_name] => Array
        (
            [0] => Highlands at Waikele
        )

    [building_style] => Array
        (
            [0] => Low-Rise 6 or Less Stories
        )

    [city] => Array
        (
            [0] => Waipahu
        )

    [county] => Array
        (
            [0] => Oahu
        )

    [disclosures] => Array
        (
            [0] => Pets Allowed (Verify)
        )

    [elementary_school] => Array
        (
            [0] => Waikele
        )

    [floor_covering] => Array
        (
            [0] => Ceramic Tile,Vinyl
        )

    [frontage] => Array
        (
            [0] => Other
        )

    [full_baths] => Array
        (
            [0] => 2
        )

    [furnished] => Array
        (
            [0] => None
        )

    [half_baths] => Array
        (
            [0] => 0
        )

    [high_school] => Array
        (
            [0] => Waipahu
        )

    [home_exampt] => Array
        (
            [0] => 100,000
        )

    [lanai_sf] => Array
        (
            [0] => 150
        )

    [land_area_sf] => Array
        (
            [0] => 424057.00
        )

    [land_recorded] => Array
        (
            [0] => Dual Systems
        )

    [land_tenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [list_agent_email] => Array
        (
            [0] => ericainhawaii@gmail.com
        )

    [list_agent_name] => Array
        (
            [0] => Erica J Lehmkuhl
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 723-0953
        )

    [list_date] => Array
        (
            [0] => 2022-06-21
        )

    [list_office_name] => Array
        (
            [0] => Seaside Realty LLC
        )

    [list_price] => Array
        (
            [0] => 599999.00
        )

    [living_sf] => Array
        (
            [0] => 941
        )

    [location] => Array
        (
            [0] => 94-542 Lumiauau Street Unit H102, Waipahu, HI 96797
        )

    [maintenance_fees] => Array
        (
            [0] => 494.00
        )

    [middle_school] => Array
        (
            [0] => Waipahu
        )

    [mls_] => Array
        (
            [0] => 202211119
        )

    [neighborhood] => Array
        (
            [0] => WAIKELE
        )

    [number_of_parking_spaces] => Array
        (
            [0] => 2
        )

    [number_of_stories] => Array
        (
            [0] => One
        )

    [office_mls_id] => Array
        (
            [0] => SSRE
        )

    [parking_features] => Array
        (
            [0] => Covered - 1,Guest,Open - 1,Street
        )

    [possession] => Array
        (
            [0] => Negotiable
        )

    [postal_code] => Array
        (
            [0] => 96797
        )

    [property_condition] => Array
        (
            [0] => Above Average
        )

    [property_type] => Array
        (
            [0] => condo_townhouse
        )

    [property_type_label] => Array
        (
            [0] => Condo Townhouse
        )

    [region] => Array
        (
            [0] => Waipahu
        )

    [rets_association_fee_total] => Array
        (
            [0] => 494
        )

    [rets_baths_full] => Array
        (
            [0] => 2
        )

    [rets_baths_half] => Array
        (
            [0] => 0
        )

    [rets_baths_total] => Array
        (
            [0] => 2.00
        )

    [rets_beds_total] => Array
        (
            [0] => 2
        )

    [rets_building_name] => Array
        (
            [0] => Highlands at Waikele
        )

    [rets_city] => Array
        (
            [0] => Waipahu
        )

    [rets_compensation_method] => Array
        (
            [0] => 4%
        )

    [rets_condo_parking_unit] => Array
        (
            [0] => 70, 100
        )

    [rets_current_price] => Array
        (
            [0] => 605000.00
        )

    [rets_dom] => Array
        (
            [0] => 8
        )

    [rets_dual_variable_compensation_yn] => Array
        (
            [0] => 1
        )

    [rets_elementary_school] => Array
        (
            [0] => Waikele
        )

    [rets_floor_number] => Array
        (
            [0] => 1
        )

    [rets_foreclosure_yn] => Array
        (
            [0] => 0
        )

    [rets_fractional_ownership_yn] => Array
        (
            [0] => 0
        )

    [rets_high_school] => Array
        (
            [0] => Waipahu
        )

    [rets_id] => Array
        (
            [0] => 16697212
        )

    [rets_immoviewer_yn] => Array
        (
            [0] => 0
        )

    [rets_internet_automated_valuation_dis] => Array
        (
            [0] => 0
        )

    [rets_internet_consumer_comment_yn] => Array
        (
            [0] => 0
        )

    [rets_list_agent_direct_work_phone] => Array
        (
            [0] => (808) 723-0953
        )

    [rets_list_agent_email] => Array
        (
            [0] => ericainhawaii@gmail.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Erica J Lehmkuhl
        )

    [rets_list_agent_mlsid] => Array
        (
            [0] => 47564
        )

    [rets_list_agent_mui] => Array
        (
            [0] => 11074635
        )

    [rets_list_office_mlsid] => Array
        (
            [0] => SSRE
        )

    [rets_list_office_mui] => Array
        (
            [0] => 16118386
        )

    [rets_list_office_name] => Array
        (
            [0] => Seaside Realty LLC
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 723-0953
        )

    [rets_list_price] => Array
        (
            [0] => 599999.00
        )

    [rets_listing_contract_date] => Array
        (
            [0] => 2022-06-21
        )

    [rets_lot_size_area] => Array
        (
            [0] => 424057.00
        )

    [rets_maintenance_expense] => Array
        (
            [0] => 494.00
        )

    [rets_management_company_name] => Array
        (
            [0] => Hawaiiana
        )

    [rets_management_company_phone] => Array
        (
            [0] => (808) 593-9100
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2022-07-29T12:28:39.650
        )

    [rets_matrix_unique_id] => Array
        (
            [0] => 16697212
        )

    [rets_middle_or_junior_school] => Array
        (
            [0] => Waipahu
        )

    [rets_mls_number] => Array
        (
            [0] => 202211119
        )

    [rets_neighbourhood] => Array
        (
            [0] => WAIKELE
        )

    [rets_new_development_construction_yn] => Array
        (
            [0] => 0
        )

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2022-06-21T08:36:21.657
        )

    [rets_original_list_price] => Array
        (
            [0] => 599999.00
        )

    [rets_owner_occupancy_percentage] => Array
        (
            [0] => 68
        )

    [rets_parcel_number] => Array
        (
            [0] => 1-9-4-007-074-0050
        )

    [rets_parking_additional] => Array
        (
            [0] => 0
        )

    [rets_parking_total] => Array
        (
            [0] => 2
        )

    [rets_permit_address_internet_yn] => Array
        (
            [0] => 1
        )

    [rets_permit_internet_yn] => Array
        (
            [0] => 1
        )

    [rets_photo_count] => Array
        (
            [0] => 24
        )

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2022-06-21T08:38:49.590
        )

    [rets_postal_code] => Array
        (
            [0] => 96797
        )

    [rets_price_change_timestamp] => Array
        (
            [0] => 2022-06-21T08:36:21.657
        )

    [rets_primary_key] => Array
        (
            [0] => 16697212
        )

    [rets_private_remarks] => Array
        (
            [0] => PLEASE SEND OFFERS TO SeasideOffers@gmail.com; Vacant and easy to show! Please ShowingTime for showing requests. Please consider Kalia Goulette at Fidelity National Title, 808-724-0466, kalia.goulette@fnf.com for escrow. Please include "as-is" addendum and STR disclosure. This unit is NOT zoned or approved for short term rental.
        )

    [rets_public_remarks] => Array
        (
            [0] => Rarely available unit in the peaceful community of Highlands at Waikele! This charming and highly desired 2 bedroom, 2 bathroom ground floor unit offers ample natural light and mountain views. This lovingly cared for home has vinyl plank flooring, in-unit laundry, bar seating in the living room, window-ac and abundant storage space. The primary bedroom is quite spacious with an en-suite bathroom and linen closet. Enjoy your very own private yard with a covered lanai, perfect for indoor/outdoor entertaining. 2 assigned parking stalls (one covered, one uncovered) and plenty of guest parking available. The sale also includes outdoor storage container. Dog park is about 250 feet from your doorstep. Just minutes from Waikele Premium Outlets and Waikele Center with restaurants, shopping, and Waikele golf course! Easy access to H1 and Kunia Road make this location ideal for commuters.
        )

    [rets_room_count] => Array
        (
            [0] => 0
        )

    [rets_sqft_garage_carport] => Array
        (
            [0] => 0
        )

    [rets_sqft_lanai_open] => Array
        (
            [0] => 150
        )

    [rets_sqft_roofed_living] => Array
        (
            [0] => 791
        )

    [rets_sqft_total] => Array
        (
            [0] => 941
        )

    [rets_state_or_province] => Array
        (
            [0] => HI
        )

    [rets_status_change_timestamp] => Array
        (
            [0] => 2022-07-29T12:28:39.650
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2022-07-29
        )

    [rets_street_name] => Array
        (
            [0] => Lumiauau
        )

    [rets_street_number] => Array
        (
            [0] => 94-542
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.407413$-158.009409$241.81$13.33$1.00$_r-MAzbjloSuBLSkGqvclA
        )

    [rets_sub_agency_compensation] => Array
        (
            [0] => 2.5%
        )

    [rets_tax_amount] => Array
        (
            [0] => 104.00
        )

    [rets_tax_annual_amount] => Array
        (
            [0] => 1248.00
        )

    [rets_tax_assessed_value] => Array
        (
            [0] => 483100.00
        )

    [rets_tax_assessed_value_improvements] => Array
        (
            [0] => 156300.00
        )

    [rets_tax_assessed_value_land] => Array
        (
            [0] => 326800.00
        )

    [rets_tax_excemption_owner_occupancy] => Array
        (
            [0] => 100,000
        )

    [rets_tax_paid_by_seller_yn] => Array
        (
            [0] => 0
        )

    [rets_tax_year] => Array
        (
            [0] => 2021
        )

    [rets_thumbnail_url] => Array
        (
            [0] => https://cdn.rets.ci/marcusrealty-images/16697212/0660c7a19b4caeaa849680ab3680e646
        )

    [rets_tmk_area] => Array
        (
            [0] => 194
        )

    [rets_tmk_condo_property_regime_number] => Array
        (
            [0] => 50
        )

    [rets_tmk_division] => Array
        (
            [0] => 1
        )

    [rets_tmk_parcel] => Array
        (
            [0] => 74
        )

    [rets_tmk_section] => Array
        (
            [0] => 4
        )

    [rets_tmk_zone] => Array
        (
            [0] => 9
        )

    [rets_tmkplat] => Array
        (
            [0] => 7
        )

    [rets_unit_number] => Array
        (
            [0] => H102
        )

    [rets_year_built] => Array
        (
            [0] => 1994
        )

    [rets_year_remodeled] => Array
        (
            [0] => 2021
        )

    [security] => Array
        (
            [0] => Key
        )

    [state_or_province] => Array
        (
            [0] => HI
        )

    [status] => Array
        (
            [0] => Sold
        )

    [street_name] => Array
        (
            [0] => Lumiauau
        )

    [street_number] => Array
        (
            [0] => 94-542
        )

    [street_suffix] => Array
        (
            [0] => Street
        )

    [terms_accept] => Array
        (
            [0] => Cash,Conventional,Exchange,FHA,VA
        )

    [tmk] => Array
        (
            [0] => 1-9-4-007-074-0050
        )

    [unit] => Array
        (
            [0] => Bedroom on 1st Level,Even# Unit,Full Bath on 1st Floor,Ground Floor Unit,Single Level,Yard
        )

    [unit_number] => Array
        (
            [0] => H102
        )

    [view] => Array
        (
            [0] => Mountain
        )

    [wpp::rets_pk] => Array
        (
            [0] => 16697212
        )

    [wpp_gpid] => Array
        (
            [0] => 202211119
        )

    [wpp_import_schedule_id] => Array
        (
            [0] => 1463343682
        )

    [wpp_import_time] => Array
        (
            [0] => 1659133777
        )

    [year_built] => Array
        (
            [0] => 1994
        )

    [year_remodeled_] => Array
        (
            [0] => 2021
        )

    [zoning] => Array
        (
            [0] => 05 - R-5 Residential District
        )

    [new_attached_media] => Array
        (
            [0] => a:210:{i:0;i:22495487;i:1;i:22495488;i:2;i:22495489;i:3;i:22495490;i:4;i:22495491;i:5;i:22495492;i:6;i:22495493;i:7;i:22495494;i:8;i:22495495;i:9;i:22495496;i:10;i:22495497;i:11;i:22495498;i:12;i:22495499;i:13;i:22495500;i:14;i:22495501;i:15;i:22495502;i:16;i:22495503;i:17;i:22495504;i:18;i:22495505;i:19;i:22495506;i:20;i:22495507;i:21;i:22495529;i:22;i:22495530;i:23;i:22495531;i:24;i:22495532;i:25;i:22495533;i:26;i:22495534;i:27;i:22495535;i:28;i:22495536;i:29;i:22495537;i:30;i:22495538;i:31;i:22495539;i:32;i:22495540;i:33;i:22495541;i:34;i:22495542;i:35;i:22495543;i:36;i:22495544;i:37;i:22495545;i:38;i:22495546;i:39;i:22495547;i:40;i:22495548;i:41;i:22495549;i:42;i:22516895;i:43;i:22516896;i:44;i:22516897;i:45;i:22516898;i:46;i:22516899;i:47;i:22516900;i:48;i:22516901;i:49;i:22516902;i:50;i:22516903;i:51;i:22516904;i:52;i:22516905;i:53;i:22516906;i:54;i:22516907;i:55;i:22516908;i:56;i:22516909;i:57;i:22516910;i:58;i:22516911;i:59;i:22516912;i:60;i:22516913;i:61;i:22516914;i:62;i:22516915;i:63;i:22516978;i:64;i:22516979;i:65;i:22516980;i:66;i:22516981;i:67;i:22516982;i:68;i:22516983;i:69;i:22516984;i:70;i:22516985;i:71;i:22516986;i:72;i:22516987;i:73;i:22516988;i:74;i:22516989;i:75;i:22516990;i:76;i:22516991;i:77;i:22516992;i:78;i:22516993;i:79;i:22516994;i:80;i:22516995;i:81;i:22516996;i:82;i:22516997;i:83;i:22516998;i:84;i:22539735;i:85;i:22539736;i:86;i:22539737;i:87;i:22539738;i:88;i:22539739;i:89;i:22539740;i:90;i:22539741;i:91;i:22539742;i:92;i:22539743;i:93;i:22539744;i:94;i:22539745;i:95;i:22539746;i:96;i:22539747;i:97;i:22539748;i:98;i:22539749;i:99;i:22539750;i:100;i:22539751;i:101;i:22539752;i:102;i:22539753;i:103;i:22539754;i:104;i:22539755;i:105;i:22539781;i:106;i:22539782;i:107;i:22539783;i:108;i:22539784;i:109;i:22539785;i:110;i:22539786;i:111;i:22539787;i:112;i:22539788;i:113;i:22539789;i:114;i:22539790;i:115;i:22539791;i:116;i:22539792;i:117;i:22539793;i:118;i:22539794;i:119;i:22539795;i:120;i:22539796;i:121;i:22539797;i:122;i:22539798;i:123;i:22539799;i:124;i:22539800;i:125;i:22539801;i:126;i:22541784;i:127;i:22541785;i:128;i:22541786;i:129;i:22541787;i:130;i:22541788;i:131;i:22541789;i:132;i:22541790;i:133;i:22541791;i:134;i:22541792;i:135;i:22541793;i:136;i:22541794;i:137;i:22541795;i:138;i:22541796;i:139;i:22541797;i:140;i:22541798;i:141;i:22541799;i:142;i:22541800;i:143;i:22541801;i:144;i:22541802;i:145;i:22541803;i:146;i:22541804;i:147;i:22544144;i:148;i:22544145;i:149;i:22544146;i:150;i:22544147;i:151;i:22544148;i:152;i:22544149;i:153;i:22544150;i:154;i:22544151;i:155;i:22544152;i:156;i:22544153;i:157;i:22544154;i:158;i:22544155;i:159;i:22544156;i:160;i:22544157;i:161;i:22544158;i:162;i:22544159;i:163;i:22544160;i:164;i:22544161;i:165;i:22544162;i:166;i:22544163;i:167;i:22544164;i:168;i:22573937;i:169;i:22573938;i:170;i:22573939;i:171;i:22573940;i:172;i:22573941;i:173;i:22573942;i:174;i:22573943;i:175;i:22573944;i:176;i:22573945;i:177;i:22573946;i:178;i:22573947;i:179;i:22573948;i:180;i:22573949;i:181;i:22573950;i:182;i:22573951;i:183;i:22573952;i:184;i:22573953;i:185;i:22573954;i:186;i:22573955;i:187;i:22573956;i:188;i:22573957;i:189;i:22885813;i:190;i:22885814;i:191;i:22885815;i:192;i:22885816;i:193;i:22885817;i:194;i:22885818;i:195;i:22885819;i:196;i:22885820;i:197;i:22885821;i:198;i:22885822;i:199;i:22885823;i:200;i:22885824;i:201;i:22885825;i:202;i:22885826;i:203;i:22885827;i:204;i:22885828;i:205;i:22885829;i:206;i:22885830;i:207;i:22885831;i:208;i:22885832;i:209;i:22885833;}
        )

    [rets_open_house_count] => Array
        (
            [0] => 1
        )

    [rets_active_open_house_count] => Array
        (
            [0] => 0
        )

    [rets_open_house_upcoming] => Array
        (
            [0] => 
        )

    [rets_supplement_count] => Array
        (
            [0] => 0
        )

    [rets_supplement_modification_timestam] => Array
        (
            [0] => 2022-06-25T12:13:22.710
        )

    [rets_active_continue_to_show_date] => Array
        (
            [0] => 2022-06-27
        )

    [rets_close_date] => Array
        (
            [0] => 2022-07-29
        )

    [rets_close_price] => Array
        (
            [0] => 605000.00
        )

    [rets_co_selling_agent_direct_work_pho] => Array
        (
            [0] => (808) 382-6871
        )

    [rets_co_selling_agent_email] => Array
        (
            [0] => nmanzano77@gmail.com
        )

    [rets_co_selling_agent_full_name] => Array
        (
            [0] => Noradel B Manzano
        )

    [rets_co_selling_agent_mlsid] => Array
        (
            [0] => 52292
        )

    [rets_co_selling_agent_mui] => Array
        (
            [0] => 16612338
        )

    [rets_co_selling_office_mlsid] => Array
        (
            [0] => FIVE
        )

    [rets_co_selling_office_mui] => Array
        (
            [0] => 3486552
        )

    [rets_co_selling_office_name] => Array
        (
            [0] => Five Star Realty, Inc.
        )

    [rets_co_selling_office_phone] => Array
        (
            [0] => (808) 382-6871
        )

    [rets_expiration_date] => Array
        (
            [0] => 2022-11-30
        )

    [rets_off_market_date] => Array
        (
            [0] => 2022-07-29
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 382-6871
        )

    [rets_selling_agent_email] => Array
        (
            [0] => ruthiem87@gmail.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Ruth Manzano Javier
        )

    [rets_selling_agent_mlsid] => Array
        (
            [0] => 43542
        )

    [rets_selling_agent_mui] => Array
        (
            [0] => 3483670
        )

    [rets_selling_office_mlsid] => Array
        (
            [0] => FIVE
        )

    [rets_selling_office_mui] => Array
        (
            [0] => 3486552
        )

    [rets_selling_office_name] => Array
        (
            [0] => Five Star Realty, Inc.
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 382-6871
        )

    [_thumbnail_id] => Array
        (
            [0] => 22885813
        )

)

  • Bedrooms: 2
  • Full Baths: 2
  • Land Area (sf): 424,057
  • Living (sf): 941
  • Year Built: 1994
  • Building Name: Highlands at Waikele

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • Number of Stories: One
  • View: Mountain
  • Listing Office: Seaside Realty LLC

  • Maintenance Fees: $494
  • Land Tenure: FS - Fee Simple

  • Elementary School: Waikele
  • Middle School: Waipahu
  • High School: Waipahu

CONTACT US

Marcus Realty

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