Previous Next

987 Queen Street Unit 510 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202600373"
  }
  ["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) "510"
  }
  ["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) "532000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(739) "Be in the desirable and thriving Ward Village community with this well-priced, well-maintained studio in Aalii. The parking stall is on the same level as the unit, so no need to wait for an elevator. A 5th floor storage room is also included with the sale. Upgrades include new Washer/Dryer, USB outlets, and a home smart system. Digital blinds and fresh drapes for the lanai doors give multiple privacy options. This unit has high 9ft ceilings, which make the space feel more open. Aalii is known for its plethora of amenities and is next to Whole Foods in Kakaako. The WV community benefits from Assocation security patrol, and has wide sidewalks. Enjoy premium restaurant and retail offerings, all within a conveniently accessible area."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp 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) "425"
  }
  ["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(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "574.31"
  }
  ["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) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "jenfreas@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 284-0808"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Jennifer C Freas"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19199500"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-02-24T09:55:20.620"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-01-15"
  }
  ["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:55:20.620"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27273592"
  }
  ["listing_image"]=>
  array(20) {
    [0]=>
    string(8) "27273592"
    [1]=>
    string(8) "27273593"
    [2]=>
    string(8) "27273594"
    [3]=>
    string(8) "27273595"
    [4]=>
    string(8) "27273596"
    [5]=>
    string(8) "27273597"
    [6]=>
    string(8) "27273598"
    [7]=>
    string(8) "27273599"
    [8]=>
    string(8) "27273600"
    [9]=>
    string(8) "27273601"
    [10]=>
    string(8) "27273602"
    [11]=>
    string(8) "27273603"
    [12]=>
    string(8) "27273604"
    [13]=>
    string(8) "27273605"
    [14]=>
    string(8) "27273606"
    [15]=>
    string(8) "27273607"
    [16]=>
    string(8) "27273608"
    [17]=>
    string(8) "27273609"
    [18]=>
    string(8) "27273610"
    [19]=>
    string(8) "27273611"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202600373
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Be in the desirable and thriving Ward Village community with this well-priced, well-maintained studio in Aalii. The parking stall is on the same level as the unit, so no need to wait for an elevator. A 5th floor storage room is also included with the sale. Upgrades include new Washer/Dryer, USB outlets, and a home smart system. Digital blinds and fresh drapes for the lanai doors give multiple privacy options. This unit has high 9ft ceilings, which make the space feel more open. Aalii is known for its plethora of amenities and is next to Whole Foods in Kakaako. The WV community benefits from Assocation security patrol, and has wide sidewalks. Enjoy premium restaurant and retail offerings, all within a conveniently accessible area.
        )

    [ListOfficeName] => Array
        (
            [0] => eXp Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 284-0808
        )

    [ListAgentFullName] => Array
        (
            [0] => Jennifer C Freas
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-02-24T09:55:20.620
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:55:20.620
        )

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

    [listing_image] => Array
        (
            [0] => 27273592
            [1] => 27273593
            [2] => 27273594
            [3] => 27273595
            [4] => 27273596
            [5] => 27273597
            [6] => 27273598
            [7] => 27273599
            [8] => 27273600
            [9] => 27273601
            [10] => 27273602
            [11] => 27273603
            [12] => 27273604
            [13] => 27273605
            [14] => 27273606
            [15] => 27273607
            [16] => 27273608
            [17] => 27273609
            [18] => 27273610
            [19] => 27273611
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: None
• Listing Office: eXp Realty

FINANCIAL INFO

• Maintenance Fees: $574
• 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 February 24, 2026 - 9:55 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.