Previous Next

987 Queen Street Unit 3908 Honolulu, HI 96814

Listing
Overview

Price: $595,000
Area: KAKAAKO
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202506554"
  }
  ["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) "3908"
  }
  ["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) "595000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1113) "Experience elevated island living in this high-floor, turn-key studio at ‘A‘ali‘i, custom furnished by Rottet Studio. Designed for efficiency and style, this move-in-ready unit features smart modular wall furniture that maximizes space for a seamless living experience. The fully equipped kitchen includes tableware and accessories, making your transition effortless. Enjoy the convenience of an assigned parking stall with an electric charger and a bathroom outfitted with an electric outlet for a washlet. As a resident, you’ll have access to world-class amenities, including the penthouse-level fitness club, Lanai 42, and a sky lounge with breathtaking ocean views. The 8th-floor amenity deck offers resort-style features such as cabanas, private indoor/outdoor dining areas, BBQ stations, a pool, a jacuzzi, a children’s pool, and a playground. Located in the vibrant heart of Ward Village, you’ll be close to top restaurants, spas, coffee shops, a dog park, and Ala Moana Beach. Don’t miss this opportunity to own a thoughtfully designed home in one of Honolulu’s most desirable communities!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "Engel & Volkers Honolulu"
  }
  ["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) "413"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["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(20) "City,Coastline,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "507.70"
  }
  ["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(6) "PPRO03"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(32) "Marco.Schlesser@evrealestate.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 232-6420"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Marco Schlesser"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18609653"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-11-10T17:41:50.347"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-03-12"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "17:41:50.347"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26916766"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26916766"
    [1]=>
    string(8) "26916767"
    [2]=>
    string(8) "26916768"
    [3]=>
    string(8) "26916769"
    [4]=>
    string(8) "26916770"
    [5]=>
    string(8) "26916771"
    [6]=>
    string(8) "26916772"
    [7]=>
    string(8) "26916773"
    [8]=>
    string(8) "26916774"
    [9]=>
    string(8) "26916775"
    [10]=>
    string(8) "26916776"
    [11]=>
    string(8) "26916777"
    [12]=>
    string(8) "26916778"
    [13]=>
    string(8) "26916779"
    [14]=>
    string(8) "26916780"
    [15]=>
    string(8) "26916781"
    [16]=>
    string(8) "26916782"
    [17]=>
    string(8) "26916783"
    [18]=>
    string(8) "26916784"
    [19]=>
    string(8) "26916785"
    [20]=>
    string(8) "26916786"
    [21]=>
    string(8) "26916787"
    [22]=>
    string(8) "26916788"
    [23]=>
    string(8) "26916789"
    [24]=>
    string(8) "26916790"
    [25]=>
    string(8) "26916791"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202506554
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Experience elevated island living in this high-floor, turn-key studio at ‘A‘ali‘i, custom furnished by Rottet Studio. Designed for efficiency and style, this move-in-ready unit features smart modular wall furniture that maximizes space for a seamless living experience. The fully equipped kitchen includes tableware and accessories, making your transition effortless. Enjoy the convenience of an assigned parking stall with an electric charger and a bathroom outfitted with an electric outlet for a washlet. As a resident, you’ll have access to world-class amenities, including the penthouse-level fitness club, Lanai 42, and a sky lounge with breathtaking ocean views. The 8th-floor amenity deck offers resort-style features such as cabanas, private indoor/outdoor dining areas, BBQ stations, a pool, a jacuzzi, a children’s pool, and a playground. Located in the vibrant heart of Ward Village, you’ll be close to top restaurants, spas, coffee shops, a dog park, and Ala Moana Beach. Don’t miss this opportunity to own a thoughtfully designed home in one of Honolulu’s most desirable communities!
        )

    [ListOfficeName] => Array
        (
            [0] => Engel & Volkers Honolulu
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => City,Coastline,Ocean
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Marco.Schlesser@evrealestate.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 232-6420
        )

    [ListAgentFullName] => Array
        (
            [0] => Marco Schlesser
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-11-10T17:41:50.347
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-03-12
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:41:50.347
        )

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

    [listing_image] => Array
        (
            [0] => 26916766
            [1] => 26916767
            [2] => 26916768
            [3] => 26916769
            [4] => 26916770
            [5] => 26916771
            [6] => 26916772
            [7] => 26916773
            [8] => 26916774
            [9] => 26916775
            [10] => 26916776
            [11] => 26916777
            [12] => 26916778
            [13] => 26916779
            [14] => 26916780
            [15] => 26916781
            [16] => 26916782
            [17] => 26916783
            [18] => 26916784
            [19] => 26916785
            [20] => 26916786
            [21] => 26916787
            [22] => 26916788
            [23] => 26916789
            [24] => 26916790
            [25] => 26916791
        )

)

PROPERTY INFO

• Full Baths: 1
• Living (sf): 413
• Year Built: 2021
• Building Name: Aalii

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: City,Coastline,Ocean
• Listing Office: Engel & Volkers Honolulu

FINANCIAL INFO

• Maintenance Fees: $508
• 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 November 10, 2025 - 5:41 PM Information is deemed reliable but not guaranteed. Copyright: 2025 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.