Stunning Oceanview Condo in highly desirable Waikiki Beach Tower! Located directly in front of Kuhio Beach with endless, unobstructed views of the Pacific Ocean, Koolau Mountain Range, and picturesque Diamond Head, this condo-hotel has it all. Enjoy epic sunsets on the spacious lanai or sip your morning coffee watching surfers glide across the gentle waves. Featuring 2 Bedrooms, 2 bathrooms, a full kitchen with updated appliances, an in-unit washer and dryer, and an assigned parking stall for all your daily needs. Renting out your unit nightly with the Aqua-Aston Hotel Program provides income potential yet flexibility to stay in the unit while you’re in town. Top tier amenities include heated pool, jacuzzi, full gym, yoga studio, conference rooms, lounge, BBQ lanai and cabanas, and 24 hr valet and concierge. Give us a call today, you won’t want to miss this incredible opportunity in Waikiki’s premier condo-hotel!
Listing by: Compass (808) 825-4277
array(173) {
["agency"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(10) "1429600.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "227800.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1657400.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "2"
}
["building_name"]=>
array(1) {
[0]=>
string(19) "Waikiki Beach Tower"
}
["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(46) "Pets Allowed (Verify),Property Disclosure Stmt"
}
["elementary_school"]=>
array(1) {
[0]=>
string(9) "Jefferson"
}
["floor_covering"]=>
array(1) {
[0]=>
string(29) "Ceramic Tile,Vinyl,W/W Carpet"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["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(3) "160"
}
["land_recorded"]=>
array(1) {
[0]=>
string(14) "Regular System"
}
["land_tenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["list_agent_email"]=>
array(1) {
[0]=>
string(23) "alesia@barneshawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(15) "Alesia D Barnes"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-06-18"
}
["list_office_name"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "2200000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1310"
}
["location"]=>
array(1) {
[0]=>
string(50) "2470 Kalakaua Avenue Unit 2501, Honolulu, HI 96815"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(7) "1846.90"
}
["middle_school"]=>
array(1) {
[0]=>
string(10) "Washington"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202211727"
}
["neighborhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "1"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "21+"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["parking_features"]=>
array(1) {
[0]=>
string(20) "Assigned,Covered - 1"
}
["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_2"]=>
array(1) {
[0]=>
string(3) "686"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(4) "2533"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "2.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(19) "Waikiki Beach Tower"
}
["rets_city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(22) "aaron@barneshawaii.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Aaron D Businger"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "46150"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "10057564"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(8) "15465233"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(2) "95"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "2200000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "3"
}
["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) "4"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(2) "25"
}
["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) "16712283"
}
["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) 825-4277"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(23) "alesia@barneshawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Alesia D Barnes"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "43678"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3483745"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "15465233"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "2200000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-06-18"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(7) "1846.90"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(10) "Aqua-Aston"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-931-1577"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-07-22T09:00:15.137"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16712283"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(10) "Washington"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202211727"
}
["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-06-18T08:44:58.760"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "2200000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-2-6-023-007-0079"
}
["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) "2022-06-18T08:44:58.760"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96815"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-18T08:44:58.760"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16712283"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(209) "Please use ShowingTime for all showing requests. For all other questions, please call/text Aaron Businger at 808-429-2353. Monthly HOA Fee - $1,846.90, Easement Rent - $315.84, Reserve Contribution - $370.30."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(926) "Stunning Oceanview Condo in highly desirable Waikiki Beach Tower! Located directly in front of Kuhio Beach with endless, unobstructed views of the Pacific Ocean, Koolau Mountain Range, and picturesque Diamond Head, this condo-hotel has it all. Enjoy epic sunsets on the spacious lanai or sip your morning coffee watching surfers glide across the gentle waves. Featuring 2 Bedrooms, 2 bathrooms, a full kitchen with updated appliances, an in-unit washer and dryer, and an assigned parking stall for all your daily needs. Renting out your unit nightly with the Aqua-Aston Hotel Program provides income potential yet flexibility to stay in the unit while you're in town. Top tier amenities include heated pool, jacuzzi, full gym, yoga studio, conference rooms, lounge, BBQ lanai and cabanas, and 24 hr valet and concierge. Give us a call today, you won't want to miss this incredible opportunity in Waikiki's premier condo-hotel!"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "160"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1150"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1310"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-22T09:00:15.137"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-07-21"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Kalakaua"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(4) "2470"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(106) "1$21.275028$-157.823996$308.37$13.33$1.00$CAoSLEFGMVFpcE1hNWV4UFc4S0lLUEt6LUxqWGRwT0wtQVFmbm5FOThTTnhIQUs5"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(7) "2275.32"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(8) "27303.84"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1657400.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(10) "1429600.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "227800.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) "2022"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16712283/1e1413138adf1ab99417b68a38c31cee"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "126"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "79"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(1) "7"
}
["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) "23"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(4) "2501"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1983"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2022"
}
["security"]=>
array(1) {
[0]=>
string(45) "Card,Key,Keyed Elevator,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(8) "Kalakaua"
}
["street_number"]=>
array(1) {
[0]=>
string(4) "2470"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-2-6-023-007-0079"
}
["unit"]=>
array(1) {
[0]=>
string(77) "Bedroom on 1st Level,Corner/End,Full Bath on 1st Floor,Odd# Unit,Single Level"
}
["unit_number"]=>
array(1) {
[0]=>
string(4) "2501"
}
["view"]=>
array(1) {
[0]=>
string(82) "City,Coastline,Diamond Head,Golf Course,Marina/Canal,Mountain,Ocean,Sunrise,Sunset"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16712283"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202211727"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1658516454"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1983"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2022"
}
["zoning"]=>
array(1) {
[0]=>
string(30) "X6 - Resort Mixed Use Precinct"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2397) "a:147:{i:0;i:22471938;i:1;i:22471939;i:2;i:22471940;i:3;i:22471941;i:4;i:22471942;i:5;i:22471943;i:6;i:22471944;i:7;i:22471945;i:8;i:22471946;i:9;i:22471947;i:10;i:22471948;i:11;i:22471949;i:12;i:22471950;i:13;i:22471951;i:14;i:22471952;i:15;i:22471953;i:16;i:22471954;i:17;i:22471955;i:18;i:22471956;i:19;i:22471957;i:20;i:22471958;i:21;i:22475855;i:22;i:22475856;i:23;i:22475857;i:24;i:22475858;i:25;i:22475859;i:26;i:22475860;i:27;i:22475861;i:28;i:22475862;i:29;i:22475863;i:30;i:22475864;i:31;i:22475865;i:32;i:22475866;i:33;i:22475867;i:34;i:22475868;i:35;i:22475869;i:36;i:22475870;i:37;i:22475871;i:38;i:22475872;i:39;i:22475873;i:40;i:22475874;i:41;i:22475875;i:42;i:22475876;i:43;i:22475877;i:44;i:22475878;i:45;i:22475879;i:46;i:22475880;i:47;i:22475881;i:48;i:22475882;i:49;i:22475883;i:50;i:22475884;i:51;i:22475885;i:52;i:22475886;i:53;i:22475887;i:54;i:22475888;i:55;i:22475889;i:56;i:22475890;i:57;i:22475891;i:58;i:22475892;i:59;i:22475893;i:60;i:22475894;i:61;i:22475895;i:62;i:22475896;i:63;i:22477856;i:64;i:22477857;i:65;i:22477858;i:66;i:22477859;i:67;i:22477860;i:68;i:22477861;i:69;i:22477862;i:70;i:22477863;i:71;i:22477864;i:72;i:22477865;i:73;i:22477866;i:74;i:22477867;i:75;i:22477868;i:76;i:22477869;i:77;i:22477870;i:78;i:22477871;i:79;i:22477872;i:80;i:22477873;i:81;i:22477874;i:82;i:22477875;i:83;i:22477876;i:84;i:22478980;i:85;i:22478981;i:86;i:22478982;i:87;i:22478983;i:88;i:22478984;i:89;i:22478985;i:90;i:22478986;i:91;i:22478987;i:92;i:22478988;i:93;i:22478989;i:94;i:22478990;i:95;i:22478991;i:96;i:22478992;i:97;i:22478993;i:98;i:22478994;i:99;i:22478995;i:100;i:22478996;i:101;i:22478997;i:102;i:22478998;i:103;i:22478999;i:104;i:22479000;i:105;i:22497553;i:106;i:22497554;i:107;i:22497555;i:108;i:22497556;i:109;i:22497557;i:110;i:22497558;i:111;i:22497559;i:112;i:22497560;i:113;i:22497561;i:114;i:22497562;i:115;i:22497563;i:116;i:22497564;i:117;i:22497565;i:118;i:22497566;i:119;i:22497567;i:120;i:22497568;i:121;i:22497569;i:122;i:22497570;i:123;i:22497571;i:124;i:22497572;i:125;i:22497573;i:126;i:22803157;i:127;i:22803158;i:128;i:22803159;i:129;i:22803160;i:130;i:22803161;i:131;i:22803162;i:132;i:22803163;i:133;i:22803164;i:134;i:22803165;i:135;i:22803166;i:136;i:22803167;i:137;i:22803168;i:138;i:22803169;i:139;i:22803170;i:140;i:22803171;i:141;i:22803172;i:142;i:22803173;i:143;i:22803174;i:144;i:22803175;i:145;i:22803176;i:146;i:22803177;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-06-21"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-07-21"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "2200000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-11-30"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-07-21"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 971-7711"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(19) "ryota@hi50group.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(10) "Ryota Seki"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "39951"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3482158"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HAFO"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3485292"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(27) "Hawaii 5-0 Properties, Inc."
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 971-7711"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22803157"
}
}
Array
(
[agency] => Array
(
[0] => Compass
)
[assd_val_imprv] => Array
(
[0] => 1429600.00
)
[assd_val_land] => Array
(
[0] => 227800.00
)
[assd_val_total] => Array
(
[0] => 1657400.00
)
[bedrooms] => Array
(
[0] => 2
)
[building_name] => Array
(
[0] => Waikiki Beach Tower
)
[building_style] => Array
(
[0] => Condotel
)
[city] => Array
(
[0] => Honolulu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pets Allowed (Verify),Property Disclosure Stmt
)
[elementary_school] => Array
(
[0] => Jefferson
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Vinyl,W/W Carpet
)
[full_baths] => Array
(
[0] => 2
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Kaimuki
)
[home_exampt] => Array
(
[0] => 0
)
[lanai_sf] => Array
(
[0] => 160
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => alesia@barneshawaii.com
)
[list_agent_name] => Array
(
[0] => Alesia D Barnes
)
[list_agent_phone_number] => Array
(
[0] => (808) 825-4277
)
[list_date] => Array
(
[0] => 2022-06-18
)
[list_office_name] => Array
(
[0] => Compass
)
[list_price] => Array
(
[0] => 2200000.00
)
[living_sf] => Array
(
[0] => 1310
)
[location] => Array
(
[0] => 2470 Kalakaua Avenue Unit 2501, Honolulu, HI 96815
)
[maintenance_fees] => Array
(
[0] => 1846.90
)
[middle_school] => Array
(
[0] => Washington
)
[mls_] => Array
(
[0] => 202211727
)
[neighborhood] => Array
(
[0] => WAIKIKI
)
[number_of_parking_spaces] => Array
(
[0] => 1
)
[number_of_stories] => Array
(
[0] => 21+
)
[office_mls_id] => Array
(
[0] => COHI
)
[parking_features] => Array
(
[0] => Assigned,Covered - 1
)
[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_2] => Array
(
[0] => 686
)
[rets_association_fee_total] => Array
(
[0] => 2533
)
[rets_baths_full] => Array
(
[0] => 2
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 2.00
)
[rets_beds_total] => Array
(
[0] => 2
)
[rets_building_name] => Array
(
[0] => Waikiki Beach Tower
)
[rets_city] => Array
(
[0] => Honolulu
)
[rets_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 825-4277
)
[rets_co_list_agent_email] => Array
(
[0] => aaron@barneshawaii.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => Aaron D Businger
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 46150
)
[rets_co_list_agent_mui] => Array
(
[0] => 10057564
)
[rets_co_list_office_mlsid] => Array
(
[0] => COHI
)
[rets_co_list_office_mui] => Array
(
[0] => 15465233
)
[rets_co_list_office_name] => Array
(
[0] => Compass
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 825-4277
)
[rets_condo_parking_unit] => Array
(
[0] => 95
)
[rets_current_price] => Array
(
[0] => 2200000.00
)
[rets_dom] => Array
(
[0] => 3
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Jefferson
)
[rets_elevators_number_of] => Array
(
[0] => 4
)
[rets_floor_number] => Array
(
[0] => 25
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kaimuki
)
[rets_id] => Array
(
[0] => 16712283
)
[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) 825-4277
)
[rets_list_agent_email] => Array
(
[0] => alesia@barneshawaii.com
)
[rets_list_agent_full_name] => Array
(
[0] => Alesia D Barnes
)
[rets_list_agent_mlsid] => Array
(
[0] => 43678
)
[rets_list_agent_mui] => Array
(
[0] => 3483745
)
[rets_list_office_mlsid] => Array
(
[0] => COHI
)
[rets_list_office_mui] => Array
(
[0] => 15465233
)
[rets_list_office_name] => Array
(
[0] => Compass
)
[rets_list_office_phone] => Array
(
[0] => (808) 825-4277
)
[rets_list_price] => Array
(
[0] => 2200000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-06-18
)
[rets_maintenance_expense] => Array
(
[0] => 1846.90
)
[rets_management_company_name] => Array
(
[0] => Aqua-Aston
)
[rets_management_company_phone] => Array
(
[0] => 808-931-1577
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-07-22T09:00:15.137
)
[rets_matrix_unique_id] => Array
(
[0] => 16712283
)
[rets_middle_or_junior_school] => Array
(
[0] => Washington
)
[rets_mls_number] => Array
(
[0] => 202211727
)
[rets_neighbourhood] => Array
(
[0] => WAIKIKI
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-06-18T08:44:58.760
)
[rets_original_list_price] => Array
(
[0] => 2200000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 2
)
[rets_parcel_number] => Array
(
[0] => 1-2-6-023-007-0079
)
[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] => 2022-06-18T08:44:58.760
)
[rets_postal_code] => Array
(
[0] => 96815
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-06-18T08:44:58.760
)
[rets_primary_key] => Array
(
[0] => 16712283
)
[rets_private_remarks] => Array
(
[0] => Please use ShowingTime for all showing requests. For all other questions, please call/text Aaron Businger at 808-429-2353. Monthly HOA Fee - $1,846.90, Easement Rent - $315.84, Reserve Contribution - $370.30.
)
[rets_public_remarks] => Array
(
[0] => Stunning Oceanview Condo in highly desirable Waikiki Beach Tower! Located directly in front of Kuhio Beach with endless, unobstructed views of the Pacific Ocean, Koolau Mountain Range, and picturesque Diamond Head, this condo-hotel has it all. Enjoy epic sunsets on the spacious lanai or sip your morning coffee watching surfers glide across the gentle waves. Featuring 2 Bedrooms, 2 bathrooms, a full kitchen with updated appliances, an in-unit washer and dryer, and an assigned parking stall for all your daily needs. Renting out your unit nightly with the Aqua-Aston Hotel Program provides income potential yet flexibility to stay in the unit while you're in town. Top tier amenities include heated pool, jacuzzi, full gym, yoga studio, conference rooms, lounge, BBQ lanai and cabanas, and 24 hr valet and concierge. Give us a call today, you won't want to miss this incredible opportunity in Waikiki's premier condo-hotel!
)
[rets_sqft_lanai_open] => Array
(
[0] => 160
)
[rets_sqft_roofed_living] => Array
(
[0] => 1150
)
[rets_sqft_total] => Array
(
[0] => 1310
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-07-22T09:00:15.137
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-07-21
)
[rets_street_name] => Array
(
[0] => Kalakaua
)
[rets_street_number] => Array
(
[0] => 2470
)
[rets_street_view_param] => Array
(
[0] => 1$21.275028$-157.823996$308.37$13.33$1.00$CAoSLEFGMVFpcE1hNWV4UFc4S0lLUEt6LUxqWGRwT0wtQVFmbm5FOThTTnhIQUs5
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 2275.32
)
[rets_tax_annual_amount] => Array
(
[0] => 27303.84
)
[rets_tax_assessed_value] => Array
(
[0] => 1657400.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 1429600.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 227800.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2022
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16712283/1e1413138adf1ab99417b68a38c31cee
)
[rets_tmk_area] => Array
(
[0] => 126
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 79
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 7
)
[rets_tmk_section] => Array
(
[0] => 6
)
[rets_tmk_zone] => Array
(
[0] => 2
)
[rets_tmkplat] => Array
(
[0] => 23
)
[rets_unit_number] => Array
(
[0] => 2501
)
[rets_year_built] => Array
(
[0] => 1983
)
[rets_year_remodeled] => Array
(
[0] => 2022
)
[security] => Array
(
[0] => Card,Key,Keyed Elevator,Security Patrol,Video
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Kalakaua
)
[street_number] => Array
(
[0] => 2470
)
[street_suffix] => Array
(
[0] => Avenue
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-2-6-023-007-0079
)
[unit] => Array
(
[0] => Bedroom on 1st Level,Corner/End,Full Bath on 1st Floor,Odd# Unit,Single Level
)
[unit_number] => Array
(
[0] => 2501
)
[view] => Array
(
[0] => City,Coastline,Diamond Head,Golf Course,Marina/Canal,Mountain,Ocean,Sunrise,Sunset
)
[wpp::rets_pk] => Array
(
[0] => 16712283
)
[wpp_gpid] => Array
(
[0] => 202211727
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1658516454
)
[year_built] => Array
(
[0] => 1983
)
[year_remodeled_] => Array
(
[0] => 2022
)
[zoning] => Array
(
[0] => X6 - Resort Mixed Use Precinct
)
[new_attached_media] => Array
(
[0] => a:147:{i:0;i:22471938;i:1;i:22471939;i:2;i:22471940;i:3;i:22471941;i:4;i:22471942;i:5;i:22471943;i:6;i:22471944;i:7;i:22471945;i:8;i:22471946;i:9;i:22471947;i:10;i:22471948;i:11;i:22471949;i:12;i:22471950;i:13;i:22471951;i:14;i:22471952;i:15;i:22471953;i:16;i:22471954;i:17;i:22471955;i:18;i:22471956;i:19;i:22471957;i:20;i:22471958;i:21;i:22475855;i:22;i:22475856;i:23;i:22475857;i:24;i:22475858;i:25;i:22475859;i:26;i:22475860;i:27;i:22475861;i:28;i:22475862;i:29;i:22475863;i:30;i:22475864;i:31;i:22475865;i:32;i:22475866;i:33;i:22475867;i:34;i:22475868;i:35;i:22475869;i:36;i:22475870;i:37;i:22475871;i:38;i:22475872;i:39;i:22475873;i:40;i:22475874;i:41;i:22475875;i:42;i:22475876;i:43;i:22475877;i:44;i:22475878;i:45;i:22475879;i:46;i:22475880;i:47;i:22475881;i:48;i:22475882;i:49;i:22475883;i:50;i:22475884;i:51;i:22475885;i:52;i:22475886;i:53;i:22475887;i:54;i:22475888;i:55;i:22475889;i:56;i:22475890;i:57;i:22475891;i:58;i:22475892;i:59;i:22475893;i:60;i:22475894;i:61;i:22475895;i:62;i:22475896;i:63;i:22477856;i:64;i:22477857;i:65;i:22477858;i:66;i:22477859;i:67;i:22477860;i:68;i:22477861;i:69;i:22477862;i:70;i:22477863;i:71;i:22477864;i:72;i:22477865;i:73;i:22477866;i:74;i:22477867;i:75;i:22477868;i:76;i:22477869;i:77;i:22477870;i:78;i:22477871;i:79;i:22477872;i:80;i:22477873;i:81;i:22477874;i:82;i:22477875;i:83;i:22477876;i:84;i:22478980;i:85;i:22478981;i:86;i:22478982;i:87;i:22478983;i:88;i:22478984;i:89;i:22478985;i:90;i:22478986;i:91;i:22478987;i:92;i:22478988;i:93;i:22478989;i:94;i:22478990;i:95;i:22478991;i:96;i:22478992;i:97;i:22478993;i:98;i:22478994;i:99;i:22478995;i:100;i:22478996;i:101;i:22478997;i:102;i:22478998;i:103;i:22478999;i:104;i:22479000;i:105;i:22497553;i:106;i:22497554;i:107;i:22497555;i:108;i:22497556;i:109;i:22497557;i:110;i:22497558;i:111;i:22497559;i:112;i:22497560;i:113;i:22497561;i:114;i:22497562;i:115;i:22497563;i:116;i:22497564;i:117;i:22497565;i:118;i:22497566;i:119;i:22497567;i:120;i:22497568;i:121;i:22497569;i:122;i:22497570;i:123;i:22497571;i:124;i:22497572;i:125;i:22497573;i:126;i:22803157;i:127;i:22803158;i:128;i:22803159;i:129;i:22803160;i:130;i:22803161;i:131;i:22803162;i:132;i:22803163;i:133;i:22803164;i:134;i:22803165;i:135;i:22803166;i:136;i:22803167;i:137;i:22803168;i:138;i:22803169;i:139;i:22803170;i:140;i:22803171;i:141;i:22803172;i:142;i:22803173;i:143;i:22803174;i:144;i:22803175;i:145;i:22803176;i:146;i:22803177;}
)
[rets_open_house_count] => Array
(
[0] => 1
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-06-21
)
[rets_close_date] => Array
(
[0] => 2022-07-21
)
[rets_close_price] => Array
(
[0] => 2200000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-11-30
)
[rets_off_market_date] => Array
(
[0] => 2022-07-21
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 971-7711
)
[rets_selling_agent_email] => Array
(
[0] => ryota@hi50group.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Ryota Seki
)
[rets_selling_agent_mlsid] => Array
(
[0] => 39951
)
[rets_selling_agent_mui] => Array
(
[0] => 3482158
)
[rets_selling_office_mlsid] => Array
(
[0] => HAFO
)
[rets_selling_office_mui] => Array
(
[0] => 3485292
)
[rets_selling_office_name] => Array
(
[0] => Hawaii 5-0 Properties, Inc.
)
[rets_selling_office_phone] => Array
(
[0] => (808) 971-7711
)
[_thumbnail_id] => Array
(
[0] => 22803157
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446