987 Queen Street Unit 3802 Honolulu, HI 96814

Listing
Overview

Price: $1,498,000
Area: KAKAAKO
Status: Active

'A'ali'i stands in the heart of Ward Village, an award-winning community in Honolulu, where boutique shops, diverse dining options, sandy beaches, boat harbors, and green parks are all within blocks. This soaring high floor, front-corner 2-bedroom, 2-bath residence stuns with Pacific Ocean, Beach Park, and Boat Harbor views from the main living area, kitchen and dining space, as well as the primary bedroom suite. Finishes include high-end appointments, Bosch appliances, luxury flooring, granite counter-tops, designer cabinetry and built-ins throughout; this residence includes and is sold with the turn-key furniture package. Resort full-suite amenities include a rooftop sky lounge, rooftop fitness center, ocean view gathering and event spaces, yoga room, children's splash pool, adult swimming pool and hot tub, multiple covered cabanas and outdoor barbecue areas, green spaces, and much more. Sale includes two parking stalls, an EV charger, a storage room, and storage locker. Modern, sophisticated, luxurious; welcome home to 'A'ali'i #3802. Listing includes enhanced, virtually staged and zoomed-in photos. Listing by: Sachi HI Pacific Century Prop. (808) 596-8801

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202505359"
  }
  ["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) "3802"
  }
  ["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(10) "1498000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1119) "'A'ali'i stands in the heart of Ward Village, an award-winning community in Honolulu, where boutique shops, diverse dining options, sandy beaches, boat harbors, and green parks are all within blocks. This soaring high floor, front-corner 2-bedroom, 2-bath residence stuns with Pacific Ocean, Beach Park, and Boat Harbor views from the main living area, kitchen and dining space, as well as the primary bedroom suite. Finishes include high-end appointments, Bosch appliances, luxury flooring, granite counter-tops, designer cabinetry and built-ins throughout; this residence includes and is sold with the turn-key furniture package. Resort full-suite amenities include a rooftop sky lounge, rooftop fitness center, ocean view gathering and event spaces, yoga room, children's splash pool, adult swimming pool and hot tub, multiple covered cabanas and outdoor barbecue areas, green spaces, and much more. Sale includes two parking stalls, an EV charger, a storage room, and storage locker. Modern, sophisticated, luxurious; welcome home to 'A'ali'i #3802. Listing includes enhanced, virtually staged and zoomed-in photos."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(30) "Sachi HI Pacific Century Prop."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "868"
  }
  ["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) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(10) "City,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1152.10"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Kaahumanu"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(9) "Stevenson"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(8) "Mckinley"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "SACH"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "atsuko@sachihawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-8801"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Atsuko Ajed"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18566791"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-02-21T15:40:52.037"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-02-20"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "15:40:52.037"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26890727"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "26890727"
    [1]=>
    string(8) "26890728"
    [2]=>
    string(8) "26890729"
    [3]=>
    string(8) "26890730"
    [4]=>
    string(8) "26890731"
    [5]=>
    string(8) "26890732"
    [6]=>
    string(8) "26890733"
    [7]=>
    string(8) "26890734"
    [8]=>
    string(8) "26890735"
    [9]=>
    string(8) "26890736"
    [10]=>
    string(8) "26890737"
    [11]=>
    string(8) "26890738"
    [12]=>
    string(8) "26890739"
    [13]=>
    string(8) "26890740"
    [14]=>
    string(8) "26890930"
    [15]=>
    string(8) "26890931"
    [16]=>
    string(8) "26890932"
    [17]=>
    string(8) "26890933"
    [18]=>
    string(8) "26890934"
    [19]=>
    string(8) "26890935"
    [20]=>
    string(8) "26890936"
    [21]=>
    string(8) "26890937"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202505359
        )

    [StreetNumber] => Array
        (
            [0] => 987
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

    [StreetName] => Array
        (
            [0] => Queen
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => 3802
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96814
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 1498000.00
        )

    [Neighbourhood] => Array
        (
            [0] => KAKAAKO
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => 'A'ali'i stands in the heart of Ward Village, an award-winning community in Honolulu, where boutique shops, diverse dining options, sandy beaches, boat harbors, and green parks are all within blocks. This soaring high floor, front-corner 2-bedroom, 2-bath residence stuns with Pacific Ocean, Beach Park, and Boat Harbor views from the main living area, kitchen and dining space, as well as the primary bedroom suite. Finishes include high-end appointments, Bosch appliances, luxury flooring, granite counter-tops, designer cabinetry and built-ins throughout; this residence includes and is sold with the turn-key furniture package. Resort full-suite amenities include a rooftop sky lounge, rooftop fitness center, ocean view gathering and event spaces, yoga room, children's splash pool, adult swimming pool and hot tub, multiple covered cabanas and outdoor barbecue areas, green spaces, and much more. Sale includes two parking stalls, an EV charger, a storage room, and storage locker. Modern, sophisticated, luxurious; welcome home to 'A'ali'i #3802. Listing includes enhanced, virtually staged and zoomed-in photos.
        )

    [ListOfficeName] => Array
        (
            [0] => Sachi HI Pacific Century Prop.
        )

    [BedsTotal] => Array
        (
            [0] => 2
        )

    [BathsFull] => Array
        (
            [0] => 2
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 
        )

    [SqftTotal] => Array
        (
            [0] => 868
        )

    [YearBuilt] => Array
        (
            [0] => 2019
        )

    [BuildingName] => Array
        (
            [0] => Aalii
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

    [ParkingTotal] => Array
        (
            [0] => 2
        )

    [StoriesType] => Array
        (
            [0] => 21+
        )

    [View] => Array
        (
            [0] => City,Ocean
        )

    [MaintenanceExpense] => Array
        (
            [0] => 1152.10
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => Kaahumanu
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => Stevenson
        )

    [HighSchool] => Array
        (
            [0] => Mckinley
        )

    [ListOfficeMLSID] => Array
        (
            [0] => SACH
        )

    [ListAgentEmail] => Array
        (
            [0] => atsuko@sachihawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 596-8801
        )

    [ListAgentFullName] => Array
        (
            [0] => Atsuko Ajed
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18566791
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-02-21T15:40:52.037
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-02-20
        )

    [MLSAreaMajor] => Array
        (
            [0] => Metro
        )

    [PropertyFrontage] => Array
        (
            [0] => Other
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 15:40:52.037
        )

    [_thumbnail_id] => Array
        (
            [0] => 26890727
        )

    [listing_image] => Array
        (
            [0] => 26890727
            [1] => 26890728
            [2] => 26890729
            [3] => 26890730
            [4] => 26890731
            [5] => 26890732
            [6] => 26890733
            [7] => 26890734
            [8] => 26890735
            [9] => 26890736
            [10] => 26890737
            [11] => 26890738
            [12] => 26890739
            [13] => 26890740
            [14] => 26890930
            [15] => 26890931
            [16] => 26890932
            [17] => 26890933
            [18] => 26890934
            [19] => 26890935
            [20] => 26890936
            [21] => 26890937
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Living (sf): 868
  • Year Built: 2019
  • Building Name: Aalii

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: City,Ocean
  • Listing Office: Sachi HI Pacific Century Prop.

  • Maintenance Fees: $1,152
  • Land Tenure: FS - Fee Simple

  • Elementary School: Kaahumanu
  • Middle School: Stevenson
  • High School: Mckinley

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446