987 Queen Street Unit 2514 Honolulu, HI 96814

Listing
Overview

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

Sweeping views from this rarely available prime corner end-unit in the highly desirable Aalii, featuring one of the building’s most sought-after 2-bedroom floor plans. This residence offers a unique tri-view perspective from the living room with ocean, mountain, and city views—a rare combination made possible by its corner orientation and expansive floor-to-ceiling windows. The layout provides excellent bedroom separation for added privacy, ideal for both everyday living and hosting guests. Step onto the lanai to enjoy ocean views overlooking Kewalo Basin Boat Harbor, adding a dynamic coastal element to the urban setting. This home is enhanced with custom built-ins, electronic blinds, and upgraded storage solutions throughout. Offered fully furnished and turnkey, the residence allows for effortless move-in or immediate enjoyment as a second home or investment. Storage included with the unit. Ideally located within the award winning master-planned community of Ward Village, Aalii offers resort-style amenities and convenient access to beaches, dining, shopping, and Honolulu’s premier lifestyle destinations. Listing by: List Sotheby's Int'l Realty (808) 201-4470

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202528130"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "987"
  }
  ["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) "2514"
  }
  ["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(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1025000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1128) "Sweeping views from this rarely available prime corner end-unit in the highly desirable Aalii, featuring one of the building’s most sought-after 2-bedroom floor plans. This residence offers a unique tri-view perspective from the living room with ocean, mountain, and city views—a rare combination made possible by its corner orientation and expansive floor-to-ceiling windows. The layout provides excellent bedroom separation for added privacy, ideal for both everyday living and hosting guests. Step onto the lanai to enjoy ocean views overlooking Kewalo Basin Boat Harbor, adding a dynamic coastal element to the urban setting. This home is enhanced with custom built-ins, electronic blinds, and upgraded storage solutions throughout. Offered fully furnished and turnkey, the residence allows for effortless move-in or immediate enjoyment as a second home or investment. Storage included with the unit. Ideally located within the award winning master-planned community of Ward Village, Aalii offers resort-style amenities and convenient access to beaches, dining, shopping, and Honolulu’s premier lifestyle destinations."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l 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) "969"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2019"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(5) "Aalii"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(19) "City,Mountain,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1175.89"
  }
  ["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) "LIST"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "listings@hiestates.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 201-4470"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(17) "Scott K Startsman"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19176756"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-12-18T17:40:31.813"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-12-18"
  }
  ["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) "17:40:31.813"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27249662"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27249662"
    [1]=>
    string(8) "27249663"
    [2]=>
    string(8) "27249664"
    [3]=>
    string(8) "27249665"
    [4]=>
    string(8) "27249666"
    [5]=>
    string(8) "27249667"
    [6]=>
    string(8) "27249668"
    [7]=>
    string(8) "27249669"
    [8]=>
    string(8) "27249670"
    [9]=>
    string(8) "27249671"
    [10]=>
    string(8) "27249672"
    [11]=>
    string(8) "27249673"
    [12]=>
    string(8) "27249674"
    [13]=>
    string(8) "27249675"
    [14]=>
    string(8) "27249676"
    [15]=>
    string(8) "27249677"
    [16]=>
    string(8) "27249678"
    [17]=>
    string(8) "27249679"
    [18]=>
    string(8) "27249680"
    [19]=>
    string(8) "27249681"
    [20]=>
    string(8) "27249682"
    [21]=>
    string(8) "27249683"
    [22]=>
    string(8) "27249684"
    [23]=>
    string(8) "27249685"
    [24]=>
    string(8) "27249686"
    [25]=>
    string(8) "27249687"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202528130
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Sweeping views from this rarely available prime corner end-unit in the highly desirable Aalii, featuring one of the building’s most sought-after 2-bedroom floor plans. This residence offers a unique tri-view perspective from the living room with ocean, mountain, and city views—a rare combination made possible by its corner orientation and expansive floor-to-ceiling windows. The layout provides excellent bedroom separation for added privacy, ideal for both everyday living and hosting guests. Step onto the lanai to enjoy ocean views overlooking Kewalo Basin Boat Harbor, adding a dynamic coastal element to the urban setting. This home is enhanced with custom built-ins, electronic blinds, and upgraded storage solutions throughout. Offered fully furnished and turnkey, the residence allows for effortless move-in or immediate enjoyment as a second home or investment. Storage included with the unit. Ideally located within the award winning master-planned community of Ward Village, Aalii offers resort-style amenities and convenient access to beaches, dining, shopping, and Honolulu’s premier lifestyle destinations.
        )

    [ListOfficeName] => Array
        (
            [0] => List Sotheby's Int'l Realty
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Aalii
        )

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

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

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

    [View] => Array
        (
            [0] => City,Mountain,Ocean
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => listings@hiestates.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 201-4470
        )

    [ListAgentFullName] => Array
        (
            [0] => Scott K Startsman
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-12-18T17:40:31.813
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-12-18
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:40:31.813
        )

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

    [listing_image] => Array
        (
            [0] => 27249662
            [1] => 27249663
            [2] => 27249664
            [3] => 27249665
            [4] => 27249666
            [5] => 27249667
            [6] => 27249668
            [7] => 27249669
            [8] => 27249670
            [9] => 27249671
            [10] => 27249672
            [11] => 27249673
            [12] => 27249674
            [13] => 27249675
            [14] => 27249676
            [15] => 27249677
            [16] => 27249678
            [17] => 27249679
            [18] => 27249680
            [19] => 27249681
            [20] => 27249682
            [21] => 27249683
            [22] => 27249684
            [23] => 27249685
            [24] => 27249686
            [25] => 27249687
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Living (sf): 969
  • Year Built: 2019
  • Building Name: Aalii

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • View: City,Mountain,Ocean
  • Listing Office: List Sotheby's Int'l Realty

  • Maintenance Fees: $1,176
  • 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 December 18, 2025 - 5:40 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.