1850 Ala Moana Boulevard Unit 317
Honolulu, HI 96815

Listing
Overview

Price: $255,000
Area: WAIKIKI
Status: Sold

Welcome to Aqua Palms at Waikiki, your opportunity to own a legal vacation rental in a desirable boutique condo hotel. Conveniently located near the world-famous Waikiki beaches, Ala Moana Shopping Center, Hawaii Convention Center, and much more! This unit is recently renovated and features complete hotel furniture, central AC, a Juliet balcony, spacious bathroom, mini fridge, microwave, and coffee maker. Amenities include a pool, sun deck, BBQ area, gym, laundry facility, and concierge. Live in this unit, rent it out yourself, or participate in the hotel rental pool. Current owners participated in the rental pool for many years and have rental statements to share. Great condo for your permanent home, vacation home, or income opportunities. Clean, comfortable, and convenient, a must-see to fully appreciate!

Listing by: Coldwell Banker Realty

array(160) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "164300.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(8) "52300.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "216600.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(16) "Palms At Waikiki"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(29) "Condotel,High-Rise 7+ Stories"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(37) "Mixed Use OK,Property Disclosure Stmt"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(9) "Jefferson"
  }
  ["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"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(2) "14"
  }
  ["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(28) "tiffany.higadoi@cbrealty.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(16) "Tiffany Higa-Doi"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-29"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "255000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "265"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(53) "1850 Ala Moana Boulevard Unit 317, Honolulu, HI 96815"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "503.38"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(10) "Washington"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202125017"
  }
  ["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) "CBPP"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(19) "Other,Secured Entry"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(26) "45 Days or Less,At Closing"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96815"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(21) "Above Average,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(5) "Metro"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "503"
  }
  ["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) "240000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "12"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(9) "Jefferson"
  }
  ["rets_elevators_number_of"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_floor_number"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_fractional_ownership_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_high_school"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16193104"
  }
  ["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) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(28) "tiffany.higadoi@cbrealty.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Tiffany Higa-Doi"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "49382"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "14170151"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "CBPP"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485212"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "255000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-29"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "503.38"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(4) "Aqua"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-947-7256"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-09T08:41:13.460"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16193104"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(10) "Washington"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202125017"
  }
  ["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) "2021-09-30T14:59:58.637"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "255000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-2-6-012-003-0043"
  }
  ["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) "16"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-01T15:44:13.640"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96815"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-01T15:22:10.057"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16193104"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(285) "Please email tiffany.higadoi@cbrealty.com or text for all showings. The preferred showing time is between 1 pm to 3 pm during check-ins. For escrow, seller requests Craig Endo with Old Republic Title, cendo@ortc.com. Please include As Is & Coldwell Banker Addendum with offers. Mahalo!"
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(818) "Welcome to Aqua Palms at Waikiki, your opportunity to own a legal vacation rental in a desirable boutique condo hotel. Conveniently located near the world-famous Waikiki beaches, Ala Moana Shopping Center, Hawaii Convention Center, and much more! This unit is recently renovated and features complete hotel furniture, central AC, a Juliet balcony, spacious bathroom, mini fridge, microwave, and coffee maker. Amenities include a pool, sun deck, BBQ area, gym, laundry facility, and concierge. Live in this unit, rent it out yourself, or participate in the hotel rental pool. Current owners participated in the rental pool for many years and have rental statements to share. Great condo for your permanent home, vacation home, or income opportunities. Clean, comfortable, and convenient, a must-see to fully appreciate!"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(2) "14"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "251"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "265"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-09T08:41:13.460"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-08"
  }
  ["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(106) "1$21.285009$-157.836578$324.07$13.33$1.00$CAoSKkFGMVFpcE52WV9MZ1ZVdFE1NWJWQUVuaDVqZlIwM2J2cWNxcURFSm5pdw.."
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "254.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "216600.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "164300.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(8) "52300.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_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16193104/e27c2bab5a136fb9e18e6ead43fabc61"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "126"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(2) "43"
  }
  ["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) "317"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1970"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(21) "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-0043"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(77) "Bedroom on 1st Level,Central AC,Full Bath on 1st Floor,Odd# Unit,Single Level"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(3) "317"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(4) "City"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16193104"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202125017"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1636483311"
  }
  ["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(1533) "a:96:{i:0;i:20883240;i:1;i:20883241;i:2;i:20883242;i:3;i:20883243;i:4;i:20883244;i:5;i:20883245;i:6;i:20883246;i:7;i:20883247;i:8;i:20883248;i:9;i:20883249;i:10;i:20883250;i:11;i:20883251;i:12;i:20883252;i:13;i:20883253;i:14;i:20883254;i:15;i:20883255;i:16;i:20883479;i:17;i:20883480;i:18;i:20883481;i:19;i:20883482;i:20;i:20883483;i:21;i:20883484;i:22;i:20883485;i:23;i:20883486;i:24;i:20883487;i:25;i:20883488;i:26;i:20883489;i:27;i:20883490;i:28;i:20883491;i:29;i:20883492;i:30;i:20883493;i:31;i:20883494;i:32;i:20883495;i:33;i:20883496;i:34;i:20883497;i:35;i:20883498;i:36;i:20883499;i:37;i:20883500;i:38;i:20883501;i:39;i:20883502;i:40;i:20883503;i:41;i:20883504;i:42;i:20883505;i:43;i:20883506;i:44;i:20883507;i:45;i:20883508;i:46;i:20883509;i:47;i:20883510;i:48;i:20883556;i:49;i:20883557;i:50;i:20883558;i:51;i:20883559;i:52;i:20883560;i:53;i:20883561;i:54;i:20883562;i:55;i:20883563;i:56;i:20883564;i:57;i:20883565;i:58;i:20883566;i:59;i:20883567;i:60;i:20883568;i:61;i:20883569;i:62;i:20883570;i:63;i:20883571;i:64;i:20945491;i:65;i:20945492;i:66;i:20945493;i:67;i:20945494;i:68;i:20945495;i:69;i:20945496;i:70;i:20945497;i:71;i:20945498;i:72;i:20945499;i:73;i:20945500;i:74;i:20945501;i:75;i:20945502;i:76;i:20945503;i:77;i:20945504;i:78;i:20945505;i:79;i:20945506;i:80;i:21124276;i:81;i:21124277;i:82;i:21124278;i:83;i:21124279;i:84;i:21124280;i:85;i:21124281;i:86;i:21124282;i:87;i:21124283;i:88;i:21124284;i:89;i:21124285;i:90;i:21124286;i:91;i:21124287;i:92;i:21124288;i:93;i:21124289;i:94;i:21124290;i:95;i:21124291;}"
  }
  ["rets_supplement_count"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_supplement_modification_timestam"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-01T15:53:56.000"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-09"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "3048.00"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-08"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "240000.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-09-29"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-08"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 946-2980"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "oliviayoon808@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(11) "Olivia Yoon"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "43789"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3483817"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "GREE"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "9676855"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(17) "Green Tree Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 946-2980"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21124276"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 164300.00
        )

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

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

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

    [building_name] => Array
        (
            [0] => Palms At Waikiki
        )

    [building_style] => Array
        (
            [0] => Condotel,High-Rise 7+ Stories
        )

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

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

    [disclosures] => Array
        (
            [0] => Mixed Use OK,Property Disclosure Stmt
        )

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

    [floor_covering] => Array
        (
            [0] => Ceramic Tile,W/W Carpet
        )

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

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

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

    [high_school] => Array
        (
            [0] => Kaimuki
        )

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

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

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

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

    [list_agent_email] => Array
        (
            [0] => tiffany.higadoi@cbrealty.com
        )

    [list_agent_name] => Array
        (
            [0] => Tiffany Higa-Doi
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 596-0456
        )

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

    [list_office_name] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

    [location] => Array
        (
            [0] => 1850 Ala Moana Boulevard Unit 317, Honolulu, HI 96815
        )

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

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

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

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

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

    [number_of_stories] => Array
        (
            [0] => 8-14
        )

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

    [parking_features] => Array
        (
            [0] => Other,Secured Entry
        )

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

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

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

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

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

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

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

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

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

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

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

    [rets_elevators_number_of] => Array
        (
            [0] => 3
        )

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

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

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

    [rets_high_school] => Array
        (
            [0] => Kaimuki
        )

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

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

    [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) 596-0456
        )

    [rets_list_agent_email] => Array
        (
            [0] => tiffany.higadoi@cbrealty.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Tiffany Higa-Doi
        )

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

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

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

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

    [rets_list_office_name] => Array
        (
            [0] => Coldwell Banker Realty
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 596-0456
        )

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

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

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

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

    [rets_management_company_phone] => Array
        (
            [0] => 808-947-7256
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-11-09T08:41:13.460
        )

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

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

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

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

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

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-09-30T14:59:58.637
        )

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

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

    [rets_parcel_number] => Array
        (
            [0] => 1-2-6-012-003-0043
        )

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

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-10-01T15:44:13.640
        )

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

    [rets_price_change_timestamp] => Array
        (
            [0] => 2021-10-01T15:22:10.057
        )

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

    [rets_private_remarks] => Array
        (
            [0] => Please email tiffany.higadoi@cbrealty.com or text for all showings. The preferred showing time is between 1 pm to 3 pm during check-ins. For escrow, seller requests Craig Endo with Old Republic Title, cendo@ortc.com. Please include As Is & Coldwell Banker Addendum with offers. Mahalo!
        )

    [rets_public_remarks] => Array
        (
            [0] => Welcome to Aqua Palms at Waikiki, your opportunity to own a legal vacation rental in a desirable boutique condo hotel. Conveniently located near the world-famous Waikiki beaches, Ala Moana Shopping Center, Hawaii Convention Center, and much more! This unit is recently renovated and features complete hotel furniture, central AC, a Juliet balcony, spacious bathroom, mini fridge, microwave, and coffee maker. Amenities include a pool, sun deck, BBQ area, gym, laundry facility, and concierge. Live in this unit, rent it out yourself, or participate in the hotel rental pool. Current owners participated in the rental pool for many years and have rental statements to share. Great condo for your permanent home, vacation home, or income opportunities. Clean, comfortable, and convenient, a must-see to fully appreciate!
        )

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

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

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

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

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-11-09T08:41:13.460
        )

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

    [rets_street_name] => Array
        (
            [0] => Ala Moana
        )

    [rets_street_number] => Array
        (
            [0] => 1850
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.285009$-157.836578$324.07$13.33$1.00$CAoSKkFGMVFpcE52WV9MZ1ZVdFE1NWJWQUVuaDVqZlIwM2J2cWNxcURFSm5pdw..
        )

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

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

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

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

    [rets_tax_assessed_value_land] => Array
        (
            [0] => 52300.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_thumbnail_url] => Array
        (
            [0] => https://cdn.rets.ci/marcusrealty-images/16193104/e27c2bab5a136fb9e18e6ead43fabc61
        )

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

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

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

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

    [security] => Array
        (
            [0] => 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-0043
        )

    [unit] => Array
        (
            [0] => Bedroom on 1st Level,Central AC,Full Bath on 1st Floor,Odd# Unit,Single Level
        )

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

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

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

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

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

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

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

    [zoning] => Array
        (
            [0] => AM - Apartment Mixed Use
        )

    [new_attached_media] => Array
        (
            [0] => a:96:{i:0;i:20883240;i:1;i:20883241;i:2;i:20883242;i:3;i:20883243;i:4;i:20883244;i:5;i:20883245;i:6;i:20883246;i:7;i:20883247;i:8;i:20883248;i:9;i:20883249;i:10;i:20883250;i:11;i:20883251;i:12;i:20883252;i:13;i:20883253;i:14;i:20883254;i:15;i:20883255;i:16;i:20883479;i:17;i:20883480;i:18;i:20883481;i:19;i:20883482;i:20;i:20883483;i:21;i:20883484;i:22;i:20883485;i:23;i:20883486;i:24;i:20883487;i:25;i:20883488;i:26;i:20883489;i:27;i:20883490;i:28;i:20883491;i:29;i:20883492;i:30;i:20883493;i:31;i:20883494;i:32;i:20883495;i:33;i:20883496;i:34;i:20883497;i:35;i:20883498;i:36;i:20883499;i:37;i:20883500;i:38;i:20883501;i:39;i:20883502;i:40;i:20883503;i:41;i:20883504;i:42;i:20883505;i:43;i:20883506;i:44;i:20883507;i:45;i:20883508;i:46;i:20883509;i:47;i:20883510;i:48;i:20883556;i:49;i:20883557;i:50;i:20883558;i:51;i:20883559;i:52;i:20883560;i:53;i:20883561;i:54;i:20883562;i:55;i:20883563;i:56;i:20883564;i:57;i:20883565;i:58;i:20883566;i:59;i:20883567;i:60;i:20883568;i:61;i:20883569;i:62;i:20883570;i:63;i:20883571;i:64;i:20945491;i:65;i:20945492;i:66;i:20945493;i:67;i:20945494;i:68;i:20945495;i:69;i:20945496;i:70;i:20945497;i:71;i:20945498;i:72;i:20945499;i:73;i:20945500;i:74;i:20945501;i:75;i:20945502;i:76;i:20945503;i:77;i:20945504;i:78;i:20945505;i:79;i:20945506;i:80;i:21124276;i:81;i:21124277;i:82;i:21124278;i:83;i:21124279;i:84;i:21124280;i:85;i:21124281;i:86;i:21124282;i:87;i:21124283;i:88;i:21124284;i:89;i:21124285;i:90;i:21124286;i:91;i:21124287;i:92;i:21124288;i:93;i:21124289;i:94;i:21124290;i:95;i:21124291;}
        )

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

    [rets_supplement_modification_timestam] => Array
        (
            [0] => 2021-10-01T15:53:56.000
        )

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

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

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

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

    [rets_expiration_date] => Array
        (
            [0] => 2022-09-29
        )

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

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 946-2980
        )

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

    [rets_selling_agent_full_name] => Array
        (
            [0] => Olivia Yoon
        )

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

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

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

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

    [rets_selling_office_name] => Array
        (
            [0] => Green Tree Realty
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 946-2980
        )

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

)

  • Full Baths: 1
  • Living (sf): 265
  • Year Built: 1970
  • Building Name: Palms At Waikiki

  • Property Condition: Above Average,Average
  • Number of Stories: 8-14
  • View: City
  • Listing Office: Coldwell Banker Realty

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

  • Elementary School: Jefferson
  • Middle School: Washington
  • High School: Kaimuki

CONTACT US

Marcus Realty

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