1177 Queen Street Unit 4509 Honolulu, HI 96814

Take a Virtual Tour

Listing
Overview

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

Rarely available: this elegant three-bedroom residence is situated on the 45th floor of Koolani highly sought-after northeast-facing corner with unparalleled vistas of Honolulu's most renowned landmarks: Diamond Head, the Ko’olau mountain range, the Pacific Ocean, Ala Moana Beach Park and Waikiki, it boasts a front-row seat view for the Friday night fireworks, providing a backdrop for entertaining. This 09 stack orientation allows natural trade-winds to flow into the space; primary bedroom suite is privately separate from other bedrooms, hardwood flooring and floor-to-ceiling windows enhance a spacious and light-filled interior. The gourmet kitchen is equipped with Viking appliances and a gas cook-top, ideal for enjoying a quiet meal at home while admiring the breathtaking scenery. Located in Kaka’ako district that offers an opportunity to live and play in one of the most desirable locations in the world. Resort-style amenities that include TWO tennis courts, heated pool, whirlpool, theater, billiard room, large party room, BBQ cabanas, business center and state-of-the-art gym. With 370 residences in total, Koolani is designed to provide the ultimate in comfort and luxury. Listing by: Compass (808) 398-0443

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202420784"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1177"
  }
  ["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) "4509"
  }
  ["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(59) "https://listings.hetproductions.com/sites/enllrrx/unbranded"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1650000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1198) "Rarely available: this elegant three-bedroom residence is situated on the 45th floor of Koolani highly sought-after northeast-facing corner with unparalleled vistas of Honolulu's most renowned landmarks: Diamond Head, the Ko’olau mountain range, the Pacific Ocean, Ala Moana Beach Park and Waikiki, it boasts a front-row seat view for the Friday night fireworks, providing a backdrop for entertaining. This 09 stack orientation allows natural trade-winds to flow into the space; primary bedroom suite is privately separate from other bedrooms, hardwood flooring and floor-to-ceiling windows enhance a spacious and light-filled interior.  The gourmet kitchen is equipped with Viking appliances and a gas cook-top, ideal for enjoying a quiet meal at home while admiring the breathtaking scenery.  Located in Kaka’ako district that offers an opportunity to live and play in one of the most desirable locations in the world.  Resort-style amenities that include TWO tennis courts, heated pool, whirlpool, theater, billiard room, large party room, BBQ cabanas, business center and state-of-the-art gym. With 370 residences in total, Koolani is designed to provide the ultimate in comfort and luxury."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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(4) "1392"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2006"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(7) "Koolani"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(50) "City,Coastline,Diamond Head,Mountain,Ocean,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1737.21"
  }
  ["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) "COHI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "maggiehawaii@hotmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 398-0443"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Maggie L Huang"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-01T11:05:17.980"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18254201"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26705781"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26705781"
    [1]=>
    string(8) "26705782"
    [2]=>
    string(8) "26705783"
    [3]=>
    string(8) "26705784"
    [4]=>
    string(8) "26705785"
    [5]=>
    string(8) "26705786"
    [6]=>
    string(8) "26705787"
    [7]=>
    string(8) "26705788"
    [8]=>
    string(8) "26705789"
    [9]=>
    string(8) "26705790"
    [10]=>
    string(8) "26705791"
    [11]=>
    string(8) "26705792"
    [12]=>
    string(8) "26705793"
    [13]=>
    string(8) "26705794"
    [14]=>
    string(8) "26705795"
    [15]=>
    string(8) "26705796"
    [16]=>
    string(8) "26705797"
    [17]=>
    string(8) "26705798"
    [18]=>
    string(8) "26705799"
    [19]=>
    string(8) "26705800"
    [20]=>
    string(8) "26705801"
    [21]=>
    string(8) "26705802"
    [22]=>
    string(8) "26705803"
    [23]=>
    string(8) "26705804"
    [24]=>
    string(8) "26705805"
    [25]=>
    string(8) "26705806"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-09-23"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:05:17.980"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202420784
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://listings.hetproductions.com/sites/enllrrx/unbranded
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Rarely available: this elegant three-bedroom residence is situated on the 45th floor of Koolani highly sought-after northeast-facing corner with unparalleled vistas of Honolulu's most renowned landmarks: Diamond Head, the Ko’olau mountain range, the Pacific Ocean, Ala Moana Beach Park and Waikiki, it boasts a front-row seat view for the Friday night fireworks, providing a backdrop for entertaining. This 09 stack orientation allows natural trade-winds to flow into the space; primary bedroom suite is privately separate from other bedrooms, hardwood flooring and floor-to-ceiling windows enhance a spacious and light-filled interior.  The gourmet kitchen is equipped with Viking appliances and a gas cook-top, ideal for enjoying a quiet meal at home while admiring the breathtaking scenery.  Located in Kaka’ako district that offers an opportunity to live and play in one of the most desirable locations in the world.  Resort-style amenities that include TWO tennis courts, heated pool, whirlpool, theater, billiard room, large party room, BBQ cabanas, business center and state-of-the-art gym. With 370 residences in total, Koolani is designed to provide the ultimate in comfort and luxury.
        )

    [ListOfficeName] => Array
        (
            [0] => Compass
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Excellent,Above Average
        )

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

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

    [View] => Array
        (
            [0] => City,Coastline,Diamond Head,Mountain,Ocean,Sunrise
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => maggiehawaii@hotmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 398-0443
        )

    [ListAgentFullName] => Array
        (
            [0] => Maggie L Huang
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-01T11:05:17.980
        )

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

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26705781
            [1] => 26705782
            [2] => 26705783
            [3] => 26705784
            [4] => 26705785
            [5] => 26705786
            [6] => 26705787
            [7] => 26705788
            [8] => 26705789
            [9] => 26705790
            [10] => 26705791
            [11] => 26705792
            [12] => 26705793
            [13] => 26705794
            [14] => 26705795
            [15] => 26705796
            [16] => 26705797
            [17] => 26705798
            [18] => 26705799
            [19] => 26705800
            [20] => 26705801
            [21] => 26705802
            [22] => 26705803
            [23] => 26705804
            [24] => 26705805
            [25] => 26705806
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-09-23
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:05:17.980
        )

)

  • BedsTotal: 3
  • Full Baths: 2
  • Living (sf): 1,392
  • Year Built: 2006
  • Building Name: Koolani

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 2
  • View: City,Coastline,Diamond Head,Mountain,Ocean,Sunrise
  • Listing Office: Compass

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

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on May 1, 2025 - 11:05 AM Information is deemed reliable but not guaranteed. Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.

© Marcus Realty. All Rights Reserved.