Previous Next

987 Queen Street Unit 1004 Honolulu, HI 96814

Listing
Overview

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

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) "710000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1058) "Priced to sell!  This sunny unit is located on the Diamond Head side of the building with a view of the ocean from the lanai and bedroom.  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 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, Whole Foods, urgent care, and ocean recreation. 
A must see at a great price!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "Coldwell Banker Island Prop"
  }
  ["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(6) "CBIP04"
  }
  ["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(10) "2026-05-29"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19249674"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-05-29T09:25:45.917"
  }
  ["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) "09:25:45.917"
  }
  ["_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] => 710000.00
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => Priced to sell!  This sunny unit is located on the Diamond Head side of the building with a view of the ocean from the lanai and bedroom.  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 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, Whole Foods, urgent care, and ocean recreation. 
A must see at a great price!
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Island Prop
        )

    [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] => CBIP04
        )

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

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

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

    [CloseDate] => Array
        (
            [0] => 2026-05-29
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-05-29T09:25:45.917
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:25:45.917
        )

    [_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: Coldwell Banker Island Prop

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 May 29, 2026 - 9:25 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.