987 Queen Street Unit 2604 Honolulu, HI 96814
Listing
Overview
Price: $799,000
Area: KAKAAKO
Status: Active
Recently brand new Luxury Condo at Kaka'ako prime location, High floor, great ocean view 1b/1b. Close to Wholefoods, Ala Moana beach/park and lots of walkable dining area. Very secured building, Bosch appliance and panoramic beautiful ocean view, World class amenities on the 8th floor with Pools, jacuzzi, cabanas, indoor/outdoor private event rooms and BBQ. On the 42nd floor with sky lounge 360 degree beautiful ocean and city views. Gym, Yoga, event party room and more. Excellent condition. Must see to be sold As-Is. Seller prefer to use First Hawaii Title - Jin Yu Listing by: Locations LLC (808) 735-4200
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202407880"
}
["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) "799000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "799000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(571) "Recently brand new Luxury Condo at Kaka'ako prime location, High floor, great ocean view 1b/1b. Close to Wholefoods, Ala Moana beach/park and lots of walkable dining area. Very secured building, Bosch appliance and panoramic beautiful ocean view, World class amenities on the 8th floor with Pools, jacuzzi, cabanas, indoor/outdoor private event rooms and BBQ. On the 42nd floor with sky lounge 360 degree beautiful ocean and city views. Gym, Yoga, event party room and more. Excellent condition. Must see to be sold As-Is. Seller prefer to use First Hawaii Title - Jin Yu"
}
["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(33) "City,Coastline,Diamond Head,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "783.00"
}
["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) "LOCA"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(32) "youngsook.on@locationshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Youngsook On"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-04-10T08:34:24.913"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17929051"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-10T08:32:38.677"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26160452"
}
["listing_image"]=>
array(12) {
[0]=>
string(8) "26160452"
[1]=>
string(8) "26160453"
[2]=>
string(8) "26160454"
[3]=>
string(8) "26160455"
[4]=>
string(8) "26160456"
[5]=>
string(8) "26160457"
[6]=>
string(8) "26160458"
[7]=>
string(8) "26160459"
[8]=>
string(8) "26160460"
[9]=>
string(8) "26160461"
[10]=>
string(8) "26160462"
[11]=>
string(8) "26160463"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202407880
)
[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] => 799000.00
)
[CurrentPrice] => Array
(
[0] => 799000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Recently brand new Luxury Condo at Kaka'ako prime location, High floor, great ocean view 1b/1b. Close to Wholefoods, Ala Moana beach/park and lots of walkable dining area. Very secured building, Bosch appliance and panoramic beautiful ocean view, World class amenities on the 8th floor with Pools, jacuzzi, cabanas, indoor/outdoor private event rooms and BBQ. On the 42nd floor with sky lounge 360 degree beautiful ocean and city views. Gym, Yoga, event party room and more. Excellent condition. Must see to be sold As-Is. Seller prefer to use First Hawaii Title - Jin Yu
)
[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,Diamond Head,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 783.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => LOCA
)
[ListAgentEmail] => Array
(
[0] => youngsook.on@locationshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 735-4200
)
[ListAgentFullName] => Array
(
[0] => Youngsook On
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-04-10T08:34:24.913
)
[Matrix_Unique_ID] => Array
(
[0] => 17929051
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-10T08:32:38.677
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26160452
)
[listing_image] => Array
(
[0] => 26160452
[1] => 26160453
[2] => 26160454
[3] => 26160455
[4] => 26160456
[5] => 26160457
[6] => 26160458
[7] => 26160459
[8] => 26160460
[9] => 26160461
[10] => 26160462
[11] => 26160463
)
)
- 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,Diamond Head,Ocean
- Listing Office: Locations LLC
- Maintenance Fees: $783
- Land Tenure: FS - Fee Simple