Our office will be closed on Monday, November 11th, 2024.
987 Queen Street Unit 3812 Honolulu, HI 96814
Listing Overview
Price: $815,000 Area: KAKAAKO Status: Active Under Contract
Welcome to 'A'ali'i in the heart of Ward Village. This one bedroom, one bathroom unit is located on the 38th floor with stunning ocean and city views. The open kitchen concept features Bosch appliances, Studio Becker cabinetry, and natural stone countertops. The unit comes equipped with Mitsubishi split air conditioning units, front-loading Whirlpool washer and dryer, and remote-controlled roller shades. 'A'ali'i amenities include a luxurious lobby, penthouse-level sky deck with panoramic ocean views, rooftop fitness club, indoor/outdoor event spaces, yoga room, BBQ areas, great lawn, and a resort-style pool and spa. The building also has ample guest parking, bicycle and surfboard storage facilities, and a dog park. Enjoy Kakaako living with great restaurants, amazing shopping, Whole Foods Market, Ward Theater Complex, and Ala Moana Beach Park just steps away. Listing by: AMG Realty Inc (808) 343-6789
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421678"
}
["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) "3812"
}
["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) "815000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "815000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(875) "Welcome to 'A'ali'i in the heart of Ward Village. This one bedroom, one bathroom unit is located on the 38th floor with stunning ocean and city views. The open kitchen concept features Bosch appliances, Studio Becker cabinetry, and natural stone countertops. The unit comes equipped with Mitsubishi split air conditioning units, front-loading Whirlpool washer and dryer, and remote-controlled roller shades. 'A'ali'i amenities include a luxurious lobby, penthouse-level sky deck with panoramic ocean views, rooftop fitness club, indoor/outdoor event spaces, yoga room, BBQ areas, great lawn, and a resort-style pool and spa. The building also has ample guest parking, bicycle and surfboard storage facilities, and a dog park. Enjoy Kakaako living with great restaurants, amazing shopping, Whole Foods Market, Ward Theater Complex, and Ala Moana Beach Park just steps away."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "AMG Realty Inc"
}
["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) "679"
}
["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) "801.29"
}
["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) "ENDO"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(20) "gtaira@amghawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 343-6789"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Garrett S Taira"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-02T07:29:21.710"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18279375"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-24T14:13:13.633"
}
["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) "26706503"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26706503"
[1]=>
string(8) "26706504"
[2]=>
string(8) "26706505"
[3]=>
string(8) "26706506"
[4]=>
string(8) "26706507"
[5]=>
string(8) "26706508"
[6]=>
string(8) "26706509"
[7]=>
string(8) "26706510"
[8]=>
string(8) "26706511"
[9]=>
string(8) "26706512"
[10]=>
string(8) "26706513"
[11]=>
string(8) "26706514"
[12]=>
string(8) "26706515"
[13]=>
string(8) "26706516"
[14]=>
string(8) "26706517"
[15]=>
string(8) "26706518"
[16]=>
string(8) "26706519"
[17]=>
string(8) "26706520"
[18]=>
string(8) "26706521"
[19]=>
string(8) "26706522"
[20]=>
string(8) "26706523"
[21]=>
string(8) "26706524"
[22]=>
string(8) "26706525"
[23]=>
string(8) "26706526"
[24]=>
string(8) "26706527"
[25]=>
string(8) "26706528"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421678
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 3812
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 815000.00
)
[CurrentPrice] => Array
(
[0] => 815000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Welcome to 'A'ali'i in the heart of Ward Village. This one bedroom, one bathroom unit is located on the 38th floor with stunning ocean and city views. The open kitchen concept features Bosch appliances, Studio Becker cabinetry, and natural stone countertops. The unit comes equipped with Mitsubishi split air conditioning units, front-loading Whirlpool washer and dryer, and remote-controlled roller shades. 'A'ali'i amenities include a luxurious lobby, penthouse-level sky deck with panoramic ocean views, rooftop fitness club, indoor/outdoor event spaces, yoga room, BBQ areas, great lawn, and a resort-style pool and spa. The building also has ample guest parking, bicycle and surfboard storage facilities, and a dog park. Enjoy Kakaako living with great restaurants, amazing shopping, Whole Foods Market, Ward Theater Complex, and Ala Moana Beach Park just steps away.
)
[ListOfficeName] => Array
(
[0] => AMG Realty Inc
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 679
)
[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] => 801.29
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ENDO
)
[ListAgentEmail] => Array
(
[0] => gtaira@amghawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 343-6789
)
[ListAgentFullName] => Array
(
[0] => Garrett S Taira
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-02T07:29:21.710
)
[Matrix_Unique_ID] => Array
(
[0] => 18279375
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-24T14:13:13.633
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26706503
)
[listing_image] => Array
(
[0] => 26706503
[1] => 26706504
[2] => 26706505
[3] => 26706506
[4] => 26706507
[5] => 26706508
[6] => 26706509
[7] => 26706510
[8] => 26706511
[9] => 26706512
[10] => 26706513
[11] => 26706514
[12] => 26706515
[13] => 26706516
[14] => 26706517
[15] => 26706518
[16] => 26706519
[17] => 26706520
[18] => 26706521
[19] => 26706522
[20] => 26706523
[21] => 26706524
[22] => 26706525
[23] => 26706526
[24] => 26706527
[25] => 26706528
)
)
