987 Queen Street Unit 1401 Honolulu, HI 96814

Take a Virtual Tour

Listing
Overview

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

Luxury living awaits in this ocean view “01” stack, fully furnished condo in the heart of Kaka’ako. This condo has been upgraded and outfitted with High-Quality customized furniture, fixtures, rugs and wall art. Upgrades include; programmable (Wi-Fi-enabled) Hunter Douglas Power blinds installed in all rooms, dimmer switches installed in all rooms to include bathrooms, custom light fixtures throughout the kitchen, hallway, closets and bedrooms, custom high gloss closet build out in each bedroom, custom floating shelves installed in the kitchen, bathrooms and living room, and floating nightstands installed in all bedrooms. Lastly, all new living room furniture pieces from Jonathon Louis, American leather furniture, and ALF Italia. Unit comes with one parking stall, which includes an overhead storage locker and also an additional 37 sq ft storage unit. Residents of this luxurious building have access to a range of Resort-Style amenities, including a 42nd-floor penthouse level amenity deck which includes 360 views of the ocean and city with a fitness center, yoga room, meeting rooms, pool table, outdoor sky terrace, recreation space and multiple party rooms with full kitchens. Listing by: Fathom Realty HI LLC

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202309547"
  }
  ["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) "1401"
  }
  ["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(50) "https://987-queen-st-1401.showthisproperty.com/mls"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1560000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1560000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1198) "Luxury living awaits in this ocean view “01” stack, fully furnished condo in the heart of Kaka’ako. This condo has been upgraded and outfitted with High-Quality customized furniture, fixtures, rugs and wall art. Upgrades include; programmable (Wi-Fi-enabled) Hunter Douglas Power blinds installed in all rooms, dimmer switches installed in all rooms to include bathrooms, custom light fixtures throughout the kitchen, hallway, closets and bedrooms, custom high gloss closet build out in each bedroom, custom floating shelves installed in the kitchen, bathrooms and living room, and floating nightstands installed in all bedrooms. Lastly, all new living room furniture pieces from Jonathon Louis, American leather furniture, and ALF Italia. Unit comes with one parking stall, which includes an overhead storage locker and also an additional 37 sq ft storage unit. Residents of this luxurious building have access to a range of Resort-Style amenities, including a 42nd-floor penthouse level amenity deck which includes 360 views of the ocean and city with a fitness center, yoga room, meeting rooms, pool table, outdoor sky terrace, recreation space and multiple party rooms with full kitchens."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(20) "Fathom Realty HI LLC"
  }
  ["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) "927"
  }
  ["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(70) "City,Coastline,Diamond Head,Marina/Canal,Mountain,Ocean,Sunrise,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1076.00"
  }
  ["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) "PAKU"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "homegoals32@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Dre Burdin"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-08-07T21:56:38.973"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17285523"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-04-23T20:34:12.920"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25845610"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25845610"
    [1]=>
    string(8) "25845611"
    [2]=>
    string(8) "25845612"
    [3]=>
    string(8) "25845613"
    [4]=>
    string(8) "25845614"
    [5]=>
    string(8) "25845615"
    [6]=>
    string(8) "25845616"
    [7]=>
    string(8) "25845617"
    [8]=>
    string(8) "25845618"
    [9]=>
    string(8) "25845619"
    [10]=>
    string(8) "25845620"
    [11]=>
    string(8) "25845621"
    [12]=>
    string(8) "25845622"
    [13]=>
    string(8) "25845623"
    [14]=>
    string(8) "25845624"
    [15]=>
    string(8) "25845625"
    [16]=>
    string(8) "25845626"
    [17]=>
    string(8) "25845627"
    [18]=>
    string(8) "25845628"
    [19]=>
    string(8) "25845629"
    [20]=>
    string(8) "25845630"
    [21]=>
    string(8) "25845631"
    [22]=>
    string(8) "25845632"
    [23]=>
    string(8) "25845633"
    [24]=>
    string(8) "25845634"
    [25]=>
    string(8) "25845635"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202309547
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://987-queen-st-1401.showthisproperty.com/mls
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Luxury living awaits in this ocean view “01” stack, fully furnished condo in the heart of Kaka’ako. This condo has been upgraded and outfitted with High-Quality customized furniture, fixtures, rugs and wall art. Upgrades include; programmable (Wi-Fi-enabled) Hunter Douglas Power blinds installed in all rooms, dimmer switches installed in all rooms to include bathrooms, custom light fixtures throughout the kitchen, hallway, closets and bedrooms, custom high gloss closet build out in each bedroom, custom floating shelves installed in the kitchen, bathrooms and living room, and floating nightstands installed in all bedrooms. Lastly, all new living room furniture pieces from Jonathon Louis, American leather furniture, and ALF Italia. Unit comes with one parking stall, which includes an overhead storage locker and also an additional 37 sq ft storage unit. Residents of this luxurious building have access to a range of Resort-Style amenities, including a 42nd-floor penthouse level amenity deck which includes 360 views of the ocean and city with a fitness center, yoga room, meeting rooms, pool table, outdoor sky terrace, recreation space and multiple party rooms with full kitchens.
        )

    [ListOfficeName] => Array
        (
            [0] => Fathom Realty HI LLC
        )

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

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

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

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

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

    [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,Diamond Head,Marina/Canal,Mountain,Ocean,Sunrise,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => homegoals32@gmail.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Dre Burdin
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-08-07T21:56:38.973
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-04-23T20:34:12.920
        )

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

    [listing_image] => Array
        (
            [0] => 25845610
            [1] => 25845611
            [2] => 25845612
            [3] => 25845613
            [4] => 25845614
            [5] => 25845615
            [6] => 25845616
            [7] => 25845617
            [8] => 25845618
            [9] => 25845619
            [10] => 25845620
            [11] => 25845621
            [12] => 25845622
            [13] => 25845623
            [14] => 25845624
            [15] => 25845625
            [16] => 25845626
            [17] => 25845627
            [18] => 25845628
            [19] => 25845629
            [20] => 25845630
            [21] => 25845631
            [22] => 25845632
            [23] => 25845633
            [24] => 25845634
            [25] => 25845635
        )

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

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

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

)

  • BedsTotal: 2
  • Full Baths: 2
  • Living (sf): 927
  • Year Built: 2021
  • Building Name: Aalii

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • View: City,Coastline,Diamond Head,Marina/Canal,Mountain,Ocean,Sunrise,Sunset
  • Listing Office: Fathom Realty HI LLC

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

CONTACT US

Marcus Realty

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