987 Queen Street Unit 3703 Honolulu, HI 96814
Listing
Overview
Price: $759,000
Area: KAKAAKO
Status: Active
Welcome to A'ali'i! Howard Hughes' newest residential building in Ward Village, this unit comes with beautiful ocean and city views. Furnitures are optional and negotiable. 8th floor amenities are Pool & Kid's pool, Cabanas, Private BBQ’s. Rooftop gym & yoga, bike & surf racks and storage. Also, penthouse Lanai w/ private, indoor & outdoor sky lounges, private dining. This peaceful and decadent slice of paradise is vacant and easy to see, schedule a visit now! Listing by: Transglobal Realty
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202316366"
}
["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) "3703"
}
["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) "759000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "759000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(466) "Welcome to A'ali'i! Howard Hughes' newest residential building in Ward Village, this unit comes with beautiful ocean and city views. Furnitures are optional and negotiable. 8th floor amenities are Pool & Kid's pool, Cabanas, Private BBQ’s. Rooftop gym & yoga, bike & surf racks and storage. Also, penthouse Lanai w/ private, indoor & outdoor sky lounges, private dining. This peaceful and decadent slice of paradise is vacant and easy to see, schedule a visit now!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Transglobal Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "535"
}
["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(0) ""
}
["View"]=>
array(1) {
[0]=>
string(21) "Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "601.21"
}
["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) "TGRA"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "tg.honolulu@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(9) "Huanbo Yu"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-08-20T13:21:45.150"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17438333"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-07-12T14:03:16.587"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25866740"
}
["listing_image"]=>
array(19) {
[0]=>
string(8) "25866740"
[1]=>
string(8) "25866741"
[2]=>
string(8) "25866742"
[3]=>
string(8) "25866743"
[4]=>
string(8) "25866744"
[5]=>
string(8) "25866745"
[6]=>
string(8) "25866746"
[7]=>
string(8) "25866747"
[8]=>
string(8) "25866748"
[9]=>
string(8) "25866749"
[10]=>
string(8) "25866750"
[11]=>
string(8) "25866751"
[12]=>
string(8) "25866752"
[13]=>
string(8) "25866753"
[14]=>
string(8) "25866754"
[15]=>
string(8) "25866755"
[16]=>
string(8) "25866756"
[17]=>
string(8) "25866757"
[18]=>
string(8) "25866758"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Marina,Ocean"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202316366
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 3703
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 759000.00
)
[CurrentPrice] => Array
(
[0] => 759000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to A'ali'i! Howard Hughes' newest residential building in Ward Village, this unit comes with beautiful ocean and city views. Furnitures are optional and negotiable. 8th floor amenities are Pool & Kid's pool, Cabanas, Private BBQ’s. Rooftop gym & yoga, bike & surf racks and storage. Also, penthouse Lanai w/ private, indoor & outdoor sky lounges, private dining. This peaceful and decadent slice of paradise is vacant and easy to see, schedule a visit now!
)
[ListOfficeName] => Array
(
[0] => Transglobal Realty
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 535
)
[YearBuilt] => Array
(
[0] => 2021
)
[BuildingName] => Array
(
[0] => Aalii
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 601.21
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => TGRA
)
[ListAgentEmail] => Array
(
[0] => tg.honolulu@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => Huanbo Yu
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-08-20T13:21:45.150
)
[Matrix_Unique_ID] => Array
(
[0] => 17438333
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-07-12T14:03:16.587
)
[_thumbnail_id] => Array
(
[0] => 25866740
)
[listing_image] => Array
(
[0] => 25866740
[1] => 25866741
[2] => 25866742
[3] => 25866743
[4] => 25866744
[5] => 25866745
[6] => 25866746
[7] => 25866747
[8] => 25866748
[9] => 25866749
[10] => 25866750
[11] => 25866751
[12] => 25866752
[13] => 25866753
[14] => 25866754
[15] => 25866755
[16] => 25866756
[17] => 25866757
[18] => 25866758
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Marina,Ocean
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 1
- Full Baths: 1
- Living (sf): 535
- Year Built: 2021
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: Mountain,Ocean,Sunset
- Listing Office: Transglobal Realty
- Maintenance Fees: $601
- Land Tenure: FS - Fee Simple
