987 Queen Street Unit 3517 Honolulu, HI 96814

Take a Virtual Tour

Listing
Overview

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

This gorgeous high floor residence comes with more than $100,000 of upgrades including the developer's original Turn-Key Package crafted by renowned interior designer Lauren Rottet at Rottet Studio. Additionally, two storage lockers behind the unit’s parking stall, upgraded with its own EV Outlet, and a bonus Spacious Walk-in Storage Room approx. 44 sq ft all on level 6, conveniently located near the elevators. Enjoy cool breezes, panoramic mountains and city views. The fresh vibrant interior features contemporary elegant finishes throughout. Natural stone countertops with full-height backsplashes, Bosch kitchen appliances, beautiful flooring in the living room and walk-in closet in the bedroom. Stylish amenities include a rooftop Sky deck with breathtaking ocean view, fitness center, Yoga room, resort style pools, jacuzzi, private cabanas, BBQ areas, indoor/outdoor lounge, dog park, children's play area and more. It's Pet friendly! Close to the Whole Foods market, restaurants, shops, parks, Kewalo boat harbor and Ala Moana Beach Park. Listing by: Coldwell Banker Realty (808) 286-5118

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202320793"
  }
  ["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) "3517"
  }
  ["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(39) "http://player.vimeo.com/video/725119774"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1053) "This gorgeous high floor residence comes with more than $100,000 of upgrades including the developer's original Turn-Key Package crafted by renowned interior designer Lauren Rottet at Rottet Studio. Additionally, two storage lockers behind the unit’s parking stall, upgraded with its own EV Outlet, and a bonus Spacious Walk-in Storage Room approx. 44 sq ft all on level 6, conveniently located near the elevators. Enjoy cool breezes, panoramic mountains and city views. The fresh vibrant interior features contemporary elegant finishes throughout. Natural stone countertops with full-height backsplashes, Bosch kitchen appliances, beautiful flooring in the living room and walk-in closet in the bedroom. Stylish amenities include a rooftop Sky deck with breathtaking ocean view, fitness center, Yoga room, resort style pools, jacuzzi, private cabanas, BBQ areas, indoor/outdoor lounge, dog park, children's play area and more. It's Pet friendly! Close to the Whole Foods market, restaurants, shops, parks, Kewalo boat harbor and Ala Moana Beach Park."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker 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) "596"
  }
  ["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) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(21) "City,Mountain,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "704.17"
  }
  ["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(6) "CBPP02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "hiromihawaiihomes@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 286-5118"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Hiromi Farmer"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-10-14T23:08:25.703"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17553799"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-09-11T14:23:36.210"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25951881"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "25951881"
    [1]=>
    string(8) "25951882"
    [2]=>
    string(8) "25951883"
    [3]=>
    string(8) "25951884"
    [4]=>
    string(8) "25951885"
    [5]=>
    string(8) "25951886"
    [6]=>
    string(8) "25951887"
    [7]=>
    string(8) "25951888"
    [8]=>
    string(8) "25951889"
    [9]=>
    string(8) "25951890"
    [10]=>
    string(8) "25951891"
    [11]=>
    string(8) "25951892"
    [12]=>
    string(8) "25951893"
    [13]=>
    string(8) "25951894"
    [14]=>
    string(8) "25951895"
    [15]=>
    string(8) "25951896"
    [16]=>
    string(8) "25951897"
    [17]=>
    string(8) "25951898"
    [18]=>
    string(8) "25951899"
    [19]=>
    string(8) "25951900"
    [20]=>
    string(8) "25951901"
    [21]=>
    string(8) "25951902"
    [22]=>
    string(8) "25951903"
    [23]=>
    string(8) "25951904"
    [24]=>
    string(8) "25951905"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202320793
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => http://player.vimeo.com/video/725119774
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => This gorgeous high floor residence comes with more than $100,000 of upgrades including the developer's original Turn-Key Package crafted by renowned interior designer Lauren Rottet at Rottet Studio. Additionally, two storage lockers behind the unit’s parking stall, upgraded with its own EV Outlet, and a bonus Spacious Walk-in Storage Room approx. 44 sq ft all on level 6, conveniently located near the elevators. Enjoy cool breezes, panoramic mountains and city views. The fresh vibrant interior features contemporary elegant finishes throughout. Natural stone countertops with full-height backsplashes, Bosch kitchen appliances, beautiful flooring in the living room and walk-in closet in the bedroom. Stylish amenities include a rooftop Sky deck with breathtaking ocean view, fitness center, Yoga room, resort style pools, jacuzzi, private cabanas, BBQ areas, indoor/outdoor lounge, dog park, children's play area and more. It's Pet friendly! Close to the Whole Foods market, restaurants, shops, parks, Kewalo boat harbor and Ala Moana Beach Park.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => City,Mountain,Sunrise
        )

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 286-5118
        )

    [ListAgentFullName] => Array
        (
            [0] => Hiromi Farmer
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-10-14T23:08:25.703
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-09-11T14:23:36.210
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 25951881
            [1] => 25951882
            [2] => 25951883
            [3] => 25951884
            [4] => 25951885
            [5] => 25951886
            [6] => 25951887
            [7] => 25951888
            [8] => 25951889
            [9] => 25951890
            [10] => 25951891
            [11] => 25951892
            [12] => 25951893
            [13] => 25951894
            [14] => 25951895
            [15] => 25951896
            [16] => 25951897
            [17] => 25951898
            [18] => 25951899
            [19] => 25951900
            [20] => 25951901
            [21] => 25951902
            [22] => 25951903
            [23] => 25951904
            [24] => 25951905
        )

)

  • BedsTotal: 1
  • Full Baths: 1
  • Living (sf): 596
  • Year Built: 2019
  • Building Name: Aalii

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • View: City,Mountain,Sunrise
  • Listing Office: Coldwell Banker Realty

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

CONTACT US

Marcus Realty

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