Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
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
)
)
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: 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.
