1177 Queen Street Unit 4204 Honolulu, HI 96814

Listing
Overview

Price: $1,380,000
Area: KAKAAKO
Status: Active Under Contract

"Koolani" High Floor Two bed, Two bath unit. Ocean View from living, Bed rooms. Kitchen Range has Gas Top Burner. The unit parking are located same as lobby floor. Side by side parking. Concierge, Heated Pool, Children Pool, BBQ Area, Two Full Size Tennis Courts. Putting Green, Billiards Room, Movie Theater, Party room, Game Room, Business Center. Walk to Ward Village, Walk to Ala Moana Shopping Center, Walk to Ala Moana Beach. You can Enjoy Hawaii Life. Island Spa is located in the Building. Owner can use the Spa with extra special fee. Listing by: Hawaiian Joy LLC (808) 221-8073

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202322289"
  }
  ["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) "4204"
  }
  ["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) "1380000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1380000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(544) ""Koolani" High Floor Two bed, Two bath unit. Ocean View from living, Bed rooms. Kitchen Range has Gas Top Burner. The unit parking are located same as lobby floor.  Side by side parking. Concierge, Heated Pool, Children Pool, BBQ Area, Two Full Size Tennis Courts. Putting Green, Billiards Room, Movie Theater, Party room, Game Room, Business Center. Walk to Ward Village, Walk to Ala Moana Shopping Center, Walk to Ala Moana Beach. You can Enjoy Hawaii Life. Island Spa is located in the Building. Owner can use the Spa with extra special fee."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(16) "Hawaiian Joy LLC"
  }
  ["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(4) "1162"
  }
  ["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(27) "City,Coastline,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1210.01"
  }
  ["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) "HAWA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "yumi@hawaiianjoy.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 221-8073"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Yumi Matsumoto"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-11-16T08:21:41.427"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17594544"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-10-06T09:53:30.000"
  }
  ["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) "25980329"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25980329"
    [1]=>
    string(8) "25980330"
    [2]=>
    string(8) "25980331"
    [3]=>
    string(8) "25980332"
    [4]=>
    string(8) "25980333"
    [5]=>
    string(8) "25980334"
    [6]=>
    string(8) "25980335"
    [7]=>
    string(8) "25980336"
    [8]=>
    string(8) "25980337"
    [9]=>
    string(8) "25980338"
    [10]=>
    string(8) "25980339"
    [11]=>
    string(8) "25980340"
    [12]=>
    string(8) "25980341"
    [13]=>
    string(8) "25980342"
    [14]=>
    string(8) "25980343"
    [15]=>
    string(8) "25980344"
    [16]=>
    string(8) "25980345"
    [17]=>
    string(8) "25980346"
    [18]=>
    string(8) "25980347"
    [19]=>
    string(8) "25980348"
    [20]=>
    string(8) "25980349"
    [21]=>
    string(8) "25980350"
    [22]=>
    string(8) "25980351"
    [23]=>
    string(8) "25980352"
    [24]=>
    string(8) "25980353"
    [25]=>
    string(8) "25980354"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202322289
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => "Koolani" High Floor Two bed, Two bath unit. Ocean View from living, Bed rooms. Kitchen Range has Gas Top Burner. The unit parking are located same as lobby floor.  Side by side parking. Concierge, Heated Pool, Children Pool, BBQ Area, Two Full Size Tennis Courts. Putting Green, Billiards Room, Movie Theater, Party room, Game Room, Business Center. Walk to Ward Village, Walk to Ala Moana Shopping Center, Walk to Ala Moana Beach. You can Enjoy Hawaii Life. Island Spa is located in the Building. Owner can use the Spa with extra special fee.
        )

    [ListOfficeName] => Array
        (
            [0] => Hawaiian Joy LLC
        )

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

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

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

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

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

    [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,Ocean,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => yumi@hawaiianjoy.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 221-8073
        )

    [ListAgentFullName] => Array
        (
            [0] => Yumi Matsumoto
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-11-16T08:21:41.427
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-10-06T09:53:30.000
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 25980329
            [1] => 25980330
            [2] => 25980331
            [3] => 25980332
            [4] => 25980333
            [5] => 25980334
            [6] => 25980335
            [7] => 25980336
            [8] => 25980337
            [9] => 25980338
            [10] => 25980339
            [11] => 25980340
            [12] => 25980341
            [13] => 25980342
            [14] => 25980343
            [15] => 25980344
            [16] => 25980345
            [17] => 25980346
            [18] => 25980347
            [19] => 25980348
            [20] => 25980349
            [21] => 25980350
            [22] => 25980351
            [23] => 25980352
            [24] => 25980353
            [25] => 25980354
        )

)

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

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 2
  • View: City,Coastline,Ocean,Sunset
  • Listing Office: Hawaiian Joy LLC

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

CONTACT US

Marcus Realty

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