The unit is facing to cool and quite side, you may relax at the larger lanai. Rarely available the unit has a king size bed. Aqua Palms Waikiki is conveniently located at the gateway to Waikiki, and also close to Ala Moana Center, Duke Kahanamoku Lagoon, and Fort DeRussy. There are on-site amenities including BBQ, a pool and sun deck and restaurant. Guest rooms were newly renovated in 2020 with carpet, cabinet, closet, furniture, curtain, and fresh paint. There are microwave and refrigerator at the kitchenette. Tastefully furnished and decorated by the earth color which makes Hawaiian & contemporary style. There are sprinklers and wired smoke detectors are in the building. The unit is currently in the hotel rental pool which is managed by Aqua Aston. New owner can take over or manage by itself.
Listing by: Locations LLC
array(153) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "185900.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(8) "56700.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "242600.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "0"
}
["building_name"]=>
array(1) {
[0]=>
string(16) "Palms At Waikiki"
}
["building_style"]=>
array(1) {
[0]=>
string(8) "Condotel"
}
["city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(57) "1031 Exchange,Non Resident Owner,Property Disclosure Stmt"
}
["floor_covering"]=>
array(1) {
[0]=>
string(23) "Ceramic Tile,W/W Carpet"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "Full"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(2) "47"
}
["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(33) "angela.brenna@locationshawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(20) "Angela Hiroko Brenna"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-07-08"
}
["list_office_name"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "289000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "319"
}
["location"]=>
array(1) {
[0]=>
string(53) "1850 Ala Moana Boulevard Unit 415, Honolulu, HI 96815"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "557.00"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202213037"
}
["neighborhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "0"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(4) "8-14"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "LOCA"
}
["parking_features"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96815"
}
["property_condition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["property_type"]=>
array(1) {
[0]=>
string(15) "condo_townhouse"
}
["property_type_label"]=>
array(1) {
[0]=>
string(15) "Condo Townhouse"
}
["region"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "557"
}
["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) "0"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(16) "Palms At Waikiki"
}
["rets_city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "290000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "4"
}
["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) "16748762"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(33) "angela.brenna@locationshawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(20) "Angela Hiroko Brenna"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "29722"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3478204"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "LOCA"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3485305"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "289000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-07-08"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "557.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(10) "Aqua Aston"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-947-7256"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-08-16T15:57:49.517"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16748762"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202213037"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-08T09:10:24.937"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "289000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-2-6-012-003-0067"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_permit_address_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_permit_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_photo_count"]=>
array(1) {
[0]=>
string(2) "21"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-08T09:10:24.937"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96815"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-08T09:10:24.937"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16748762"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(56) "Please call front desk to set up showing at 808-947-7256"
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(805) "The unit is facing to cool and quite side, you may relax at the larger lanai. Rarely available the unit has a king size bed. Aqua Palms Waikiki is conveniently located at the gateway to Waikiki, and also close to Ala Moana Center, Duke Kahanamoku Lagoon, and Fort DeRussy. There are on-site amenities including BBQ, a pool and sun deck and restaurant. Guest rooms were newly renovated in 2020 with carpet, cabinet, closet, furniture, curtain, and fresh paint. There are microwave and refrigerator at the kitchenette. Tastefully furnished and decorated by the earth color which makes Hawaiian & contemporary style. There are sprinklers and wired smoke detectors are in the building. The unit is currently in the hotel rental pool which is managed by Aqua Aston. New owner can take over or manage by itself."
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(2) "47"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "272"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "319"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-08-16T15:57:49.517"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-08-16"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(9) "Ala Moana"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(4) "1850"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(105) "1$21.28501$-157.836578$324.16$13.33$1.00$CAoSKkFGMVFpcE52WV9MZ1ZVdFE1NWJWQUVuaDVqZlIwM2J2cWNxcURFSm5pdw.."
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(4) "2.5%"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-07-07T16:44:20.247"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "269.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "3228.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "242600.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "185900.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(8) "56700.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16748762/26ce00155f2db062365903627b42f26e"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "126"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "67"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "6"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "12"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(3) "415"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1970"
}
["security"]=>
array(1) {
[0]=>
string(26) "Card,Security Patrol,Video"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(9) "Ala Moana"
}
["street_number"]=>
array(1) {
[0]=>
string(4) "1850"
}
["street_suffix"]=>
array(1) {
[0]=>
string(9) "Boulevard"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-2-6-012-003-0067"
}
["unit"]=>
array(1) {
[0]=>
string(44) "Bedroom on 1st Level,Central AC,Single Level"
}
["unit_number"]=>
array(1) {
[0]=>
string(3) "415"
}
["view"]=>
array(1) {
[0]=>
string(4) "City"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16748762"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202213037"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1660701514"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1970"
}
["zoning"]=>
array(1) {
[0]=>
string(24) "AM - Apartment Mixed Use"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1005) "a:63:{i:0;i:22661706;i:1;i:22661707;i:2;i:22661708;i:3;i:22661709;i:4;i:22661710;i:5;i:22661711;i:6;i:22661712;i:7;i:22661713;i:8;i:22661714;i:9;i:22661715;i:10;i:22661716;i:11;i:22661717;i:12;i:22661718;i:13;i:22661719;i:14;i:22661720;i:15;i:22661721;i:16;i:22661722;i:17;i:22661723;i:18;i:22661724;i:19;i:22661725;i:20;i:22661726;i:21;i:22707581;i:22;i:22707582;i:23;i:22707583;i:24;i:22707584;i:25;i:22707585;i:26;i:22707586;i:27;i:22707587;i:28;i:22707588;i:29;i:22707589;i:30;i:22707590;i:31;i:22707591;i:32;i:22707592;i:33;i:22707593;i:34;i:22707594;i:35;i:22707595;i:36;i:22707596;i:37;i:22707597;i:38;i:22707598;i:39;i:22707599;i:40;i:22707600;i:41;i:22707601;i:42;i:23073015;i:43;i:23073016;i:44;i:23073017;i:45;i:23073018;i:46;i:23073019;i:47;i:23073020;i:48;i:23073021;i:49;i:23073022;i:50;i:23073023;i:51;i:23073024;i:52;i:23073025;i:53;i:23073026;i:54;i:23073027;i:55;i:23073028;i:56;i:23073029;i:57;i:23073030;i:58;i:23073031;i:59;i:23073032;i:60;i:23073033;i:61;i:23073034;i:62;i:23073035;}"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-07-12"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-08-16"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "290000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-07-07"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-08-16"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 676-7200"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(29) "Florence.Calica@cbpacific.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(17) "Florence Y Calica"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "29304"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3478049"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(6) "CBPP15"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "12345774"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 676-7200"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "23073015"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 185900.00
)
[assd_val_land] => Array
(
[0] => 56700.00
)
[assd_val_total] => Array
(
[0] => 242600.00
)
[bedrooms] => Array
(
[0] => 0
)
[building_name] => Array
(
[0] => Palms At Waikiki
)
[building_style] => Array
(
[0] => Condotel
)
[city] => Array
(
[0] => Honolulu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => 1031 Exchange,Non Resident Owner,Property Disclosure Stmt
)
[floor_covering] => Array
(
[0] => Ceramic Tile,W/W Carpet
)
[full_baths] => Array
(
[0] => 1
)
[furnished] => Array
(
[0] => Full
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 0
)
[lanai_sf] => Array
(
[0] => 47
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => angela.brenna@locationshawaii.com
)
[list_agent_name] => Array
(
[0] => Angela Hiroko Brenna
)
[list_agent_phone_number] => Array
(
[0] => (808) 735-4200
)
[list_date] => Array
(
[0] => 2022-07-08
)
[list_office_name] => Array
(
[0] => Locations LLC
)
[list_price] => Array
(
[0] => 289000.00
)
[living_sf] => Array
(
[0] => 319
)
[location] => Array
(
[0] => 1850 Ala Moana Boulevard Unit 415, Honolulu, HI 96815
)
[maintenance_fees] => Array
(
[0] => 557.00
)
[mls_] => Array
(
[0] => 202213037
)
[neighborhood] => Array
(
[0] => WAIKIKI
)
[number_of_parking_spaces] => Array
(
[0] => 0
)
[number_of_stories] => Array
(
[0] => 8-14
)
[office_mls_id] => Array
(
[0] => LOCA
)
[parking_features] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96815
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Metro
)
[rets_association_fee_total] => Array
(
[0] => 557
)
[rets_baths_full] => Array
(
[0] => 1
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 1.00
)
[rets_beds_total] => Array
(
[0] => 0
)
[rets_building_name] => Array
(
[0] => Palms At Waikiki
)
[rets_city] => Array
(
[0] => Honolulu
)
[rets_condo_parking_unit] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 290000.00
)
[rets_dom] => Array
(
[0] => 5
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_floor_number] => Array
(
[0] => 4
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16748762
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 0
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 735-4200
)
[rets_list_agent_email] => Array
(
[0] => angela.brenna@locationshawaii.com
)
[rets_list_agent_full_name] => Array
(
[0] => Angela Hiroko Brenna
)
[rets_list_agent_mlsid] => Array
(
[0] => 29722
)
[rets_list_agent_mui] => Array
(
[0] => 3478204
)
[rets_list_office_mlsid] => Array
(
[0] => LOCA
)
[rets_list_office_mui] => Array
(
[0] => 3485305
)
[rets_list_office_name] => Array
(
[0] => Locations LLC
)
[rets_list_office_phone] => Array
(
[0] => (808) 735-4200
)
[rets_list_price] => Array
(
[0] => 289000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-07-08
)
[rets_maintenance_expense] => Array
(
[0] => 557.00
)
[rets_management_company_name] => Array
(
[0] => Aqua Aston
)
[rets_management_company_phone] => Array
(
[0] => 808-947-7256
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-08-16T15:57:49.517
)
[rets_matrix_unique_id] => Array
(
[0] => 16748762
)
[rets_mls_number] => Array
(
[0] => 202213037
)
[rets_neighbourhood] => Array
(
[0] => WAIKIKI
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-07-08T09:10:24.937
)
[rets_original_list_price] => Array
(
[0] => 289000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 2
)
[rets_parcel_number] => Array
(
[0] => 1-2-6-012-003-0067
)
[rets_parking_additional] => Array
(
[0] => 0
)
[rets_parking_total] => Array
(
[0] => 0
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 21
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-07-08T09:10:24.937
)
[rets_postal_code] => Array
(
[0] => 96815
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-07-08T09:10:24.937
)
[rets_primary_key] => Array
(
[0] => 16748762
)
[rets_private_remarks] => Array
(
[0] => Please call front desk to set up showing at 808-947-7256
)
[rets_public_remarks] => Array
(
[0] => The unit is facing to cool and quite side, you may relax at the larger lanai. Rarely available the unit has a king size bed. Aqua Palms Waikiki is conveniently located at the gateway to Waikiki, and also close to Ala Moana Center, Duke Kahanamoku Lagoon, and Fort DeRussy. There are on-site amenities including BBQ, a pool and sun deck and restaurant. Guest rooms were newly renovated in 2020 with carpet, cabinet, closet, furniture, curtain, and fresh paint. There are microwave and refrigerator at the kitchenette. Tastefully furnished and decorated by the earth color which makes Hawaiian & contemporary style. There are sprinklers and wired smoke detectors are in the building. The unit is currently in the hotel rental pool which is managed by Aqua Aston. New owner can take over or manage by itself.
)
[rets_sqft_lanai_open] => Array
(
[0] => 47
)
[rets_sqft_roofed_living] => Array
(
[0] => 272
)
[rets_sqft_total] => Array
(
[0] => 319
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-08-16T15:57:49.517
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-08-16
)
[rets_street_name] => Array
(
[0] => Ala Moana
)
[rets_street_number] => Array
(
[0] => 1850
)
[rets_street_view_param] => Array
(
[0] => 1$21.28501$-157.836578$324.16$13.33$1.00$CAoSKkFGMVFpcE52WV9MZ1ZVdFE1NWJWQUVuaDVqZlIwM2J2cWNxcURFSm5pdw..
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5%
)
[rets_supplement_count] => Array
(
[0] => 2
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-07-07T16:44:20.247
)
[rets_tax_amount] => Array
(
[0] => 269.00
)
[rets_tax_annual_amount] => Array
(
[0] => 3228.00
)
[rets_tax_assessed_value] => Array
(
[0] => 242600.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 185900.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 56700.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 1
)
[rets_tax_year] => Array
(
[0] => 2021
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16748762/26ce00155f2db062365903627b42f26e
)
[rets_tmk_area] => Array
(
[0] => 126
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 67
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 3
)
[rets_tmk_section] => Array
(
[0] => 6
)
[rets_tmk_zone] => Array
(
[0] => 2
)
[rets_tmkplat] => Array
(
[0] => 12
)
[rets_unit_number] => Array
(
[0] => 415
)
[rets_year_built] => Array
(
[0] => 1970
)
[security] => Array
(
[0] => Card,Security Patrol,Video
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Ala Moana
)
[street_number] => Array
(
[0] => 1850
)
[street_suffix] => Array
(
[0] => Boulevard
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-2-6-012-003-0067
)
[unit] => Array
(
[0] => Bedroom on 1st Level,Central AC,Single Level
)
[unit_number] => Array
(
[0] => 415
)
[view] => Array
(
[0] => City
)
[wpp::rets_pk] => Array
(
[0] => 16748762
)
[wpp_gpid] => Array
(
[0] => 202213037
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1660701514
)
[year_built] => Array
(
[0] => 1970
)
[zoning] => Array
(
[0] => AM - Apartment Mixed Use
)
[new_attached_media] => Array
(
[0] => a:63:{i:0;i:22661706;i:1;i:22661707;i:2;i:22661708;i:3;i:22661709;i:4;i:22661710;i:5;i:22661711;i:6;i:22661712;i:7;i:22661713;i:8;i:22661714;i:9;i:22661715;i:10;i:22661716;i:11;i:22661717;i:12;i:22661718;i:13;i:22661719;i:14;i:22661720;i:15;i:22661721;i:16;i:22661722;i:17;i:22661723;i:18;i:22661724;i:19;i:22661725;i:20;i:22661726;i:21;i:22707581;i:22;i:22707582;i:23;i:22707583;i:24;i:22707584;i:25;i:22707585;i:26;i:22707586;i:27;i:22707587;i:28;i:22707588;i:29;i:22707589;i:30;i:22707590;i:31;i:22707591;i:32;i:22707592;i:33;i:22707593;i:34;i:22707594;i:35;i:22707595;i:36;i:22707596;i:37;i:22707597;i:38;i:22707598;i:39;i:22707599;i:40;i:22707600;i:41;i:22707601;i:42;i:23073015;i:43;i:23073016;i:44;i:23073017;i:45;i:23073018;i:46;i:23073019;i:47;i:23073020;i:48;i:23073021;i:49;i:23073022;i:50;i:23073023;i:51;i:23073024;i:52;i:23073025;i:53;i:23073026;i:54;i:23073027;i:55;i:23073028;i:56;i:23073029;i:57;i:23073030;i:58;i:23073031;i:59;i:23073032;i:60;i:23073033;i:61;i:23073034;i:62;i:23073035;}
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-07-12
)
[rets_close_date] => Array
(
[0] => 2022-08-16
)
[rets_close_price] => Array
(
[0] => 290000.00
)
[rets_expiration_date] => Array
(
[0] => 2023-07-07
)
[rets_off_market_date] => Array
(
[0] => 2022-08-16
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 676-7200
)
[rets_selling_agent_email] => Array
(
[0] => Florence.Calica@cbpacific.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Florence Y Calica
)
[rets_selling_agent_mlsid] => Array
(
[0] => 29304
)
[rets_selling_agent_mui] => Array
(
[0] => 3478049
)
[rets_selling_office_mlsid] => Array
(
[0] => CBPP15
)
[rets_selling_office_mui] => Array
(
[0] => 12345774
)
[rets_selling_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_selling_office_phone] => Array
(
[0] => (808) 676-7200
)
[_thumbnail_id] => Array
(
[0] => 23073015
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446