1850 Ala Moana Boulevard Unit 202
Honolulu, HI 96815

Take a Virtual Tour

Listing
Overview

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

An exclusive new corner-end listing with immediate access to the swimming pool at Palms at Waikiki! Fully renovated (2020) extra-large studio unit on the same floor as the amenities with the fitness center, swimming pool, ice, and vending machines. Quality features include newer carpet, king-size bed, popcorn removal, interior paint, and one of the few ADA accessible vacation rental units in Waikiki. Palms at Waikiki is a higher-end boutique condo-hotel (RARE CENTRAL AC) in Waikiki with high hotel occupancy and short distances to Waikiki beach, Hilton Hawaiian Village, Ala Moana Shopping Mall, and numerous shops and restaurants. Maintenance fees include central AC, electricity, internet, cable TV, water, & sewer. 2nd floor but 5 stories above ground level. Put in hotel pool or self-manage.

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

  • Property Condition: Excellent
  • Number of Stories: 15-20
  • View: City
  • Listing Office: Coldwell Banker Realty

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

CONTACT US

Marcus Realty

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

array(151) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "284800.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(8) "75100.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "359900.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"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(12) "Mixed Use OK"
  }
  ["exclusions"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["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"
  }
  ["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(31) "andrew.leitheiser@cbpacific.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(19) "Andrew J Leitheiser"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-03"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "279000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "360"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(53) "1850 Ala Moana Boulevard Unit 202, Honolulu, HI 96815"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "721.29"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202110412"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(5) "15-20"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "CBPP"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(42) "45 Days or Less,45 Days or More,At Closing"
  }
  ["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) "721"
  }
  ["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) "279000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elevators_number_of"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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) "15880878"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(31) "andrew.leitheiser@cbpacific.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(19) "Andrew J Leitheiser"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "44892"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9335109"
  }
  ["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) "279000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-03"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "721.29"
  }
  ["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-07-22T08:19:48.780"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15880878"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202110412"
  }
  ["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-05-03T08:22:36.247"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "279000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-2-6-012-003-0007"
  }
  ["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-05-03T08:33:45.917"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96815"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15880878"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(391) "Please email andrew.leitheiser@cbrealty.com or text for all showings. The preferred time is between 1 pm to 3 pm during check-ins. #202 is a special unit with immediate access to the swimming pool, ADA accessible, and a larger floorplan. Please consider Nicole Yasuda with First American and include As-Is & Coldwell Banker Addendum for offers. 2nd floor but 5 stories from the ground level."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(800) "An exclusive new corner-end listing with immediate access to the swimming pool at Palms at Waikiki! Fully renovated (2020) extra-large studio unit on the same floor as the amenities with the fitness center, swimming pool, ice, and vending machines. Quality features include newer carpet, king-size bed, popcorn removal, interior paint, and one of the few ADA accessible vacation rental units in Waikiki. Palms at Waikiki is a higher-end boutique condo-hotel (RARE CENTRAL AC) in Waikiki with high hotel occupancy and short distances to Waikiki beach, Hilton Hawaiian Village, Ala Moana Shopping Mall, and numerous shops and restaurants. Maintenance fees include central AC, electricity, internet, cable TV, water, & sewer. 2nd floor but 5 stories above ground level. Put in hotel pool or self-manage."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "360"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "360"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-22T08:19:48.780"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-22"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(9) "Ala Moana"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(4) "1850"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(2) "3%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "422.49"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "359900.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "284800.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(8) "75100.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) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/15880878/81535ab7704d1398ff2fd937a59eef31"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "126"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(1) "7"
  }
  ["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) "202"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1970"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(30) "Card,Key,Security Patrol,Video"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(26) "Cash,Conventional,Exchange"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-2-6-012-003-0007"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(60) "ADA Accessible,Central AC,Corner/End,Even# Unit,Single Level"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(4) "City"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15880878"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202110412"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628910473"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1970"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(24) "AM - Apartment Mixed Use"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1802) "a:112:{i:0;i:19916805;i:1;i:19916806;i:2;i:19916807;i:3;i:19916808;i:4;i:19916809;i:5;i:19916810;i:6;i:19916811;i:7;i:19916812;i:8;i:19916813;i:9;i:19916814;i:10;i:19916815;i:11;i:19916816;i:12;i:19916817;i:13;i:19916818;i:14;i:19916819;i:15;i:19916820;i:16;i:19916878;i:17;i:19916879;i:18;i:19916880;i:19;i:19916881;i:20;i:19916882;i:21;i:19916883;i:22;i:19916884;i:23;i:19916885;i:24;i:19916886;i:25;i:19916887;i:26;i:19916888;i:27;i:19916889;i:28;i:19916890;i:29;i:19916891;i:30;i:19916892;i:31;i:19916893;i:32;i:19917074;i:33;i:19917075;i:34;i:19917076;i:35;i:19917077;i:36;i:19917078;i:37;i:19917079;i:38;i:19917080;i:39;i:19917081;i:40;i:19917082;i:41;i:19917083;i:42;i:19917084;i:43;i:19917085;i:44;i:19917086;i:45;i:19917087;i:46;i:19917088;i:47;i:19917089;i:48;i:19917112;i:49;i:19917113;i:50;i:19917114;i:51;i:19917115;i:52;i:19917116;i:53;i:19917117;i:54;i:19917118;i:55;i:19917119;i:56;i:19917120;i:57;i:19917121;i:58;i:19917122;i:59;i:19917123;i:60;i:19917124;i:61;i:19917125;i:62;i:19917126;i:63;i:19917127;i:64;i:20036095;i:65;i:20036096;i:66;i:20036097;i:67;i:20036098;i:68;i:20036099;i:69;i:20036100;i:70;i:20036101;i:71;i:20036102;i:72;i:20036103;i:73;i:20036104;i:74;i:20036105;i:75;i:20036106;i:76;i:20036107;i:77;i:20036108;i:78;i:20036109;i:79;i:20036110;i:80;i:20159858;i:81;i:20159859;i:82;i:20159860;i:83;i:20159861;i:84;i:20159862;i:85;i:20159863;i:86;i:20159864;i:87;i:20159865;i:88;i:20159866;i:89;i:20159867;i:90;i:20159868;i:91;i:20159869;i:92;i:20159870;i:93;i:20159871;i:94;i:20159872;i:95;i:20159873;i:96;i:20283987;i:97;i:20283988;i:98;i:20283989;i:99;i:20283990;i:100;i:20283991;i:101;i:20283992;i:102;i:20283993;i:103;i:20283994;i:104;i:20283995;i:105;i:20283996;i:106;i:20283997;i:107;i:20283998;i:108;i:20283999;i:109;i:20284000;i:110;i:20284001;i:111;i:20284002;}"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(106) "1$21.285009$-157.836578$324.07$13.33$1.00$CAoSKkFGMVFpcE52WV9MZ1ZVdFE1NWJWQUVuaDVqZlIwM2J2cWNxcURFSm5pdw.."
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(62) "https://tours.360aaa.net/public/vtour/display/1825382?idx=1#!/"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(62) "https://tours.360aaa.net/public/vtour/display/1825382?idx=1#!/"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96815"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-13"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-13"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["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"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(3) "202"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-22"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "279000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-22"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 593-7705"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(22) "herwinh@iprealtors.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(13) "Herwin C Hung"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "16298"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8808829"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "DTHH"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "9444378"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(30) "Island Pacific Real Estate LLC"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 593-7705"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20283987"
  }
}