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(819) "Here's your chance to own in the desirable and thriving Ward Village community! This Aalii studio comes with all the fixes, convenience and amenities you could ask for in urban living. 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, a home smart system, digital blinds and fresh drapes. 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 security patrol, and has wide sidewalks to enjoy the all of the top notch restaurant and retail in the area. Enjoy regular Ward Village activities and events, 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-09-02T12:49:42.460"
  }
  ["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) "12:49:42.460"
  }
  ["_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] => Here's your chance to own in the desirable and thriving Ward Village community! This Aalii studio comes with all the fixes, convenience and amenities you could ask for in urban living. 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, a home smart system, digital blinds and fresh drapes. 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 security patrol, and has wide sidewalks to enjoy the all of the top notch restaurant and retail in the area. Enjoy regular Ward Village activities and events, 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-09-02T12:49:42.460
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 12:49:42.460
        )

    [_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 September 2, 2026 - 12:49 PM 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.