987 Queen Street Unit 4017 Honolulu, HI 96814

Take a Virtual Tour

Listing
Overview

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

Aalii offers a premium living experience that welcomes you from the moment you arrive. Located in the vibrant Ward Village, one of America’s most premiere and innovative master-planned communities, you will be steps away from Whole Foods, Ala Moana Center and Beach Park. Situated just one floor below the penthouse, Aalii 4017 provides an extraordinary high-floor living experience with breathtaking mountain views and refreshing trade winds flowing through your home. This exquisite residence is an urban sanctuary designed by the renowned Rottet Studio. The owner has made upgrades, including a system closet, custom shelving in the pantry, and built-in cabinet in the bedroom. Fully furnished with designer pieces, this residence allows you to enjoy a turnkey experience and start enjoying your new home immediately. Aalii boasts a plethora of amenities, including the expansive Fitness Club, Sky Lounge, and Event Space on the 42nd floor, a place to enjoy and relax with your friends and family. Additionally, the 8th floor features a pool, cabanas, Keiki Play Area, BBQ, and indoor event spaces with a kitchen. Don’t miss this opportunity to own a piece of luxury high above the Oahu coastline. Listing by: Map Vision Inc. (808) 721-2203

array(43) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202428248"
  }
  ["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) "4017"
  }
  ["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(112) "https://3dshowcasehawaii.us13.list-manage.com/track/click?u=0bfdee4448f8a11917c136252&id=c7e40191fc&e=087c2e104e"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "929000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1204) "Aalii offers a premium living experience that welcomes you from the moment you arrive. Located in the vibrant Ward Village, one of America’s most premiere and innovative master-planned communities, you will be steps away from Whole Foods, Ala Moana Center and Beach Park. Situated just one floor below the penthouse, Aalii 4017 provides an extraordinary high-floor living experience with breathtaking mountain views and refreshing trade winds flowing through your home. This exquisite residence is an urban sanctuary designed by the renowned Rottet Studio. The owner has made upgrades, including a system closet, custom shelving in the pantry, and built-in cabinet in the bedroom. Fully furnished with designer pieces, this residence allows you to enjoy a turnkey experience and start enjoying your new home immediately. Aalii boasts a plethora of amenities, including the expansive Fitness Club, Sky Lounge, and Event Space on the 42nd floor, a place to enjoy and relax with your friends and family. Additionally, the 8th floor features a pool, cabanas, Keiki Play Area, BBQ, and indoor event spaces with a kitchen. Don’t miss this opportunity to own a piece of luxury high above the Oahu coastline."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(15) "Map Vision 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) "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(13) "City,Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "978.02"
  }
  ["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) "MAPV"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "jiro@mapvisionhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 721-2203"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Jiro Mizukami"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-12-19T07:40:04.713"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18437563"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-12-19"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26811549"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26811549"
    [1]=>
    string(8) "26811550"
    [2]=>
    string(8) "26811551"
    [3]=>
    string(8) "26811552"
    [4]=>
    string(8) "26811553"
    [5]=>
    string(8) "26811554"
    [6]=>
    string(8) "26811555"
    [7]=>
    string(8) "26811556"
    [8]=>
    string(8) "26811557"
    [9]=>
    string(8) "26811558"
    [10]=>
    string(8) "26811559"
    [11]=>
    string(8) "26811560"
    [12]=>
    string(8) "26811561"
    [13]=>
    string(8) "26811562"
    [14]=>
    string(8) "26811563"
    [15]=>
    string(8) "26811564"
    [16]=>
    string(8) "26811565"
    [17]=>
    string(8) "26811566"
    [18]=>
    string(8) "26811567"
    [19]=>
    string(8) "26811568"
    [20]=>
    string(8) "26811569"
    [21]=>
    string(8) "26811570"
    [22]=>
    string(8) "26811571"
    [23]=>
    string(8) "26811572"
    [24]=>
    string(8) "26811573"
    [25]=>
    string(8) "26811574"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202428248
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://3dshowcasehawaii.us13.list-manage.com/track/click?u=0bfdee4448f8a11917c136252&id=c7e40191fc&e=087c2e104e
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Aalii offers a premium living experience that welcomes you from the moment you arrive. Located in the vibrant Ward Village, one of America’s most premiere and innovative master-planned communities, you will be steps away from Whole Foods, Ala Moana Center and Beach Park. Situated just one floor below the penthouse, Aalii 4017 provides an extraordinary high-floor living experience with breathtaking mountain views and refreshing trade winds flowing through your home. This exquisite residence is an urban sanctuary designed by the renowned Rottet Studio. The owner has made upgrades, including a system closet, custom shelving in the pantry, and built-in cabinet in the bedroom. Fully furnished with designer pieces, this residence allows you to enjoy a turnkey experience and start enjoying your new home immediately. Aalii boasts a plethora of amenities, including the expansive Fitness Club, Sky Lounge, and Event Space on the 42nd floor, a place to enjoy and relax with your friends and family. Additionally, the 8th floor features a pool, cabanas, Keiki Play Area, BBQ, and indoor event spaces with a kitchen. Don’t miss this opportunity to own a piece of luxury high above the Oahu coastline.
        )

    [ListOfficeName] => Array
        (
            [0] => Map Vision Inc.
        )

    [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
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => jiro@mapvisionhawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 721-2203
        )

    [ListAgentFullName] => Array
        (
            [0] => Jiro Mizukami
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-12-19T07:40:04.713
        )

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

    [ListingContractDate] => Array
        (
            [0] => 2024-12-19
        )

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

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

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

    [listing_image] => Array
        (
            [0] => 26811549
            [1] => 26811550
            [2] => 26811551
            [3] => 26811552
            [4] => 26811553
            [5] => 26811554
            [6] => 26811555
            [7] => 26811556
            [8] => 26811557
            [9] => 26811558
            [10] => 26811559
            [11] => 26811560
            [12] => 26811561
            [13] => 26811562
            [14] => 26811563
            [15] => 26811564
            [16] => 26811565
            [17] => 26811566
            [18] => 26811567
            [19] => 26811568
            [20] => 26811569
            [21] => 26811570
            [22] => 26811571
            [23] => 26811572
            [24] => 26811573
            [25] => 26811574
        )

)

  • 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
  • Listing Office: Map Vision Inc.

  • Maintenance Fees: $978
  • 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