987 Queen Street Unit 4009 Honolulu, HI 96814
Listing
Overview
Price: $625,000
Area: KAKAAKO
Status: Active
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(6) "Active"
}
["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
)
[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
