94-614 Lumiaina Street Unit P202
Waipahu, HI 96797

Listing
Overview

Price: $469,000
Area: WAIKELE
Status: Sold

Welcome home to your newly upgraded 2 bedroom, 2 bath, 2 parking sanctuary in Parkglen at Waikele!! Just renovated with all new kitchen appliances, cabinets, flooring, quartz countertops, and fixtures! Sink your feet into the soft new wall to wall carpet and let the cool tradewinds refresh this beautiful space. Renovated bathrooms with new cabinets, flooring, and resurfaced tubs. This is a pet friendly community with lots of open space quietly placed away from the main street in the back of the community next to an open grassy field by the gulch. Lots of nearby parks and conveniences such as Waikele Community Park, Patsy Mink Park, Waikele Premium Outlets, Safeway, UFC Gym, Lowes, dining and more.

  • Bedrooms: 2
  • Full Baths: 2
  • Land Area (sf): 770,184
  • Living (sf): 922
  • Year Built: 1993
  • Building Name: Parkglen At Waikele

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • Number of Stories: One
  • View: Garden
  • Listing Office: AMG Realty Inc

  • Maintenance Fees: $530
  • Association Fees: $50
  • 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

array(164) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(8) "96600.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "340200.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "436800.00"
  }
  ["assn_fee_inclusions"]=>
  array(1) {
    [0]=>
    string(2) "50"
  }
  ["association_fees"]=>
  array(1) {
    [0]=>
    string(2) "50"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(19) "Parkglen At Waikele"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(7) "Walk-Up"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Waikele"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(16) "Vinyl,W/W Carpet"
  }
  ["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(4) "none"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(2) "92"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "770184.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(22) "dsherman@amghawaii.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(16) "Daniel T Sherman"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 545-8187"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-23"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(14) "AMG Realty Inc"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "469000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "922"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(51) "94-614 Lumiaina Street Unit P202, Waipahu, HI 96797"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "529.90"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202109767"
  }
  ["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) "ENDO"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(8) "Assigned"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(15) "45 Days or Less"
  }
  ["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_community_name"]=>
  array(1) {
    [0]=>
    string(7) "Waikele"
  }
  ["rets_association_fee"]=>
  array(1) {
    [0]=>
    string(2) "50"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "580"
  }
  ["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(19) "Parkglen At Waikele"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(7) "136,141"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "509000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Waikele"
  }
  ["rets_floor_number"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["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) "15864335"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 545-8187"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(22) "dsherman@amghawaii.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Daniel T Sherman"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "46915"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "10678212"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "ENDO"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487516"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(14) "AMG Realty Inc"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 545-8187"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "469000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-23"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "770184.00"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "529.90"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(19) "Hawaiian Properties"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-539-9777"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-03T22:26:25.243"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15864335"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202109767"
  }
  ["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) "2021-04-23T16:15:31.503"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "469000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "59"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-007-032-0122"
  }
  ["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) "21"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-23T16:15:31.503"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15864335"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(271) "Listor will be showing on 4/24/2021 from 9:00 AM - 11:00 AM and host Open House on 4/25/2021 2:00 PM - 5:00 PM.  Please submit offers by 5:00 PM on 4/27/2021.  Offers will be reviewed on Wednesday 4/28/2021.

Please use Nicole Yasuda and Kapiolani First American Title."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(711) "Welcome home to your newly upgraded 2 bedroom, 2 bath, 2 parking sanctuary in Parkglen at Waikele!!  Just renovated with all new kitchen appliances, cabinets, flooring, quartz countertops, and fixtures!  Sink your feet into the soft new wall to wall carpet and let the cool tradewinds refresh this beautiful space.  Renovated bathrooms with new cabinets, flooring, and resurfaced tubs.  This is a pet friendly community with lots of open space quietly placed away from the main street in the back of the community next to an open grassy field by the gulch.  Lots of nearby parks and conveniences such as Waikele Community Park, Patsy Mink Park, Waikele Premium Outlets, Safeway, UFC Gym, Lowes, dining and more."
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(2) "92"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "830"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "922"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-03T22:26:25.243"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-03"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(8) "Lumiaina"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "94-614"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.398095$-158.012827$342.46$13.33$1.00$i6UhqHRextnSdHpgpSBtIw"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "123.96"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "436800.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(8) "96600.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "340200.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(4) "none"
  }
  ["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/15864335/e160075385d2082a857ffd89c9e54043"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "194"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(3) "122"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "32"
  }
  ["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) "P202"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1993"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-007-032-0122"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(44) "Bedroom on 1st Level,Corner/End,Single Level"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15864335"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202109767"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628915118"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1993"
  }
  ["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(2754) "a:168:{i:0;i:19863005;i:1;i:19863006;i:2;i:19863007;i:3;i:19863008;i:4;i:19863009;i:5;i:19863010;i:6;i:19863011;i:7;i:19863012;i:8;i:19863013;i:9;i:19863014;i:10;i:19863015;i:11;i:19863016;i:12;i:19863017;i:13;i:19863018;i:14;i:19863019;i:15;i:19863020;i:16;i:19863021;i:17;i:19863022;i:18;i:19863023;i:19;i:19863024;i:20;i:19863025;i:21;i:19865275;i:22;i:19865276;i:23;i:19865277;i:24;i:19865278;i:25;i:19865279;i:26;i:19865280;i:27;i:19865281;i:28;i:19865282;i:29;i:19865283;i:30;i:19865284;i:31;i:19865285;i:32;i:19865286;i:33;i:19865287;i:34;i:19865288;i:35;i:19865289;i:36;i:19865290;i:37;i:19865291;i:38;i:19865292;i:39;i:19865293;i:40;i:19865294;i:41;i:19865295;i:42;i:19865296;i:43;i:19865297;i:44;i:19865298;i:45;i:19865299;i:46;i:19865300;i:47;i:19865301;i:48;i:19865302;i:49;i:19865303;i:50;i:19865304;i:51;i:19865305;i:52;i:19865306;i:53;i:19865307;i:54;i:19865308;i:55;i:19865309;i:56;i:19865310;i:57;i:19865311;i:58;i:19865312;i:59;i:19865313;i:60;i:19865314;i:61;i:19865315;i:62;i:19865316;i:63;i:19868454;i:64;i:19868455;i:65;i:19868456;i:66;i:19868457;i:67;i:19868458;i:68;i:19868459;i:69;i:19868460;i:70;i:19868461;i:71;i:19868462;i:72;i:19868463;i:73;i:19868464;i:74;i:19868465;i:75;i:19868466;i:76;i:19868467;i:77;i:19868468;i:78;i:19868469;i:79;i:19868470;i:80;i:19868471;i:81;i:19868472;i:82;i:19868473;i:83;i:19868474;i:84;i:19897840;i:85;i:19897841;i:86;i:19897842;i:87;i:19897843;i:88;i:19897844;i:89;i:19897845;i:90;i:19897846;i:91;i:19897847;i:92;i:19897848;i:93;i:19897849;i:94;i:19897850;i:95;i:19897851;i:96;i:19897852;i:97;i:19897853;i:98;i:19897854;i:99;i:19897855;i:100;i:19897856;i:101;i:19897857;i:102;i:19897858;i:103;i:19897859;i:104;i:19897860;i:105;i:19913429;i:106;i:19913430;i:107;i:19913431;i:108;i:19913432;i:109;i:19913433;i:110;i:19913434;i:111;i:19913435;i:112;i:19913436;i:113;i:19913437;i:114;i:19913438;i:115;i:19913439;i:116;i:19913440;i:117;i:19913441;i:118;i:19913442;i:119;i:19913443;i:120;i:19913444;i:121;i:19913445;i:122;i:19913446;i:123;i:19913447;i:124;i:19913448;i:125;i:19913449;i:126;i:20042240;i:127;i:20042241;i:128;i:20042242;i:129;i:20042243;i:130;i:20042244;i:131;i:20042245;i:132;i:20042246;i:133;i:20042247;i:134;i:20042248;i:135;i:20042249;i:136;i:20042250;i:137;i:20042251;i:138;i:20042252;i:139;i:20042253;i:140;i:20042254;i:141;i:20042255;i:142;i:20042256;i:143;i:20042257;i:144;i:20042258;i:145;i:20042259;i:146;i:20042260;i:147;i:20290347;i:148;i:20290348;i:149;i:20290349;i:150;i:20290350;i:151;i:20290351;i:152;i:20290352;i:153;i:20290353;i:154;i:20290354;i:155;i:20290355;i:156;i:20290356;i:157;i:20290357;i:158;i:20290358;i:159;i:20290359;i:160;i:20290360;i:161;i:20290361;i:162;i:20290362;i:163;i:20290363;i:164;i:20290364;i:165;i:20290365;i:166;i:20290366;i:167;i:20290367;}"
  }
  ["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_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-28"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-03"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "509000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-03"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 597-5550"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(26) "drew.mcdurmin@cbrealty.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(13) "Drew McDurmin"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "50743"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "15448291"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "CBPP09"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487755"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 597-5550"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(8) "Lumiaina"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "94-614"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(4) "P202"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20290347"
  }
}