94-1363 Kulewa Loop Unit 15R
Waipahu, HI 96797

Take a Virtual Tour

Listing
Overview

Price: $450,000
Area: WAIPIO GENTRY
Status: Sold

This property will not last long…..A move-in ready, 2 bedroom, 1 bath, upstairs corner unit in Waipio Gentry with maintenance fees under $500 per month. Come home to the highly sought after Royal Palm at Waipio which is conveniently located near freeway access, Costco, Foodland, Waikele Shopping Center, Okinawan Center, schools, grocery stores, multiple parks – playgrounds – sports fields/courts, bus stops and many restaurants….Don’t miss this opportunity. The complex is both Pet Friendly (one cat and one dog (AOAO requires Owner have HO Insurance coverage for pet liability) – verify) and approved for VA lending, in addition to its own pool and BBQ area (currently under renovation). This unit has 1 assigned covered parking and plenty of guest parking, not to mention the ample street parking if you have more than one car. This 2nd-floor unit experiences nice breezes, has an open lanai, and has been meticulously maintained. It has a logical, open floor plan with window A/C units and fans for climate control, a new water heater, new disposal and a new overhead fan. Put this on your must see list!

Listing by: Exceptional Homes Hawaii

array(173) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "214800.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "165900.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "380700.00"
  }
  ["assn_fee_inclusions"]=>
  array(1) {
    [0]=>
    string(2) "13"
  }
  ["association_fees"]=>
  array(1) {
    [0]=>
    string(2) "13"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(22) "Royal Palm At Waipio 2"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(9) "Townhouse"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(46) "Pets Allowed (Verify),Property Disclosure Stmt"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(9) "Kanoelani"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(25) "Laminate,Vinyl,W/W Carpet"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(10) "Pearl City"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(6) "100000"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(2) "80"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "113517.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(20) "JonMann808@gmail.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(10) "Jon S Mann"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 900-3817"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-29"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(24) "Exceptional Homes Hawaii"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "450000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "788"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(47) "94-1363 Kulewa Loop Unit 15R, Waipahu, HI 96797"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "467.00"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(9) "Highlands"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202124802"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPIO GENTRY"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "MANN"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(33) "Assigned,Covered - 1,Guest,Street"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(26) "45 Days or Less,At Closing"
  }
  ["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_community_name"]=>
  array(1) {
    [0]=>
    string(13) "Gentry Waipio"
  }
  ["rets_association_fee"]=>
  array(1) {
    [0]=>
    string(2) "13"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "480"
  }
  ["rets_association_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-671-2272"
  }
  ["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) "2"
  }
  ["rets_building_name"]=>
  array(1) {
    [0]=>
    string(22) "Royal Palm At Waipio 2"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_compensation_method"]=>
  array(1) {
    [0]=>
    string(5) "50/50"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(2) "94"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "460000.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(9) "Kanoelani"
  }
  ["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(10) "Pearl City"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16187835"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_internet_automated_valuation_dis"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_internet_consumer_comment_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 900-3817"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(20) "JonMann808@gmail.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(10) "Jon S Mann"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "26838"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3476484"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "MANN"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487274"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(24) "Exceptional Homes Hawaii"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 900-3817"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "450000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-29"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "113517.00"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "467.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(10) "Touchstone"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-566-4100"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-19T14:16:06.413"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16187835"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(9) "Highlands"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202124802"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPIO GENTRY"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-30T00:53:46.540"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "450000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "43"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-115-037-0057"
  }
  ["rets_parking_additional"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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) "25"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-30T00:53:46.540"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-30T00:53:46.540"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16187835"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(348) "Please use Showing Time to schedule all appointments.  No Showings until First Showing and First Open House, Sunday, October 3rd, 1:00pm-5:00pm.  Sellers prefer First American Title, Escrow Officer, Nicole Yasuda, Kapiolani Office.  Please submit Offers by noon on Tuesday, October 5th with response to be provided by 5pm on Wednesday, October 6th."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(1120) "This property will not last long.....A move-in ready, 2 bedroom, 1 bath, upstairs corner unit in Waipio Gentry with maintenance fees under $500 per month.  Come home to the highly sought after Royal Palm at Waipio which is conveniently located near freeway access, Costco, Foodland, Waikele Shopping Center, Okinawan Center, schools, grocery stores, multiple parks - playgrounds - sports fields/courts, bus stops and many restaurants....Don't miss this opportunity.  The complex is both Pet Friendly (one cat and one dog (AOAO requires Owner have HO Insurance coverage for pet liability) - verify) and approved for VA lending, in addition to its own pool and BBQ area (currently under renovation).  This unit has 1 assigned covered parking and plenty of guest parking, not to mention the ample street parking if you have more than one car.  This 2nd-floor unit experiences nice breezes, has an open lanai, and has been meticulously maintained.  It has a logical, open floor plan with window A/C units and fans for climate control, a new water heater, new disposal and a new overhead fan.  Put this on your must see list!"
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(2) "80"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "708"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "788"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-19T14:16:06.413"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-19"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(6) "Kulewa"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(7) "94-1363"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "108.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "380700.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "214800.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "165900.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(6) "100000"
  }
  ["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/16187835/59bd5137a0565d6f292d9194b9eaf1a4"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "194"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(2) "57"
  }
  ["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) "9"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(3) "115"
  }
  ["rets_unit_number"]=>
  array(1) {
    [0]=>
    string(3) "15R"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1987"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2019"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(19) "Key,Security Patrol"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(6) "Kulewa"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(7) "94-1363"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Loop"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(20) "Cash,Conventional,VA"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-115-037-0057"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(23) "Corner/End,Single Level"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(3) "15R"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16187835"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202124802"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1637367393"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1987"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2019"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(30) "11 - A-1 Low Density Apartment"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2397) "a:147:{i:0;i:20867792;i:1;i:20867793;i:2;i:20867794;i:3;i:20867795;i:4;i:20867796;i:5;i:20867797;i:6;i:20867798;i:7;i:20867799;i:8;i:20867800;i:9;i:20867801;i:10;i:20867802;i:11;i:20867803;i:12;i:20867804;i:13;i:20867805;i:14;i:20867806;i:15;i:20867807;i:16;i:20867808;i:17;i:20867809;i:18;i:20867810;i:19;i:20867811;i:20;i:20867812;i:21;i:20867813;i:22;i:20867814;i:23;i:20867815;i:24;i:20867816;i:25;i:20867817;i:26;i:20867818;i:27;i:20867819;i:28;i:20867820;i:29;i:20867821;i:30;i:20867822;i:31;i:20867823;i:32;i:20867824;i:33;i:20867825;i:34;i:20867826;i:35;i:20867827;i:36;i:20867828;i:37;i:20867829;i:38;i:20867830;i:39;i:20867831;i:40;i:20867832;i:41;i:20867833;i:42;i:20891461;i:43;i:20891462;i:44;i:20891463;i:45;i:20891464;i:46;i:20891465;i:47;i:20891466;i:48;i:20891467;i:49;i:20891468;i:50;i:20891469;i:51;i:20891470;i:52;i:20891471;i:53;i:20891472;i:54;i:20891473;i:55;i:20891474;i:56;i:20891475;i:57;i:20891476;i:58;i:20891477;i:59;i:20891478;i:60;i:20891479;i:61;i:20891480;i:62;i:20891481;i:63;i:20899693;i:64;i:20899694;i:65;i:20899695;i:66;i:20899696;i:67;i:20899697;i:68;i:20899698;i:69;i:20899699;i:70;i:20899700;i:71;i:20899701;i:72;i:20899702;i:73;i:20899703;i:74;i:20899704;i:75;i:20899705;i:76;i:20899706;i:77;i:20899707;i:78;i:20899708;i:79;i:20899709;i:80;i:20899710;i:81;i:20899711;i:82;i:20899712;i:83;i:20899713;i:84;i:20907444;i:85;i:20907445;i:86;i:20907446;i:87;i:20907447;i:88;i:20907448;i:89;i:20907449;i:90;i:20907450;i:91;i:20907451;i:92;i:20907452;i:93;i:20907453;i:94;i:20907454;i:95;i:20907455;i:96;i:20907456;i:97;i:20907457;i:98;i:20907458;i:99;i:20907459;i:100;i:20907460;i:101;i:20907461;i:102;i:20907462;i:103;i:20907463;i:104;i:20907464;i:105;i:21155641;i:106;i:21155642;i:107;i:21155643;i:108;i:21155644;i:109;i:21155645;i:110;i:21155646;i:111;i:21155647;i:112;i:21155648;i:113;i:21155649;i:114;i:21155650;i:115;i:21155651;i:116;i:21155652;i:117;i:21155653;i:118;i:21155654;i:119;i:21155655;i:120;i:21155656;i:121;i:21155657;i:122;i:21155658;i:123;i:21155659;i:124;i:21155660;i:125;i:21155661;i:126;i:21195436;i:127;i:21195437;i:128;i:21195438;i:129;i:21195439;i:130;i:21195440;i:131;i:21195441;i:132;i:21195442;i:133;i:21195443;i:134;i:21195444;i:135;i:21195445;i:136;i:21195446;i:137;i:21195447;i:138;i:21195448;i:139;i:21195449;i:140;i:21195450;i:141;i:21195451;i:142;i:21195452;i:143;i:21195453;i:144;i:21195454;i:145;i:21195455;i:146;i:21195456;}"
  }
  ["rets_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_active_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(69) "https://app.immoviewer.com/landing/unbranded/615c0e076b11d71d770772b7"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(69) "https://app.immoviewer.com/landing/unbranded/615c0e076b11d71d770772b7"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-05"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-05"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "1296.00"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-19"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "460000.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-03-30"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-19"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 487-3855"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(39) "Kelley.Zukeran-Sakaino@evrealestate.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(22) "Kelley Zukeran-Sakaino"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "47319"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "10927811"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "PPRO02"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487726"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(24) "Engel & Volkers-Honolulu"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 487-3855"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21195436"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 214800.00
        )

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

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

    [assn_fee_inclusions] => Array
        (
            [0] => 13
        )

    [association_fees] => Array
        (
            [0] => 13
        )

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

    [building_name] => Array
        (
            [0] => Royal Palm At Waipio 2
        )

    [building_style] => Array
        (
            [0] => Townhouse
        )

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

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

    [disclosures] => Array
        (
            [0] => Pets Allowed (Verify),Property Disclosure Stmt
        )

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

    [floor_covering] => Array
        (
            [0] => Laminate,Vinyl,W/W Carpet
        )

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

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

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

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

    [high_school] => Array
        (
            [0] => Pearl City
        )

    [home_exampt] => Array
        (
            [0] => 100000
        )

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

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

    [land_recorded] => Array
        (
            [0] => Land Court
        )

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

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

    [list_agent_name] => Array
        (
            [0] => Jon S Mann
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 900-3817
        )

    [list_date] => Array
        (
            [0] => 2021-09-29
        )

    [list_office_name] => Array
        (
            [0] => Exceptional Homes Hawaii
        )

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

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

    [location] => Array
        (
            [0] => 94-1363 Kulewa Loop Unit 15R, Waipahu, HI 96797
        )

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

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

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

    [neighborhood] => Array
        (
            [0] => WAIPIO GENTRY
        )

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

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

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

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

    [possession] => Array
        (
            [0] => 45 Days or Less,At Closing
        )

    [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_community_name] => Array
        (
            [0] => Gentry Waipio
        )

    [rets_association_fee] => Array
        (
            [0] => 13
        )

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

    [rets_association_phone] => Array
        (
            [0] => 808-671-2272
        )

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

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

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

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

    [rets_building_name] => Array
        (
            [0] => Royal Palm At Waipio 2
        )

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

    [rets_compensation_method] => Array
        (
            [0] => 50/50
        )

    [rets_condo_parking_unit] => Array
        (
            [0] => 94
        )

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

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

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

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

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

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

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

    [rets_high_school] => Array
        (
            [0] => Pearl City
        )

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

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

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

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

    [rets_list_agent_direct_work_phone] => Array
        (
            [0] => (808) 900-3817
        )

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

    [rets_list_agent_full_name] => Array
        (
            [0] => Jon S Mann
        )

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

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

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

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

    [rets_list_office_name] => Array
        (
            [0] => Exceptional Homes Hawaii
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 900-3817
        )

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

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-09-29
        )

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

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

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

    [rets_management_company_phone] => Array
        (
            [0] => 808-566-4100
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-11-19T14:16:06.413
        )

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

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

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

    [rets_neighbourhood] => Array
        (
            [0] => WAIPIO GENTRY
        )

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

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-09-30T00:53:46.540
        )

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

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

    [rets_parcel_number] => Array
        (
            [0] => 1-9-4-115-037-0057
        )

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

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

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

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

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

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-09-30T00:53:46.540
        )

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

    [rets_price_change_timestamp] => Array
        (
            [0] => 2021-09-30T00:53:46.540
        )

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

    [rets_private_remarks] => Array
        (
            [0] => Please use Showing Time to schedule all appointments.  No Showings until First Showing and First Open House, Sunday, October 3rd, 1:00pm-5:00pm.  Sellers prefer First American Title, Escrow Officer, Nicole Yasuda, Kapiolani Office.  Please submit Offers by noon on Tuesday, October 5th with response to be provided by 5pm on Wednesday, October 6th.
        )

    [rets_public_remarks] => Array
        (
            [0] => This property will not last long.....A move-in ready, 2 bedroom, 1 bath, upstairs corner unit in Waipio Gentry with maintenance fees under $500 per month.  Come home to the highly sought after Royal Palm at Waipio which is conveniently located near freeway access, Costco, Foodland, Waikele Shopping Center, Okinawan Center, schools, grocery stores, multiple parks - playgrounds - sports fields/courts, bus stops and many restaurants....Don't miss this opportunity.  The complex is both Pet Friendly (one cat and one dog (AOAO requires Owner have HO Insurance coverage for pet liability) - verify) and approved for VA lending, in addition to its own pool and BBQ area (currently under renovation).  This unit has 1 assigned covered parking and plenty of guest parking, not to mention the ample street parking if you have more than one car.  This 2nd-floor unit experiences nice breezes, has an open lanai, and has been meticulously maintained.  It has a logical, open floor plan with window A/C units and fans for climate control, a new water heater, new disposal and a new overhead fan.  Put this on your must see list!
        )

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

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

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

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

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

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-11-19T14:16:06.413
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-11-19
        )

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

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

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

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

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

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

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

    [rets_tax_excemption_owner_occupancy] => Array
        (
            [0] => 100000
        )

    [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/16187835/59bd5137a0565d6f292d9194b9eaf1a4
        )

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

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

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

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

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

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

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

    [rets_unit_number] => Array
        (
            [0] => 15R
        )

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

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

    [security] => Array
        (
            [0] => Key,Security Patrol
        )

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

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

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

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

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

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

    [tmk] => Array
        (
            [0] => 1-9-4-115-037-0057
        )

    [unit] => Array
        (
            [0] => Corner/End,Single Level
        )

    [unit_number] => Array
        (
            [0] => 15R
        )

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

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

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

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

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

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

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

    [zoning] => Array
        (
            [0] => 11 - A-1 Low Density Apartment
        )

    [new_attached_media] => Array
        (
            [0] => a:147:{i:0;i:20867792;i:1;i:20867793;i:2;i:20867794;i:3;i:20867795;i:4;i:20867796;i:5;i:20867797;i:6;i:20867798;i:7;i:20867799;i:8;i:20867800;i:9;i:20867801;i:10;i:20867802;i:11;i:20867803;i:12;i:20867804;i:13;i:20867805;i:14;i:20867806;i:15;i:20867807;i:16;i:20867808;i:17;i:20867809;i:18;i:20867810;i:19;i:20867811;i:20;i:20867812;i:21;i:20867813;i:22;i:20867814;i:23;i:20867815;i:24;i:20867816;i:25;i:20867817;i:26;i:20867818;i:27;i:20867819;i:28;i:20867820;i:29;i:20867821;i:30;i:20867822;i:31;i:20867823;i:32;i:20867824;i:33;i:20867825;i:34;i:20867826;i:35;i:20867827;i:36;i:20867828;i:37;i:20867829;i:38;i:20867830;i:39;i:20867831;i:40;i:20867832;i:41;i:20867833;i:42;i:20891461;i:43;i:20891462;i:44;i:20891463;i:45;i:20891464;i:46;i:20891465;i:47;i:20891466;i:48;i:20891467;i:49;i:20891468;i:50;i:20891469;i:51;i:20891470;i:52;i:20891471;i:53;i:20891472;i:54;i:20891473;i:55;i:20891474;i:56;i:20891475;i:57;i:20891476;i:58;i:20891477;i:59;i:20891478;i:60;i:20891479;i:61;i:20891480;i:62;i:20891481;i:63;i:20899693;i:64;i:20899694;i:65;i:20899695;i:66;i:20899696;i:67;i:20899697;i:68;i:20899698;i:69;i:20899699;i:70;i:20899700;i:71;i:20899701;i:72;i:20899702;i:73;i:20899703;i:74;i:20899704;i:75;i:20899705;i:76;i:20899706;i:77;i:20899707;i:78;i:20899708;i:79;i:20899709;i:80;i:20899710;i:81;i:20899711;i:82;i:20899712;i:83;i:20899713;i:84;i:20907444;i:85;i:20907445;i:86;i:20907446;i:87;i:20907447;i:88;i:20907448;i:89;i:20907449;i:90;i:20907450;i:91;i:20907451;i:92;i:20907452;i:93;i:20907453;i:94;i:20907454;i:95;i:20907455;i:96;i:20907456;i:97;i:20907457;i:98;i:20907458;i:99;i:20907459;i:100;i:20907460;i:101;i:20907461;i:102;i:20907462;i:103;i:20907463;i:104;i:20907464;i:105;i:21155641;i:106;i:21155642;i:107;i:21155643;i:108;i:21155644;i:109;i:21155645;i:110;i:21155646;i:111;i:21155647;i:112;i:21155648;i:113;i:21155649;i:114;i:21155650;i:115;i:21155651;i:116;i:21155652;i:117;i:21155653;i:118;i:21155654;i:119;i:21155655;i:120;i:21155656;i:121;i:21155657;i:122;i:21155658;i:123;i:21155659;i:124;i:21155660;i:125;i:21155661;i:126;i:21195436;i:127;i:21195437;i:128;i:21195438;i:129;i:21195439;i:130;i:21195440;i:131;i:21195441;i:132;i:21195442;i:133;i:21195443;i:134;i:21195444;i:135;i:21195445;i:136;i:21195446;i:137;i:21195447;i:138;i:21195448;i:139;i:21195449;i:140;i:21195450;i:141;i:21195451;i:142;i:21195452;i:143;i:21195453;i:144;i:21195454;i:145;i:21195455;i:146;i:21195456;}
        )

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

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

    [rets_virtual_tour_url_unbranded] => Array
        (
            [0] => https://app.immoviewer.com/landing/unbranded/615c0e076b11d71d770772b7
        )

    [virtual_tour] => Array
        (
            [0] => https://app.immoviewer.com/landing/unbranded/615c0e076b11d71d770772b7
        )

    [rets_active_continue_to_show_date] => Array
        (
            [0] => 2021-10-05
        )

    [rets_pending_date] => Array
        (
            [0] => 2021-10-05
        )

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

    [rets_close_date] => Array
        (
            [0] => 2021-11-19
        )

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

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

    [rets_off_market_date] => Array
        (
            [0] => 2021-11-19
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 487-3855
        )

    [rets_selling_agent_email] => Array
        (
            [0] => Kelley.Zukeran-Sakaino@evrealestate.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Kelley Zukeran-Sakaino
        )

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

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

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

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

    [rets_selling_office_name] => Array
        (
            [0] => Engel & Volkers-Honolulu
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 487-3855
        )

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

)

  • Bedrooms: 2
  • Full Baths: 1
  • Land Area (sf): 113,517
  • Living (sf): 788
  • Year Built: 1987
  • Building Name: Royal Palm At Waipio 2

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • Number of Stories: Two
  • View: None
  • Listing Office: Exceptional Homes Hawaii

  • Maintenance Fees: $467
  • Association Fees: $13
  • Land Tenure: FS - Fee Simple

  • Elementary School: Kanoelani
  • Middle School: Highlands
  • High School: Pearl City

CONTACT US

Marcus Realty

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