987 Queen Street Unit 2604 Honolulu, HI 96814
Listing
Overview
Price: $795,000
Area: KAKAAKO
Status: Active Under Contract
Welcome to the A'ali'i at Ward Village, an upscale urban retreat in the heart of Honolulu. This high-floor, spacious
one-bedroom offers a perfect blend of luxury and comfort. Enjoy resort style living with a wide range of amenities,
including a stunning pool, state-of-the-art fitness center and the exclusive sky lounge on the 42nd floor, perfect for relaxing
or entertaining while soaking in the views. A'ali'i also offers numerous event rooms, ideal for gathering and celebrations.
Experience the best of island living in one of Honolulu's most desirable locations. Listing by: Locations LLC (808) 699-6737
array(47) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424101"
}
["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) "2604"
}
["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) "795000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(572) "Welcome to the A'ali'i at Ward Village, an upscale urban retreat in the heart of Honolulu. This high-floor, spacious
one-bedroom offers a perfect blend of luxury and comfort. Enjoy resort style living with a wide range of amenities,
including a stunning pool, state-of-the-art fitness center and the exclusive sky lounge on the 42nd floor, perfect for relaxing
or entertaining while soaking in the views. A'ali'i also offers numerous event rooms, ideal for gathering and celebrations.
Experience the best of island living in one of Honolulu's most desirable locations."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["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(20) "City,Coastline,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "783.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Kaahumanu"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(10) "Washington"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Mckinley"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "LOCA"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(31) "wendy.doana@locationshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 699-6737"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Wendy H Doana"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-23T09:47:35.840"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18329565"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26739485"
}
["listing_image"]=>
array(19) {
[0]=>
string(8) "26739485"
[1]=>
string(8) "26739486"
[2]=>
string(8) "26739487"
[3]=>
string(8) "26739488"
[4]=>
string(8) "26739489"
[5]=>
string(8) "26739490"
[6]=>
string(8) "26739491"
[7]=>
string(8) "26739492"
[8]=>
string(8) "26739493"
[9]=>
string(8) "26739494"
[10]=>
string(8) "26739495"
[11]=>
string(8) "26739496"
[12]=>
string(8) "26739497"
[13]=>
string(8) "26739498"
[14]=>
string(8) "26739499"
[15]=>
string(8) "26739500"
[16]=>
string(8) "26739501"
[17]=>
string(8) "26739502"
[18]=>
string(8) "26739503"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-10-21"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424101
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 2604
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 795000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Welcome to the A'ali'i at Ward Village, an upscale urban retreat in the heart of Honolulu. This high-floor, spacious
one-bedroom offers a perfect blend of luxury and comfort. Enjoy resort style living with a wide range of amenities,
including a stunning pool, state-of-the-art fitness center and the exclusive sky lounge on the 42nd floor, perfect for relaxing
or entertaining while soaking in the views. A'ali'i also offers numerous event rooms, ideal for gathering and celebrations.
Experience the best of island living in one of Honolulu's most desirable locations.
)
[ListOfficeName] => Array
(
[0] => Locations LLC
)
[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,Coastline,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 783.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kaahumanu
)
[MiddleOrJuniorSchool] => Array
(
[0] => Washington
)
[HighSchool] => Array
(
[0] => Mckinley
)
[ListOfficeMLSID] => Array
(
[0] => LOCA
)
[ListAgentEmail] => Array
(
[0] => wendy.doana@locationshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 699-6737
)
[ListAgentFullName] => Array
(
[0] => Wendy H Doana
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-23T09:47:35.840
)
[Matrix_Unique_ID] => Array
(
[0] => 18329565
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26739485
)
[listing_image] => Array
(
[0] => 26739485
[1] => 26739486
[2] => 26739487
[3] => 26739488
[4] => 26739489
[5] => 26739490
[6] => 26739491
[7] => 26739492
[8] => 26739493
[9] => 26739494
[10] => 26739495
[11] => 26739496
[12] => 26739497
[13] => 26739498
[14] => 26739499
[15] => 26739500
[16] => 26739501
[17] => 26739502
[18] => 26739503
)
[ListingContractDate] => Array
(
[0] => 2024-10-21
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
)
- BedsTotal: 1
- Full Baths: 1
- Living (sf): 624
- Year Built: 2021
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Coastline,Ocean
- Listing Office: Locations LLC
- Maintenance Fees: $783
- Land Tenure: FS - Fee Simple
- Elementary School: Kaahumanu
- Middle School: Washington
- High School: Mckinley
