987 Queen Street Unit 223 Honolulu, HI 96814

Listing
Overview

Price: $515,000
Area: KAKAAKO
Status: Active

Welcome to A‘ali‘i #223 — a sleek and modern studio perfectly positioned in the heart of Kaka‘ako’s vibrant community. Located on the desirable podium level of the popular A‘ali‘i, this residence combines luxury, convenience, and style. This thoughtfully designed studio features high-end Italian furnishings and custom built-ins, maximizing space while offering elegance and comfort throughout. As an A‘ali‘i resident, you’ll have access to a full suite of luxury amenities, including BBQ cabanas, a dog park, fitness center, and multiple meeting rooms. Located in the vibrant Kaka‘ako neighborhood, you’re just moments away from world-class dining, shopping, and entertainment, all within a lively, walkable community. A storage unit is deeded to the property and is negotiable. Listing by: Infinite Ocean LLC (808) 971-1138

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202525416"
  }
  ["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(3) "223"
  }
  ["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(9) "515000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(804) "Welcome to A‘ali‘i #223 — a sleek and modern studio perfectly positioned in the heart of Kaka‘ako’s vibrant community. Located on the desirable podium level of the popular A‘ali‘i, this residence combines luxury, convenience, and style. This thoughtfully designed studio features high-end Italian furnishings and custom built-ins, maximizing space while offering elegance and comfort throughout. As an A‘ali‘i resident, you’ll have access to a full suite of luxury amenities, including BBQ cabanas, a dog park, fitness center, and multiple meeting rooms. Located in the vibrant Kaka‘ako neighborhood, you’re just moments away from world-class dining, shopping, and entertainment, all within a lively, walkable community. A storage unit is deeded to the property and is negotiable."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(18) "Infinite Ocean LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "282"
  }
  ["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(11) "City,Garden"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "462.32"
  }
  ["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) "IOHI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "bob.sage@iohawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 971-1138"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(8) "Bob Sage"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19117541"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-02-19T15:07:14.007"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-11-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) "15:07:14.007"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27219298"
  }
  ["listing_image"]=>
  array(20) {
    [0]=>
    string(8) "27219298"
    [1]=>
    string(8) "27219299"
    [2]=>
    string(8) "27219300"
    [3]=>
    string(8) "27219301"
    [4]=>
    string(8) "27219302"
    [5]=>
    string(8) "27219303"
    [6]=>
    string(8) "27219304"
    [7]=>
    string(8) "27219305"
    [8]=>
    string(8) "27219306"
    [9]=>
    string(8) "27219307"
    [10]=>
    string(8) "27219308"
    [11]=>
    string(8) "27219309"
    [12]=>
    string(8) "27219310"
    [13]=>
    string(8) "27219311"
    [14]=>
    string(8) "27219312"
    [15]=>
    string(8) "27219313"
    [16]=>
    string(8) "27219314"
    [17]=>
    string(8) "27219315"
    [18]=>
    string(8) "27219316"
    [19]=>
    string(8) "27219317"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202525416
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to A‘ali‘i #223 — a sleek and modern studio perfectly positioned in the heart of Kaka‘ako’s vibrant community. Located on the desirable podium level of the popular A‘ali‘i, this residence combines luxury, convenience, and style. This thoughtfully designed studio features high-end Italian furnishings and custom built-ins, maximizing space while offering elegance and comfort throughout. As an A‘ali‘i resident, you’ll have access to a full suite of luxury amenities, including BBQ cabanas, a dog park, fitness center, and multiple meeting rooms. Located in the vibrant Kaka‘ako neighborhood, you’re just moments away from world-class dining, shopping, and entertainment, all within a lively, walkable community. A storage unit is deeded to the property and is negotiable.
        )

    [ListOfficeName] => Array
        (
            [0] => Infinite Ocean LLC
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => City,Garden
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => bob.sage@iohawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 971-1138
        )

    [ListAgentFullName] => Array
        (
            [0] => Bob Sage
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-02-19T15:07:14.007
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:07:14.007
        )

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

    [listing_image] => Array
        (
            [0] => 27219298
            [1] => 27219299
            [2] => 27219300
            [3] => 27219301
            [4] => 27219302
            [5] => 27219303
            [6] => 27219304
            [7] => 27219305
            [8] => 27219306
            [9] => 27219307
            [10] => 27219308
            [11] => 27219309
            [12] => 27219310
            [13] => 27219311
            [14] => 27219312
            [15] => 27219313
            [16] => 27219314
            [17] => 27219315
            [18] => 27219316
            [19] => 27219317
        )

)

  • Full Baths: 1
  • Living (sf): 282
  • Year Built: 2019
  • Building Name: Aalii

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • View: City,Garden
  • Listing Office: Infinite Ocean LLC

  • Maintenance Fees: $462
  • 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 February 19, 2026 - 3:07 PM Information is deemed reliable but not guaranteed. Copyright: 2026 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.