Previous Next

987 Queen Street Unit 2604 Honolulu, HI 96814

Listing
Overview

Price: $795,000
Area: KAKAAKO
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202424101"
  }
  ["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) "2604"
  }
  ["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) "795000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "795000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(572) "Welcome to the A'ali'i at Ward Village, an upscale urban retreat in the heart of Honolulu. This high-floor, spacious
one-bedroom offers a perfect blend of luxury and comfort. Enjoy resort style living with a wide range of amenities,
including a stunning pool, state-of-the-art fitness center and the exclusive sky lounge on the 42nd floor, perfect for relaxing
or entertaining while soaking in the views. A'ali'i also offers numerous event rooms, ideal for gathering and celebrations.
Experience the best of island living in one of Honolulu's most desirable locations."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Locations LLC"
  }
  ["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) "624"
  }
  ["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) "783.00"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Kaahumanu"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(10) "Washington"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(8) "Mckinley"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "LOCA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(31) "wendy.doana@locationshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 699-6737"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Wendy H Doana"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-21T09:09:15.047"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18329565"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-21T09:09:15.047"
  }
  ["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) "26739485"
  }
  ["listing_image"]=>
  array(19) {
    [0]=>
    string(8) "26739485"
    [1]=>
    string(8) "26739486"
    [2]=>
    string(8) "26739487"
    [3]=>
    string(8) "26739488"
    [4]=>
    string(8) "26739489"
    [5]=>
    string(8) "26739490"
    [6]=>
    string(8) "26739491"
    [7]=>
    string(8) "26739492"
    [8]=>
    string(8) "26739493"
    [9]=>
    string(8) "26739494"
    [10]=>
    string(8) "26739495"
    [11]=>
    string(8) "26739496"
    [12]=>
    string(8) "26739497"
    [13]=>
    string(8) "26739498"
    [14]=>
    string(8) "26739499"
    [15]=>
    string(8) "26739500"
    [16]=>
    string(8) "26739501"
    [17]=>
    string(8) "26739502"
    [18]=>
    string(8) "26739503"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202424101
        )

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

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

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

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

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

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

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

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

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

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

    [CurrentPrice] => Array
        (
            [0] => 795000.00
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to the A'ali'i at Ward Village, an upscale urban retreat in the heart of Honolulu. This high-floor, spacious
one-bedroom offers a perfect blend of luxury and comfort. Enjoy resort style living with a wide range of amenities,
including a stunning pool, state-of-the-art fitness center and the exclusive sky lounge on the 42nd floor, perfect for relaxing
or entertaining while soaking in the views. A'ali'i also offers numerous event rooms, ideal for gathering and celebrations.
Experience the best of island living in one of Honolulu's most desirable locations.
        )

    [ListOfficeName] => Array
        (
            [0] => Locations LLC
        )

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

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

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

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

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

    [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] => 783.00
        )

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => wendy.doana@locationshawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 699-6737
        )

    [ListAgentFullName] => Array
        (
            [0] => Wendy H Doana
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-21T09:09:15.047
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-10-21T09:09:15.047
        )

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

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

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

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

    [listing_image] => Array
        (
            [0] => 26739485
            [1] => 26739486
            [2] => 26739487
            [3] => 26739488
            [4] => 26739489
            [5] => 26739490
            [6] => 26739491
            [7] => 26739492
            [8] => 26739493
            [9] => 26739494
            [10] => 26739495
            [11] => 26739496
            [12] => 26739497
            [13] => 26739498
            [14] => 26739499
            [15] => 26739500
            [16] => 26739501
            [17] => 26739502
            [18] => 26739503
        )

)

PROPERTY INFO

• BedsTotal: 1
• Full Baths: 1
• Living (sf): 624
• Year Built: 2021
• Building Name: Aalii

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: City,Coastline,Ocean
• Listing Office: Locations LLC

FINANCIAL INFO

• Maintenance Fees: $783
• Land Tenure: FS - Fee Simple

SCHOOLS

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

CONTACT US

Marcus Realty

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