987 Queen Street Unit 2409 Honolulu, HI 96814
Listing
Overview
Price: $568,000
Area: KAKAAKO
Status: Sold (Limited photos per MLS privacy policy)
Fully furnished studio with 1 parking and storage at A‘ali‘i! This turn-key unit comes with the developer’s furnishing package, making it move-in or rental-ready immediately after closing. The included storage unit is a valuable addition, especially for a studio. It also includes an additional outlet in the bathroom, which was a developer upgrade.
A‘ali‘i is situated in the heart of vibrant Kaka‘ako/Ward Village, just steps from Whole Foods Market and surrounded by an array of eateries and shops. Ala Moana Beach Park is also within walking distance.
Resort-style amenities include a pool, whirlpool, gym, private dining rooms, BBQ areas, a dog run, and a stunning rooftop sky lounge with breathtaking views. Listing by: List Sotheby's Int'l Realty (808) 745-8196
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202504757"
}
["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) "2409"
}
["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) "568000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(727) "Fully furnished studio with 1 parking and storage at A‘ali‘i! This turn-key unit comes with the developer’s furnishing package, making it move-in or rental-ready immediately after closing. The included storage unit is a valuable addition, especially for a studio. It also includes an additional outlet in the bathroom, which was a developer upgrade.
A‘ali‘i is situated in the heart of vibrant Kaka‘ako/Ward Village, just steps from Whole Foods Market and surrounded by an array of eateries and shops. Ala Moana Beach Park is also within walking distance.
Resort-style amenities include a pool, whirlpool, gym, private dining rooms, BBQ areas, a dog run, and a stunning rooftop sky lounge with breathtaking views."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "List Sotheby's Int'l Realty"
}
["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) "408"
}
["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(26) "City,Mountain,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(6) "LIST03"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "yinoue@listsir.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 745-8196"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Yusaku Inoue"
}
["CloseDate"]=>
array(1) {
[0]=>
string(10) "2025-12-01"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18549580"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-01T11:05:32.187"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-02-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:05:32.187"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26876241"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26876241"
[1]=>
string(8) "26876242"
[2]=>
string(8) "26876243"
[3]=>
string(8) "26876244"
[4]=>
string(8) "26876245"
[5]=>
string(8) "26876246"
[6]=>
string(8) "26876247"
[7]=>
string(8) "26876248"
[8]=>
string(8) "26876249"
[9]=>
string(8) "26876250"
[10]=>
string(8) "26876251"
[11]=>
string(8) "26876252"
[12]=>
string(8) "26876253"
[13]=>
string(8) "26876254"
[14]=>
string(8) "26876255"
[15]=>
string(8) "26876256"
[16]=>
string(8) "26876257"
[17]=>
string(8) "26876258"
[18]=>
string(8) "26876259"
[19]=>
string(8) "26876260"
[20]=>
string(8) "26876261"
[21]=>
string(8) "26876262"
[22]=>
string(8) "26876263"
[23]=>
string(8) "26876264"
[24]=>
string(8) "26876265"
[25]=>
string(8) "26876266"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202504757
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 2409
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 568000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Sold
)
[PublicRemarks] => Array
(
[0] => Fully furnished studio with 1 parking and storage at A‘ali‘i! This turn-key unit comes with the developer’s furnishing package, making it move-in or rental-ready immediately after closing. The included storage unit is a valuable addition, especially for a studio. It also includes an additional outlet in the bathroom, which was a developer upgrade.
A‘ali‘i is situated in the heart of vibrant Kaka‘ako/Ward Village, just steps from Whole Foods Market and surrounded by an array of eateries and shops. Ala Moana Beach Park is also within walking distance.
Resort-style amenities include a pool, whirlpool, gym, private dining rooms, BBQ areas, a dog run, and a stunning rooftop sky lounge with breathtaking views.
)
[ListOfficeName] => Array
(
[0] => List Sotheby's Int'l Realty
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 408
)
[YearBuilt] => Array
(
[0] => 2021
)
[BuildingName] => Array
(
[0] => Aalii
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Mountain,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] => LIST03
)
[ListAgentEmail] => Array
(
[0] => yinoue@listsir.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 745-8196
)
[ListAgentFullName] => Array
(
[0] => Yusaku Inoue
)
[CloseDate] => Array
(
[0] => 2025-12-01
)
[Matrix_Unique_ID] => Array
(
[0] => 18549580
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-01T11:05:32.187
)
[ListingContractDate] => Array
(
[0] => 2025-02-11
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 11:05:32.187
)
[_thumbnail_id] => Array
(
[0] => 26876241
)
[listing_image] => Array
(
[0] => 26876241
[1] => 26876242
[2] => 26876243
[3] => 26876244
[4] => 26876245
[5] => 26876246
[6] => 26876247
[7] => 26876248
[8] => 26876249
[9] => 26876250
[10] => 26876251
[11] => 26876252
[12] => 26876253
[13] => 26876254
[14] => 26876255
[15] => 26876256
[16] => 26876257
[17] => 26876258
[18] => 26876259
[19] => 26876260
[20] => 26876261
[21] => 26876262
[22] => 26876263
[23] => 26876264
[24] => 26876265
[25] => 26876266
)
)
- Full Baths: 1
- Living (sf): 408
- Year Built: 2021
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Mountain,Ocean,Sunset
- Listing Office: List Sotheby's Int'l Realty
- Maintenance Fees: $506
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 1, 2025 - 11:05 AM
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.
© Marcus Realty. All Rights Reserved.
