987 Queen Street Unit 3008 Honolulu, HI 96814
Listing
Overview
Price: $670,000
Area: KAKAAKO
Status: Active
Fully furnished studio unit at newer condominium at Ward Village. Blocks away from dining, grocery, major shopping mall and beach. The unit is on the cooler side with ocean and city view with a storage room. Luxury resort like amenities include pool, whirlpool, bbq and party room on 8th floor and indoor/outdoor lounge area and fitness room with views on penthouse level. 24hrs security. Listing by: Hawaii Hale Realty, LLC (808) 754-6030
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202409235"
}
["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) "3008"
}
["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) "670000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "670000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(388) "Fully furnished studio unit at newer condominium at Ward Village. Blocks away from dining, grocery, major shopping mall and beach. The unit is on the cooler side with ocean and city view with a storage room. Luxury resort like amenities include pool, whirlpool, bbq and party room on 8th floor and indoor/outdoor lounge area and fitness room with views on penthouse level. 24hrs security."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(23) "Hawaii Hale Realty, LLC"
}
["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(19) "City,Mountain,Ocean"
}
["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) "HIHR"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(28) "hawaiihalerealty01@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 754-6030"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Chris S Nemoto"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-05-11T11:32:46.690"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17966681"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-01T11:55:06.933"
}
["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) "26186892"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "26186892"
[1]=>
string(8) "26186893"
[2]=>
string(8) "26186894"
[3]=>
string(8) "26186895"
[4]=>
string(8) "26186896"
[5]=>
string(8) "26186897"
[6]=>
string(8) "26186898"
[7]=>
string(8) "26186899"
[8]=>
string(8) "26186900"
[9]=>
string(8) "26186901"
[10]=>
string(8) "26186902"
[11]=>
string(8) "26186903"
[12]=>
string(8) "26186904"
[13]=>
string(8) "26186905"
[14]=>
string(8) "26186906"
[15]=>
string(8) "26186907"
[16]=>
string(8) "26186908"
[17]=>
string(8) "26186909"
[18]=>
string(8) "26186910"
[19]=>
string(8) "26186911"
[20]=>
string(8) "26186912"
[21]=>
string(8) "26186913"
[22]=>
string(8) "26199485"
[23]=>
string(8) "26199486"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202409235
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 3008
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 670000.00
)
[CurrentPrice] => Array
(
[0] => 670000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Fully furnished studio unit at newer condominium at Ward Village. Blocks away from dining, grocery, major shopping mall and beach. The unit is on the cooler side with ocean and city view with a storage room. Luxury resort like amenities include pool, whirlpool, bbq and party room on 8th floor and indoor/outdoor lounge area and fitness room with views on penthouse level. 24hrs security.
)
[ListOfficeName] => Array
(
[0] => Hawaii Hale Realty, LLC
)
[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,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 496.04
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HIHR
)
[ListAgentEmail] => Array
(
[0] => hawaiihalerealty01@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 754-6030
)
[ListAgentFullName] => Array
(
[0] => Chris S Nemoto
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-05-11T11:32:46.690
)
[Matrix_Unique_ID] => Array
(
[0] => 17966681
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-01T11:55:06.933
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26186892
)
[listing_image] => Array
(
[0] => 26186892
[1] => 26186893
[2] => 26186894
[3] => 26186895
[4] => 26186896
[5] => 26186897
[6] => 26186898
[7] => 26186899
[8] => 26186900
[9] => 26186901
[10] => 26186902
[11] => 26186903
[12] => 26186904
[13] => 26186905
[14] => 26186906
[15] => 26186907
[16] => 26186908
[17] => 26186909
[18] => 26186910
[19] => 26186911
[20] => 26186912
[21] => 26186913
[22] => 26199485
[23] => 26199486
)
)
- Full Baths: 1
- Living (sf): 410
- Year Built: 2021
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Mountain,Ocean
- Listing Office: Hawaii Hale Realty, LLC
- Maintenance Fees: $496
- Land Tenure: FS - Fee Simple