987 Queen Street Unit 2704 Honolulu, HI 96814
Listing
Overview
Price: $798,000
Area: KAKAAKO
Status: Active Under Contract
Beautiful ocean view 1 Bedroom/1 Bath 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. 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(5-059). Listing by: HOMETIQUE (808) 754-2284
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202408460"
}
["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) "2704"
}
["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) "798000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "798000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(694) "Beautiful ocean view 1 Bedroom/1 Bath 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. 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(5-059)."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(9) "HOMETIQUE"
}
["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) "624"
}
["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(32) "City,Marina/Canal,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "783.58"
}
["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) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-29T04:38:44.277"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17945750"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-23T08:28:25.237"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26176346"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26176346"
[1]=>
string(8) "26176347"
[2]=>
string(8) "26176348"
[3]=>
string(8) "26176349"
[4]=>
string(8) "26176350"
[5]=>
string(8) "26176351"
[6]=>
string(8) "26176352"
[7]=>
string(8) "26176353"
[8]=>
string(8) "26176354"
[9]=>
string(8) "26176355"
[10]=>
string(8) "26176356"
[11]=>
string(8) "26176357"
[12]=>
string(8) "26176358"
[13]=>
string(8) "26176359"
[14]=>
string(8) "26176360"
[15]=>
string(8) "26176361"
[16]=>
string(8) "26176362"
[17]=>
string(8) "26176363"
[18]=>
string(8) "26176364"
[19]=>
string(8) "26176365"
[20]=>
string(8) "26176366"
[21]=>
string(8) "26176367"
[22]=>
string(8) "26176368"
[23]=>
string(8) "26176369"
[24]=>
string(8) "26176370"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202408460
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 2704
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 798000.00
)
[CurrentPrice] => Array
(
[0] => 798000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Beautiful ocean view 1 Bedroom/1 Bath 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. 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(5-059).
)
[ListOfficeName] => Array
(
[0] => HOMETIQUE
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 624
)
[YearBuilt] => Array
(
[0] => 2021
)
[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] => 783.58
)
[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] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-29T04:38:44.277
)
[Matrix_Unique_ID] => Array
(
[0] => 17945750
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-23T08:28:25.237
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26176346
)
[listing_image] => Array
(
[0] => 26176346
[1] => 26176347
[2] => 26176348
[3] => 26176349
[4] => 26176350
[5] => 26176351
[6] => 26176352
[7] => 26176353
[8] => 26176354
[9] => 26176355
[10] => 26176356
[11] => 26176357
[12] => 26176358
[13] => 26176359
[14] => 26176360
[15] => 26176361
[16] => 26176362
[17] => 26176363
[18] => 26176364
[19] => 26176365
[20] => 26176366
[21] => 26176367
[22] => 26176368
[23] => 26176369
[24] => 26176370
)
)
- BedsTotal: 1
- Full Baths: 1
- Living (sf): 624
- Year Built: 2021
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Marina/Canal,Mountain,Ocean
- Listing Office: HOMETIQUE
- Maintenance Fees: $784
- Land Tenure: FS - Fee Simple
