987 Queen Street Unit 621 Honolulu, HI 96813

Listing
Overview

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

This thoughtfully designed studio located in ‘A‘ali‘i at Ward Village features high-quality, built-in furnishings that maximize both space and functionality. The unit includes a custom Murphy bed system with integrated couch, a built-in desk, and abundant closet and cabinet storage. The kitchen is outfitted with a sleek custom-panel refrigerator and dishwasher, creating a seamless and luxurious aesthetic while maintaining full functionality. Residents of ‘A‘ali‘i enjoy resort-style amenities, including a swimming pool, hot tub, state-of-the-art fitness center, multiple spacious gathering and party rooms, and a stunning 42nd-floor sky lounge with panoramic views. Ideally situated in the heart of Ward Village, this planned, walkable neighborhood offers convenient access to Ala Moana Shopping Center, Waikiki, Whole Foods Market, and an array of dining and entertainment options! The unit also includes a dedicated parking stall equipped with a 220V outlet, perfect for electric vehicle charging! Listing by: SC Realty, LLC (808) 398-4690

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202600446"
  }
  ["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) "621"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96813"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "525000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1016) "This thoughtfully designed studio located in ‘A‘ali‘i at Ward Village features high-quality, built-in furnishings that maximize both space and functionality. The unit includes a custom Murphy bed system with integrated couch, a built-in desk, and abundant closet and cabinet storage. The kitchen is outfitted with a sleek custom-panel refrigerator and dishwasher, creating a seamless and luxurious aesthetic while maintaining full functionality. Residents of ‘A‘ali‘i enjoy resort-style amenities, including a swimming pool, hot tub, state-of-the-art fitness center, multiple spacious gathering and party rooms, and a stunning 42nd-floor sky lounge with panoramic views. Ideally situated in the heart of Ward Village, this planned, walkable neighborhood offers convenient access to Ala Moana Shopping Center, Waikiki, Whole Foods Market, and an array of dining and entertainment options! The unit also includes a dedicated parking stall equipped with a 220V outlet, perfect for electric vehicle charging!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "SC Realty, 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) "2021"
  }
  ["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) "393.33"
  }
  ["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) "SCRE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "Justin.Baptista@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 398-4690"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(25) "Justin Fredric B Baptista"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19201285"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-09T11:06:27.210"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-01-08"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:06:27.210"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27265686"
  }
  ["listing_image"]=>
  array(19) {
    [0]=>
    string(8) "27265686"
    [1]=>
    string(8) "27265687"
    [2]=>
    string(8) "27265688"
    [3]=>
    string(8) "27265689"
    [4]=>
    string(8) "27265690"
    [5]=>
    string(8) "27265691"
    [6]=>
    string(8) "27265692"
    [7]=>
    string(8) "27265693"
    [8]=>
    string(8) "27265694"
    [9]=>
    string(8) "27265695"
    [10]=>
    string(8) "27265696"
    [11]=>
    string(8) "27265697"
    [12]=>
    string(8) "27265698"
    [13]=>
    string(8) "27265699"
    [14]=>
    string(8) "27265700"
    [15]=>
    string(8) "27265701"
    [16]=>
    string(8) "27265702"
    [17]=>
    string(8) "27265703"
    [18]=>
    string(8) "27265704"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202600446
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => This thoughtfully designed studio located in ‘A‘ali‘i at Ward Village features high-quality, built-in furnishings that maximize both space and functionality. The unit includes a custom Murphy bed system with integrated couch, a built-in desk, and abundant closet and cabinet storage. The kitchen is outfitted with a sleek custom-panel refrigerator and dishwasher, creating a seamless and luxurious aesthetic while maintaining full functionality. Residents of ‘A‘ali‘i enjoy resort-style amenities, including a swimming pool, hot tub, state-of-the-art fitness center, multiple spacious gathering and party rooms, and a stunning 42nd-floor sky lounge with panoramic views. Ideally situated in the heart of Ward Village, this planned, walkable neighborhood offers convenient access to Ala Moana Shopping Center, Waikiki, Whole Foods Market, and an array of dining and entertainment options! The unit also includes a dedicated parking stall equipped with a 220V outlet, perfect for electric vehicle charging!
        )

    [ListOfficeName] => Array
        (
            [0] => SC Realty, LLC
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Justin.Baptista@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 398-4690
        )

    [ListAgentFullName] => Array
        (
            [0] => Justin Fredric B Baptista
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-09T11:06:27.210
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-01-08
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:06:27.210
        )

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

    [listing_image] => Array
        (
            [0] => 27265686
            [1] => 27265687
            [2] => 27265688
            [3] => 27265689
            [4] => 27265690
            [5] => 27265691
            [6] => 27265692
            [7] => 27265693
            [8] => 27265694
            [9] => 27265695
            [10] => 27265696
            [11] => 27265697
            [12] => 27265698
            [13] => 27265699
            [14] => 27265700
            [15] => 27265701
            [16] => 27265702
            [17] => 27265703
            [18] => 27265704
        )

)

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

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

  • Maintenance Fees: $393
  • 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 March 9, 2026 - 11:06 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.