987 Queen Street Unit 2509 Honolulu, HI 96814
Listing
Overview
Price: $599,000
Area: KAKAAKO
Status: Active
Fully Furnished, higher floor studio with mesmerizing view of the pool, spa, cabana, mountain, city, ocean and sunset views from your lanai! Super convenient location near Whole Foods, a variety of restaurants, shops and Ala Moana Beach! Aalii has a modern and sophisticated sense of place. The turn-key, unit's finishes include tile & luxury vinyl flooring, quartz counter tops, rain shower and Bosch appliances. New washer in 2022. You will love the exquisite amenities: 2 roof top decks with spectacular views from the Sky Lounge, a dream Fitness Club, Yoga Room, Outdoor Fitness Deck, Jacuzzi, cabanas, BBQ areas, large Dog park with pet washing station and numerous indoor/outdoor party rooms to entertain and have fun! Ward Village was named the Best master Plan Community in America in 2018! You will feel home at Aalii! Great tenant would like to stay and it could be a turn-key investment! Listing by: eXp Realty (808) 725-2794
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202406009"
}
["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) "2509"
}
["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) "599000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "599000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(898) "Fully Furnished, higher floor studio with mesmerizing view of the pool, spa, cabana, mountain, city, ocean and sunset views from your lanai! Super convenient location near Whole Foods, a variety of restaurants, shops and Ala Moana Beach! Aalii has a modern and sophisticated sense of place. The turn-key, unit's finishes include tile & luxury vinyl flooring, quartz counter tops, rain shower and Bosch appliances. New washer in 2022. You will love the exquisite amenities: 2 roof top decks with spectacular views from the Sky Lounge, a dream Fitness Club, Yoga Room, Outdoor Fitness Deck, Jacuzzi, cabanas, BBQ areas, large Dog park with pet washing station and numerous indoor/outdoor party rooms to entertain and have fun! Ward Village was named the Best master Plan Community in America in 2018! You will feel home at Aalii! Great tenant would like to stay and it could be a turn-key investment!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["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) "408"
}
["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(17) "City,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "461.40"
}
["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) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "vanina.nakaoka@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Vanina Nakaoka"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-10T15:41:04.327"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17877379"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-13T16:36:50.007"
}
["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) "26579765"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "26579765"
[1]=>
string(8) "26579766"
[2]=>
string(8) "26579767"
[3]=>
string(8) "26579768"
[4]=>
string(8) "26579769"
[5]=>
string(8) "26579770"
[6]=>
string(8) "26579771"
[7]=>
string(8) "26579772"
[8]=>
string(8) "26579773"
[9]=>
string(8) "26579774"
[10]=>
string(8) "26579775"
[11]=>
string(8) "26579776"
[12]=>
string(8) "26579777"
[13]=>
string(8) "26579778"
[14]=>
string(8) "26579779"
[15]=>
string(8) "26579780"
[16]=>
string(8) "26579781"
[17]=>
string(8) "26579782"
[18]=>
string(8) "26579783"
[19]=>
string(8) "26579784"
[20]=>
string(8) "26579785"
[21]=>
string(8) "26579786"
[22]=>
string(8) "26579787"
[23]=>
string(8) "26579788"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202406009
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 2509
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 599000.00
)
[CurrentPrice] => Array
(
[0] => 599000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Fully Furnished, higher floor studio with mesmerizing view of the pool, spa, cabana, mountain, city, ocean and sunset views from your lanai! Super convenient location near Whole Foods, a variety of restaurants, shops and Ala Moana Beach! Aalii has a modern and sophisticated sense of place. The turn-key, unit's finishes include tile & luxury vinyl flooring, quartz counter tops, rain shower and Bosch appliances. New washer in 2022. You will love the exquisite amenities: 2 roof top decks with spectacular views from the Sky Lounge, a dream Fitness Club, Yoga Room, Outdoor Fitness Deck, Jacuzzi, cabanas, BBQ areas, large Dog park with pet washing station and numerous indoor/outdoor party rooms to entertain and have fun! Ward Village was named the Best master Plan Community in America in 2018! You will feel home at Aalii! Great tenant would like to stay and it could be a turn-key investment!
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 408
)
[YearBuilt] => Array
(
[0] => 2021
)
[BuildingName] => Array
(
[0] => Aalii
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 461.40
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => vanina.nakaoka@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 725-2794
)
[ListAgentFullName] => Array
(
[0] => Vanina Nakaoka
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-10T15:41:04.327
)
[Matrix_Unique_ID] => Array
(
[0] => 17877379
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-13T16:36:50.007
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26579765
)
[listing_image] => Array
(
[0] => 26579765
[1] => 26579766
[2] => 26579767
[3] => 26579768
[4] => 26579769
[5] => 26579770
[6] => 26579771
[7] => 26579772
[8] => 26579773
[9] => 26579774
[10] => 26579775
[11] => 26579776
[12] => 26579777
[13] => 26579778
[14] => 26579779
[15] => 26579780
[16] => 26579781
[17] => 26579782
[18] => 26579783
[19] => 26579784
[20] => 26579785
[21] => 26579786
[22] => 26579787
[23] => 26579788
)
)
- Full Baths: 1
- Living (sf): 408
- Year Built: 2021
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Ocean,Sunset
- Listing Office: eXp Realty
- Maintenance Fees: $461
- Land Tenure: FS - Fee Simple
