Previous Next

987 Queen Street Unit 1512 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202515743"
  }
  ["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) "1512"
  }
  ["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) "809000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(952) "Welcome to modern island living at Aalii in the heart of vibrant Kakaako! This well-designed 1-bedroom, 1-bath residence offers the perfect balance of style and functionality with stunning city and ocean views that sparkle by night. This highly desirable stack 12 unit is the largest 1 bedroom floor plan in the building. The upgraded kitchen features a large island — ideal for cooking, entertaining, or casual dining — and flows seamlessly into the open-concept living space.  Added feature is the motorized electric shades perfect for keeping out light and heat.  Enjoy resort-style amenities, including a refreshing pool, BBQ cabanas, state-of-the-art fitness center, dedicated yoga room, dog park, children's playground, stylish meeting rooms, and more. Live steps away from Whole Foods, restaurants, parks, and the ocean — all part of the thriving Ward Village community. Urban sophistication meets island comfort in this move-in-ready gem!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["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) "679"
  }
  ["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(32) "City,Marina/Canal,Mountain,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "820.13"
  }
  ["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) "CBPP04"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "Antonet.Barut@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 479-2089"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Antonet C Barut"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18855804"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-12T12:41:21.633"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-07-09"
  }
  ["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) "12:41:21.633"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27061816"
  }
  ["listing_image"]=>
  array(24) {
    [0]=>
    string(8) "27061816"
    [1]=>
    string(8) "27061817"
    [2]=>
    string(8) "27061818"
    [3]=>
    string(8) "27061819"
    [4]=>
    string(8) "27061820"
    [5]=>
    string(8) "27061821"
    [6]=>
    string(8) "27061822"
    [7]=>
    string(8) "27061823"
    [8]=>
    string(8) "27061824"
    [9]=>
    string(8) "27061825"
    [10]=>
    string(8) "27061826"
    [11]=>
    string(8) "27061827"
    [12]=>
    string(8) "27061828"
    [13]=>
    string(8) "27061829"
    [14]=>
    string(8) "27061830"
    [15]=>
    string(8) "27061831"
    [16]=>
    string(8) "27061832"
    [17]=>
    string(8) "27061833"
    [18]=>
    string(8) "27061834"
    [19]=>
    string(8) "27061835"
    [20]=>
    string(8) "27061836"
    [21]=>
    string(8) "27061837"
    [22]=>
    string(8) "27061838"
    [23]=>
    string(8) "27061839"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202515743
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to modern island living at Aalii in the heart of vibrant Kakaako! This well-designed 1-bedroom, 1-bath residence offers the perfect balance of style and functionality with stunning city and ocean views that sparkle by night. This highly desirable stack 12 unit is the largest 1 bedroom floor plan in the building. The upgraded kitchen features a large island — ideal for cooking, entertaining, or casual dining — and flows seamlessly into the open-concept living space.  Added feature is the motorized electric shades perfect for keeping out light and heat.  Enjoy resort-style amenities, including a refreshing pool, BBQ cabanas, state-of-the-art fitness center, dedicated yoga room, dog park, children's playground, stylish meeting rooms, and more. Live steps away from Whole Foods, restaurants, parks, and the ocean — all part of the thriving Ward Village community. Urban sophistication meets island comfort in this move-in-ready gem!
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Antonet.Barut@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 479-2089
        )

    [ListAgentFullName] => Array
        (
            [0] => Antonet C Barut
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-12T12:41:21.633
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-07-09
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 12:41:21.633
        )

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

    [listing_image] => Array
        (
            [0] => 27061816
            [1] => 27061817
            [2] => 27061818
            [3] => 27061819
            [4] => 27061820
            [5] => 27061821
            [6] => 27061822
            [7] => 27061823
            [8] => 27061824
            [9] => 27061825
            [10] => 27061826
            [11] => 27061827
            [12] => 27061828
            [13] => 27061829
            [14] => 27061830
            [15] => 27061831
            [16] => 27061832
            [17] => 27061833
            [18] => 27061834
            [19] => 27061835
            [20] => 27061836
            [21] => 27061837
            [22] => 27061838
            [23] => 27061839
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: City,Marina/Canal,Mountain,Ocean
• Listing Office: Coldwell Banker Realty

FINANCIAL INFO

• Maintenance Fees: $820
• 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 July 12, 2025 - 12: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.