Previous Next

987 Queen Street Unit 3404 Honolulu, HI 96814

Listing
Overview

Price: $799,000
Area: KAKAAKO
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202512121"
  }
  ["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) "3404"
  }
  ["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) "799000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(980) "Welcome to 'A'ali'i in the vibrant Ward Village / Kakaako. This one-bedroom unit is on the 34th floor with stunning ocean and city views. The open kitchen concept features Bosch appliances, Studio Becker cabinetry, and natural stone countertops. Aa'lii has many great amenities, located on the 1st floor you will find a dog park and green space. On the 8th floor, showcases a jacuzzi , adult pool, keiki pool, BBQ pit and 5 indoor and outdoor party rooms for residents to use. 'A'ali'i amenities also include a luxurious lobby and penthouse-level sky deck with panoramic ocean views. This 42nd-floor penthouse level amenity deck come with fitness center, yoga room, meeting rooms, pool table, and outdoor sky terrace and recreation space. The building also has ample guest parking, bicycle and surfboard storage facilities. Enjoy Kakaako living with great restaurants, amazing shopping, Whole Foods Market, Ward Theater Complex, and Ala Moana Beach Park just steps away. Must see!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Locations LLC"
  }
  ["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) "624"
  }
  ["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(10) "City,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "802.01"
  }
  ["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) "LOCA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(28) "kevin.yu@locationshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-4200"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Kevin Y Yu"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18749790"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-08-06T11:20:44.807"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-16"
  }
  ["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) "11:20:44.807"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26998782"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26998782"
    [1]=>
    string(8) "26998783"
    [2]=>
    string(8) "26998784"
    [3]=>
    string(8) "26998785"
    [4]=>
    string(8) "26998786"
    [5]=>
    string(8) "26998787"
    [6]=>
    string(8) "26998788"
    [7]=>
    string(8) "26998789"
    [8]=>
    string(8) "26998790"
    [9]=>
    string(8) "26998791"
    [10]=>
    string(8) "26998792"
    [11]=>
    string(8) "26998793"
    [12]=>
    string(8) "26998794"
    [13]=>
    string(8) "26998795"
    [14]=>
    string(8) "26998796"
    [15]=>
    string(8) "26998797"
    [16]=>
    string(8) "26998798"
    [17]=>
    string(8) "26998799"
    [18]=>
    string(8) "26998800"
    [19]=>
    string(8) "26998801"
    [20]=>
    string(8) "26998802"
    [21]=>
    string(8) "26998803"
    [22]=>
    string(8) "26998804"
    [23]=>
    string(8) "26998805"
    [24]=>
    string(8) "26998806"
    [25]=>
    string(8) "26998807"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202512121
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to 'A'ali'i in the vibrant Ward Village / Kakaako. This one-bedroom unit is on the 34th floor with stunning ocean and city views. The open kitchen concept features Bosch appliances, Studio Becker cabinetry, and natural stone countertops. Aa'lii has many great amenities, located on the 1st floor you will find a dog park and green space. On the 8th floor, showcases a jacuzzi , adult pool, keiki pool, BBQ pit and 5 indoor and outdoor party rooms for residents to use. 'A'ali'i amenities also include a luxurious lobby and penthouse-level sky deck with panoramic ocean views. This 42nd-floor penthouse level amenity deck come with fitness center, yoga room, meeting rooms, pool table, and outdoor sky terrace and recreation space. The building also has ample guest parking, bicycle and surfboard storage facilities. Enjoy Kakaako living with great restaurants, amazing shopping, Whole Foods Market, Ward Theater Complex, and Ala Moana Beach Park just steps away. Must see!
        )

    [ListOfficeName] => Array
        (
            [0] => Locations LLC
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => kevin.yu@locationshawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 735-4200
        )

    [ListAgentFullName] => Array
        (
            [0] => Kevin Y Yu
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-08-06T11:20:44.807
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-05-16
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:20:44.807
        )

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

    [listing_image] => Array
        (
            [0] => 26998782
            [1] => 26998783
            [2] => 26998784
            [3] => 26998785
            [4] => 26998786
            [5] => 26998787
            [6] => 26998788
            [7] => 26998789
            [8] => 26998790
            [9] => 26998791
            [10] => 26998792
            [11] => 26998793
            [12] => 26998794
            [13] => 26998795
            [14] => 26998796
            [15] => 26998797
            [16] => 26998798
            [17] => 26998799
            [18] => 26998800
            [19] => 26998801
            [20] => 26998802
            [21] => 26998803
            [22] => 26998804
            [23] => 26998805
            [24] => 26998806
            [25] => 26998807
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: City,Ocean
• Listing Office: Locations LLC

FINANCIAL INFO

• Maintenance Fees: $802
• 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 August 6, 2025 - 11:20 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.