BACK ON MARKET with new plumbing valves, supply lines, faucet & some electrical upgrades from this lovely studio condo with beautiful views of the Ala Wai Canal, mountains, rainbows, and heart of Waikiki. Walk to the International Market Place, Kuhio, and Kalakaua Avenue, near beaches, shops, restaurants, busline, and more. Operated by Aston management, rented for a two nights minimum, legal short term rental condo in Waikiki! Property is turnkey making it a great hotel rental property, however, you can manage your own rentals too.
Listing by: MOKULANI Properties, inc
array(165) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "116500.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(8) "56200.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "172700.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "0"
}
["building_name"]=>
array(1) {
[0]=>
string(16) "Aloha Surf Hotel"
}
["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(38) "1031 Exchange,Property Disclosure Stmt"
}
["elementary_school"]=>
array(1) {
[0]=>
string(9) "Jefferson"
}
["floor_covering"]=>
array(1) {
[0]=>
string(23) "Ceramic Tile,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["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) "45"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "22825.00"
}
["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(32) "ma2822583@MOKULANIproperties.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(15) "Mary Anne Bruno"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 637-8899"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-06-14"
}
["list_office_name"]=>
array(1) {
[0]=>
string(24) "MOKULANI Properties, inc"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "269000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "261"
}
["location"]=>
array(1) {
[0]=>
string(51) "444 Kanekapolei Street Unit 500, Honolulu, HI 96815"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "395.00"
}
["middle_school"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202211396"
}
["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) "BRUN"
}
["parking_features"]=>
array(1) {
[0]=>
string(34) "None,Garage,Open,Street,Unassigned"
}
["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(13) "Above 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) "395"
}
["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) "Aloha Surf Hotel"
}
["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) "269000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "43"
}
["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) "2"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "5"
}
["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) "16704390"
}
["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) 637-8899"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(32) "ma2822583@MOKULANIproperties.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Mary Anne Bruno"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "06811"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "8842699"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "BRUN"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3485502"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(24) "MOKULANI Properties, inc"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 637-8899"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "269000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-06-14"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "22825.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "395.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(11) "Aqua Resort"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(10) "8086287948"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-09-17T23:08:17.110"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16704390"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202211396"
}
["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-14T15:56:10.167"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "269000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(1) "8"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-2-6-021-016-0065"
}
["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) "11"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-14T15:56:10.167"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96815"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16704390"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(203) "Contact # 808.923.0222, for Guest Services: Maria, or Resident Manager, Tim Clark for availability to see the condo hotel. Best between 1 pm, and 3 PM after check-out cleanings, and new guest arrivals."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(540) "BACK ON MARKET with new plumbing valves, supply lines, faucet & some electrical upgrades from this lovely studio condo with beautiful views of the Ala Wai Canal, mountains, rainbows, and heart of Waikiki. Walk to the International Market Place, Kuhio, and Kalakaua Avenue, near beaches, shops, restaurants, busline, and more. Operated by Aston management, rented for a two nights minimum, legal short term rental condo in Waikiki! Property is turnkey making it a great hotel rental property, however, you can manage your own rentals too."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(2) "45"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "216"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "261"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-09-17T23:08:17.110"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-09-16"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(11) "Kanekapolei"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(3) "444"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(106) "1$21.279045$-157.823572$349.21$13.33$1.00$CAoSLEFGMVFpcE5BblZISmRGaGx1blk2a3lpQnhZNk1QY1Fuc1pucTNoQldjZE5i"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(2) "3%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "206.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2472.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "172700.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "116500.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(8) "56200.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/16704390/167c7a263a6314afb16a4c4590fd784b"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "126"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "65"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "16"
}
["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) "21"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(3) "500"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1968"
}
["security"]=>
array(1) {
[0]=>
string(10) "Card,Video"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(11) "Kanekapolei"
}
["street_number"]=>
array(1) {
[0]=>
string(3) "444"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(4) "Cash"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-2-6-021-016-0065"
}
["unit"]=>
array(1) {
[0]=>
string(12) "Single Level"
}
["unit_number"]=>
array(1) {
[0]=>
string(3) "500"
}
["view"]=>
array(1) {
[0]=>
string(26) "City,Marina/Canal,Mountain"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16704390"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202211396"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1663492153"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1968"
}
["zoning"]=>
array(1) {
[0]=>
string(24) "AM - Apartment Mixed Use"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1405) "a:88:{i:0;i:22437967;i:1;i:22437968;i:2;i:22437969;i:3;i:22437970;i:4;i:22437971;i:5;i:22437972;i:6;i:22437973;i:7;i:22437974;i:8;i:22437975;i:9;i:22437976;i:10;i:22437977;i:11;i:22438186;i:12;i:22438187;i:13;i:22438188;i:14;i:22438189;i:15;i:22438190;i:16;i:22438191;i:17;i:22438192;i:18;i:22438193;i:19;i:22438194;i:20;i:22438195;i:21;i:22438196;i:22;i:22642577;i:23;i:22642578;i:24;i:22642579;i:25;i:22642580;i:26;i:22642581;i:27;i:22642582;i:28;i:22642583;i:29;i:22642584;i:30;i:22642585;i:31;i:22642586;i:32;i:22642587;i:33;i:22685718;i:34;i:22685719;i:35;i:22685720;i:36;i:22685721;i:37;i:22685722;i:38;i:22685723;i:39;i:22685724;i:40;i:22685725;i:41;i:22685726;i:42;i:22685727;i:43;i:22685728;i:44;i:22882710;i:45;i:22882711;i:46;i:22882712;i:47;i:22882713;i:48;i:22882714;i:49;i:22882715;i:50;i:22882716;i:51;i:22882717;i:52;i:22882718;i:53;i:22882719;i:54;i:22882720;i:55;i:22882857;i:56;i:22882858;i:57;i:22882859;i:58;i:22882860;i:59;i:22882861;i:60;i:22882862;i:61;i:22882863;i:62;i:22882864;i:63;i:22882865;i:64;i:22882866;i:65;i:22882867;i:66;i:23061309;i:67;i:23061310;i:68;i:23061311;i:69;i:23061312;i:70;i:23061313;i:71;i:23061314;i:72;i:23061315;i:73;i:23061316;i:74;i:23061317;i:75;i:23061318;i:76;i:23061319;i:77;i:23368624;i:78;i:23368625;i:79;i:23368626;i:80;i:23368627;i:81;i:23368628;i:82;i:23368629;i:83;i:23368630;i:84;i:23368631;i:85;i:23368632;i:86;i:23368633;i:87;i:23368634;}"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-08-15"
}
["fee_purchase"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-09-16"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "269000.00"
}
["rets_concessions"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-12-31"
}
["rets_fee_purchase"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-09-16"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(24) "christophercausey@kw.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(22) "Christopher R S Causey"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "49126"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "13202486"
}
["rets_selling_agent_remarks"]=>
array(1) {
[0]=>
string(389) "New owner will renovate to enhance the beautiful views of Ala Wai Canal, and mountain ranges. Walk to International Marketplace, restaurants, shops, hotels, Waikiki beach, Urgent Care, and more, perfect location for legal short term rental investment in a well maintained building. Aston operates the front desk, for any owner wanting to operate as a condo hotel, with min 2 nights stay."
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "KWPP"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "8991040"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "23368624"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 116500.00
)
[assd_val_land] => Array
(
[0] => 56200.00
)
[assd_val_total] => Array
(
[0] => 172700.00
)
[bedrooms] => Array
(
[0] => 0
)
[building_name] => Array
(
[0] => Aloha Surf Hotel
)
[building_style] => Array
(
[0] => Condotel
)
[city] => Array
(
[0] => Honolulu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => 1031 Exchange,Property Disclosure Stmt
)
[elementary_school] => Array
(
[0] => Jefferson
)
[floor_covering] => Array
(
[0] => Ceramic Tile,W/W Carpet
)
[frontage] => Array
(
[0] => Other
)
[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] => 45
)
[land_area_sf] => Array
(
[0] => 22825.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => ma2822583@MOKULANIproperties.com
)
[list_agent_name] => Array
(
[0] => Mary Anne Bruno
)
[list_agent_phone_number] => Array
(
[0] => (808) 637-8899
)
[list_date] => Array
(
[0] => 2022-06-14
)
[list_office_name] => Array
(
[0] => MOKULANI Properties, inc
)
[list_price] => Array
(
[0] => 269000.00
)
[living_sf] => Array
(
[0] => 261
)
[location] => Array
(
[0] => 444 Kanekapolei Street Unit 500, Honolulu, HI 96815
)
[maintenance_fees] => Array
(
[0] => 395.00
)
[middle_school] => Array
(
[0] => Kaimuki
)
[mls_] => Array
(
[0] => 202211396
)
[neighborhood] => Array
(
[0] => WAIKIKI
)
[number_of_parking_spaces] => Array
(
[0] => 0
)
[number_of_stories] => Array
(
[0] => 8-14
)
[office_mls_id] => Array
(
[0] => BRUN
)
[parking_features] => Array
(
[0] => None,Garage,Open,Street,Unassigned
)
[possession] => Array
(
[0] => 45 Days or Less,At Closing
)
[postal_code] => Array
(
[0] => 96815
)
[property_condition] => Array
(
[0] => Above Average
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Metro
)
[rets_association_fee_total] => Array
(
[0] => 395
)
[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] => Aloha Surf Hotel
)
[rets_city] => Array
(
[0] => Honolulu
)
[rets_condo_parking_unit] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 269000.00
)
[rets_dom] => Array
(
[0] => 43
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Jefferson
)
[rets_elevators_number_of] => Array
(
[0] => 2
)
[rets_floor_number] => Array
(
[0] => 5
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kaimuki
)
[rets_id] => Array
(
[0] => 16704390
)
[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) 637-8899
)
[rets_list_agent_email] => Array
(
[0] => ma2822583@MOKULANIproperties.com
)
[rets_list_agent_full_name] => Array
(
[0] => Mary Anne Bruno
)
[rets_list_agent_mlsid] => Array
(
[0] => 06811
)
[rets_list_agent_mui] => Array
(
[0] => 8842699
)
[rets_list_office_mlsid] => Array
(
[0] => BRUN
)
[rets_list_office_mui] => Array
(
[0] => 3485502
)
[rets_list_office_name] => Array
(
[0] => MOKULANI Properties, inc
)
[rets_list_office_phone] => Array
(
[0] => (808) 637-8899
)
[rets_list_price] => Array
(
[0] => 269000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-06-14
)
[rets_lot_size_area] => Array
(
[0] => 22825.00
)
[rets_maintenance_expense] => Array
(
[0] => 395.00
)
[rets_management_company_name] => Array
(
[0] => Aqua Resort
)
[rets_management_company_phone] => Array
(
[0] => 8086287948
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-09-17T23:08:17.110
)
[rets_matrix_unique_id] => Array
(
[0] => 16704390
)
[rets_middle_or_junior_school] => Array
(
[0] => Kaimuki
)
[rets_mls_number] => Array
(
[0] => 202211396
)
[rets_neighbourhood] => Array
(
[0] => WAIKIKI
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-06-14T15:56:10.167
)
[rets_original_list_price] => Array
(
[0] => 269000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 8
)
[rets_parcel_number] => Array
(
[0] => 1-2-6-021-016-0065
)
[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] => 11
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-06-14T15:56:10.167
)
[rets_postal_code] => Array
(
[0] => 96815
)
[rets_primary_key] => Array
(
[0] => 16704390
)
[rets_private_remarks] => Array
(
[0] => Contact # 808.923.0222, for Guest Services: Maria, or Resident Manager, Tim Clark for availability to see the condo hotel. Best between 1 pm, and 3 PM after check-out cleanings, and new guest arrivals.
)
[rets_public_remarks] => Array
(
[0] => BACK ON MARKET with new plumbing valves, supply lines, faucet & some electrical upgrades from this lovely studio condo with beautiful views of the Ala Wai Canal, mountains, rainbows, and heart of Waikiki. Walk to the International Market Place, Kuhio, and Kalakaua Avenue, near beaches, shops, restaurants, busline, and more. Operated by Aston management, rented for a two nights minimum, legal short term rental condo in Waikiki! Property is turnkey making it a great hotel rental property, however, you can manage your own rentals too.
)
[rets_room_count] => Array
(
[0] => 4
)
[rets_sqft_lanai_open] => Array
(
[0] => 45
)
[rets_sqft_roofed_living] => Array
(
[0] => 216
)
[rets_sqft_total] => Array
(
[0] => 261
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-09-17T23:08:17.110
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-09-16
)
[rets_street_name] => Array
(
[0] => Kanekapolei
)
[rets_street_number] => Array
(
[0] => 444
)
[rets_street_view_param] => Array
(
[0] => 1$21.279045$-157.823572$349.21$13.33$1.00$CAoSLEFGMVFpcE5BblZISmRGaGx1blk2a3lpQnhZNk1QY1Fuc1pucTNoQldjZE5i
)
[rets_sub_agency_compensation] => Array
(
[0] => 3%
)
[rets_tax_amount] => Array
(
[0] => 206.00
)
[rets_tax_annual_amount] => Array
(
[0] => 2472.00
)
[rets_tax_assessed_value] => Array
(
[0] => 172700.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 116500.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 56200.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/16704390/167c7a263a6314afb16a4c4590fd784b
)
[rets_tmk_area] => Array
(
[0] => 126
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 65
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 16
)
[rets_tmk_section] => Array
(
[0] => 6
)
[rets_tmk_zone] => Array
(
[0] => 2
)
[rets_tmkplat] => Array
(
[0] => 21
)
[rets_unit_number] => Array
(
[0] => 500
)
[rets_year_built] => Array
(
[0] => 1968
)
[security] => Array
(
[0] => Card,Video
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Kanekapolei
)
[street_number] => Array
(
[0] => 444
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash
)
[tmk] => Array
(
[0] => 1-2-6-021-016-0065
)
[unit] => Array
(
[0] => Single Level
)
[unit_number] => Array
(
[0] => 500
)
[view] => Array
(
[0] => City,Marina/Canal,Mountain
)
[wpp::rets_pk] => Array
(
[0] => 16704390
)
[wpp_gpid] => Array
(
[0] => 202211396
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1663492153
)
[year_built] => Array
(
[0] => 1968
)
[zoning] => Array
(
[0] => AM - Apartment Mixed Use
)
[new_attached_media] => Array
(
[0] => a:88:{i:0;i:22437967;i:1;i:22437968;i:2;i:22437969;i:3;i:22437970;i:4;i:22437971;i:5;i:22437972;i:6;i:22437973;i:7;i:22437974;i:8;i:22437975;i:9;i:22437976;i:10;i:22437977;i:11;i:22438186;i:12;i:22438187;i:13;i:22438188;i:14;i:22438189;i:15;i:22438190;i:16;i:22438191;i:17;i:22438192;i:18;i:22438193;i:19;i:22438194;i:20;i:22438195;i:21;i:22438196;i:22;i:22642577;i:23;i:22642578;i:24;i:22642579;i:25;i:22642580;i:26;i:22642581;i:27;i:22642582;i:28;i:22642583;i:29;i:22642584;i:30;i:22642585;i:31;i:22642586;i:32;i:22642587;i:33;i:22685718;i:34;i:22685719;i:35;i:22685720;i:36;i:22685721;i:37;i:22685722;i:38;i:22685723;i:39;i:22685724;i:40;i:22685725;i:41;i:22685726;i:42;i:22685727;i:43;i:22685728;i:44;i:22882710;i:45;i:22882711;i:46;i:22882712;i:47;i:22882713;i:48;i:22882714;i:49;i:22882715;i:50;i:22882716;i:51;i:22882717;i:52;i:22882718;i:53;i:22882719;i:54;i:22882720;i:55;i:22882857;i:56;i:22882858;i:57;i:22882859;i:58;i:22882860;i:59;i:22882861;i:60;i:22882862;i:61;i:22882863;i:62;i:22882864;i:63;i:22882865;i:64;i:22882866;i:65;i:22882867;i:66;i:23061309;i:67;i:23061310;i:68;i:23061311;i:69;i:23061312;i:70;i:23061313;i:71;i:23061314;i:72;i:23061315;i:73;i:23061316;i:74;i:23061317;i:75;i:23061318;i:76;i:23061319;i:77;i:23368624;i:78;i:23368625;i:79;i:23368626;i:80;i:23368627;i:81;i:23368628;i:82;i:23368629;i:83;i:23368630;i:84;i:23368631;i:85;i:23368632;i:86;i:23368633;i:87;i:23368634;}
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-08-15
)
[fee_purchase] => Array
(
[0] => 0
)
[rets_close_date] => Array
(
[0] => 2022-09-16
)
[rets_close_price] => Array
(
[0] => 269000.00
)
[rets_concessions] => Array
(
[0] => 0
)
[rets_expiration_date] => Array
(
[0] => 2022-12-31
)
[rets_fee_purchase] => Array
(
[0] => 0
)
[rets_off_market_date] => Array
(
[0] => 2022-09-16
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 596-2888
)
[rets_selling_agent_email] => Array
(
[0] => christophercausey@kw.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Christopher R S Causey
)
[rets_selling_agent_mlsid] => Array
(
[0] => 49126
)
[rets_selling_agent_mui] => Array
(
[0] => 13202486
)
[rets_selling_agent_remarks] => Array
(
[0] => New owner will renovate to enhance the beautiful views of Ala Wai Canal, and mountain ranges. Walk to International Marketplace, restaurants, shops, hotels, Waikiki beach, Urgent Care, and more, perfect location for legal short term rental investment in a well maintained building. Aston operates the front desk, for any owner wanting to operate as a condo hotel, with min 2 nights stay.
)
[rets_selling_office_mlsid] => Array
(
[0] => KWPP
)
[rets_selling_office_mui] => Array
(
[0] => 8991040
)
[rets_selling_office_name] => Array
(
[0] => Keller Williams Honolulu
)
[rets_selling_office_phone] => Array
(
[0] => (808) 596-2888
)
[_thumbnail_id] => Array
(
[0] => 23368624
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446