987 Queen Street Unit 1208 Honolulu, HI 96814
Listing
Overview
Price: $615,000
Area: KAKAAKO
Status: Active
Furnished with the developer's top tier furniture package for efficient and luxurious living, make this piece of Kakaako your home or pied-a-terre. Just a couple blocks to the largest beach park in the state of Hawaii that features surfing, white sand beach, picnic areas, running trails, protected swimming areas, and so much more. The Kakaako neighborhood has everything you need right out the front door. Whether your enjoy top rated restaurants, breakfast hideaways, Whole Foods, or economical diners there is something for every taste nearby.
Are you a digital nomad? There's a shared work space with a huge community just around the corner at the Hub.
Come see the top floor that has large work out area with free weights and machines, yoga/stretching room, rooftop hang out, reservable movie room for entertaining, group meeting rooms, and lots of little areas that create intimate areas throughout the building. Did I mention the full size pool and hot tubs with BBQs and cabanas on the 8th floor pool deck.
There is just so much that you get with buying into these super efficient studios in a full amenity building.
Covered car parking. VA Assumable loan - email agent Listing by: TheOahuAgents.com (808) 271-2223
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202503312"
}
["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) "1208"
}
["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"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1185) "Furnished with the developer's top tier furniture package for efficient and luxurious living, make this piece of Kakaako your home or pied-a-terre. Just a couple blocks to the largest beach park in the state of Hawaii that features surfing, white sand beach, picnic areas, running trails, protected swimming areas, and so much more. The Kakaako neighborhood has everything you need right out the front door. Whether your enjoy top rated restaurants, breakfast hideaways, Whole Foods, or economical diners there is something for every taste nearby.
Are you a digital nomad? There's a shared work space with a huge community just around the corner at the Hub.
Come see the top floor that has large work out area with free weights and machines, yoga/stretching room, rooftop hang out, reservable movie room for entertaining, group meeting rooms, and lots of little areas that create intimate areas throughout the building. Did I mention the full size pool and hot tubs with BBQs and cabanas on the 8th floor pool deck.
There is just so much that you get with buying into these super efficient studios in a full amenity building.
Covered car parking. VA Assumable loan - email agent"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(17) "TheOahuAgents.com"
}
["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) "410"
}
["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(20) "City,Coastline,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "496.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) "TOAS"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "David@TheOahuAgents.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 271-2223"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "David M Nash"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18527802"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-22T18:15:01.360"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-02-05"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "18:15:01.360"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26872684"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26872684"
[1]=>
string(8) "26872685"
[2]=>
string(8) "26872686"
[3]=>
string(8) "26872687"
[4]=>
string(8) "26872688"
[5]=>
string(8) "26872689"
[6]=>
string(8) "26872690"
[7]=>
string(8) "26872691"
[8]=>
string(8) "26872692"
[9]=>
string(8) "26872693"
[10]=>
string(8) "26872694"
[11]=>
string(8) "26872695"
[12]=>
string(8) "26872696"
[13]=>
string(8) "26872697"
[14]=>
string(8) "26872698"
[15]=>
string(8) "26872699"
[16]=>
string(8) "26872700"
[17]=>
string(8) "26872701"
[18]=>
string(8) "26872702"
[19]=>
string(8) "26872703"
[20]=>
string(8) "26872704"
[21]=>
string(8) "26872705"
[22]=>
string(8) "26872706"
[23]=>
string(8) "26872707"
[24]=>
string(8) "26872708"
[25]=>
string(8) "26872709"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202503312
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 1208
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 615000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Furnished with the developer's top tier furniture package for efficient and luxurious living, make this piece of Kakaako your home or pied-a-terre. Just a couple blocks to the largest beach park in the state of Hawaii that features surfing, white sand beach, picnic areas, running trails, protected swimming areas, and so much more. The Kakaako neighborhood has everything you need right out the front door. Whether your enjoy top rated restaurants, breakfast hideaways, Whole Foods, or economical diners there is something for every taste nearby.
Are you a digital nomad? There's a shared work space with a huge community just around the corner at the Hub.
Come see the top floor that has large work out area with free weights and machines, yoga/stretching room, rooftop hang out, reservable movie room for entertaining, group meeting rooms, and lots of little areas that create intimate areas throughout the building. Did I mention the full size pool and hot tubs with BBQs and cabanas on the 8th floor pool deck.
There is just so much that you get with buying into these super efficient studios in a full amenity building.
Covered car parking. VA Assumable loan - email agent
)
[ListOfficeName] => Array
(
[0] => TheOahuAgents.com
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 410
)
[YearBuilt] => Array
(
[0] => 2021
)
[BuildingName] => Array
(
[0] => Aalii
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Coastline,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 496.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => TOAS
)
[ListAgentEmail] => Array
(
[0] => David@TheOahuAgents.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 271-2223
)
[ListAgentFullName] => Array
(
[0] => David M Nash
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18527802
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-22T18:15:01.360
)
[ListingContractDate] => Array
(
[0] => 2025-02-05
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 18:15:01.360
)
[_thumbnail_id] => Array
(
[0] => 26872684
)
[listing_image] => Array
(
[0] => 26872684
[1] => 26872685
[2] => 26872686
[3] => 26872687
[4] => 26872688
[5] => 26872689
[6] => 26872690
[7] => 26872691
[8] => 26872692
[9] => 26872693
[10] => 26872694
[11] => 26872695
[12] => 26872696
[13] => 26872697
[14] => 26872698
[15] => 26872699
[16] => 26872700
[17] => 26872701
[18] => 26872702
[19] => 26872703
[20] => 26872704
[21] => 26872705
[22] => 26872706
[23] => 26872707
[24] => 26872708
[25] => 26872709
)
)
- Full Baths: 1
- Living (sf): 410
- Year Built: 2021
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Coastline,Ocean
- Listing Office: TheOahuAgents.com
- Maintenance Fees: $496
- Land Tenure: FS - Fee Simple
