Previous Next

987 Queen Street Unit 2906 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202510843"
  }
  ["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) "2906"
  }
  ["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) "585000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1180) "This unit stands out as the "LOWEST-PRICED STUDIO WITH STORAGE" currently on the market, offering exceptional value! the of heart of Ward Village, this impeccably designed studio condo with storage offers a seamless blend of style, comfort, and urban convenience. Located just steps from award-winning restaurants, boutique coffee shops, serene spas, a brand-new dog park, and the iconic Ala Moana Mall and Beach, this is modern island living at its finest.
The bright and spacious interior is thoughtfully appointed with premium Bosch stainless steel appliances, elegant luxury vinyl flooring, pristine white quartz countertops, and a custom-designed hidden Murphy bed with generous closet space—perfectly maximizing form and function.
Residents enjoy access to an array of resort-style amenities, including a breathtaking pool, soothing Jacuzzis, a state-of-the-art fitness center with panoramic views, a tranquil yoga room, event rooms, outdoor BBQ areas, and a beautifully landscaped dog park. The exclusive 42nd-floor Sky Lounge, residents can take in sweeping 360-degree views of the ocean and mountains.

Open House May 4 2pm-5pm. Please text-808-896-7893 for access."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(16) "Real Broker, LLC"
  }
  ["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) "2019"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(5) "Aalii"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(10) "City,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "658.32"
  }
  ["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) "RBLL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "taingmonik@yahoo.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 896-7893"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Monik Taing"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18713234"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-01T15:00:01.290"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-29"
  }
  ["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) "15:00:01.290"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26978801"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "26978801"
    [1]=>
    string(8) "26978802"
    [2]=>
    string(8) "26978803"
    [3]=>
    string(8) "26978804"
    [4]=>
    string(8) "26978805"
    [5]=>
    string(8) "26978806"
    [6]=>
    string(8) "26978807"
    [7]=>
    string(8) "26978808"
    [8]=>
    string(8) "26978809"
    [9]=>
    string(8) "26978810"
    [10]=>
    string(8) "26978811"
    [11]=>
    string(8) "26978812"
    [12]=>
    string(8) "26978813"
    [13]=>
    string(8) "26978814"
    [14]=>
    string(8) "26978815"
    [15]=>
    string(8) "26978816"
    [16]=>
    string(8) "26978817"
    [17]=>
    string(8) "26978818"
    [18]=>
    string(8) "26978819"
    [19]=>
    string(8) "26978820"
    [20]=>
    string(8) "26978821"
    [21]=>
    string(8) "26978822"
    [22]=>
    string(8) "26978823"
    [23]=>
    string(8) "26978824"
    [24]=>
    string(8) "26978825"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202510843
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => This unit stands out as the "LOWEST-PRICED STUDIO WITH STORAGE" currently on the market, offering exceptional value! the of heart of Ward Village, this impeccably designed studio condo with storage offers a seamless blend of style, comfort, and urban convenience. Located just steps from award-winning restaurants, boutique coffee shops, serene spas, a brand-new dog park, and the iconic Ala Moana Mall and Beach, this is modern island living at its finest.
The bright and spacious interior is thoughtfully appointed with premium Bosch stainless steel appliances, elegant luxury vinyl flooring, pristine white quartz countertops, and a custom-designed hidden Murphy bed with generous closet space—perfectly maximizing form and function.
Residents enjoy access to an array of resort-style amenities, including a breathtaking pool, soothing Jacuzzis, a state-of-the-art fitness center with panoramic views, a tranquil yoga room, event rooms, outdoor BBQ areas, and a beautifully landscaped dog park. The exclusive 42nd-floor Sky Lounge, residents can take in sweeping 360-degree views of the ocean and mountains.

Open House May 4 2pm-5pm. Please text-808-896-7893 for access.
        )

    [ListOfficeName] => Array
        (
            [0] => Real Broker, LLC
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => taingmonik@yahoo.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 896-7893
        )

    [ListAgentFullName] => Array
        (
            [0] => Monik Taing
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-01T15:00:01.290
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-04-29
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:00:01.290
        )

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

    [listing_image] => Array
        (
            [0] => 26978801
            [1] => 26978802
            [2] => 26978803
            [3] => 26978804
            [4] => 26978805
            [5] => 26978806
            [6] => 26978807
            [7] => 26978808
            [8] => 26978809
            [9] => 26978810
            [10] => 26978811
            [11] => 26978812
            [12] => 26978813
            [13] => 26978814
            [14] => 26978815
            [15] => 26978816
            [16] => 26978817
            [17] => 26978818
            [18] => 26978819
            [19] => 26978820
            [20] => 26978821
            [21] => 26978822
            [22] => 26978823
            [23] => 26978824
            [24] => 26978825
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 1
• View: City,Ocean
• Listing Office: Real Broker, LLC

FINANCIAL INFO

• Maintenance Fees: $658
• 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 1, 2025 - 3:00 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.