1001 Queen Street Unit 4005
Honolulu, HI 96814

Listing
Overview

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

Welcome to the finest Penthouse living at Ae’o, located in the exclusive master planned community of Ward Village, with private across to Whole Foods! Enjoy dramatic soaring ceilings (only found in Penthouse units), oak wood flooring (living room and bedroom), a spectacular oversized walk in closet, parking on the much preferred 2nd level and as a bonus a good sized storage room, located right behind the parking stall. Unit shows pride of ownership and is in a superb condition. Ae’o offers some stunning amenities including 2 pools, hot tub, gym, spa, sauna, steam room, barbecue stations, media room, theater, catering kitchen, rooftop entertainment deck, 3 guest suites & more.

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

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • Number of Stories: 21+
  • View: City,Mountain,Ocean
  • Listing Office: Hawaii Living LLC

  • Maintenance Fees: $675
  • Association Fees: $26
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(153) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "831100.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(8) "46900.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "878000.00"
  }
  ["assn_fee_inclusions"]=>
  array(1) {
    [0]=>
    string(2) "26"
  }
  ["association_fees"]=>
  array(1) {
    [0]=>
    string(2) "26"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(4) "Ae'o"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "High-Rise 7+ Stories"
  }
  ["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"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(21) "Ceramic Tile,Hardwood"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(7) "Partial"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(6) "100000"
  }
  ["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(25) "Kristian@HawaiiLiving.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(16) "Kristian Nielsen"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 943-9000"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-08"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(17) "Hawaii Living LLC"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "935000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "714"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(47) "1001 Queen Street Unit 4005, Honolulu, HI 96814"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "674.91"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202117916"
  }
  ["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(4) "HOHI"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(20) "Assigned,Covered - 1"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(26) "45 Days or Less,At Closing"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96814"
  }
  ["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_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-15"
  }
  ["rets_association_fee"]=>
  array(1) {
    [0]=>
    string(2) "26"
  }
  ["rets_association_fee_2"]=>
  array(1) {
    [0]=>
    string(2) "39"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "740"
  }
  ["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) "1"
  }
  ["rets_building_name"]=>
  array(1) {
    [0]=>
    string(4) "Ae'o"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(1) "."
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "935000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "7"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elevators_number_of"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_floor_number"]=>
  array(1) {
    [0]=>
    string(2) "40"
  }
  ["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) "16025933"
  }
  ["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) 943-9000"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(25) "Kristian@HawaiiLiving.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Kristian Nielsen"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "44326"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9035157"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "HOHI"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "8987821"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(17) "Hawaii Living LLC"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 943-9000"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "935000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-08"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "674.91"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(9) "Hawaiiana"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 593-9100"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-08-30T11:28:27.687"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16025933"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202117916"
  }
  ["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-07-08T09:25:16.970"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "935000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "63"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-2-3-002-106-0459"
  }
  ["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) "24"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-08T09:25:16.970"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96814"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-08T09:25:16.970"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16025933"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(151) "Contact Kristian - kristian@hawaiiliving.com / (808) 372-6184.
Listor must be present.
Furniture: Seller will consider selling as a separate package."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(684) "Welcome to the finest Penthouse living at Ae'o, located in the exclusive master planned community of Ward Village, with private across to Whole Foods! Enjoy dramatic soaring ceilings (only found in Penthouse units), oak wood flooring (living room and bedroom), a spectacular oversized walk in closet, parking on the much preferred 2nd level and as a bonus a good sized storage room, located right behind the parking stall. Unit shows pride of ownership and is in a superb condition. Ae'o offers some stunning amenities including 2 pools, hot tub, gym, spa, sauna, steam room, barbecue stations, media room, theater, catering kitchen, rooftop entertainment deck, 3 guest suites & more."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "714"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "714"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-08-30T11:28:27.687"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-30"
  }
  ["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(105) "1$21.294749$-157.853231$27.12$13.33$1.00$CAoSLEFGMVFpcE95WFV2TEpnd0xqSFRMSTdqbEh3bUg5UFhYSERrOHQ3M1pLNFo2"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "294.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "878000.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "831100.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(8) "46900.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(6) "100000"
  }
  ["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/16025933/1f50a1b12d2a20f0f86d8dd05adc8cdb"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "123"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(3) "459"
  }
  ["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) "4005"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "2018"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(25) "Key,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(5) "Queen"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(4) "1001"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-2-3-002-106-0459"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(12) "Single Level"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(4) "4005"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(19) "City,Mountain,Ocean"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16025933"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202117916"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1630358948"
  }
  ["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:19983698;i:1;i:19983699;i:2;i:19983700;i:3;i:19983701;i:4;i:19983702;i:5;i:19983703;i:6;i:19983704;i:7;i:19983705;i:8;i:19983706;i:9;i:19983707;i:10;i:19983708;i:11;i:19983709;i:12;i:19983710;i:13;i:19983711;i:14;i:19983712;i:15;i:19983713;i:16;i:19983714;i:17;i:19983715;i:18;i:19983716;i:19;i:19983717;i:20;i:19983718;i:21;i:20196189;i:22;i:20196190;i:23;i:20196191;i:24;i:20196192;i:25;i:20196193;i:26;i:20196194;i:27;i:20196195;i:28;i:20196196;i:29;i:20196197;i:30;i:20196198;i:31;i:20196199;i:32;i:20196200;i:33;i:20196201;i:34;i:20196202;i:35;i:20196203;i:36;i:20196204;i:37;i:20196205;i:38;i:20196206;i:39;i:20196207;i:40;i:20196208;i:41;i:20196209;i:42;i:20234522;i:43;i:20234523;i:44;i:20234524;i:45;i:20234525;i:46;i:20234526;i:47;i:20234527;i:48;i:20234528;i:49;i:20234529;i:50;i:20234530;i:51;i:20234531;i:52;i:20234532;i:53;i:20234533;i:54;i:20234534;i:55;i:20234535;i:56;i:20234536;i:57;i:20234537;i:58;i:20234538;i:59;i:20234539;i:60;i:20234540;i:61;i:20234541;i:62;i:20234542;i:63;i:20632284;i:64;i:20632285;i:65;i:20632286;i:66;i:20632287;i:67;i:20632288;i:68;i:20632289;i:69;i:20632290;i:70;i:20632291;i:71;i:20632292;i:72;i:20632293;i:73;i:20632294;i:74;i:20632295;i:75;i:20632296;i:76;i:20632297;i:77;i:20632298;i:78;i:20632299;i:79;i:20632300;i:80;i:20632301;i:81;i:20632302;i:82;i:20632303;i:83;i:20632304;}"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-15"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-30"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "935000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-30"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-8801"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(22) "ayakoancheta@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "Ayako I Ancheta"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "35912"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3480722"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "SACH"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486539"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(30) "Sachi HI Pacific Century Prop."
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-8801"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20632284"
  }
}