Previous Next

987 Queen Street Unit 3702 Honolulu, HI 96814

Listing
Overview

Price: $1,375,000
Area: KAKAAKO
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202601377"
  }
  ["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) "3702"
  }
  ["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(10) "1375000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(959) "A'alii is centrally located in Ward Village close to Whole Foods and other food and commercial establishments.  Short walking distance to Ala Moana Beach Park for your recreational needs.  This preferred "02 Stack" Diamond Head side corner condo has never been occupied; almost brand new!  Physical layout of this desirable high floor unit with 2 bedrooms and 2 full baths is well organized for the convenience of occupants in mind.  Bosch appliances, natural stone counter tops, window shades, two closet systems and more.  Excellent amenities are among the benefits which enhance the living quality.  Priced to sell with special storage!  This storage unit is located right next to the #3702 main entrance (see photos); separate door and owner purchased separately.  Plus, exceptionally convenient parking stalls; one stall located on the 2nd level at the garage entrance.  The second stall also located on the 2nd level with additional storage.  MUST SEE!!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(19) "Diamond Head Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "865"
  }
  ["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) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(23) "City,Marina/Canal,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1252.00"
  }
  ["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) "DHRI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(28) "delphinefunasaki@hotmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 391-3901"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(19) "Delphine S Funasaki"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19226174"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-01-25T17:00:01.123"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-01-22"
  }
  ["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) "17:00:01.123"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27280284"
  }
  ["listing_image"]=>
  array(20) {
    [0]=>
    string(8) "27280284"
    [1]=>
    string(8) "27280285"
    [2]=>
    string(8) "27280286"
    [3]=>
    string(8) "27280287"
    [4]=>
    string(8) "27280288"
    [5]=>
    string(8) "27280289"
    [6]=>
    string(8) "27280290"
    [7]=>
    string(8) "27280291"
    [8]=>
    string(8) "27280292"
    [9]=>
    string(8) "27280293"
    [10]=>
    string(8) "27280294"
    [11]=>
    string(8) "27280295"
    [12]=>
    string(8) "27280296"
    [13]=>
    string(8) "27280297"
    [14]=>
    string(8) "27280298"
    [15]=>
    string(8) "27280299"
    [16]=>
    string(8) "27280300"
    [17]=>
    string(8) "27280301"
    [18]=>
    string(8) "27280302"
    [19]=>
    string(8) "27280303"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202601377
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => A'alii is centrally located in Ward Village close to Whole Foods and other food and commercial establishments.  Short walking distance to Ala Moana Beach Park for your recreational needs.  This preferred "02 Stack" Diamond Head side corner condo has never been occupied; almost brand new!  Physical layout of this desirable high floor unit with 2 bedrooms and 2 full baths is well organized for the convenience of occupants in mind.  Bosch appliances, natural stone counter tops, window shades, two closet systems and more.  Excellent amenities are among the benefits which enhance the living quality.  Priced to sell with special storage!  This storage unit is located right next to the #3702 main entrance (see photos); separate door and owner purchased separately.  Plus, exceptionally convenient parking stalls; one stall located on the 2nd level at the garage entrance.  The second stall also located on the 2nd level with additional storage.  MUST SEE!!
        )

    [ListOfficeName] => Array
        (
            [0] => Diamond Head Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => delphinefunasaki@hotmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 391-3901
        )

    [ListAgentFullName] => Array
        (
            [0] => Delphine S Funasaki
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-01-25T17:00:01.123
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:00:01.123
        )

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

    [listing_image] => Array
        (
            [0] => 27280284
            [1] => 27280285
            [2] => 27280286
            [3] => 27280287
            [4] => 27280288
            [5] => 27280289
            [6] => 27280290
            [7] => 27280291
            [8] => 27280292
            [9] => 27280293
            [10] => 27280294
            [11] => 27280295
            [12] => 27280296
            [13] => 27280297
            [14] => 27280298
            [15] => 27280299
            [16] => 27280300
            [17] => 27280301
            [18] => 27280302
            [19] => 27280303
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 2
• Living (sf): 865
• Year Built: 2019
• Building Name: Aalii

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 2
• View: City,Marina/Canal,Ocean
• Listing Office: Diamond Head Realty

FINANCIAL INFO

• Maintenance Fees: $1,252
• 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 January 25, 2026 - 5:00 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.