987 Queen Street Unit 4009 Honolulu, HI 96814
Listing
Overview
Price: $625,000
Area: KAKAAKO
Status: Active Under Contract
Aalii 4009 offers the best priced, highest floor residence in all of Ward Village. The ocean to mountain views are spectacular, and preferred on the Ewa facing side of the building. The amenity deck in tandem with Victoria Ward Park provides nearly 600 feet of distance between this studio and the nearest building in sight. Beautiful interior finishes with sleek Rottet Studio cabinetry, natural curated stone countertops w/ backsplashes and Bosch appliances. The home is outfitted by Inspiration Interiors with sturdy, top quality furnishings. Brand new Casper queen size mattress installed prior to listing. Aalii provides resort like amenities such as pools, cabanas, entertainment suites and childrens' playground. "Level 42" features party rooms, stunning balcony views and a massive fitness center....feels like you are exercising in the clouds. The building and community is pet friendly with a dog run on the ground level. Ward Village is the most exciting and innovative neighborhood Oahu's ever seen. Restaurants, shopping, Whole Foods, Ala Moana Outdoor Mall, and world famous beaches are close proximity to Aalii. Purchase your piece of Ward Village today! Listing by: Coldwell Banker Realty (808) 542-6540
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202411728"
}
["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) "4009"
}
["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) "625000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "625000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1169) "Aalii 4009 offers the best priced, highest floor residence in all of Ward Village. The ocean to mountain views are spectacular, and preferred on the Ewa facing side of the building. The amenity deck in tandem with Victoria Ward Park provides nearly 600 feet of distance between this studio and the nearest building in sight. Beautiful interior finishes with sleek Rottet Studio cabinetry, natural curated stone countertops w/ backsplashes and Bosch appliances. The home is outfitted by Inspiration Interiors with sturdy, top quality furnishings. Brand new Casper queen size mattress installed prior to listing. Aalii provides resort like amenities such as pools, cabanas, entertainment suites and childrens' playground. "Level 42" features party rooms, stunning balcony views and a massive fitness center....feels like you are exercising in the clouds. The building and community is pet friendly with a dog run on the ground level. Ward Village is the most exciting and innovative neighborhood Oahu's ever seen. Restaurants, shopping, Whole Foods, Ala Moana Outdoor Mall, and world famous beaches are close proximity to Aalii. Purchase your piece of Ward Village today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker 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) "2019"
}
["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(36) "City,Coastline,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "497.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) "CBPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(28) "Travis.McGaughy@cbrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 542-6540"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Travis L McGaughy"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-07-11T11:29:27.910"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18018669"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-22T09:50:05.157"
}
["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) "26405576"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26405576"
[1]=>
string(8) "26405577"
[2]=>
string(8) "26405578"
[3]=>
string(8) "26405579"
[4]=>
string(8) "26405580"
[5]=>
string(8) "26405581"
[6]=>
string(8) "26405582"
[7]=>
string(8) "26405583"
[8]=>
string(8) "26405584"
[9]=>
string(8) "26405585"
[10]=>
string(8) "26405586"
[11]=>
string(8) "26405587"
[12]=>
string(8) "26405588"
[13]=>
string(8) "26405589"
[14]=>
string(8) "26405590"
[15]=>
string(8) "26405591"
[16]=>
string(8) "26405592"
[17]=>
string(8) "26405593"
[18]=>
string(8) "26405594"
[19]=>
string(8) "26405595"
[20]=>
string(8) "26405596"
[21]=>
string(8) "26405597"
[22]=>
string(8) "26405598"
[23]=>
string(8) "26405599"
[24]=>
string(8) "26405600"
[25]=>
string(8) "26405601"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202411728
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 4009
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 625000.00
)
[CurrentPrice] => Array
(
[0] => 625000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Aalii 4009 offers the best priced, highest floor residence in all of Ward Village. The ocean to mountain views are spectacular, and preferred on the Ewa facing side of the building. The amenity deck in tandem with Victoria Ward Park provides nearly 600 feet of distance between this studio and the nearest building in sight. Beautiful interior finishes with sleek Rottet Studio cabinetry, natural curated stone countertops w/ backsplashes and Bosch appliances. The home is outfitted by Inspiration Interiors with sturdy, top quality furnishings. Brand new Casper queen size mattress installed prior to listing. Aalii provides resort like amenities such as pools, cabanas, entertainment suites and childrens' playground. "Level 42" features party rooms, stunning balcony views and a massive fitness center....feels like you are exercising in the clouds. The building and community is pet friendly with a dog run on the ground level. Ward Village is the most exciting and innovative neighborhood Oahu's ever seen. Restaurants, shopping, Whole Foods, Ala Moana Outdoor Mall, and world famous beaches are close proximity to Aalii. Purchase your piece of Ward Village today!
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 408
)
[YearBuilt] => Array
(
[0] => 2019
)
[BuildingName] => Array
(
[0] => Aalii
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Coastline,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 497.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP
)
[ListAgentEmail] => Array
(
[0] => Travis.McGaughy@cbrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 542-6540
)
[ListAgentFullName] => Array
(
[0] => Travis L McGaughy
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-07-11T11:29:27.910
)
[Matrix_Unique_ID] => Array
(
[0] => 18018669
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-22T09:50:05.157
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26405576
)
[listing_image] => Array
(
[0] => 26405576
[1] => 26405577
[2] => 26405578
[3] => 26405579
[4] => 26405580
[5] => 26405581
[6] => 26405582
[7] => 26405583
[8] => 26405584
[9] => 26405585
[10] => 26405586
[11] => 26405587
[12] => 26405588
[13] => 26405589
[14] => 26405590
[15] => 26405591
[16] => 26405592
[17] => 26405593
[18] => 26405594
[19] => 26405595
[20] => 26405596
[21] => 26405597
[22] => 26405598
[23] => 26405599
[24] => 26405600
[25] => 26405601
)
)
- Full Baths: 1
- Living (sf): 408
- Year Built: 2019
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Coastline,Mountain,Ocean,Sunset
- Listing Office: Coldwell Banker Realty
- Maintenance Fees: $497
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 11, 2024 - 11:29 AM
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.
