1001 Queen Street Unit 2506 Honolulu, HI 96814

Take a Virtual Tour

Listing
Overview

Price: $1,320,000
Area: KAKAAKO
Status: Active

Welcome to this furnished and rarely lived-in 2-bedroom 2-bath residence in the heart of the thriving Kakaako neighborhood. Situated on the preferred Diamond Head side of Ae’o building, this thoughtfully designed unit features floor-to-ceiling windows boasting stunning ocean, city & mountain views. Its efficient layout, complete with premium Bosch stainless steel appliances, quartz counter tops, motorized shades, hardwood floors, Toto washlet, and the building resort style amenities truly enhance both comfort and privacy. In addition, two assigned parking stalls on the mezzanine level makes shopping at Wholefoods super convenient. Centrally located in the award-winning Ward Village development, you are steps away from shopping, dining, entertainment, beach – all part of Honolulu’s most dynamic and walkable urban community. Listing by: BHGRE Advantage Realty (808) 392-9799

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202514113"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1001"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Queen"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "2506"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96814"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(59) "https://listings.hetproductions.com/sites/jnwwqzx/unbranded"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1320000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(843) "Welcome to this furnished and rarely lived-in 2-bedroom 2-bath residence in the heart of the thriving Kakaako neighborhood.  Situated on the preferred Diamond Head side of Ae’o building, this thoughtfully designed unit features floor-to-ceiling windows boasting stunning ocean, city & mountain views.  Its efficient layout, complete with premium Bosch stainless steel appliances, quartz counter tops, motorized shades, hardwood floors, Toto washlet, and the building resort style amenities truly enhance both comfort and privacy. In addition, two assigned parking stalls on the mezzanine level makes shopping at Wholefoods super convenient.  Centrally located in the award-winning Ward Village development, you are steps away from shopping, dining, entertainment, beach – all part of Honolulu’s most dynamic and walkable urban community."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "983"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2018"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(4) "Ae'o"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(33) "City,Coastline,Diamond Head,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1022.77"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "ADVG"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "MeiP@BetterHawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 392-9799"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(8) "Mei Pang"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18808315"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-06-13T20:26:43.167"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-13"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "20:26:43.167"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27030574"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27030574"
    [1]=>
    string(8) "27030575"
    [2]=>
    string(8) "27030576"
    [3]=>
    string(8) "27030577"
    [4]=>
    string(8) "27030578"
    [5]=>
    string(8) "27030579"
    [6]=>
    string(8) "27030580"
    [7]=>
    string(8) "27030581"
    [8]=>
    string(8) "27030582"
    [9]=>
    string(8) "27030583"
    [10]=>
    string(8) "27030584"
    [11]=>
    string(8) "27030585"
    [12]=>
    string(8) "27030586"
    [13]=>
    string(8) "27030587"
    [14]=>
    string(8) "27030588"
    [15]=>
    string(8) "27030589"
    [16]=>
    string(8) "27030590"
    [17]=>
    string(8) "27030591"
    [18]=>
    string(8) "27030592"
    [19]=>
    string(8) "27030593"
    [20]=>
    string(8) "27030594"
    [21]=>
    string(8) "27030595"
    [22]=>
    string(8) "27030596"
    [23]=>
    string(8) "27030597"
    [24]=>
    string(8) "27030598"
    [25]=>
    string(8) "27030599"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202514113
        )

    [StreetNumber] => Array
        (
            [0] => 1001
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

    [StreetName] => Array
        (
            [0] => Queen
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => 2506
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96814
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://listings.hetproductions.com/sites/jnwwqzx/unbranded
        )

    [ListPrice] => Array
        (
            [0] => 1320000.00
        )

    [Neighbourhood] => Array
        (
            [0] => KAKAAKO
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Welcome to this furnished and rarely lived-in 2-bedroom 2-bath residence in the heart of the thriving Kakaako neighborhood.  Situated on the preferred Diamond Head side of Ae’o building, this thoughtfully designed unit features floor-to-ceiling windows boasting stunning ocean, city & mountain views.  Its efficient layout, complete with premium Bosch stainless steel appliances, quartz counter tops, motorized shades, hardwood floors, Toto washlet, and the building resort style amenities truly enhance both comfort and privacy. In addition, two assigned parking stalls on the mezzanine level makes shopping at Wholefoods super convenient.  Centrally located in the award-winning Ward Village development, you are steps away from shopping, dining, entertainment, beach – all part of Honolulu’s most dynamic and walkable urban community.
        )

    [ListOfficeName] => Array
        (
            [0] => BHGRE Advantage Realty
        )

    [BedsTotal] => Array
        (
            [0] => 2
        )

    [BathsFull] => Array
        (
            [0] => 2
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 
        )

    [SqftTotal] => Array
        (
            [0] => 983
        )

    [YearBuilt] => Array
        (
            [0] => 2018
        )

    [BuildingName] => Array
        (
            [0] => Ae'o
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

    [ParkingTotal] => Array
        (
            [0] => 2
        )

    [StoriesType] => Array
        (
            [0] => 21+
        )

    [View] => Array
        (
            [0] => City,Coastline,Diamond Head,Ocean
        )

    [MaintenanceExpense] => Array
        (
            [0] => 1022.77
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => ADVG
        )

    [ListAgentEmail] => Array
        (
            [0] => MeiP@BetterHawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 392-9799
        )

    [ListAgentFullName] => Array
        (
            [0] => Mei Pang
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18808315
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-06-13T20:26:43.167
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-06-13
        )

    [MLSAreaMajor] => Array
        (
            [0] => Metro
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 20:26:43.167
        )

    [_thumbnail_id] => Array
        (
            [0] => 27030574
        )

    [listing_image] => Array
        (
            [0] => 27030574
            [1] => 27030575
            [2] => 27030576
            [3] => 27030577
            [4] => 27030578
            [5] => 27030579
            [6] => 27030580
            [7] => 27030581
            [8] => 27030582
            [9] => 27030583
            [10] => 27030584
            [11] => 27030585
            [12] => 27030586
            [13] => 27030587
            [14] => 27030588
            [15] => 27030589
            [16] => 27030590
            [17] => 27030591
            [18] => 27030592
            [19] => 27030593
            [20] => 27030594
            [21] => 27030595
            [22] => 27030596
            [23] => 27030597
            [24] => 27030598
            [25] => 27030599
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Living (sf): 983
  • Year Built: 2018
  • Building Name: Ae'o

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: City,Coastline,Diamond Head,Ocean
  • Listing Office: BHGRE Advantage Realty

  • Maintenance Fees: $1,023
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on June 13, 2025 - 8:26 PM Information is deemed reliable but not guaranteed. Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.

© Marcus Realty. All Rights Reserved.