987 Queen Street Unit 1806 Honolulu, HI 96814

Listing
Overview

Price: $528,000
Area: KAKAAKO
Status: Sold (Limited photos per MLS privacy policy)

Experience the best of modern urban living at Aalii in the heart of Kakaako award-winning Ward Village. Wake up to gorgeous ocean views and begin your day with a short walk to Whole Foods, neighborhood cafés, award-winning restaurants, boutique shopping, Victoria Ward Park, and Ala Moana Beach Park. This beautifully maintained, move-in-ready studio is thoughtfully designed with floor-to-ceiling windows, a private lanai, Bosch appliances, premium European-style cabinetry, quartz countertops, split A/C, an in-unit washer and dryer, and one assigned parking stall. Resort-style amenities include the spectacular Sky Deck, infinity and lap pools, spa, fitness center, yoga room, private event rooms, BBQ cabanas, indoor and outdoor lounges, and beautifully landscaped gathering spaces. Whether you’re buying your first home, a second home, or an investment property -it’s an opportunity to experience the vibrant Ward Village lifestyle, where luxury, convenience, and island living come together every day. Listing by: Coldwell Banker Realty (808) 676-7200

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202612141"
  }
  ["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) "1806"
  }
  ["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) "528000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1013) "Experience the best of modern urban living at Aalii in the heart of Kakaako award-winning Ward Village. Wake up to gorgeous ocean views and begin your day with a short walk to Whole Foods, neighborhood cafés, award-winning restaurants, boutique shopping, Victoria Ward Park, and Ala Moana Beach Park. This beautifully maintained, move-in-ready studio is thoughtfully designed with floor-to-ceiling windows, a private lanai, Bosch appliances, premium European-style cabinetry, quartz countertops, split A/C, an in-unit washer and dryer, and one assigned parking stall. Resort-style amenities include the spectacular Sky Deck, infinity and lap pools, spa, fitness center, yoga room, private event rooms, BBQ cabanas, indoor and outdoor lounges, and beautifully landscaped gathering spaces. Whether you’re buying your first home, a second home, or an investment property -it’s an opportunity to experience the vibrant Ward Village lifestyle, where luxury, convenience, and island living come together every day."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["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) "419"
  }
  ["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(29) "City,Coastline,Mountain,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "556.00"
  }
  ["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(6) "CBPP15"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(29) "marie.valenzuela@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 676-7200"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(19) "Marie CL Valenzuela"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-08-06"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19535241"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-08-06T09:26:42.023"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-06-22"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Ocean"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "09:26:42.023"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27432929"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27432929"
    [1]=>
    string(8) "27432930"
    [2]=>
    string(8) "27432931"
    [3]=>
    string(8) "27432932"
    [4]=>
    string(8) "27432933"
    [5]=>
    string(8) "27432934"
    [6]=>
    string(8) "27432935"
    [7]=>
    string(8) "27432936"
    [8]=>
    string(8) "27432937"
    [9]=>
    string(8) "27432938"
    [10]=>
    string(8) "27432939"
    [11]=>
    string(8) "27432940"
    [12]=>
    string(8) "27432941"
    [13]=>
    string(8) "27432942"
    [14]=>
    string(8) "27432943"
    [15]=>
    string(8) "27432944"
    [16]=>
    string(8) "27432945"
    [17]=>
    string(8) "27432946"
    [18]=>
    string(8) "27432947"
    [19]=>
    string(8) "27432948"
    [20]=>
    string(8) "27432949"
    [21]=>
    string(8) "27432950"
    [22]=>
    string(8) "27432951"
    [23]=>
    string(8) "27432952"
    [24]=>
    string(8) "27432953"
    [25]=>
    string(8) "27438956"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202612141
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Experience the best of modern urban living at Aalii in the heart of Kakaako award-winning Ward Village. Wake up to gorgeous ocean views and begin your day with a short walk to Whole Foods, neighborhood cafés, award-winning restaurants, boutique shopping, Victoria Ward Park, and Ala Moana Beach Park. This beautifully maintained, move-in-ready studio is thoughtfully designed with floor-to-ceiling windows, a private lanai, Bosch appliances, premium European-style cabinetry, quartz countertops, split A/C, an in-unit washer and dryer, and one assigned parking stall. Resort-style amenities include the spectacular Sky Deck, infinity and lap pools, spa, fitness center, yoga room, private event rooms, BBQ cabanas, indoor and outdoor lounges, and beautifully landscaped gathering spaces. Whether you’re buying your first home, a second home, or an investment property -it’s an opportunity to experience the vibrant Ward Village lifestyle, where luxury, convenience, and island living come together every day.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => marie.valenzuela@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 676-7200
        )

    [ListAgentFullName] => Array
        (
            [0] => Marie CL Valenzuela
        )

    [CloseDate] => Array
        (
            [0] => 2026-08-06
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-08-06T09:26:42.023
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-06-22
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:26:42.023
        )

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

    [listing_image] => Array
        (
            [0] => 27432929
            [1] => 27432930
            [2] => 27432931
            [3] => 27432932
            [4] => 27432933
            [5] => 27432934
            [6] => 27432935
            [7] => 27432936
            [8] => 27432937
            [9] => 27432938
            [10] => 27432939
            [11] => 27432940
            [12] => 27432941
            [13] => 27432942
            [14] => 27432943
            [15] => 27432944
            [16] => 27432945
            [17] => 27432946
            [18] => 27432947
            [19] => 27432948
            [20] => 27432949
            [21] => 27432950
            [22] => 27432951
            [23] => 27432952
            [24] => 27432953
            [25] => 27438956
        )

)

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

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • View: City,Coastline,Mountain,Ocean
  • Listing Office: Coldwell Banker Realty

  • Maintenance Fees: $556
  • 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 August 6, 2026 - 9:26 AM 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.