Previous Next

987 Queen Street Unit 3209 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202515895"
  }
  ["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) "3209"
  }
  ["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) "575000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(661) "High-floor, fully furnished studio at A'ali'i delivers postcard-worthy city-to-ocean sunset views from your private lanai. Turn-key interiors feature tile and LVP flooring, quartz counters, Bosch appliances, and a custom furniture package by Rottet Studio. Whole Foods, restaurants, and Ala Moana Beach are right outside your door. Enjoy the rooftop sky lounge, a premium fitness center with yoga room, resort pool with spa cabanas, BBQ pavilions, and versatile indoor-outdoor gathering spaces. All in award-winning Ward Village, which is Honolulu's most sought after urban living community. Just bring your bags as this unit is ready to be moved into tomorrow."
  }
  ["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) "409"
  }
  ["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(27) "City,Coastline,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "506.31"
  }
  ["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(4) "RBLL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "Lex@lifeonoahu.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 277-4715"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Lex Ferguson"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18860291"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-11T11:42:35.293"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-07-11"
  }
  ["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) "11:42:35.293"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27064748"
  }
  ["listing_image"]=>
  array(19) {
    [0]=>
    string(8) "27064748"
    [1]=>
    string(8) "27064749"
    [2]=>
    string(8) "27064750"
    [3]=>
    string(8) "27064751"
    [4]=>
    string(8) "27064752"
    [5]=>
    string(8) "27064753"
    [6]=>
    string(8) "27064754"
    [7]=>
    string(8) "27064755"
    [8]=>
    string(8) "27064756"
    [9]=>
    string(8) "27064757"
    [10]=>
    string(8) "27064758"
    [11]=>
    string(8) "27064759"
    [12]=>
    string(8) "27064760"
    [13]=>
    string(8) "27064761"
    [14]=>
    string(8) "27064762"
    [15]=>
    string(8) "27064763"
    [16]=>
    string(8) "27064764"
    [17]=>
    string(8) "27064765"
    [18]=>
    string(8) "27064766"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202515895
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => High-floor, fully furnished studio at A'ali'i delivers postcard-worthy city-to-ocean sunset views from your private lanai. Turn-key interiors feature tile and LVP flooring, quartz counters, Bosch appliances, and a custom furniture package by Rottet Studio. Whole Foods, restaurants, and Ala Moana Beach are right outside your door. Enjoy the rooftop sky lounge, a premium fitness center with yoga room, resort pool with spa cabanas, BBQ pavilions, and versatile indoor-outdoor gathering spaces. All in award-winning Ward Village, which is Honolulu's most sought after urban living community. Just bring your bags as this unit is ready to be moved into tomorrow.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Lex@lifeonoahu.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 277-4715
        )

    [ListAgentFullName] => Array
        (
            [0] => Lex Ferguson
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-11T11:42:35.293
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:42:35.293
        )

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

    [listing_image] => Array
        (
            [0] => 27064748
            [1] => 27064749
            [2] => 27064750
            [3] => 27064751
            [4] => 27064752
            [5] => 27064753
            [6] => 27064754
            [7] => 27064755
            [8] => 27064756
            [9] => 27064757
            [10] => 27064758
            [11] => 27064759
            [12] => 27064760
            [13] => 27064761
            [14] => 27064762
            [15] => 27064763
            [16] => 27064764
            [17] => 27064765
            [18] => 27064766
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: City,Coastline,Ocean,Sunset
• Listing Office: Real Broker, LLC

FINANCIAL INFO

• Maintenance Fees: $506
• 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 11, 2025 - 11:42 AM 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.