94-870 Lumiauau Street Unit S204
Waipahu, HI 96797

Listing
Overview

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

Aloha, and welcome home! Incredible opportunity to own your own piece of paradise at an affordable price. Enjoy the close proximity to the renowned Waikele Premium Outlet shopping, Costco, Lowes, various bases, vast array of restaurants, golfing, outside recreational activities, schools and college, and easy access to Interstates H-1, and H-3 and many other comforts. This
two-bedroom condominium boasts a sought-after location, parking, and no neighbors above you. Don’t miss your opportunity to own a piece of Aloha. All potential buyers are asked to check with city and tax records to determine actual bedroom, bathroom counts and all details on this property listed above to their satisfaction. This is an AS-IS REO property.

Listing by: Realhome Services & Solutions

array(158) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "213600.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "170000.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "383600.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(15) "Hoomaka Village"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(26) "Low-Rise 6 or Less Stories"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(11) "See Remarks"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(2) "90"
  }
  ["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) "Drew.Hershey@RHSS.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(12) "Drew Hershey"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(855) 882-1314"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-08"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(29) "Realhome Services & Solutions"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "359000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "740"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(51) "94-870 Lumiauau Street Unit S204, Waipahu, HI 96797"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "368.31"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202123528"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["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) "RHSS"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(14) "Assigned,Guest"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(7) "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(24) "AOAO of Ho'omaka Village"
  }
  ["rets_association_fee"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "368"
  }
  ["rets_association_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-799-4911"
  }
  ["rets_back_on_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-17"
  }
  ["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(15) "Hoomaka Village"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(4) "166C"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "390000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-08-13"
  }
  ["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_id"]=>
  array(1) {
    [0]=>
    string(8) "16154902"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_internet_automated_valuation_dis"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_internet_consumer_comment_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(855) 882-1314"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(21) "Drew.Hershey@RHSS.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(12) "Drew Hershey"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "48147"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "12431154"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "RHSS"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "9136164"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(29) "Realhome Services & Solutions"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(855) 882-1314"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "359000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-08"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "368.31"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(19) "Hawaiian Properties"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 523-0702"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-01T04:52:26.190"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16154902"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202123528"
  }
  ["rets_model_site_contact_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-799-4911"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-29"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-09T16:28:18.630"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "359000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-007-033-0182"
  }
  ["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-09T16:28:18.630"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-09T16:28:18.630"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16154902"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(848) "For showing instructions, go to ShowingTime in the MLS. This is a vacant property, and no appointment is necessary. Show during the day, as the electric is off.  Please call (866) 952-6514 option #1 if you experience any access issues.  This is a REO Auction property. Buyers’ premium paid at closing by buyer.  See www.Hubzu.com to place an offer, for fee details, and availability.  Seller expects buyers to do any inspection and due diligence PRIOR to making a bid, as there is no inspection contingencies.  When Agent or Buyer places a bid offer on www.Hubzu.com, they will simply type in their bid offer along with pre-approval or proof of funds.  There are no contracts required to upload to submit your bid offer.  Do not email offers to the listing agent.  Limited Service Listing.  For other questions, please email Drew.Hershey@RHSS.com"
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(735) "Aloha, and welcome home! Incredible opportunity to own your own piece of paradise at an affordable price. Enjoy the close proximity to the renowned Waikele Premium Outlet shopping, Costco, Lowes, various bases, vast array of restaurants, golfing, outside recreational activities, schools and college, and easy access to Interstates H-1, and H-3 and many other comforts. This 
two-bedroom condominium boasts a sought-after location, parking, and no neighbors above you. Don’t miss your opportunity to own a piece of Aloha. All potential buyers are asked to check with city and tax records to determine actual bedroom, bathroom counts and all details on this property listed above to their satisfaction. This is an AS-IS REO property."
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(2) "90"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "650"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "740"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-01T04:52:26.190"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-29"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(8) "Lumiauau"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "94-870"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(76) "1$21.403741163044$-157.9977572082083$72.57$13.33$1.00$UExPKSy2ECuQioBmmGxPkg"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(2) "3%"
  }
  ["rets_supplement_count"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_supplement_modification_timestam"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-09T16:32:04.183"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "104.83"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "383600.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "213600.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "170000.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["rets_temporarily_withdrawn_date"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16154902/99de0406a886b3c1f2bf465bceebd141"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "194"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(3) "182"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "33"
  }
  ["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) "S204"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1991"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(8) "Lumiauau"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "94-870"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-007-033-0182"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(10) "Even# Unit"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(4) "S204"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16154902"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202123528"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1635778391"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1991"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(30) "11 - A-1 Low Density Apartment"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1005) "a:63:{i:0;i:20770684;i:1;i:20770685;i:2;i:20770686;i:3;i:20770687;i:4;i:20770688;i:5;i:20770689;i:6;i:20770690;i:7;i:20770691;i:8;i:20770692;i:9;i:20770693;i:10;i:20770694;i:11;i:20770695;i:12;i:20770696;i:13;i:20770697;i:14;i:20770698;i:15;i:20770699;i:16;i:20770700;i:17;i:20770701;i:18;i:20770702;i:19;i:20770703;i:20;i:20770704;i:21;i:20794864;i:22;i:20794865;i:23;i:20794866;i:24;i:20794867;i:25;i:20794868;i:26;i:20794869;i:27;i:20794870;i:28;i:20794871;i:29;i:20794872;i:30;i:20794873;i:31;i:20794874;i:32;i:20794875;i:33;i:20794876;i:34;i:20794877;i:35;i:20794878;i:36;i:20794879;i:37;i:20794880;i:38;i:20794881;i:39;i:20794882;i:40;i:20794883;i:41;i:20794884;i:42;i:21070476;i:43;i:21070477;i:44;i:21070478;i:45;i:21070479;i:46;i:21070480;i:47;i:21070481;i:48;i:21070482;i:49;i:21070483;i:50;i:21070484;i:51;i:21070485;i:52;i:21070486;i:53;i:21070487;i:54;i:21070488;i:55;i:21070489;i:56;i:21070490;i:57;i:21070491;i:58;i:21070492;i:59;i:21070493;i:60;i:21070494;i:61;i:21070495;i:62;i:21070496;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-21"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-29"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "390000.00"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 277-0652"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(27) "johnnytrealestate@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(9) "Johnny Tu"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "45067"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9491378"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "TOPP"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15421241"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(27) "Top Property Management LLC"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 277-0652"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "1257.96"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21070476"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 213600.00
        )

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

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

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

    [building_name] => Array
        (
            [0] => Hoomaka Village
        )

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

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

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

    [disclosures] => Array
        (
            [0] => See Remarks
        )

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

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

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

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

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

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

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

    [list_agent_email] => Array
        (
            [0] => Drew.Hershey@RHSS.com
        )

    [list_agent_name] => Array
        (
            [0] => Drew Hershey
        )

    [list_agent_phone_number] => Array
        (
            [0] => (855) 882-1314
        )

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

    [list_office_name] => Array
        (
            [0] => Realhome Services & Solutions
        )

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

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

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

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

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

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

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

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

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

    [parking_features] => Array
        (
            [0] => Assigned,Guest
        )

    [possession] => Array
        (
            [0] => At Closing
        )

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

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

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

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

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

    [rets_association_community_name] => Array
        (
            [0] => AOAO of Ho'omaka Village
        )

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

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

    [rets_association_phone] => Array
        (
            [0] => 808-799-4911
        )

    [rets_back_on_market_date] => Array
        (
            [0] => 2021-09-17
        )

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

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

    [rets_condo_parking_unit] => Array
        (
            [0] => 166C
        )

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

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

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

    [rets_expiration_date] => Array
        (
            [0] => 2022-08-13
        )

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

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

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

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

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

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

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

    [rets_list_agent_direct_work_phone] => Array
        (
            [0] => (855) 882-1314
        )

    [rets_list_agent_email] => Array
        (
            [0] => Drew.Hershey@RHSS.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Drew Hershey
        )

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

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

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

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

    [rets_list_office_name] => Array
        (
            [0] => Realhome Services & Solutions
        )

    [rets_list_office_phone] => Array
        (
            [0] => (855) 882-1314
        )

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

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

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

    [rets_management_company_name] => Array
        (
            [0] => Hawaiian Properties
        )

    [rets_management_company_phone] => Array
        (
            [0] => (808) 523-0702
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-11-01T04:52:26.190
        )

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

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

    [rets_model_site_contact_phone] => Array
        (
            [0] => 808-799-4911
        )

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

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

    [rets_off_market_date] => Array
        (
            [0] => 2021-10-29
        )

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-09-09T16:28:18.630
        )

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

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

    [rets_parcel_number] => Array
        (
            [0] => 1-9-4-007-033-0182
        )

    [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-09T16:28:18.630
        )

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

    [rets_price_change_timestamp] => Array
        (
            [0] => 2021-09-09T16:28:18.630
        )

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

    [rets_private_remarks] => Array
        (
            [0] => For showing instructions, go to ShowingTime in the MLS. This is a vacant property, and no appointment is necessary. Show during the day, as the electric is off.  Please call (866) 952-6514 option #1 if you experience any access issues.  This is a REO Auction property. Buyers’ premium paid at closing by buyer.  See www.Hubzu.com to place an offer, for fee details, and availability.  Seller expects buyers to do any inspection and due diligence PRIOR to making a bid, as there is no inspection contingencies.  When Agent or Buyer places a bid offer on www.Hubzu.com, they will simply type in their bid offer along with pre-approval or proof of funds.  There are no contracts required to upload to submit your bid offer.  Do not email offers to the listing agent.  Limited Service Listing.  For other questions, please email Drew.Hershey@RHSS.com
        )

    [rets_public_remarks] => Array
        (
            [0] => Aloha, and welcome home! Incredible opportunity to own your own piece of paradise at an affordable price. Enjoy the close proximity to the renowned Waikele Premium Outlet shopping, Costco, Lowes, various bases, vast array of restaurants, golfing, outside recreational activities, schools and college, and easy access to Interstates H-1, and H-3 and many other comforts. This 
two-bedroom condominium boasts a sought-after location, parking, and no neighbors above you. Don’t miss your opportunity to own a piece of Aloha. All potential buyers are asked to check with city and tax records to determine actual bedroom, bathroom counts and all details on this property listed above to their satisfaction. This is an AS-IS REO property.
        )

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

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

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

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

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

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-11-01T04:52:26.190
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-10-29
        )

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

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

    [rets_street_view_param] => Array
        (
            [0] => 1$21.403741163044$-157.9977572082083$72.57$13.33$1.00$UExPKSy2ECuQioBmmGxPkg
        )

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

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

    [rets_supplement_modification_timestam] => Array
        (
            [0] => 2021-09-09T16:32:04.183
        )

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

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

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

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

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

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

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

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

    [rets_thumbnail_url] => Array
        (
            [0] => https://cdn.rets.ci/marcusrealty-images/16154902/99de0406a886b3c1f2bf465bceebd141
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [tmk] => Array
        (
            [0] => 1-9-4-007-033-0182
        )

    [unit] => Array
        (
            [0] => Even# Unit
        )

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

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

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

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

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

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

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

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

    [new_attached_media] => Array
        (
            [0] => a:63:{i:0;i:20770684;i:1;i:20770685;i:2;i:20770686;i:3;i:20770687;i:4;i:20770688;i:5;i:20770689;i:6;i:20770690;i:7;i:20770691;i:8;i:20770692;i:9;i:20770693;i:10;i:20770694;i:11;i:20770695;i:12;i:20770696;i:13;i:20770697;i:14;i:20770698;i:15;i:20770699;i:16;i:20770700;i:17;i:20770701;i:18;i:20770702;i:19;i:20770703;i:20;i:20770704;i:21;i:20794864;i:22;i:20794865;i:23;i:20794866;i:24;i:20794867;i:25;i:20794868;i:26;i:20794869;i:27;i:20794870;i:28;i:20794871;i:29;i:20794872;i:30;i:20794873;i:31;i:20794874;i:32;i:20794875;i:33;i:20794876;i:34;i:20794877;i:35;i:20794878;i:36;i:20794879;i:37;i:20794880;i:38;i:20794881;i:39;i:20794882;i:40;i:20794883;i:41;i:20794884;i:42;i:21070476;i:43;i:21070477;i:44;i:21070478;i:45;i:21070479;i:46;i:21070480;i:47;i:21070481;i:48;i:21070482;i:49;i:21070483;i:50;i:21070484;i:51;i:21070485;i:52;i:21070486;i:53;i:21070487;i:54;i:21070488;i:55;i:21070489;i:56;i:21070490;i:57;i:21070491;i:58;i:21070492;i:59;i:21070493;i:60;i:21070494;i:61;i:21070495;i:62;i:21070496;}
        )

    [rets_active_continue_to_show_date] => Array
        (
            [0] => 2021-09-21
        )

    [rets_close_date] => Array
        (
            [0] => 2021-10-29
        )

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

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 277-0652
        )

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

    [rets_selling_agent_full_name] => Array
        (
            [0] => Johnny Tu
        )

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

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

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

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

    [rets_selling_office_name] => Array
        (
            [0] => Top Property Management LLC
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 277-0652
        )

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

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

)

  • Bedrooms: 2
  • Full Baths: 1
  • Living (sf): 740
  • Year Built: 1991
  • Building Name: Hoomaka Village

  • Property Condition: Average
  • Number of Parking Spaces: 1
  • Number of Stories: Two
  • View: None
  • Listing Office: Realhome Services & Solutions

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

CONTACT US

Marcus Realty

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