987 Queen Street Unit 2906 Honolulu, HI 96814
Listing
Overview
Price: $615,000
Area: KAKAAKO
Status: Active
Price to sell!! Experience luxury in this unique high-floor ocean and mountain view condo at Aalii, complete with storage unit #S7-004 and 1 assigned parking space. This furnished unit features pristine, looks like new appliances and top-of-the-line upgrades including elegant mirrors, a Murphy bed, vinyl flooring, quartz countertops, and Bosch appliances. Enjoy luxurious living with mesmerizing ocean and city views from the rooftop Sky Lounge. Aalii offers unparalleled amenities like an outdoor fitness deck, Jacuzzi, cabanas, BBQ areas, and more. Embrace urban living in this one-of-a-kind residence located in Kakaako/Ward, with dining, the beach, and Ala Moana Mall at your doorstep. Price reduction, motivated seller! Open House on Saturday, August 25th, from 2pm to 5pm. Listing by: Real Broker, LLC (808) 650-5145
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202416079"
}
["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) "2906"
}
["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) "615000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "615000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(780) "Price to sell!! Experience luxury in this unique high-floor ocean and mountain view condo at Aalii, complete with storage unit #S7-004 and 1 assigned parking space. This furnished unit features pristine, looks like new appliances and top-of-the-line upgrades including elegant mirrors, a Murphy bed, vinyl flooring, quartz countertops, and Bosch appliances. Enjoy luxurious living with mesmerizing ocean and city views from the rooftop Sky Lounge. Aalii offers unparalleled amenities like an outdoor fitness deck, Jacuzzi, cabanas, BBQ areas, and more. Embrace urban living in this one-of-a-kind residence located in Kakaako/Ward, with dining, the beach, and Ala Moana Mall at your doorstep. Price reduction, motivated seller! Open House on Saturday, August 25th, from 2pm to 5pm."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(16) "Real Broker, LLC"
}
["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) "413"
}
["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(19) "City,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "500.13"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Kaahumanu"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(9) "Stevenson"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Mckinley"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "RBLL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(20) "taingmonik@yahoo.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 650-5145"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Monik Taing"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-27T16:24:24.587"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18128167"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-13T10:17:15.230"
}
["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) "26622056"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26622056"
[1]=>
string(8) "26622057"
[2]=>
string(8) "26622058"
[3]=>
string(8) "26622059"
[4]=>
string(8) "26622060"
[5]=>
string(8) "26622061"
[6]=>
string(8) "26622062"
[7]=>
string(8) "26622063"
[8]=>
string(8) "26622064"
[9]=>
string(8) "26622065"
[10]=>
string(8) "26622066"
[11]=>
string(8) "26622067"
[12]=>
string(8) "26622068"
[13]=>
string(8) "26622069"
[14]=>
string(8) "26622070"
[15]=>
string(8) "26622071"
[16]=>
string(8) "26622072"
[17]=>
string(8) "26622073"
[18]=>
string(8) "26622074"
[19]=>
string(8) "26622075"
[20]=>
string(8) "26622076"
[21]=>
string(8) "26622077"
[22]=>
string(8) "26622078"
[23]=>
string(8) "26622079"
[24]=>
string(8) "26622080"
[25]=>
string(8) "26622081"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202416079
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 2906
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 615000.00
)
[CurrentPrice] => Array
(
[0] => 615000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Price to sell!! Experience luxury in this unique high-floor ocean and mountain view condo at Aalii, complete with storage unit #S7-004 and 1 assigned parking space. This furnished unit features pristine, looks like new appliances and top-of-the-line upgrades including elegant mirrors, a Murphy bed, vinyl flooring, quartz countertops, and Bosch appliances. Enjoy luxurious living with mesmerizing ocean and city views from the rooftop Sky Lounge. Aalii offers unparalleled amenities like an outdoor fitness deck, Jacuzzi, cabanas, BBQ areas, and more. Embrace urban living in this one-of-a-kind residence located in Kakaako/Ward, with dining, the beach, and Ala Moana Mall at your doorstep. Price reduction, motivated seller! Open House on Saturday, August 25th, from 2pm to 5pm.
)
[ListOfficeName] => Array
(
[0] => Real Broker, LLC
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 413
)
[YearBuilt] => Array
(
[0] => 2021
)
[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] => 500.13
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kaahumanu
)
[MiddleOrJuniorSchool] => Array
(
[0] => Stevenson
)
[HighSchool] => Array
(
[0] => Mckinley
)
[ListOfficeMLSID] => Array
(
[0] => RBLL
)
[ListAgentEmail] => Array
(
[0] => taingmonik@yahoo.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 650-5145
)
[ListAgentFullName] => Array
(
[0] => Monik Taing
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-27T16:24:24.587
)
[Matrix_Unique_ID] => Array
(
[0] => 18128167
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-13T10:17:15.230
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26622056
)
[listing_image] => Array
(
[0] => 26622056
[1] => 26622057
[2] => 26622058
[3] => 26622059
[4] => 26622060
[5] => 26622061
[6] => 26622062
[7] => 26622063
[8] => 26622064
[9] => 26622065
[10] => 26622066
[11] => 26622067
[12] => 26622068
[13] => 26622069
[14] => 26622070
[15] => 26622071
[16] => 26622072
[17] => 26622073
[18] => 26622074
[19] => 26622075
[20] => 26622076
[21] => 26622077
[22] => 26622078
[23] => 26622079
[24] => 26622080
[25] => 26622081
)
)
- Full Baths: 1
- Living (sf): 413
- Year Built: 2021
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Mountain,Ocean
- Listing Office: Real Broker, LLC
- Maintenance Fees: $500
- Land Tenure: FS - Fee Simple
- Elementary School: Kaahumanu
- Middle School: Stevenson
- High School: Mckinley
