Previous Next

987 Queen Street Unit 3500 Honolulu, HI 96814

Listing
Overview

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

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202419046"
  }
  ["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) "3500"
  }
  ["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) "955000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "960000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1125) "Ocean facing one-bedroom unit, fully furnished, 1 parking, 1 storage (PS5-026). Breathtaking ocean views with a 44 sf lanai that allows indoor and outdoor living. A smart home that fully maximizes space for urban living with a well-appointed kitchen complete with cutting-edge Bosch appliances, a full-height backsplash, and a natural stone countertop. High-quality customized furniture. Abundant places for storage. A`ali`i fosters the essence of effortless island living, where every detail has been considered, and relaxation awaits! This building features unique indoor/outdoor lounges and recreational areas beautifully curated and designed to be an extension of your private space. Resort-style amenities include pool, spa, BBQ grills, private cabanas, kids play area, kids pool, and a 42nd-floor penthouse level amenity deck with fitness center, yoga room, meeting rooms, pool table, and outdoor sky terrace and recreation space. A`ali`i is conveniently located in the dynamic Ward Village neighborhood with plenty of restaurant selections, near Ala Moana Beach Park, Ala Moana Shopping Center, and Whole Foods Market."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Jack Tyrrell & Company"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["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) "600"
  }
  ["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(21) "Coastline,Ocean,Other"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "775.51"
  }
  ["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) "BAYS"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "jack@jtchawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 532-3330"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "John L Tyrrell"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-03-17"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-03-17T08:12:21.807"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18223416"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-29T19:24:01.283"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26676157"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26676157"
    [1]=>
    string(8) "26676158"
    [2]=>
    string(8) "26676159"
    [3]=>
    string(8) "26676160"
    [4]=>
    string(8) "26676161"
    [5]=>
    string(8) "26676162"
    [6]=>
    string(8) "26676163"
    [7]=>
    string(8) "26676164"
    [8]=>
    string(8) "26676165"
    [9]=>
    string(8) "26676166"
    [10]=>
    string(8) "26676167"
    [11]=>
    string(8) "26676168"
    [12]=>
    string(8) "26676169"
    [13]=>
    string(8) "26676170"
    [14]=>
    string(8) "26676171"
    [15]=>
    string(8) "26676172"
    [16]=>
    string(8) "26676173"
    [17]=>
    string(8) "26676174"
    [18]=>
    string(8) "26676175"
    [19]=>
    string(8) "26676176"
    [20]=>
    string(8) "26676177"
    [21]=>
    string(8) "26676178"
    [22]=>
    string(8) "26676179"
    [23]=>
    string(8) "26676180"
    [24]=>
    string(8) "26676181"
    [25]=>
    string(8) "26676182"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-08-29"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "08:12:21.807"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202419046
        )

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

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

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

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

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

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

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

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

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

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

    [CurrentPrice] => Array
        (
            [0] => 960000.00
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => Ocean facing one-bedroom unit, fully furnished, 1 parking, 1 storage (PS5-026). Breathtaking ocean views with a 44 sf lanai that allows indoor and outdoor living. A smart home that fully maximizes space for urban living with a well-appointed kitchen complete with cutting-edge Bosch appliances, a full-height backsplash, and a natural stone countertop. High-quality customized furniture. Abundant places for storage. A`ali`i fosters the essence of effortless island living, where every detail has been considered, and relaxation awaits! This building features unique indoor/outdoor lounges and recreational areas beautifully curated and designed to be an extension of your private space. Resort-style amenities include pool, spa, BBQ grills, private cabanas, kids play area, kids pool, and a 42nd-floor penthouse level amenity deck with fitness center, yoga room, meeting rooms, pool table, and outdoor sky terrace and recreation space. A`ali`i is conveniently located in the dynamic Ward Village neighborhood with plenty of restaurant selections, near Ala Moana Beach Park, Ala Moana Shopping Center, and Whole Foods Market.
        )

    [ListOfficeName] => Array
        (
            [0] => Jack Tyrrell & Company
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Coastline,Ocean,Other
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => jack@jtchawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 532-3330
        )

    [ListAgentFullName] => Array
        (
            [0] => John L Tyrrell
        )

    [CloseDate] => Array
        (
            [0] => 2025-03-17
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-03-17T08:12:21.807
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-08-29T19:24:01.283
        )

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

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

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

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

    [listing_image] => Array
        (
            [0] => 26676157
            [1] => 26676158
            [2] => 26676159
            [3] => 26676160
            [4] => 26676161
            [5] => 26676162
            [6] => 26676163
            [7] => 26676164
            [8] => 26676165
            [9] => 26676166
            [10] => 26676167
            [11] => 26676168
            [12] => 26676169
            [13] => 26676170
            [14] => 26676171
            [15] => 26676172
            [16] => 26676173
            [17] => 26676174
            [18] => 26676175
            [19] => 26676176
            [20] => 26676177
            [21] => 26676178
            [22] => 26676179
            [23] => 26676180
            [24] => 26676181
            [25] => 26676182
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-08-29
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 08:12:21.807
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: Coastline,Ocean,Other
• Listing Office: Jack Tyrrell & Company

FINANCIAL INFO

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

SCHOOLS

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 March 17, 2025 - 8:12 AM 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.