987 Queen Street Unit 606 Honolulu, HI 96814

Listing
Overview

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

Prime Kaka‘ako Living. Move right into this well maintained furnished studio located on the 6th floor of A‘ali‘i, one of Honolulu’s most sought-after residences. This thoughtfully designed home comes with 1 assigned parking stall and is ideal for buyers seeking convenience, comfort, and resort-style living in the heart of Kaka‘ako. Just minutes away from Whole Foods, Ward Village, AMC Theaters, South Shore Market, and Ala Moana Beach Park, you’ll enjoy urban living at its best. Inside, the studio features a well-equipped kitchen with all essentials, coffee maker, plates, glasses, utensils, towels, and more. Furnishings include a bed, TV stand, dining table, and chairs, offering immediate move-in readiness or a turn-key investment opportunity. Residents have exclusive access to unparalleled amenities, including: Adult and kids’ pools, Poolside cabanas & BBQ areas, Indoor/outdoor event spaces, A state-of-the-art fitness center, Sprawling rooftop deck (Lanai 42) with panoramic views and gathering spaces, Whether you’re seeking your own private retreat or a sophisticated urban pied-à-terre, this A‘ali‘i studio offers everything you need in one of Honolulu’s most dynamic neighborhoods. Listing by: Century 21 Island Homes (808) 542-4610

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202517587"
  }
  ["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) "606"
  }
  ["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) "598000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1223) "Prime Kaka‘ako Living. Move right into this well maintained furnished studio located on the 6th floor of A‘ali‘i, one of Honolulu’s most sought-after residences. This thoughtfully designed home comes with 1 assigned parking stall and is ideal for buyers seeking convenience, comfort, and resort-style living in the heart of Kaka‘ako. Just minutes away from Whole Foods, Ward Village, AMC Theaters, South Shore Market, and Ala Moana Beach Park, you’ll enjoy urban living at its best. Inside, the studio features a well-equipped kitchen with all essentials, coffee maker, plates, glasses, utensils, towels, and more. Furnishings include a bed, TV stand, dining table, and chairs, offering immediate move-in readiness or a turn-key investment opportunity.  Residents have exclusive access to unparalleled amenities, including: Adult and kids’ pools, Poolside cabanas & BBQ areas, Indoor/outdoor event spaces, A state-of-the-art fitness center, Sprawling rooftop deck (Lanai 42) with panoramic views and gathering spaces, Whether you’re seeking your own private retreat or a sophisticated urban pied-à-terre, this A‘ali‘i studio offers everything you need in one of Honolulu’s most dynamic neighborhoods."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(23) "Century 21 Island Homes"
  }
  ["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) "413"
  }
  ["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) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "507.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) "CENI03"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "ian@c21islandhomes.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 542-4610"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Ian Wheeler"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18911249"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-08-14T16:04:01.303"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-08-10"
  }
  ["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) "16:04:01.303"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27102465"
  }
  ["listing_image"]=>
  array(15) {
    [0]=>
    string(8) "27102465"
    [1]=>
    string(8) "27102466"
    [2]=>
    string(8) "27102467"
    [3]=>
    string(8) "27102468"
    [4]=>
    string(8) "27102469"
    [5]=>
    string(8) "27102470"
    [6]=>
    string(8) "27102471"
    [7]=>
    string(8) "27102472"
    [8]=>
    string(8) "27102473"
    [9]=>
    string(8) "27102474"
    [10]=>
    string(8) "27102475"
    [11]=>
    string(8) "27102476"
    [12]=>
    string(8) "27102477"
    [13]=>
    string(8) "27102478"
    [14]=>
    string(8) "27102479"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202517587
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Prime Kaka‘ako Living. Move right into this well maintained furnished studio located on the 6th floor of A‘ali‘i, one of Honolulu’s most sought-after residences. This thoughtfully designed home comes with 1 assigned parking stall and is ideal for buyers seeking convenience, comfort, and resort-style living in the heart of Kaka‘ako. Just minutes away from Whole Foods, Ward Village, AMC Theaters, South Shore Market, and Ala Moana Beach Park, you’ll enjoy urban living at its best. Inside, the studio features a well-equipped kitchen with all essentials, coffee maker, plates, glasses, utensils, towels, and more. Furnishings include a bed, TV stand, dining table, and chairs, offering immediate move-in readiness or a turn-key investment opportunity.  Residents have exclusive access to unparalleled amenities, including: Adult and kids’ pools, Poolside cabanas & BBQ areas, Indoor/outdoor event spaces, A state-of-the-art fitness center, Sprawling rooftop deck (Lanai 42) with panoramic views and gathering spaces, Whether you’re seeking your own private retreat or a sophisticated urban pied-à-terre, this A‘ali‘i studio offers everything you need in one of Honolulu’s most dynamic neighborhoods.
        )

    [ListOfficeName] => Array
        (
            [0] => Century 21 Island Homes
        )

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

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

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

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

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

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

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

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

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

    [StoriesType] => Array
        (
            [0] => One
        )

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => ian@c21islandhomes.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 542-4610
        )

    [ListAgentFullName] => Array
        (
            [0] => Ian Wheeler
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-08-14T16:04:01.303
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-08-10
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 16:04:01.303
        )

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

    [listing_image] => Array
        (
            [0] => 27102465
            [1] => 27102466
            [2] => 27102467
            [3] => 27102468
            [4] => 27102469
            [5] => 27102470
            [6] => 27102471
            [7] => 27102472
            [8] => 27102473
            [9] => 27102474
            [10] => 27102475
            [11] => 27102476
            [12] => 27102477
            [13] => 27102478
            [14] => 27102479
        )

)

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

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • View: None
  • Listing Office: Century 21 Island Homes

  • Maintenance Fees: $507
  • 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 14, 2025 - 4:04 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.