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 3806 Honolulu, HI 96814
Listing Overview
Price: $650,000 Area: KAKAAKO Status: Active
Beautiful ocean view studio in "A'ali'i" in Ward Village! Elegantly designed by Soloman Cordwell Buenz architects with Rottet Studio (interior designers of Four Seasons), stepping into A'ali'i is like stepping into a 5 star hotel. Unit includes fully furnished (elegantly interior designed valued at $30k, NOT MURPHY BED!) Located in the heart of Kaka'ako, with Whole Foods Market, numerous shopping and dining venues, and Ala Moana beach all within walking distance, this modern residence has a large pool deck with multiple cabana and grilling areas and party rooms. The rooftop "Lanai" on the 42nd floor, boasts Sky Lounge, event space, private dining room, fitness center with sweeping ocean and city views! Enjoy the ocean view from your lanai. 1 parking included. Listing by: HOMETIQUE (808) 754-2284
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202524838"
}
["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) "3806"
}
["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) "650000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(769) "Beautiful ocean view studio in "A'ali'i" in Ward Village! Elegantly designed by Soloman Cordwell Buenz architects with Rottet Studio (interior designers of Four Seasons), stepping into A'ali'i is like stepping into a 5 star hotel. Unit includes fully furnished (elegantly interior designed valued at $30k, NOT MURPHY BED!) Located in the heart of Kaka'ako, with Whole Foods Market, numerous shopping and dining venues, and Ala Moana beach all within walking distance, this modern residence has a large pool deck with multiple cabana and grilling areas and party rooms. The rooftop "Lanai" on the 42nd floor, boasts Sky Lounge, event space, private dining room, fitness center with sweeping ocean and city views! Enjoy the ocean view from your lanai. 1 parking included."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(9) "HOMETIQUE"
}
["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) "419"
}
["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(19) "City,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "511.89"
}
["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) "HMTQ"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "atsuko.hawaii@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 754-2284"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Atsuko Sato"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19080852"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-04T11:04:50.947"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-11-04"
}
["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:04:50.947"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27208884"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "27208884"
[1]=>
string(8) "27208885"
[2]=>
string(8) "27208886"
[3]=>
string(8) "27208887"
[4]=>
string(8) "27208888"
[5]=>
string(8) "27208889"
[6]=>
string(8) "27208890"
[7]=>
string(8) "27208891"
[8]=>
string(8) "27208892"
[9]=>
string(8) "27208893"
[10]=>
string(8) "27208894"
[11]=>
string(8) "27208895"
[12]=>
string(8) "27208896"
[13]=>
string(8) "27208897"
[14]=>
string(8) "27208898"
[15]=>
string(8) "27208899"
[16]=>
string(8) "27208900"
[17]=>
string(8) "27208901"
[18]=>
string(8) "27208902"
[19]=>
string(8) "27208903"
[20]=>
string(8) "27208904"
[21]=>
string(8) "27208905"
[22]=>
string(8) "27208906"
[23]=>
string(8) "27208907"
[24]=>
string(8) "27208908"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202524838
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 3806
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 650000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Beautiful ocean view studio in "A'ali'i" in Ward Village! Elegantly designed by Soloman Cordwell Buenz architects with Rottet Studio (interior designers of Four Seasons), stepping into A'ali'i is like stepping into a 5 star hotel. Unit includes fully furnished (elegantly interior designed valued at $30k, NOT MURPHY BED!) Located in the heart of Kaka'ako, with Whole Foods Market, numerous shopping and dining venues, and Ala Moana beach all within walking distance, this modern residence has a large pool deck with multiple cabana and grilling areas and party rooms. The rooftop "Lanai" on the 42nd floor, boasts Sky Lounge, event space, private dining room, fitness center with sweeping ocean and city views! Enjoy the ocean view from your lanai. 1 parking included.
)
[ListOfficeName] => Array
(
[0] => HOMETIQUE
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 419
)
[YearBuilt] => Array
(
[0] => 2019
)
[BuildingName] => Array
(
[0] => Aalii
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 511.89
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HMTQ
)
[ListAgentEmail] => Array
(
[0] => atsuko.hawaii@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 754-2284
)
[ListAgentFullName] => Array
(
[0] => Atsuko Sato
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19080852
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-04T11:04:50.947
)
[ListingContractDate] => Array
(
[0] => 2025-11-04
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 11:04:50.947
)
[_thumbnail_id] => Array
(
[0] => 27208884
)
[listing_image] => Array
(
[0] => 27208884
[1] => 27208885
[2] => 27208886
[3] => 27208887
[4] => 27208888
[5] => 27208889
[6] => 27208890
[7] => 27208891
[8] => 27208892
[9] => 27208893
[10] => 27208894
[11] => 27208895
[12] => 27208896
[13] => 27208897
[14] => 27208898
[15] => 27208899
[16] => 27208900
[17] => 27208901
[18] => 27208902
[19] => 27208903
[20] => 27208904
[21] => 27208905
[22] => 27208906
[23] => 27208907
[24] => 27208908
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 4, 2025 - 11:04 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.
