91-681 Puamaeole Street Unit 28B
Ewa Beach, HI 96706

Take a Virtual Tour

Listing
Overview

Price: $465,000
Area: EWA GEN SODA CREEK
Status: Sold

Visit this one of a kind Palm Court, bottom floor unit. Kitchen features gas stove, stainless steel appliances, large granite island that can seat 4, extra kitchen cabinet space is possible because washer and dryer are stacked and hidden in a separate closet. A main feature in the bathrooms is the decorative beadboard treatment and pedestal sinks giving the space a more open feel. Relax on your large mountain facing lanai, on the complex perimeter, while enjoying your favorite beverage after a long day. The unit is close to Kapolei, Ko Olina, several golf courses, shopping, theaters and much more. Don’t miss the opportunity to own this turnkey unit! First showings are during this Saturday and Sunday open houses.

array(171) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "234900.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "157300.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "392200.00"
  }
  ["assn_fee_inclusions"]=>
  array(1) {
    [0]=>
    string(2) "38"
  }
  ["association_fees"]=>
  array(1) {
    [0]=>
    string(2) "38"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(10) "Palm Court"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(9) "Townhouse"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(9) "Ewa Beach"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(74) "Pet on Property,Pets Allowed (Verify),Property Disclosure Stmt,See Remarks"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(21) "Ceramic Tile,Laminate"
  }
  ["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"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(10) "100,000.00"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "515620.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(21) "Deborah@mhshawaii.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(18) "Deborah L Arguello"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 675-6642"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-14"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(23) "Sentry Residential, LLC"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "465000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "810"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(53) "91-681 Puamaeole Street Unit 28B, Ewa Beach, HI 96706"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "509.45"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202116445"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(18) "EWA GEN SODA CREEK"
  }
  ["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) "VTRN"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(35) "Assigned,Covered - 1,Guest,Open - 1"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(15) "45 Days or Less"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96706"
  }
  ["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(8) "Ewaplain"
  }
  ["rets_active_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_association_community_name"]=>
  array(1) {
    [0]=>
    string(11) "Ewa By Gent"
  }
  ["rets_association_fee"]=>
  array(1) {
    [0]=>
    string(2) "38"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "547"
  }
  ["rets_association_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-685-0111"
  }
  ["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(10) "Palm Court"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(9) "Ewa Beach"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(7) "435,451"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "485000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "7"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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_id"]=>
  array(1) {
    [0]=>
    string(8) "16003661"
  }
  ["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) 675-6642"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(21) "Deborah@mhshawaii.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(18) "Deborah L Arguello"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "45031"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9450531"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "VTRN"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15279310"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(23) "Sentry Residential, LLC"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 675-6642"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "465000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-14"
  }
  ["rets_lock_box_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "515620.00"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "509.45"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(14) "Associa Hawaii"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-836-0911"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-01T08:44:55.593"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16003661"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202116445"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(18) "EWA GEN SODA CREEK"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_open_house_upcoming"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-14T14:55:21.047"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "465000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "56"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-9-1-051-099-0202"
  }
  ["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) "22"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-14T14:55:21.047"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96706"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16003661"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(532) "2-day notice required. COVID rules apply, take off shoes. Include As-Is Addendum, buyer to order permit package if needed. For escrow please consider using Kevin Batungbacal, First American Title, 808-638-4925. Resident Mgr 808-497-7973. Tax assessment is 2021/monthly taxes are 2020. SRPDS in supplements. Per listing contract, offers will be forwarded to sellers upon receipt, seller will review offers at 5:00, 20 July 2021. Seller will not accept letters from buyers or realtor about buyers to avoid violating Fair Housing laws."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(725) "Visit this one of a kind Palm Court, bottom floor unit. Kitchen features gas stove, stainless steel appliances, large granite island that can seat 4, extra kitchen cabinet space is possible because washer and dryer are stacked and hidden in a separate closet. A main feature in the bathrooms is the decorative beadboard treatment and pedestal sinks giving the space a more open feel.  Relax on your large mountain facing lanai, on the complex perimeter, while enjoying your favorite beverage after a long day.  The unit is close to Kapolei, Ko Olina, several golf courses, shopping, theaters and much more.  Don't miss the opportunity to own this turnkey unit!  First showings are during this Saturday and Sunday open houses."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "810"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "810"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-01T08:44:55.593"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-31"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(9) "Puamaeole"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "91-681"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_supplement_count"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_supplement_modification_timestam"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-14T20:33:31.710"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(5) "85.23"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "392200.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "234900.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "157300.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(10) "100,000.00"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16003661/952f4da6fc01f4712207a83d8c4633dc"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "191"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(3) "202"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "99"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "51"
  }
  ["rets_unit_number"]=>
  array(1) {
    [0]=>
    string(3) "28B"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(69) "https://app.immoviewer.com/landing/unbranded/60f1423d01bbdf107929002f"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1990"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(25) "Gated Community,Key,Video"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(9) "Puamaeole"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "91-681"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(20) "Cash,Conventional,VA"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-9-1-051-099-0202"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(81) "Bedroom on 1st Level,Corner/End,Even# Unit,Ground Floor Unit,Single Level,Storage"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(3) "28B"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(69) "https://app.immoviewer.com/landing/unbranded/60f1423d01bbdf107929002f"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16003661"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202116445"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1630521932"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1990"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(30) "11 - A-1 Low Density Apartment"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1341) "a:84:{i:0;i:19979742;i:1;i:19979743;i:2;i:19979744;i:3;i:19979745;i:4;i:19979746;i:5;i:19979747;i:6;i:19979748;i:7;i:19979749;i:8;i:19979750;i:9;i:19979751;i:10;i:19979752;i:11;i:19979753;i:12;i:19979754;i:13;i:19979755;i:14;i:19979756;i:15;i:19979757;i:16;i:19979758;i:17;i:19979759;i:18;i:19979760;i:19;i:19979761;i:20;i:19979762;i:21;i:20088091;i:22;i:20088092;i:23;i:20088093;i:24;i:20088094;i:25;i:20088095;i:26;i:20088096;i:27;i:20088097;i:28;i:20088098;i:29;i:20088099;i:30;i:20088100;i:31;i:20088101;i:32;i:20088102;i:33;i:20088103;i:34;i:20088104;i:35;i:20088105;i:36;i:20088106;i:37;i:20088107;i:38;i:20088108;i:39;i:20088109;i:40;i:20088110;i:41;i:20088111;i:42;i:20230707;i:43;i:20230708;i:44;i:20230709;i:45;i:20230710;i:46;i:20230711;i:47;i:20230712;i:48;i:20230713;i:49;i:20230714;i:50;i:20230715;i:51;i:20230716;i:52;i:20230717;i:53;i:20230718;i:54;i:20230719;i:55;i:20230720;i:56;i:20230721;i:57;i:20230722;i:58;i:20230723;i:59;i:20230724;i:60;i:20230725;i:61;i:20230726;i:62;i:20230727;i:63;i:20646614;i:64;i:20646615;i:65;i:20646616;i:66;i:20646617;i:67;i:20646618;i:68;i:20646619;i:69;i:20646620;i:70;i:20646621;i:71;i:20646622;i:72;i:20646623;i:73;i:20646624;i:74;i:20646625;i:75;i:20646626;i:76;i:20646627;i:77;i:20646628;i:78;i:20646629;i:79;i:20646630;i:80;i:20646631;i:81;i:20646632;i:82;i:20646633;i:83;i:20646634;}"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-20"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-31"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "485000.00"
  }
  ["rets_co_selling_agent_direct_work_pho"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_co_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "chengj33@gmail.com"
  }
  ["rets_co_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Jeremy A Cheng"
  }
  ["rets_co_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "50861"
  }
  ["rets_co_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "15544406"
  }
  ["rets_co_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "EXPI"
  }
  ["rets_co_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10013908"
  }
  ["rets_co_selling_office_name"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["rets_co_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-31"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "tony@alohatony.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Tony Kawaguchi"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "30802"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3478693"
  }
  ["rets_selling_agent_remarks"]=>
  array(1) {
    [0]=>
    string(37) "Great transaction!  Thank you Jeremy!"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "EXPI"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10013908"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20646614"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 234900.00
        )

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

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

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

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

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

    [building_name] => Array
        (
            [0] => Palm Court
        )

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

    [city] => Array
        (
            [0] => Ewa Beach
        )

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

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

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

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

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

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

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

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

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

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

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

    [list_agent_email] => Array
        (
            [0] => Deborah@mhshawaii.com
        )

    [list_agent_name] => Array
        (
            [0] => Deborah L Arguello
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 675-6642
        )

    [list_date] => Array
        (
            [0] => 2021-07-14
        )

    [list_office_name] => Array
        (
            [0] => Sentry Residential, LLC
        )

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

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

    [location] => Array
        (
            [0] => 91-681 Puamaeole Street Unit 28B, Ewa Beach, HI 96706
        )

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

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

    [neighborhood] => Array
        (
            [0] => EWA GEN SODA CREEK
        )

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

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

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

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

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

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

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

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

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

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

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

    [rets_association_community_name] => Array
        (
            [0] => Ewa By Gent
        )

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

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

    [rets_association_phone] => Array
        (
            [0] => 808-685-0111
        )

    [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] => Palm Court
        )

    [rets_city] => Array
        (
            [0] => Ewa Beach
        )

    [rets_condo_parking_unit] => Array
        (
            [0] => 435,451
        )

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

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

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

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

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

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

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

    [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) 675-6642
        )

    [rets_list_agent_email] => Array
        (
            [0] => Deborah@mhshawaii.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Deborah L Arguello
        )

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

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

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

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

    [rets_list_office_name] => Array
        (
            [0] => Sentry Residential, LLC
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 675-6642
        )

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

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-07-14
        )

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

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

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

    [rets_management_company_name] => Array
        (
            [0] => Associa Hawaii
        )

    [rets_management_company_phone] => Array
        (
            [0] => 808-836-0911
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-09-01T08:44:55.593
        )

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

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

    [rets_neighbourhood] => Array
        (
            [0] => EWA GEN SODA CREEK
        )

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

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

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

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-07-14T14:55:21.047
        )

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

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

    [rets_parcel_number] => Array
        (
            [0] => 1-9-1-051-099-0202
        )

    [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] => 22
        )

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-07-14T14:55:21.047
        )

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

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

    [rets_private_remarks] => Array
        (
            [0] => 2-day notice required. COVID rules apply, take off shoes. Include As-Is Addendum, buyer to order permit package if needed. For escrow please consider using Kevin Batungbacal, First American Title, 808-638-4925. Resident Mgr 808-497-7973. Tax assessment is 2021/monthly taxes are 2020. SRPDS in supplements. Per listing contract, offers will be forwarded to sellers upon receipt, seller will review offers at 5:00, 20 July 2021. Seller will not accept letters from buyers or realtor about buyers to avoid violating Fair Housing laws.
        )

    [rets_public_remarks] => Array
        (
            [0] => Visit this one of a kind Palm Court, bottom floor unit. Kitchen features gas stove, stainless steel appliances, large granite island that can seat 4, extra kitchen cabinet space is possible because washer and dryer are stacked and hidden in a separate closet. A main feature in the bathrooms is the decorative beadboard treatment and pedestal sinks giving the space a more open feel.  Relax on your large mountain facing lanai, on the complex perimeter, while enjoying your favorite beverage after a long day.  The unit is close to Kapolei, Ko Olina, several golf courses, shopping, theaters and much more.  Don't miss the opportunity to own this turnkey unit!  First showings are during this Saturday and Sunday open houses.
        )

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

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

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

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-09-01T08:44:55.593
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-08-31
        )

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

    [rets_street_number] => Array
        (
            [0] => 91-681
        )

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

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

    [rets_supplement_modification_timestam] => Array
        (
            [0] => 2021-07-14T20:33:31.710
        )

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

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

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

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

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

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

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

    [rets_thumbnail_url] => Array
        (
            [0] => https://cdn.rets.ci/marcusrealty-images/16003661/952f4da6fc01f4712207a83d8c4633dc
        )

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

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

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

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

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

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

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

    [rets_unit_number] => Array
        (
            [0] => 28B
        )

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

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

    [security] => Array
        (
            [0] => Gated Community,Key,Video
        )

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

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

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

    [street_number] => Array
        (
            [0] => 91-681
        )

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

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

    [tmk] => Array
        (
            [0] => 1-9-1-051-099-0202
        )

    [unit] => Array
        (
            [0] => Bedroom on 1st Level,Corner/End,Even# Unit,Ground Floor Unit,Single Level,Storage
        )

    [unit_number] => Array
        (
            [0] => 28B
        )

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

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

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

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

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

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

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

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

    [new_attached_media] => Array
        (
            [0] => a:84:{i:0;i:19979742;i:1;i:19979743;i:2;i:19979744;i:3;i:19979745;i:4;i:19979746;i:5;i:19979747;i:6;i:19979748;i:7;i:19979749;i:8;i:19979750;i:9;i:19979751;i:10;i:19979752;i:11;i:19979753;i:12;i:19979754;i:13;i:19979755;i:14;i:19979756;i:15;i:19979757;i:16;i:19979758;i:17;i:19979759;i:18;i:19979760;i:19;i:19979761;i:20;i:19979762;i:21;i:20088091;i:22;i:20088092;i:23;i:20088093;i:24;i:20088094;i:25;i:20088095;i:26;i:20088096;i:27;i:20088097;i:28;i:20088098;i:29;i:20088099;i:30;i:20088100;i:31;i:20088101;i:32;i:20088102;i:33;i:20088103;i:34;i:20088104;i:35;i:20088105;i:36;i:20088106;i:37;i:20088107;i:38;i:20088108;i:39;i:20088109;i:40;i:20088110;i:41;i:20088111;i:42;i:20230707;i:43;i:20230708;i:44;i:20230709;i:45;i:20230710;i:46;i:20230711;i:47;i:20230712;i:48;i:20230713;i:49;i:20230714;i:50;i:20230715;i:51;i:20230716;i:52;i:20230717;i:53;i:20230718;i:54;i:20230719;i:55;i:20230720;i:56;i:20230721;i:57;i:20230722;i:58;i:20230723;i:59;i:20230724;i:60;i:20230725;i:61;i:20230726;i:62;i:20230727;i:63;i:20646614;i:64;i:20646615;i:65;i:20646616;i:66;i:20646617;i:67;i:20646618;i:68;i:20646619;i:69;i:20646620;i:70;i:20646621;i:71;i:20646622;i:72;i:20646623;i:73;i:20646624;i:74;i:20646625;i:75;i:20646626;i:76;i:20646627;i:77;i:20646628;i:78;i:20646629;i:79;i:20646630;i:80;i:20646631;i:81;i:20646632;i:82;i:20646633;i:83;i:20646634;}
        )

    [rets_pending_date] => Array
        (
            [0] => 2021-07-20
        )

    [rets_close_date] => Array
        (
            [0] => 2021-08-31
        )

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

    [rets_co_selling_agent_direct_work_pho] => Array
        (
            [0] => (808) 725-2794
        )

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

    [rets_co_selling_agent_full_name] => Array
        (
            [0] => Jeremy A Cheng
        )

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

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

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

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

    [rets_co_selling_office_name] => Array
        (
            [0] => eXp Realty
        )

    [rets_co_selling_office_phone] => Array
        (
            [0] => (808) 725-2794
        )

    [rets_off_market_date] => Array
        (
            [0] => 2021-08-31
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 725-2794
        )

    [rets_selling_agent_email] => Array
        (
            [0] => tony@alohatony.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Tony Kawaguchi
        )

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

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

    [rets_selling_agent_remarks] => Array
        (
            [0] => Great transaction!  Thank you Jeremy!
        )

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

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

    [rets_selling_office_name] => Array
        (
            [0] => eXp Realty
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 725-2794
        )

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

)

  • Bedrooms: 2
  • Full Baths: 2
  • Land Area (sf): 515,620
  • Living (sf): 810
  • Year Built: 1990
  • Building Name: Palm Court

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • Number of Stories: One
  • View: Mountain
  • Listing Office: Sentry Residential, LLC

  • Maintenance Fees: $509
  • Association Fees: $38
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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