1177 Queen Street Unit 4209 Honolulu, HI 96814

Listing
Overview

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

Great value in Kakaako for a high floor 3 bedroom unit with world class amenities. Never a dull moment with views of the Koolau Mountains, rainbows, city lights and the ocean off Diamond Head's Gold Coast. For those that love to cook, you can enjoy granite counters, stainless steel Viking appliances and a gas stove. Primary suite has a walk in closet, tub and separate shower. Upgrades include hardwood floors, solar and black out shades, upgraded laundry door, newer water heater and additional storage. In addition to Central AC, this unit gets more of the eastern sunrise in morning and stays cooler in the afternoon. On site amenities include BBQ grills, swimming pool, putting green, tennis court, movie theater, billiards room, office and party rooms... If that's not enough, Koolani is walking distance to Ward Village and Ala Moana for tons of restaurants, supermarkets, shops and movie theaters. Listing by: Harcourts Island Real Estate (808) 371-3509

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202411426"
  }
  ["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) "4209"
  }
  ["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) "1788000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1788000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(907) "Great value in Kakaako for a high floor 3 bedroom unit with world class amenities. Never a dull moment with views of the Koolau Mountains, rainbows, city lights and the ocean off Diamond Head's Gold Coast. For those that love to cook, you can enjoy granite counters, stainless steel Viking appliances and a gas stove. Primary suite has a walk in closet, tub and separate shower.  Upgrades include hardwood floors, solar and black out shades, upgraded laundry door, newer water heater and additional storage. In addition to Central AC, this unit gets more of the eastern sunrise in morning and stays cooler in the afternoon. On site amenities include BBQ grills, swimming pool, putting green, tennis court, movie theater, billiards room, office and party rooms... If that's not enough, Koolani is walking distance to Ward Village and Ala Moana for tons of restaurants, supermarkets, shops and movie theaters."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(28) "Harcourts Island Real Estate"
  }
  ["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(9) "Excellent"
  }
  ["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(9) "Kaahumanu"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(9) "Stevenson"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(8) "Mckinley"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "HRCT"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(28) "david@hawaiihomelistings.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 371-3509"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "David E Buck"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-06-11T15:34:00.257"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18010796"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-05-16T19:58:55.303"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26215917"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26215917"
    [1]=>
    string(8) "26215918"
    [2]=>
    string(8) "26215919"
    [3]=>
    string(8) "26215920"
    [4]=>
    string(8) "26215921"
    [5]=>
    string(8) "26215922"
    [6]=>
    string(8) "26215923"
    [7]=>
    string(8) "26215924"
    [8]=>
    string(8) "26215925"
    [9]=>
    string(8) "26215926"
    [10]=>
    string(8) "26215927"
    [11]=>
    string(8) "26215928"
    [12]=>
    string(8) "26215929"
    [13]=>
    string(8) "26215930"
    [14]=>
    string(8) "26215931"
    [15]=>
    string(8) "26215932"
    [16]=>
    string(8) "26215933"
    [17]=>
    string(8) "26215934"
    [18]=>
    string(8) "26215935"
    [19]=>
    string(8) "26215936"
    [20]=>
    string(8) "26215937"
    [21]=>
    string(8) "26215938"
    [22]=>
    string(8) "26215939"
    [23]=>
    string(8) "26215940"
    [24]=>
    string(8) "26215941"
    [25]=>
    string(8) "26215942"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202411426
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Great value in Kakaako for a high floor 3 bedroom unit with world class amenities. Never a dull moment with views of the Koolau Mountains, rainbows, city lights and the ocean off Diamond Head's Gold Coast. For those that love to cook, you can enjoy granite counters, stainless steel Viking appliances and a gas stove. Primary suite has a walk in closet, tub and separate shower.  Upgrades include hardwood floors, solar and black out shades, upgraded laundry door, newer water heater and additional storage. In addition to Central AC, this unit gets more of the eastern sunrise in morning and stays cooler in the afternoon. On site amenities include BBQ grills, swimming pool, putting green, tennis court, movie theater, billiards room, office and party rooms... If that's not enough, Koolani is walking distance to Ward Village and Ala Moana for tons of restaurants, supermarkets, shops and movie theaters.
        )

    [ListOfficeName] => Array
        (
            [0] => Harcourts Island Real Estate
        )

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => david@hawaiihomelistings.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 371-3509
        )

    [ListAgentFullName] => Array
        (
            [0] => David E Buck
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-06-11T15:34:00.257
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-05-16T19:58:55.303
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26215917
            [1] => 26215918
            [2] => 26215919
            [3] => 26215920
            [4] => 26215921
            [5] => 26215922
            [6] => 26215923
            [7] => 26215924
            [8] => 26215925
            [9] => 26215926
            [10] => 26215927
            [11] => 26215928
            [12] => 26215929
            [13] => 26215930
            [14] => 26215931
            [15] => 26215932
            [16] => 26215933
            [17] => 26215934
            [18] => 26215935
            [19] => 26215936
            [20] => 26215937
            [21] => 26215938
            [22] => 26215939
            [23] => 26215940
            [24] => 26215941
            [25] => 26215942
        )

)

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

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: City,Coastline,Diamond Head,Mountain,Ocean,Sunrise
  • Listing Office: Harcourts Island Real Estate

  • Maintenance Fees: $1,529
  • 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