Previous Next

987 Queen Street Unit 2407 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202517015"
  }
  ["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) "2407"
  }
  ["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) "669000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(957) "Welcome to 'A'ali'i in the heart of Ward Village.  This one bedroom, one bath unit is located on the 24th floor with sweeping ocean, city and mountain views.  Floor-to-ceiling glass sliding lanai door allows for natural light and refreshing trade winds to flow into the unit.  The modern kitchen boasts Bosch appliances, sleek Studio Becker cabinetry, and quartz countertops.  The unit comes equipped with a Mitsubishi split air condition unit, front-loading washer and dryer, and manual roller shades.  'A'ali'i amenities include a luxurious lobby, penthouse-level sky deck with panoramic ocean views, rooftop fitness club, indoor/outdoor event spaces, yoga room, BBQ areas and a resort-style pool and spa.  The building also has ample guest parking, bicycle and surfboard storage facilities, and a dog park.  Enjoy Kakaako living with great restaurants, amazing shopping, Whold Foods Market, Ward Theater Complex, and Ala Moana Beach Park just steps away."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "AMG Realty Inc"
  }
  ["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) "483"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(5) "Aalii"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(26) "City,Mountain,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "601.15"
  }
  ["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) "ENDO"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "gtaira@amghawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 343-6789"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Garrett S Taira"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-10-23"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18894686"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-10-25T09:08:43.637"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-07-29"
  }
  ["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) "09:08:43.637"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27087699"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27087699"
    [1]=>
    string(8) "27087700"
    [2]=>
    string(8) "27087701"
    [3]=>
    string(8) "27087702"
    [4]=>
    string(8) "27087703"
    [5]=>
    string(8) "27087704"
    [6]=>
    string(8) "27087705"
    [7]=>
    string(8) "27087706"
    [8]=>
    string(8) "27087707"
    [9]=>
    string(8) "27087708"
    [10]=>
    string(8) "27087709"
    [11]=>
    string(8) "27087710"
    [12]=>
    string(8) "27087711"
    [13]=>
    string(8) "27087712"
    [14]=>
    string(8) "27087713"
    [15]=>
    string(8) "27087714"
    [16]=>
    string(8) "27087715"
    [17]=>
    string(8) "27087716"
    [18]=>
    string(8) "27087717"
    [19]=>
    string(8) "27087718"
    [20]=>
    string(8) "27087719"
    [21]=>
    string(8) "27087720"
    [22]=>
    string(8) "27087721"
    [23]=>
    string(8) "27087722"
    [24]=>
    string(8) "27087723"
    [25]=>
    string(8) "27087724"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202517015
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to 'A'ali'i in the heart of Ward Village.  This one bedroom, one bath unit is located on the 24th floor with sweeping ocean, city and mountain views.  Floor-to-ceiling glass sliding lanai door allows for natural light and refreshing trade winds to flow into the unit.  The modern kitchen boasts Bosch appliances, sleek Studio Becker cabinetry, and quartz countertops.  The unit comes equipped with a Mitsubishi split air condition unit, front-loading washer and dryer, and manual roller shades.  'A'ali'i amenities include a luxurious lobby, penthouse-level sky deck with panoramic ocean views, rooftop fitness club, indoor/outdoor event spaces, yoga room, BBQ areas and a resort-style pool and spa.  The building also has ample guest parking, bicycle and surfboard storage facilities, and a dog park.  Enjoy Kakaako living with great restaurants, amazing shopping, Whold Foods Market, Ward Theater Complex, and Ala Moana Beach Park just steps away.
        )

    [ListOfficeName] => Array
        (
            [0] => AMG Realty Inc
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => gtaira@amghawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 343-6789
        )

    [ListAgentFullName] => Array
        (
            [0] => Garrett S Taira
        )

    [CloseDate] => Array
        (
            [0] => 2025-10-23
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-10-25T09:08:43.637
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-07-29
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:08:43.637
        )

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

    [listing_image] => Array
        (
            [0] => 27087699
            [1] => 27087700
            [2] => 27087701
            [3] => 27087702
            [4] => 27087703
            [5] => 27087704
            [6] => 27087705
            [7] => 27087706
            [8] => 27087707
            [9] => 27087708
            [10] => 27087709
            [11] => 27087710
            [12] => 27087711
            [13] => 27087712
            [14] => 27087713
            [15] => 27087714
            [16] => 27087715
            [17] => 27087716
            [18] => 27087717
            [19] => 27087718
            [20] => 27087719
            [21] => 27087720
            [22] => 27087721
            [23] => 27087722
            [24] => 27087723
            [25] => 27087724
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 1
• View: City,Mountain,Ocean,Sunset
• Listing Office: AMG Realty Inc

FINANCIAL INFO

• Maintenance Fees: $601
• 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 October 25, 2025 - 9:08 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.