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.
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
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446