987 Queen Street Unit 2509 Honolulu, HI 96814
Listing
Overview
Price: $590,000
Area: KAKAAKO
Status: Active
PRICE REDUCTION!! 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(48) {
["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) "590000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(916) "PRICE REDUCTION!! 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) "496.04"
}
["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) "2025-04-26T13:40:02.557"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17877379"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_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"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-06-13"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "13:40:02.557"
}
}
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] => 590000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => PRICE REDUCTION!! 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] => 496.04
)
[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] => 2025-04-26T13:40:02.557
)
[Matrix_Unique_ID] => Array
(
[0] => 17877379
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_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
)
[ListingContractDate] => Array
(
[0] => 2024-06-13
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 13:40:02.557
)
)
- 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: $496
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on April 26, 2025 - 1:40 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
© Marcus Realty. All Rights Reserved.
