1177 Queen Street Unit 4509 Honolulu, HI 96814

Take a Virtual Tour

Listing
Overview

Price: $1,850,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) 825-4277

array(45) {
  ["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) "1850000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1850000.00"
  }
  ["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) "1529.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) "COHI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "maggiehawaii@hotmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Maggie L Huang"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-25T19:26:31.973"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18254201"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-23T20:31:01.143"
  }
  ["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) "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"
  }
}
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] => 1850000.00
        )

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

    [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] => 1529.00
        )

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

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-25T19:26:31.973
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-09-23T20:31:01.143
        )

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

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

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

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

)

  • 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,529
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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