Previous Next

987 Queen Street Unit 1004 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202602279"
  }
  ["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) "1004"
  }
  ["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) "755000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1114) "Located in Ward Village, this one-bedroom Aalii unit is located on the Diamond Head side of the building and provides a sunny view of the ocean from your own private lanai.  Bosch appliances grace the kitchen with Whirlpool washer and dryer close at hand.  Split air conditioners in the bedroom and living area keep the unit cool and a fresh coat of paint throughout makes this unit just like new!  There is one secured parking with overhead storage and a 24/7 front desk to assist you.  There are two amenities decks with something for just about everyone!  The penthouse level on the 42nd floor includes a 360-degree view of the surrounding ocean and mountains, comfortable indoor and outdoor workspaces, meeting rooms, and a fully equipped gym.  The eighth floor pool and jacuzzi are surrounded by barbeque areas, cabanas, a playground, keiki pool and party rooms with fully equipped kitchens.  A dog washing station and play area are located on the ground floor.   This unit is steps from theatres, award winning restaurants, shopping, groceries, urgent care, and ocean recreation. It does not get much better!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(29) "Century 21 iProperties Hawaii"
  }
  ["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) "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(13) "Ocean,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "871.30"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Kaahumanu"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(9) "Stevenson"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(8) "Mckinley"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "IPHI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "maryshimizu@hawaii.rr.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 226-0773"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Mary H Shimizu"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19249674"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-05T15:45:37.047"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-02-06"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(11) "Ocean,Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "15:45:37.047"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27295440"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27295440"
    [1]=>
    string(8) "27295441"
    [2]=>
    string(8) "27295442"
    [3]=>
    string(8) "27295443"
    [4]=>
    string(8) "27295444"
    [5]=>
    string(8) "27295445"
    [6]=>
    string(8) "27295446"
    [7]=>
    string(8) "27295447"
    [8]=>
    string(8) "27295448"
    [9]=>
    string(8) "27295449"
    [10]=>
    string(8) "27295450"
    [11]=>
    string(8) "27295451"
    [12]=>
    string(8) "27295452"
    [13]=>
    string(8) "27295453"
    [14]=>
    string(8) "27295454"
    [15]=>
    string(8) "27295455"
    [16]=>
    string(8) "27295456"
    [17]=>
    string(8) "27295457"
    [18]=>
    string(8) "27295458"
    [19]=>
    string(8) "27295459"
    [20]=>
    string(8) "27295460"
    [21]=>
    string(8) "27295461"
    [22]=>
    string(8) "27295462"
    [23]=>
    string(8) "27295463"
    [24]=>
    string(8) "27295464"
    [25]=>
    string(8) "27295465"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202602279
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Located in Ward Village, this one-bedroom Aalii unit is located on the Diamond Head side of the building and provides a sunny view of the ocean from your own private lanai.  Bosch appliances grace the kitchen with Whirlpool washer and dryer close at hand.  Split air conditioners in the bedroom and living area keep the unit cool and a fresh coat of paint throughout makes this unit just like new!  There is one secured parking with overhead storage and a 24/7 front desk to assist you.  There are two amenities decks with something for just about everyone!  The penthouse level on the 42nd floor includes a 360-degree view of the surrounding ocean and mountains, comfortable indoor and outdoor workspaces, meeting rooms, and a fully equipped gym.  The eighth floor pool and jacuzzi are surrounded by barbeque areas, cabanas, a playground, keiki pool and party rooms with fully equipped kitchens.  A dog washing station and play area are located on the ground floor.   This unit is steps from theatres, award winning restaurants, shopping, groceries, urgent care, and ocean recreation. It does not get much better!
        )

    [ListOfficeName] => Array
        (
            [0] => Century 21 iProperties Hawaii
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => maryshimizu@hawaii.rr.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 226-0773
        )

    [ListAgentFullName] => Array
        (
            [0] => Mary H Shimizu
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-05T15:45:37.047
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-02-06
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:45:37.047
        )

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

    [listing_image] => Array
        (
            [0] => 27295440
            [1] => 27295441
            [2] => 27295442
            [3] => 27295443
            [4] => 27295444
            [5] => 27295445
            [6] => 27295446
            [7] => 27295447
            [8] => 27295448
            [9] => 27295449
            [10] => 27295450
            [11] => 27295451
            [12] => 27295452
            [13] => 27295453
            [14] => 27295454
            [15] => 27295455
            [16] => 27295456
            [17] => 27295457
            [18] => 27295458
            [19] => 27295459
            [20] => 27295460
            [21] => 27295461
            [22] => 27295462
            [23] => 27295463
            [24] => 27295464
            [25] => 27295465
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: Ocean,Sunrise
• Listing Office: Century 21 iProperties Hawaii

FINANCIAL INFO

• Maintenance Fees: $871
• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Kaahumanu
• Middle School: Stevenson
• High School: Mckinley

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 5, 2026 - 3:45 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.