1001 Queen Street Unit 1411
Honolulu, HI 96814

Take a Virtual Tour

Listing
Overview

Price: $629,000
Area: KAKAAKO
Status: Sold

Luxurious large Ae’o Studio in the heart of vibrant Ward Village offers the wonderful Kakaako lifestyle. Upscale finishes, in-unit washer/dryer, central AC, Bosch appliances, and hardwood flooring add to this gem. Ala Moana Beach park, shopping, restaurants, and movie theaters are just minutes away. Amazing amenities include a dramatic roof top terrace, two pools, hot tub, movie theater, indoor and outdoor fitness areas, private dining room, catering kitchen, media room, saunas, massage room for two, children’s playground, a dog-walk area, and a direct access to Whole Foods! Near the beach, downtown, and Waikiki, this home is perfect as a starter home, second home, or investment. This rare opportunity is waiting for you! Furnishings are negotiable.

  • Full Baths: 1
  • Living (sf): 433
  • Year Built: 2018
  • Building Name: Ae'o

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • Number of Stories: 21+
  • View: City,Coastline,Mountain,Ocean,Sunset
  • Listing Office: Coldwell Banker Realty

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

CONTACT US

Marcus Realty

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

array(165) {
  ["agency"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "589800.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(8) "28400.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "618200.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(4) "Ae'o"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "High-Rise 7+ Stories"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(38) "1031 Exchange,Property Disclosure Stmt"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(14) "Hardwood,Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(10) "Negotiable"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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(19) "lisah@cbpacific.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(14) "Lisa Haeringer"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 732-1414"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-03-31"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "629000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "433"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(47) "1001 Queen Street Unit 1411, Honolulu, HI 96814"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "482.00"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202108069"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["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(6) "CBPP02"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(47) "Assigned,Covered - 1,Garage,Guest,Secured Entry"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "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) "482"
  }
  ["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(4) "Ae'o"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["rets_co_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["rets_co_list_agent_email"]=>
  array(1) {
    [0]=>
    string(19) "MaliaK@cbrealty.com"
  }
  ["rets_co_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Malia Kakos J.D."
  }
  ["rets_co_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "43549"
  }
  ["rets_co_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3483675"
  }
  ["rets_co_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "CBPP"
  }
  ["rets_co_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485212"
  }
  ["rets_co_list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_co_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(2) "95"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "629000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "36"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_floor_number"]=>
  array(1) {
    [0]=>
    string(2) "14"
  }
  ["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) "15807586"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 732-1414"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(19) "lisah@cbpacific.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Lisa Haeringer"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "25408"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8843261"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "CBPP02"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485238"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 732-1414"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "629000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-03-31"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "482.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(9) "Hawaiiana"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(8) "593-9100"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-16T12:22:29.150"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15807586"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202108069"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-03-31T16:16:44.137"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "629000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "64"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-2-3-002-106-0102"
  }
  ["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) "2021-03-31T16:16:44.137"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96814"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15807586"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(282) "Call/Text Lisa Haeringer at 808-927-7177 or email LisaH@cbpacific.com or Call/Text Malia Kakos at 808-741-8292 or email MaliaK@cbpacific.com.  Please review and sign the Covid-19 Showing form. Sale is As-Is condition. Please use Ryan Nagatori at Title Guaranty for title and escrow."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(758) "Luxurious large Ae'o Studio in the heart of vibrant Ward Village offers the wonderful Kakaako lifestyle. Upscale finishes, in-unit washer/dryer, central AC, Bosch appliances, and hardwood flooring add to this gem. Ala Moana Beach park, shopping, restaurants, and movie theaters are just minutes away. Amazing amenities include a dramatic roof top terrace, two pools, hot tub, movie theater, indoor and outdoor fitness areas, private dining room, catering kitchen, media room, saunas, massage room for two, children's playground, a dog-walk area, and a direct access to Whole Foods! Near the beach, downtown, and Waikiki, this home is perfect as a starter home, second home, or investment. This rare opportunity is waiting for you! Furnishings are negotiable."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "433"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "433"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-16T12:22:29.150"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-16"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(5) "Queen"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(4) "1001"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(106) "1$21.295105$-157.853327$202.95$13.33$1.00$CAoSLEFGMVFpcE53a0Vic0JhaGYzRFY3N3E5Y3laanlMVzVfXzhCY3RIN1ZFTXNt"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "195.10"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "618200.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "589800.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(8) "28400.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/15807586/fa542d4c7f0b6e0b37457f6f2b629b0d"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "123"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(3) "102"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(3) "106"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_unit_number"]=>
  array(1) {
    [0]=>
    string(4) "1411"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "2018"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(41) "Card,Keyed Elevator,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-3-002-106-0102"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(33) "Central AC,Odd# Unit,Single Level"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(36) "City,Coastline,Mountain,Ocean,Sunset"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15807586"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202108069"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628926287"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "2018"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(45) "Kak – Kakaako Community Development Project"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1341) "a:84:{i:0;i:19705741;i:1;i:19705742;i:2;i:19705743;i:3;i:19705744;i:4;i:19705745;i:5;i:19705746;i:6;i:19705747;i:7;i:19705748;i:8;i:19705749;i:9;i:19705750;i:10;i:19705751;i:11;i:19705752;i:12;i:19705753;i:13;i:19705754;i:14;i:19705755;i:15;i:19705756;i:16;i:19705757;i:17;i:19705758;i:18;i:19705759;i:19;i:19705760;i:20;i:19705761;i:21;i:19715442;i:22;i:19715443;i:23;i:19715444;i:24;i:19715445;i:25;i:19715446;i:26;i:19715447;i:27;i:19715448;i:28;i:19715449;i:29;i:19715450;i:30;i:19715451;i:31;i:19715452;i:32;i:19715453;i:33;i:19715454;i:34;i:19715455;i:35;i:19715456;i:36;i:19715457;i:37;i:19715458;i:38;i:19715459;i:39;i:19715460;i:40;i:19715461;i:41;i:19715462;i:42;i:20057477;i:43;i:20057478;i:44;i:20057479;i:45;i:20057480;i:46;i:20057481;i:47;i:20057482;i:48;i:20057483;i:49;i:20057484;i:50;i:20057485;i:51;i:20057486;i:52;i:20057487;i:53;i:20057488;i:54;i:20057489;i:55;i:20057490;i:56;i:20057491;i:57;i:20057492;i:58;i:20057493;i:59;i:20057494;i:60;i:20057495;i:61;i:20057496;i:62;i:20057497;i:63;i:20305819;i:64;i:20305820;i:65;i:20305821;i:66;i:20305822;i:67;i:20305823;i:68;i:20305824;i:69;i:20305825;i:70;i:20305826;i:71;i:20305827;i:72;i:20305828;i:73;i:20305829;i:74;i:20305830;i:75;i:20305831;i:76;i:20305832;i:77;i:20305833;i:78;i:20305834;i:79;i:20305835;i:80;i:20305836;i:81;i:20305837;i:82;i:20305838;i:83;i:20305839;}"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(69) "https://app.immoviewer.com/landing/unbranded/6066cff914f61404cf946ae7"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(69) "https://app.immoviewer.com/landing/unbranded/6066cff914f61404cf946ae7"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96814"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-02"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-16"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "629000.00"
  }
  ["rets_co_selling_agent_direct_work_pho"]=>
  array(1) {
    [0]=>
    string(14) "(808) 425-7887"
  }
  ["rets_co_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(14) "tom@oahure.com"
  }
  ["rets_co_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "Thomas M Malloy"
  }
  ["rets_co_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "43921"
  }
  ["rets_co_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3483907"
  }
  ["rets_co_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "GIVE"
  }
  ["rets_co_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "8884041"
  }
  ["rets_co_selling_office_name"]=>
  array(1) {
    [0]=>
    string(10) "OahuRE.com"
  }
  ["rets_co_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 425-7887"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-16"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 425-7887"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(15) "bryn@oahure.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Bryn W Kaufman"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "27729"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3477362"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "GIVE"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "8884041"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(10) "OahuRE.com"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 425-7887"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(5) "Queen"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(4) "1001"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(4) "1411"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20305819"
  }
}