987 Queen Street Unit 2604 Honolulu, HI 96814
Listing
Overview
Price: $825,000
Area: KAKAAKO
Status: Active
Recently brand new Luxury condo at Kaka'ako prime location. High floor, great ocean view, very good layout for 1b/1b. Upgraded motorized blinds. Close to Wholefoods, Ala Moana beach/park and lots of dining areas nearby. Very secured building. Bosch appliance and panoramic beautiful ocean view. World class amenities on the 8th floor with swimming Pools, jacuzzi, cabanas, indoor/outdoor private event party rooms and BBQ. On the 42nd floor with 360 degree sky lounge with beautiful ocean and city views, Gym, Yoga, event party room and more. Owner's vacation home. Almost brand new. Excellent condition. Must see! To be sold As-Is. Listing by: Locations LLC (808) 230-3311
array(42) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202311858"
}
["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) "825000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "825000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(632) "Recently brand new Luxury condo at Kaka'ako prime location. High floor, great ocean view, very good layout for 1b/1b. Upgraded motorized blinds. Close to Wholefoods, Ala Moana beach/park and lots of dining areas nearby. Very secured building. Bosch appliance and panoramic beautiful ocean view. World class amenities on the 8th floor with swimming Pools, jacuzzi, cabanas, indoor/outdoor private event party rooms and BBQ. On the 42nd floor with 360 degree sky lounge with beautiful ocean and city views, Gym, Yoga, event party room and more. Owner's vacation home. Almost brand new. Excellent condition. Must see! To be sold As-Is."
}
["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(26) "Diamond Head,Ocean,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "730.86"
}
["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) 230-3311"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Youngsook On"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-07-10T15:33:29.667"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17349831"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-06-05T08:47:28.870"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25853104"
}
["listing_image"]=>
array(12) {
[0]=>
string(8) "25853104"
[1]=>
string(8) "25853105"
[2]=>
string(8) "25853106"
[3]=>
string(8) "25853107"
[4]=>
string(8) "25853108"
[5]=>
string(8) "25853109"
[6]=>
string(8) "25853110"
[7]=>
string(8) "25853111"
[8]=>
string(8) "25853112"
[9]=>
string(8) "25853113"
[10]=>
string(8) "25853114"
[11]=>
string(8) "25853115"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202311858
)
[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] => 825000.00
)
[CurrentPrice] => Array
(
[0] => 825000.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, very good layout for 1b/1b. Upgraded motorized blinds. Close to Wholefoods, Ala Moana beach/park and lots of dining areas nearby. Very secured building. Bosch appliance and panoramic beautiful ocean view. World class amenities on the 8th floor with swimming Pools, jacuzzi, cabanas, indoor/outdoor private event party rooms and BBQ. On the 42nd floor with 360 degree sky lounge with beautiful ocean and city views, Gym, Yoga, event party room and more. Owner's vacation home. Almost brand new. Excellent condition. Must see! To be sold As-Is.
)
[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] => Diamond Head,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] => 730.86
)
[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) 230-3311
)
[ListAgentFullName] => Array
(
[0] => Youngsook On
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-07-10T15:33:29.667
)
[Matrix_Unique_ID] => Array
(
[0] => 17349831
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-06-05T08:47:28.870
)
[_thumbnail_id] => Array
(
[0] => 25853104
)
[listing_image] => Array
(
[0] => 25853104
[1] => 25853105
[2] => 25853106
[3] => 25853107
[4] => 25853108
[5] => 25853109
[6] => 25853110
[7] => 25853111
[8] => 25853112
[9] => 25853113
[10] => 25853114
[11] => 25853115
)
)
- BedsTotal: 1
- Full Baths: 1
- Living (sf): 624
- Year Built: 2021
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: Diamond Head,Ocean,Sunrise
- Listing Office: Locations LLC
- Maintenance Fees: $731
- Land Tenure: FS - Fee Simple
