987 Queen Street Unit 3514 Honolulu, HI 96814

Listing
Overview

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

Welcome to Aalii #3514, an exceptional property in Ward Village. This remarkable two-bedroom, two-bath unit offers breathtaking ocean views, a spacious lanai and features high-quality Bosch appliances with stylish countertops in the gourmet kitchen. The natural light in the living area creates a relaxing ambiance. Did I mention the TWO parking stalls that comes with this gem? Located in the heart of Ward Village, indulge in the vibrant urban lifestyle with easy access to a variety of shops, boutiques, and acclaimed restaurants. Immerse yourself in the bustling community and experience the exciting attractions of this exceptional neighborhood. Designed by renowned architects Solomon Cordwell Buenz with Rottet Studio, Aalii presents exclusive penthouse-level amenities on Lanai 42. Marvel at the breathtaking 360° views of the surrounding area, providing a picturesque backdrop for unforgettable moments. Stay fit and active in the state-of-the-art fitness center, catering to your wellness needs. All showings are by private appointment only. Listing by: Coldwell Banker Realty (808) 596-0456

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202314217"
  }
  ["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) "3514"
  }
  ["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) "1315000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1315000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1056) "Welcome to Aalii #3514, an exceptional property in Ward Village. This remarkable two-bedroom, two-bath unit offers breathtaking ocean views, a spacious lanai and features high-quality Bosch appliances with stylish countertops in the gourmet kitchen. The natural light in the living area creates a relaxing ambiance.  Did I mention the TWO parking stalls that comes with this gem?
Located in the heart of Ward Village, indulge in the vibrant urban lifestyle with easy access to a variety of shops, boutiques, and acclaimed restaurants. Immerse yourself in the bustling community and experience the exciting attractions of this exceptional neighborhood.
Designed by renowned architects Solomon Cordwell Buenz with Rottet Studio, Aalii presents exclusive penthouse-level amenities on Lanai 42. Marvel at the breathtaking 360° views of the surrounding area, providing a picturesque backdrop for unforgettable moments. Stay fit and active in the state-of-the-art fitness center, catering to your wellness needs.  All showings are by private appointment only."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["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) "969"
  }
  ["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) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1070.24"
  }
  ["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) "CBPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "tiare.kabazawa@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Tiare K Kabazawa"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-10-01T17:00:01.427"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17397627"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-06-21T16:50:36.790"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25859697"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25859697"
    [1]=>
    string(8) "25859698"
    [2]=>
    string(8) "25859699"
    [3]=>
    string(8) "25859700"
    [4]=>
    string(8) "25859701"
    [5]=>
    string(8) "25859702"
    [6]=>
    string(8) "25859703"
    [7]=>
    string(8) "25859704"
    [8]=>
    string(8) "25859705"
    [9]=>
    string(8) "25859706"
    [10]=>
    string(8) "25859707"
    [11]=>
    string(8) "25859708"
    [12]=>
    string(8) "25859709"
    [13]=>
    string(8) "25859710"
    [14]=>
    string(8) "25859711"
    [15]=>
    string(8) "25859712"
    [16]=>
    string(8) "25859713"
    [17]=>
    string(8) "25859714"
    [18]=>
    string(8) "25859715"
    [19]=>
    string(8) "25859716"
    [20]=>
    string(8) "25859717"
    [21]=>
    string(8) "25859718"
    [22]=>
    string(8) "25859719"
    [23]=>
    string(8) "25859720"
    [24]=>
    string(8) "25859721"
    [25]=>
    string(8) "25859722"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202314217
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to Aalii #3514, an exceptional property in Ward Village. This remarkable two-bedroom, two-bath unit offers breathtaking ocean views, a spacious lanai and features high-quality Bosch appliances with stylish countertops in the gourmet kitchen. The natural light in the living area creates a relaxing ambiance.  Did I mention the TWO parking stalls that comes with this gem?
Located in the heart of Ward Village, indulge in the vibrant urban lifestyle with easy access to a variety of shops, boutiques, and acclaimed restaurants. Immerse yourself in the bustling community and experience the exciting attractions of this exceptional neighborhood.
Designed by renowned architects Solomon Cordwell Buenz with Rottet Studio, Aalii presents exclusive penthouse-level amenities on Lanai 42. Marvel at the breathtaking 360° views of the surrounding area, providing a picturesque backdrop for unforgettable moments. Stay fit and active in the state-of-the-art fitness center, catering to your wellness needs.  All showings are by private appointment only.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => tiare.kabazawa@cbrealty.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Tiare K Kabazawa
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-10-01T17:00:01.427
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-06-21T16:50:36.790
        )

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

    [listing_image] => Array
        (
            [0] => 25859697
            [1] => 25859698
            [2] => 25859699
            [3] => 25859700
            [4] => 25859701
            [5] => 25859702
            [6] => 25859703
            [7] => 25859704
            [8] => 25859705
            [9] => 25859706
            [10] => 25859707
            [11] => 25859708
            [12] => 25859709
            [13] => 25859710
            [14] => 25859711
            [15] => 25859712
            [16] => 25859713
            [17] => 25859714
            [18] => 25859715
            [19] => 25859716
            [20] => 25859717
            [21] => 25859718
            [22] => 25859719
            [23] => 25859720
            [24] => 25859721
            [25] => 25859722
        )

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

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

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

)

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

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: Mountain,Ocean
  • Listing Office: Coldwell Banker Realty

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

CONTACT US

Marcus Realty

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